Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add the unique ticket code into the downlad CSV file #9127

Closed
mariobehling opened this issue Mar 18, 2024 · 4 comments · Fixed by #9130, #9132, #9133 or #9134
Closed

Add the unique ticket code into the downlad CSV file #9127

mariobehling opened this issue Mar 18, 2024 · 4 comments · Fixed by #9130, #9132, #9133 or #9134
Labels

Comments

@mariobehling
Copy link
Member

mariobehling commented Mar 18, 2024

The CSV download file of the attendee list does not include the numbers on the QR Code. Please add this field "Ticket-ID".

The ticket ID has the following format: 135ccbd7-9b23-4a52-a7fd-326fec1b2c1c
Whereas the order has a format like this: #O1691408152-34896

Screenshot from 2024-03-18 11-40-16

Expected: The exported CSV should have a table column "Ticket ID" with the ticket ID number that is encoded in the QR code as well.

Screenshot from 2024-03-18 11-48-30

@ghost
Copy link

ghost commented Mar 19, 2024

Hi @mariobehling

I have a query:
When will the ticket ID column data be generate? when the ticket is created by events or when the attendee purchasing the ticket?

Please help me confirm it. Thanks

@mariobehling
Copy link
Member Author

I have a query: When will the ticket ID column data be generate? when the ticket is created by events or when the attendee purchasing the ticket?

Please help me confirm it. Thanks

The CSV is generated when the user (organiser) clicks "Export as CSV". Into this CSV generation process one column ticket ID is missing.

As you can see in the screenshot below. The web UI already shows the ticket ID in the table column "Order". Every order has an order number (it can be several tickets in one order) and every ticket has a ticket ID (the long string that we see also in the table).

Screenshot from 2024-03-19 10-17-44

@mariobehling
Copy link
Member Author

Currently the ticket ID and the QR code are 90% identical, but there is an additional number at the end of the ticket ID in the QR code which should not be there.

Ticket ID in download CSV: b8f78f85-b602-43dc-b639-fd2e5114de56
Ticket ID in QR code: b8f78f85-b602-43dc-b639-fd2e5114de56-960

Screenshot from 2024-03-21 09-59-36

@lthanhhieu Please compare here: https://test.eventyay.com/orders/b8f78f85-b602-43dc-b639-fd2e5114de56/view
(This is an old ticket from you)

@mariobehling
Copy link
Member Author

@lthanhhieu Ok, now I understand what happened. By deleting the last digits, now several Ticket-IDs have the same ID. For example see this:
Screenshot from 2024-03-22 19-11-17

This can happen if one person orders two tickets.

An order can be several tickets in one order, but every single ticket needs to have its own ID, e.g. imagine one order with 5 tickets. Each ticket should have its own ticket ID!

The ID of the tickets in the ticket list > must < be the same as the QR code. Therefore the solution to the problem here is:
a) to revert the last PR and re-add the unique number at the end. This number should be 5 digits e.g. "12345" to support events with more people. For example 0c6a220b-0aba-43f4-a454-f9018ef9e571-12345
b) Please change the system to generate QR codes that show the ID including the last digits, e.g. 0c6a220b-0aba-43f4-a454-f9018ef9e571-12345

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment