Hello all - I'm faced with a situation where a new fee needs to be added post haste (the money train continues to roll on each day) to all tickets going forward. We've established here that the easiest thing to do is to add $1 to an already exiting fee on all our tickets.
I tested it via a sql update on one performance on one zone and things were promising. However, expanding that to an entire production season seems to crash our database. Once the update is done, I cannot access any performances. I've also tried using the Season Manager - Season Maintenance way to update the prices - but that seems to throw an error when updating a goodly number of performances even across just one price type. I've heard rumors of a bug in v12.1 regarding Season Maintenance, so I've dropped that avenue since we cannot upgrade to 12.5 anytime soon due to productions in progress and a relatively new website still undergoing revisions.
This is all done in TEST, mind you - so it's not an emergency.
However, we have 291 performances we need to update with 21 different zones using 30 different price types. Is there a programmatic way to do this or should I just send the box office flowers and have them update the prices manually?
Any ideas? I have a script I've written for the test database - that seems to update the necessary table - which I'd be happy to send to anyone that might be able to help in case there is something in the script that is foul. Any assistance or input is greatly appreciated, all. Thanks!
RJ
Hi Brian – sounds exactly like the known issue. However, our production season schedule and work on our website have prevented us from upgrading to 12.5 any time soon, so any fix via upgrade or patch was not feasible at this time. We did the best we could with what we had and got through it.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Pedaci Sent: Wednesday, November 11, 2015 1:07 PM To: Richard Jackson <richardj@alleytheatre.org> Subject: RE: [Tessitura Technical Forum] Mass price increase in v12
This sounds like a known issue in 12.1.2, where copying a row of the price gri and then pasting it into a new row two times causes the error on the second paste.
If this matches your experience, the issue is resolved in the 12.5 release.
If this doesn't help explain, please open a help ticket and we'll be more than happy to investigate further with you.
From: John Moskal II <bounce-johnmoskalii7233@tessituranetwork.com> Sent: 11/11/2015 1:49:03 PM
Richard,
Did you ever get this solved? I would have responded earlier, but I was hoping another solution would occur to me, but alas none did.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!