Hi all,
I understand we have Tessitura ticket numbers and Tessitura generated barcodes.
If we sent out 100 prepaid tickets, but want to see which one of those tickets actually entered the building. How would we do so?
For example, "Hey I have this barcode 12345, can you tell me if this is used yet?"
The seat status is "ticketed", but does that change to "entered house" when it's scanned?
Is there a table that shows a history of barcode scans?
-Allan
Hi Allan!
The seat status in your orders won't change, but you can view attendance history within the Ticket History tab (it has its own radio button) of the constituent's account. If you want to pull some fun data bits with SSMS, the table you're looking for is called T_ATTENDANCE. You can check their attendance date/time, and see where (or by whom, depending on how you use your scanners) they were scanned in based on the device used. The table also does include ticket_no, so you can pull just one ticket at a time if need be.
Best,
Darryl
For gathering scanned data, what's the difference between T_ATTENDANCE and T_NSCAN_EVENT_CONTROL? Perhaps one supersedes the other?
Thank you,
...Dave
David:
T_NSCAN_EVENT_CONTROL tracks every scan attempt for every barcode and ticket number, whether successful or not. T_ATTENDANCE contains only "good" scans - those that result in a valid admission. So the data in T_ATTENDANCE is a subset of that in EVENT_CONTROL.
To clarify, _EVENT_CONTROL tracks scanning of barcodes for the "Track Tickets" functionality. A partner table, T_NSCAN_AREA_CONTROL, tracks scans for special access areas.
Thanks Jonathan, very helpful. And timely. We’re getting ready to start scanning using access areas for the first time and I wasn’t aware of T_NSCAN_AREA_CONTROL.
This will be extremely useful!
…Dave