Hello - we had an incident occur here where all tickets for a performance were reprinted 1 hour before the performance. To keep chaos to a minimum, we instructed front of house to tear tickets rather than scanning. Now we have all the reprinted tickets and all the torn tickets. Rather than someone matching ticket to ticket to ticket (ugh) we opted to program it in.
So we scanned all the torn tickets, ran an nscan report of the scanned tickets and I have the customer_no, order_no and number of scans (i.e. number of attendees) that I'd like to use to update the attendance in Tessitura.
Before I set about writing all this, I was wondering if anyone has ever done this and what the order of updating should be? Do I need to update T_ATTENDANCE and T_ORDER_SEAT_HIST or can I update one and it will carry over to the other? if now, which one should I update first or does it even matter?
Any advice or input is appreciated. Thanks all!
RJ
I had to do something like this when we had a gun that was off line. Below is the query I used to update T_ORDER_SEAT_HISTORY. I didn't update T_ATTENDANCE, just seat history. Someone else might have a more elegant way, but this worked for me.
INSERT INTO T_ORDER_SEAT_HIST (event_date, event_code, order_no, customer_no, seat_no, price_type, perf_no, pkg_no, ticket_no, amount, user_id, user_location )
VALUES ('2015-05-07','22','932596','948','6038','','4919','0','2150397','0','dbo','NSCAN'),
('2015-05-07','22','932596','948','6037','','4919','0','2150398','0','dbo','NSCAN')