I'm wondering if anyone has a script that can "undo" or "reverse" a ticket reprint? I've found an older thread that indicates someone has created something to help reverse a mistaken batch print.
In our case, a user accidentally reprinted an entire order, when they meant to only reprint certain parking tickets. They used order entry to reprint the tickets, not the batch printing module.
If anyone has something useful for a situation like this one, I'd greatly appreciate it.
Thanks,
Michael
Michael,
I might have what you need there. We had a situation where that exact thing happened. It was a 3 performance rental where the rental client took the entirety of the prime section of our main hall and distributed all the tickets to their subscribers months in advance. All the tickets were on the same order, and the morning of the first performance a box office staffer, after being asked to reprint one pair of tickets for a subscriber who lost theirs accidentally reprinted the entire order. The rental client started freaking out, and the box office was talking about just not scanning in tickets when they came to me.
So I wrote up a script that essentially just swaps out the currently valid tickets for the otherwise most recently valid tickets (in case of additional prior reprints of other tickets) for a given order number. So it would definitely need tweaking if you wanted to use this to undo a batch printing, but for a specific order, it should work just fine. Let me know if you are interested.
If so, you might want to test it first on an order in your test system. I have not had to use this in 3+ years. I do not believe there has been any changes in the table architecture behind this area of Tessitura, but, as I said, I have not used it in a bit so it might be good just to verify.
John
John,
Thank you for your response! This sounds like it's exactly what we need. The situations are even very similar to one another--ours was a comp order with a massive block of tickets given to a department head for distribution. I can use the exact order in the Test environment to make sure it works, too. Can you send to michael.dorsey@state.mn.us?
And thanks again for your help on NCOA updates. Works great!
John, Is there anyway we could get this? We are really in a bind. dharris@tpac.org
Michael, if you were able to get this from John...Could you please pass it along. My email is dharris@tpac.org.
This would be an amazing enhancement for Tessitura. For now can you please send to me as well.
jorosco@hgo.org
I just forwarded the script that John sent us to both Daniel and M. Jane. Good luck.
Hi John,
Could we get this as well? kcullen@capa.com
Thanks so much!!
Katie
Hello Kathryn, I just emailed you my version of John's script. I added to his script and added a ridiculous amounts of comments to help understand what the query is doing. This version also allows you to see the results of running the script before you commit/rollback the transaction.
Hey Neil,
Possible to get a copy? pfitz@cnu.edu
Thanks!
Just sent it J. Paul.
Hi Neil, Could you also send your version of the script to dlemak@wexarts.org?
Thanks!!
Debra, just sent it. Neil
John A. Moskal II - me again! Any chance you could resend this script to me at my new org? mdorsey@spoletousa.org
We just had a similar situation here, and I did not carry that script with me from the MN Zoo to Spoleto. Sorry to bother you with the same thing, again!
Neil Cole Hey Neil! I don't have this script anymore, can you send a copy if you have it? We just had a similar situation here.
Michael, I just sent it.Neil
I was out for a few days on vacation. Looks like Neil got you already; you still need anything from me, or are you good to go now? Happy to send if you still need anything.