Realtime attendance monitoring

Mo, can you forward me a copy as well?

Thanks!

Randall A. Mitchell
Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mohiuddin Faruqe
Sent: Wednesday, January 07, 2015 10:02 AM
To: Randall A. Mitchell
Subject: Re: [Tessitura Technical Forum] Realtime attendance monitoring

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

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.aspx
but 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 presentation
http://www.tessituranetwork.com/tlcc/2014/pdfs/01-o_integrating_third_party.pdf
also 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.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

Mo, can you forward me a copy as well?

Thanks!

Randall A. Mitchell
Director of Information Systems | The Phoenix Symphony | Tel. (602) 452-0440 | Mobile. (602) 796-9323 | Fax. (602) 253-1772
RMitchell@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mohiuddin Faruqe
Sent: Wednesday, January 07, 2015 10:02 AM
To: Randall A. Mitchell
Subject: Re: [Tessitura Technical Forum] Realtime attendance monitoring

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

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.aspx
but 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 presentation
http://www.tessituranetwork.com/tlcc/2014/pdfs/01-o_integrating_third_party.pdf
also 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.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!