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 John – I’ve tried this in the Season Maintenance view and end up getting the same error as when I tried updating the pricing. Attached is an image of the error. However, with the TASK system down, I can’t put a ticket in either. I was kinda hoping to code my way around this, but that didn’t work either. =(
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Moskal II Sent: Friday, October 30, 2015 4:30 PM To: Richard Jackson <richardj@alleytheatre.org> Subject: Re: [Tessitura Technical Forum] Mass price increase in v12
Could you use Season Manager - Season Maintenance to add a whole new price layer of your $1 fee to everything? It might seem like a little much to add a whole new price layer to everything just for $1, but it seems like that would work better than updating existing prices as you could just add the layer with all the existing price types and calculate it all up $1 (excluding the comps).
That is just off the top of my head; I am sure there are other solutions.
From: Richard Jackson <bounce-richardjackson6492@tessituranetwork.com> Sent: 10/30/2015 5:08:52 PM
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!
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 sounds like a known issue in 12.1.2, where copying a row of the price grid 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.