|
mbauercpc
|
July 22, 2016 at 11:51 am
Hello!
We have a unique situation where we need to generate hard copy tickets, as well as sell tickets online – therefore we need them to pull from the same database during checkin so we can utilize the app.
My question is: Is there a way to generate 8,000 Registration IDs to send to the ticket printing company without having to “purchase” 8,000 tickets in increments of 250 from the front end? The sessions frequently time out during requests of 200 tickets or more…even with increased input vars and execution time.
Is there some kind of database query we can run that will generate those in bulk for us?
Thanks!
Emily
|
|
Josh
|
July 22, 2016 at 2:13 pm
Hi Emily,
I’m afraid there isn’t a feature or a single database query that can do this correctly. There are a number of relationships between database tables (for the attendee, registration, transaction, ticket type/price, and datetime within the event) that all come together to give meaning to that Registration ID. So while a query could be used to populate the registrations table with more rows with unique registration codes, they wouldn’t be connected to any transactions, attendees, or the date time within the event.
|
