Attendee information upload tool for CampTix

[andreamiddleton]

Occasionally WordCamps must run their registration through non-WordCamp channels, for various reasons.

This is a challenge for the WordCamp program, because we lose access to attendance and attendee data. This affects our ability to report accurately on WordCamp programs to sponsors and the global community.

A simple attendee upload tool would resolve this challenge. It should allow organizers to upload a CSV file to CampTix with the following attendee information, at a minimum:

First Name
Last Name
Email Address
Ticket price
Date of purchase

Organizers could create a ticket with question fields that match the CSV file they have from the other registration platform. Then, they could navigate to the Tools section and choose the Import Attendee Data tab.

On that tab, they'd find a selector for the ticket they wanted to map the attendee data to, then a file selector. Upon selecting the file, the tool would provide suggested mapping based on CSV file headings, if there were any, and otherwise ask the user to map the columns to the ticket fields.

Once the mapping was confirmed, the data would be viewable in Tickets > Attendees

[andreamiddleton]

A very basic wireframe for the proposed Import Attendee Data tab on Tickets > Tools

[hlashbrooke]

I maybe wrong (as CampTix and WordCamp.org are blurred a bit), but I think the attendee side of things is all handled inside CampTix itself, so this would need to be discussed and worked in the CampTix Githhub repo: ​https://github.com/Automattic/camptix. I could be horrendously mistaken here though, so ignore me if that's the case :P

[coreymckrill]

This could be an enhancement for CampTix itself, or it could be built as a separate plugin that works with CampTix (like the badge generator and the network tools). So you're both right. My inclination would be to build it as a separate plugin, if CampTix has the necessary integration points. So, I think it's ok to leave this here in Trac.

[khromov]

@coreymckrill Hi, I wanted to see if there has been any movement on this ticket. We had our WordCamp recently using an external ticketing system and we promised @andreamiddleton to transfer the names over into CampTix, but we're not sure we will have the manpower to pull the proposed PR off by ourselves. A simpler option for us would be if the REST API was available, we could write a simple script to upload the participants via the API.

[iandunn]

I think a CSV upload is going to be a better choice overall, because it'll be more accessible to most camps. Most camps won't want to write a custom script, even if they have a dev with time to do it.

[dd32]

This ticket has been moved to GitHub ​https://github.com/WordPress/wordcamp.org/issues/591