search

fnf-org / TicketBooth

Rails 7.1 app for creating closed community events, distributing the ticket request URL, approving and selling tickets via Stripe Integration.
https://fnf.org
Other
8 stars 4 forks source link

Guest List CSV #184

Open yarunluon opened 1 month ago

yarunluon commented 1 month ago

Instead of reopening https://github.com/fnf-org/TicketBooth/issues/144, I am creating a new ticket.

Is your feature request related to a problem? Please describe. Gate needs a list of attendees that is formatted to expeditiously check-in attendees. They will be printing out the Guest List so need a quick way to scan for names.

We need a new format for the Guest List CSV, because the Gate Check App is not being used.

Describe the solution you'd like The following solution is a compromise between @mrwilldehaan 's suggestion, the needs of the Kid's Coordinator, and what information Ticket has available

Example CSV:

Name first last,Role,Early Access,Email,Arrival Time,Tent/car/rv + payment status
Will DeHaan,Lead Ccordinator,2,will@example.com,,
Will Dehaan Keanu Reeves,Guest,0,keanu@example.com,,
Will DeHaan Tom Cruise,Guest,0,tom@example.com,,
Yarun Luon,Planner,0,yarun@example.com,,
Yarun Luon Ima Kidd,"Kid, 10",0,,,
Yarun Luon Kid Name,"Kid, 6",0,,,
Explanation of column headers. Column Description
Name First Last. Either in the format of "SponsorFullName" or "SponsorFullname GuestFullName". A->Z order by Sponsor name
Role The role of the requester such as volunteer, planner, lead coordinator, skpper, other. Use Guest if the person is a guest of the sponsor, or Kid, [Age] if the person is a kid.
Early Access The number of early access passes associated with the Sponsor. Early Access passes can be transferred to guests at the Gate.
TicketBooth does not have the ability to assign early access passes to specific people. EA/LD Coordinator or Tickets may need to go in and manually assign EA-passes to individuals after downloading the CSV before giving to Gate
Email The email of the Sponsor and the Guest. Kids will not have an email.
Arrival Time Tickets does not have this information. Will be added by Gate.
RV Status Tickets does not have this information. Will be added by gate.

The Guest List CSV can be found under the "Guest List" tab in the Admin view image

Describe alternatives you've considered The Tickets Request CSV could be repurposed as the Guest List CSV, but it would require some spreadsheet transformations from the Tickets team. These transformations include JSON parsing so doable, but not ideal for spreadsheets.

Additional context The current format of the Guest List is

Current Format of Guest Names

image

The guest list can be up to 4 pages long when printed. The majority of attendees will be in the "Guest" columns. Scanning a 4 page document to find guest names is time consuming. This will generate long queues of people in their cars.

kigster commented 1 month ago

@yarunluon Why can't we print the sponsors name on every row so that everything is super clear?

Case 1: Ticket Requester + 1 adult guest + 1 kid

Ticket Request Payee,Guest Name,Role,Email,EA,Arrival Time,Tent/Car/Rv,Payment Status
Konstantin Gredeskoul,Konstantin Gredeskoul,Web Coordinator,kig@kig.re,3,,,Completed
Konstantin Gredeskoul,Taylor Swift,Guest,taylor@swift.com,3,,,Completed
Konstantin Gredeskoul,Channing Tatum,Kid,11,3,,,Completed

Case 2: Ticket Requester is not in attendance.

Ticket Request Payee,Guest Name,Role,Email,EA,Arrival Time,Tent/Car/Rv,Payment Status
Konstantin Gredeskoul,Eugene Miloslavsky,Guest,eugene@gmail.com,3,,,Completed
Konstantin Gredeskoul,Taylor Swift,Guest,taylor@swift.com,3,,,Completed
Konstantin Gredeskoul,Channing Tatum,Kid,11,3,,,Completed