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
Special access area attendance data is recorded and you can report on it. From the Special Access Areas help topic: NOTE: Entry counts for special access areas are recorded in the T_ATTENDANCE table. To report on special access area entry data see the N-Scan Attendance Scan report. Kevin Sheehan Senior Technical Writer & Consultant Tessitura Network +1 888 643 5778 x 329 ksheehan@tessituranetwork.com 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!
Special access area attendance data is recorded and you can report on it. From the Special Access Areas help topic:
NOTE: Entry counts for special access areas are recorded in the T_ATTENDANCE table. To report on special access area entry data see the N-Scan Attendance Scan report.
Kevin Sheehan
Senior Technical Writer & Consultant
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com
Thanks, both! I'll keep you posted if I am able to get this into an activity!
Jenny
We are also looking at using special access area scanning to track attendance.
Unfortunately, it seems the T_Attendance table overwrites records with the same customer no and access area if you are scanning bar-codes of customer numbers. If your bar-codes are setup for ticket numbers or membership numbers, I assume you'd see the same behavior on a per ticket or per member card basis. Maybe not a big issue if you are scanning tickets, because each ticket is only used once, but in our case we are scanning customer numbers on a member card for lounge access, meaning the same customer will be scanned many times over the course of a season, but only one record will be updated in T_Attendance.
To solve this we are considering a nightly procedure that copies new records and appends them into a local table. this would preserve each days worth of scans for analysis later. presumably you could do something similar to update a field on the constituent record.
Hi Peter,
We are about to begin using NSCAN for special access areas at our venue for entry into our donor lounge as well. However our donor events take place for an hour prior to the performance and during intermission. We would like to scan them in at both times and would like to know which donors showed up during which portion of the event (i.e. we would want two separate scan entries for someone who arrived prior to performance and then returned at intermission).
Based on this need, I was curious as to whether Canadian Opera Company has taken any further steps towards the nightly procedure to append to a local table that you mention in your post?
Thanks,
Mandy
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.
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!