Welcome! This is the home of the Make Community Team for the WordPress open sourceOpen SourceOpen Source denotes software for which the original source code is made freely available and may be redistributed and modified. Open Source **must be** delivered via a licensing model, see GPL. project!
This team helps the community with official events like:
Discuss: Here we have policy debates, project announcements and status reports. Everyone is welcome to comment on posts and join the discussion.
Plan: Want to organize a meetupMeetupMeetup groups are locally-organized groups that get together for face-to-face events on a regular basis (commonly once a month). Learn more about Meetups in our Meetup Organizer Handbook. in your community? Excited to host a WordCampWordCampWordCamps are casual, locally-organized conferences covering everything related to WordPress. They're one of the places where the WordPress community comes together to teach one another what they’ve learned throughout the year and share the joy. Learn more.? Check out one of our handbooks to get started.
Assist: Participate in the Meetup Reactivation project, apply to be a Community DeputyDeputyCommunity Deputies are a team of people all over the world who review WordCamp and Meetup applications, interview lead organizers, and generally keep things moving at WordCamp Central. Find more about deputies in our Community Deputy Handbook., or help out as a WordCamp MentorMentorSomeone who has already organised a WordCamp and has time to meet with their assigned mentee every 2 weeks, they talk over where they should be in their timeline, help them to identify their issues, and also identify solutions for their issues..
Discover: Any skill level can find a way to be involved in our Team Projects.
Office HoursOffice HoursDefined times when the Global Community Team are in the #community-events Slack channel. If there is anything you would like to discuss – you do not need to inform them in advance.You are very welcome to drop into any of the Community Team Slack channels at any time. are held on Slack in #community-events
Proposal: CampTix Attendee to Google Sheets integration
As a WordCampWordCampWordCamps are casual, locally-organized conferences covering everything related to WordPress. They're one of the places where the WordPress community comes together to teach one another what they’ve learned throughout the year and share the joy. Learn more. 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
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 two weeks before the event was stale in a few cases:
Attendees that update their ticket information (name change, company change etc.) caused old information to still appear on the badge.
Attendees that refunded their ticket still had a badge available to be printed.
Attendees who purchased an available (recently refunded) ticket weren’t able to print their badge.
A manual process was necessary to update incorrect information, or add missing people to the vendor’s Google Sheet.
Organizers only need to create an “export” once
Over the course of planning a WordCamp, I find I am often pulling a fresh CampTix export. For the same reasons that I spelled out in the section above, an export becomes increasingly less valuable as time passes. While the CampTix Summarize tool is useful when looking for a count of attendees and how they answered a particular question, sometimes more specific information is needed. For example, it’s useful to see the attendee’s name and their answer, especially in the case of:
AccessibilityAccessibilityAccessibility (commonly shortened to a11y) refers to the design of products, devices, services, or environments for people with disabilities. The concept of accessible design ensures both “direct access” (i.e. unassisted) and “indirect access” meaning compatibility with a person’s assistive technology (for example, computer screen readers). (https://en.wikipedia.org/wiki/Accessibility) needs
For me, the export CSV file isn’t usable until I open it in a spreadsheet application and I don’t have one installed on my computer. So, I end up uploading the file into my WordCamp’s Google Drive and open the file with Google Sheets before I can begin working with it. It would simplify the workflow by having the data immediately available in Google Sheets.
We already allow a non-logged user to access CampTix data through the Attendance UIUIUI is an acronym for User Interface - the layout of the page the user interacts with. Think ‘how are they doing that’ and less about what they are doing.. This proposal adds a new tab on the screen below called Export Integration. It would have a radio field titled Enabled and a text area field titled Secret Link similar to the screenshot.
Once the Secret Link from the Export Integration is generated, it should be embedded inside the Google Sheets function IMPORTDATA() which would populate the sheet. If there are multiple use cases for Google Sheet integrations, additional Google Sheet files can be created that invoke the IMPORTRANGE() function. If only a select number of columns or rows are needed for a particular use case, the limited access use case could be wrapped by a QUERY(). Here’s an example that might make sense for the microsponsor scenario: =QUERY(IMPORTRANGE("1gcuSqpN-x1NCn5ZaEKc_IhoBFQAlMhpjtjE1eUL4ZJo"), "SELECT C, D, E WHERE B='Microsponsor'", FALSE)
I’m seeking feedback on this proposal through the end of September. Please let me know if you have any questions or need clarification.