We're trying find a solution that allows us to bulk change from one hold code to another on a performance.
I wrote this basic SQL update statement with the intent to create a custom utility that could be run via the application:
update tx_perf_hc
set hc_no =
from
where hc_no =
and perf_no =
It seems to work but I might be missing other tables that need updating as well?
Would love some insight.
Thanks!
Hi Wes,
I find an easy way to get an idea if anything else is happening is to use the Log Viewer in Tessitura (under the Help menu). Set it to trace, then do the thing in Tessitura you're trying to script (so in your case change the hold on a seat) then look in the log viewer output for what tables are updated.
CheersSarah
Hey Wes,
Not sure if you found a solution to do this, but a Utility has been developed that is used by a lot of Asia Pacific licensees to do exactly that and much more. It was developed to automate consignment of inventory (using hold codes) from one Licensee to another.
I'll see if our team can share it with you, if you're still looking for a solution?
BeauArts Centre Melbourne
I am interested in this utility/script if you have it.
We have a lot of hold codes that should have been blackout holds but were grouped in as house-seat holds. I'd love to retroactively apply the blackout codes to the shows that already on sale if there is a script to do this already out there.
Hey Beau,
Oh brother, I totally lost track of this thread. :/
I'd love to see that utility, if your offer is still on the table and your team is willing to share.
wes
Hey Sarah - again, just seeing this - missed it way back when you posted I'm afraid. That's a great idea, this will be very useful for a few other projects on the go.
Hi, if this is still on offer id love to get a copy as it sounds like the perfect solution to a project I'm working on.
IIRC We just ended up using a hold code map and used season manager to replace the holds