Hello,
I was wondering if anyone in the netwok had worked with any scripts to automatically generate seasons and performances in their Test environment.
We set up a lot of performances in Test as we are building out new web functionality, and these performances are lost after a Live to Test copy down.
I was envisioning some SQL or API scripts which would automatically create test data for us.
Has anyone tried something like this?
Thanks,
Hi Deven,
I don't have a script that automatically generates performances, but for my season build this year I created a spreadsheet of performance information that I then imported into our mapping database and ran a script that generated performances from that data.
If you'd be interested in it, let me know and I can send it your way,
Dorothy
Hello Dorothy,
That sounds wonderful. If you could kindly send that script my way, it sounds like a great opportunity for me to make progress with my task.
With your permission I would evaluate and modify this script for use in our Test environments.
Thanks!
-DPitcher@CarnegieHall.org
Deven,
There is an available tool, the Multi-Event-Build utility, that's been in use at a number of licensees for some time, which can be used to build out performances en masse based on a template. It can't create the seasons for you but it can build a great many performances very quickly.
The Tessitura Technical Services team can assist with installing and configuring this utility.
Jonathan,
Thank you for this idea. My ultimate goal is to generate 1 performance in Tessitura for every "busseinss-logic-state" our performances could be in ex: presale X,Y,Z, Premium Ticket, Offsale, Sold Out, Limited Availability, Subscription, Promo Code, etc...
I'm hoping I could create saved templates for these types and then perhaps this tool would be useful. I'll be sure to look in to it.
Hey Jonathan,
I would be interested in talking with you more about this Multi-Event-Built utility. It would be VERY helpful for us at The 5th Avenue Theatre during season build out. Should I offline email you?
Christopher Cuhel
I should note for public consumption that the Multi-Event Build installation files are available in TASK as solution #105 in the Version Upgrades and Patches workspace: Multi-Event Build Utility
Thank you for sharing that Jonathan. :)
Christopher