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
Hi Andrea!
We are in the process of starting to use Special Access Areas and I wondered the same thing. I would love to populate an activity on the patron account. Did you get any response on this or move forward in any way?
Jenny
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
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!
Thanks, both! I'll keep you posted if I am able to get this into an activity!
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.
Kevin, is this functionality only available in version 12?
Thanks,
Sabina
Something that's confusing me about Special Access Areas - do you have to have two barcodes on a ticket? If we are allowing XYZ constituency to access our lounge at intermission, do we have to have the standard ticket number bar code for them to get into the theatre and then a second barcode on their ticket to allow them entrance to the lounge?
I don't find the documentation surrounding this all that clear.
One more related question - will 'denied' access tickets to 'a special area' be recorded in V12.5?
Yes, this report is only available with N-Scan 6 and Tessitura v12.1 or higher
Thanks Jonathan. One further question if I might, does the subsequent scan of the entry into the special access area overwrite the data in T_Attendance for the seat scan?
Hi Michele.
No, if you scan the same ticket for both special-access attendance and performance attendance, you’ll get two rows in T_ATTENDANCE. Both will be populated with the qualifying ticket number and performance number, but on the row for special access area attendance, the area_no field will be populated with the ID for the special access area, where on a scan for performance admission that field will be NULL.
Another good table to check out with data for Access Area scans is T_NSCAN_AREA_CONTROL. All kinds of good info including scan messages, reason message, the area code and description, customer number, ticket number, perf no, etc.
No you do not. The Special Access Area reads the same barcode printed to allow entry to the performance, then checks the criteria in the TR_NSCAN_ACCESS_AREAS system table to determine whether this ticket holder belongs to one of the populations that are allowed into the access area.
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?
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.