Hello!
I'm wondering if anyone has found a way to track attendence for Special Access Areas using the Special Access Area feature of NSCAN. While Ticketed Events records attendence, as far as I can tell the Special Access Area only verifies criteria are met for entry.
Thank you,
Andrea
Ticketing System Administrator
National Geographic
After reading this thread, I opened a helpdesk ticket for clarification and learned the following:
All scans to Special Access areas are recorded in T_NSCAN_AREA_CONTROL - both successful ones and unsuccessful ones
When a successful Special Access area scan happens, an additional row is added to T_ATTENDANCE in addition to T_NSCAN_AREA_CONTROL. Mandy – To maintain pre-concert vs intermission attendance separate, I would suggest setting up two access areas. A record is maintained for each access area even when using the same ticket. I would also suggest reporting from the T_NSCAN_AREA_CONTROL table. We are in our second week of scanning for pre-concert lectures and update T_Special_Activity table nightly. So far we have not encountered any issues.
Jackie
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Mandy Jarvis Sent: Tuesday, September 29, 2015 3:51 PM To: Guy, Jackie Subject: Re: [Tessitura Ticketing Forum] Attendance for Special Access Areas
Hi Peter,
Thank you for your speedy response! I was thinking that we would have to run an update every 15 - 30 min in our case. Was this extremely complex to have set up or was it fairly simple?
Thank you again!
From: Peter Hussell <bounce-peterhussell5789@tessituranetwork.com> Sent: 9/29/2015 3:41:27 PM
Hi Mandy,
My understanding is that anytime you scan the same barcode for a special access area,be it a membership #, customer # or ticket #, it will overwrite the previous record in T_attendance (I hope someone from Tessitura will chime in if that is incorrect). Our solution to this is a simple nightly procedure that copies new and updated records from T_attendance and appends them to a local table. This will only capture the last update on a given day, but you could run the same procedure hourly (for example) to capture the detail of pre-show/intermission. I should note that we've done only a few tests of our setup and will not be doing it for real until our season starts in a week or so.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Jackie,
Thank you for submitting a ticket for clarification on my behalf! The two access area solution seems like a simple fix - I could then just have the person scanning change to the second access area directly on the device between pre-show and intermission. Assuming they remember, there shouldn't be an issue :).
I will talk to our tech team regarding reporting/requesting reporting from T_NSCAN_AREA_CONTROL; and will also look into the T_Special_Activity table - am I correct in my assumption that by updating T_Special_Activity nightly, you mean that you report from T_NSCAN_AREA_CONTROL, save the report as a List and apply that list as a criterion in the Manage Special Activity Utility?
Thank you again,
Mandy