Guest List CSV

[yarunluon]

Instead of reopening #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

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

• Name (aka Sponsor or Ticket Requester)
• n-Guest names

Current Format of Guest Names

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]

@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