We are using Tessitura to ticket a large-scale feast event, with capacity (weather-dependant) of up to 10,000 per night - with a combination of presales and door sales.Obviously for an event of this scale, crowd management is very complex - especially when it comes to selling door sales without going over capacity. What we really need is a realtime count of constituents currently at the event - eg people who have actually scanned their tickets in (and, if possible, discounting constituents who have scanned back out).There is a report that might be useable here:http://www.tessituranetwork.com/community/members/annieedlich6977/files/attendance-by-performance-ssrs-report-_2d00_-session-material.zip.aspxbut would that be real time? And would there be any way of tracking people who had scanned out, to keep a count of current attendees?This presentationhttp://www.tessituranetwork.com/tlcc/2014/pdfs/01-o_integrating_third_party.pdfalso seems to mention realtime attendance as a possible third-party messaging possibility, but doesn’t go into much detail. Is there a third-party system that would offer this functionality?Thanks!,Daniel.
Hi Daniel, long time ago I had created a SQL SP to be called by a SQL job at a fixed interval to send out real time statistics via email to the supervisors and Front of House managers who are in charge of the doors and ticket scanning so that they can reassign ushers based on the real time ticket scanning status. The proc just sits there and automatically kicks off one hour (adjustable) before any show start time and continues until 30 minutes (adjustable) after the show start time and send ticket scanning status every 10 minutes (adjustable). The advantage of this proc is you don't have to open Tessitura or any report to see the status. All you need is a smart phone with email access.
I had also presented it in one of the Tessitura magic sessions - may be you can still find the notes if you search in Tessitura network site. Or I can just share the code with you, if you are interested.
Best,
Mo
National Ballet of Canada
Hi all,Thanks, Michele - sometimes it's just a question of knowing the right place to look (and you're right, the house view is fun to watch).Mo, that sounds great - if you could send me the code I would really appreciate it.My only question now is about tracking people who have left, during a general admission event - so we have an accurate number of the people currently inside. Is it possible to track that - can people be scanned out? And if so, will these solutions count those?Thanks everyone!,Daniel.
You can definitely scan out, but I don't believe that is tracked on House View - at least there's nothing in the legend to indicate.
I looked in the NScan documentation and found this:
800x600
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
NOTE: Scanning a ticket out does not update Tessitura. The seat is still listed as Entered House. However, there is an N-Scan table which records tickets scanned out and records when the ticket is scanned in again.
Of course, it doesn't tell you what table that is!
Michele
Daniel/Randall, sorry for the late reply, I got caught up with few things. I found the mini magic presentation and other docs from the 2011 Mini Magic session and uploaded them to my profile. I wrote the stored procedure in 2008, so it's pretty dated. Anyway I updated it to reflect the new NScan table name. Check the Readme.txt for setup details. Please, feel free contact me if you need any clarification or help.