Attendance for Special Access Areas

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 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.

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!