Proposal: CampTix Attendee to Google Sheets integration

Proposal: CampTix Attendee to Google Sheets integration

Posted by Dot Org Community on September 11, 2022 at 7:07 pm
kitty kitty CATegory CampTix, Community, Uncategorized, WCUS, WordCamps, contributor day, proposal
As a WordCamp organizer, I would like to see CampTix Attendee data populate in a Google Sheet instead of only being available as a downloadable CSV file. This would allow organizers to make a live set of data available for their needs including but not limited to on-demand badge printing. Integration with on-demand badge printing solutions I am an organizer of WordCamp US 2022 and am posting this during contributor day. Over the last 3 days, I observed the process we had in place between WCUS and the vendor we used to print our badges. About two weeks before the event, a CampTix export was created.Unnecessary columns in the export were removed leaving only the columns the vendor needed: name, pronouns, company, Twitter handle, and ticket type (attendee, sponsor, speaker, media, volunteer, organizer).A review of the export was performed, by hand, and removed characters that the vendor couldn’t print (leaving only UTF-8 characters).About one week before the event, the modified export was sent to the badge vendor.The badge vendor uploaded our CSV file to Google Drive, and mapped the various columns to positions where text would appear on the badge.Due to last minute changes to ticket details, the export from…

…Full post on Dot Org Community
Read Full

Similar Posts

Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments