Hi everyone,
Does anyone have any experience with creating a report/procedure to alert us if a show is marked as sold out on TNEW?
I am hoping it's possible to copy the way in which TNEW determines there are no more available tickets for a performance and developing this into a stored procedure.
Thoughts?
One issue with reports in Tessitura is that you cannot (currently) trigger a report to run based on an event, rather they have to run on a fixed schedule. Also, there isn't a "only send report if there is output" option. So at best you could have a report that ran daily and showed a list of sold out shows, if any.
I've dug into capacity reporting in the past, but not recently enough to be helpful. I think the SOAP API documentation has stored procedures listed in it, so that would be your first place to look for clues on how availability is calculated by TNEW.
Thanks for the starting point, Gawain! I'll take a look.
If I go the report route I know it would just have to be periodically checked. A stored procedure that could send out alerts would be ideal although I imagine the set-up to be a little over my head.
Well, you could set up the procedure to check for a condition and if found, send something through dbmail. The procedure would be needed to run several times a day via a sql job, but it could be done
As usual, I'll mention that I published a toolkit for manipulating tessitura's report infrastructure to accomplish programmatic runs and conditional sending: https://bitbucket.org/TN_WebShare/report-server-tools (request access here). Would love to see it be used by other organizations, and receive feedback, bug reports, pull requests, contributions, etc!
I agree with this approach. Create a proc that determines inventory for perfs and do something such as, update content on tnew or email or more...
Set it up as a job and have it check every 15 minutes or so. Set and forget!