Does anyone have a custom utilty for the front end of Tessitura to unlock seats based on seat number?
Often patrons select the seats they want online then immediately call in to purchasse those seats. Instead of waiting out 30 minutes for the seats to automatically release, we would like our Box Office managers who do not have access to SSMS to be able to just enter the seat number into a utility and unlock it. Just wanted to see if any other organization had developed anything like this before delving into customizing something specific. Saw a couple shared reports in TASK, but nothing that specifically unlocked by that database seat number you see when you right click on the seat in the seat map.
Hi! We've got a custom utility that does exactly this. Do you want me to send you the files for it?
--Stacey
I'd love that utility too please!
I would love to take a look at it to...
I'd love to see it, too. Thanks in advance!
-Sheela
Oh, you guys, I'm so sorry to get everyone excited! I mis-read the original post. Our utility unlocks via the "locked by" number, not the database seat number (though the locked by number is found by clicking on the seat map). Also, it won't unlock an order that's held in an anonymous web user's cart if the time the seats have been locked is under the web timeout value from T_DEFAULTS -- so it won't really help with those customers who put stuff in their cart, then call you to buy the same seats.
Our utility is a slightly modified version of the Cleanup Connection utility available in Shared Reports. I'm still happy to send it to anyone who's interested, but wanted to make sure I let you know I had over-promised!
Thank you, Stacey. I think we going to end up customizing something since we are looking for a solution that unlocks while under that timeout value. Appreciate the response!