Hi
We are re-developing our website and there is a change to SYOS. With new display we need to change the facility map to display the seats better for the customer. However, this affects productions that are currently onsale some of whcih have performance that are already selling right the way through 2012.
The physical seats aren't changing so will only require mapping seat_ids, performance_nos and zone_nos to new performances using the new facility map and was thinking of updating the following tables t_lineitem, t_sub_lineitem, t_transaction, t_order_seat_history and tx_perf_seat (with the EIS tables at later stage).
This has to be automated as much as possible as will probably need to do this a few hours before the new site launch, and while the existing site is switched off,
Is there a better or simpler way of doing this?
Thanks
Mark
Hey Mark,
I'm not 100% sure, but take a look at the Facility Setup Documentation, section 3 page 52.
Making changes to a facility in use.
There are a number of procedures you can run, which i've used many times.But again, i'm not sure if this will meet you exact needs.
James
I'm not sure if this would apply in your case, or how much of it you've already done, but if the issue is that the existing facility just visually on the screen doesn't look the way you want it to appear in SYOS, if you want to reorient the existing seats, but it's the same physical facility and same seat numbers, etc, rather than creating a new zone map, or a new facility, you could try just changing the x and y positions of the existing seats, and flip flop them with existing nonseats and just make the original facility look different.
Thank you.
Amanda, that sounds like it might be the solution.
We're in a similar situation where we will definitely need to create a new facility, or at least new screens in the existing facility to get the SYOS features we want. Got excited for a minute thinking about the possibility of doing all the switch over from the back end. I suspect there's lots of gotcha's in trying to make those kinds of changes through sql. As is, we're tentatively planning to use the new facility starting next season, and reseat all of the subscribers by hand after the rollover is finished this winter.
Not as fun as playing science fair in the database, but probably safer.
That said, if anyone's successfully switched facilities and changed existing orders to the new facility, I'd love to hear about it.