Order Import hold code issue

Hi Renu,

What is it you're trying to do?  Update the hold code via SQL rather than via Tess?

Martin

I wish to automate the entire order import. Doing set ups from front end is what I am trying to avoid. The tr_import_order_set has a particular hold code set up which doesnt always match up in seat map. This needs to be changed to match the tr_import_order_set hold code. I do it from tessitura front end and was asking if any one does it from back end?

Hi Renu,

Not sure if this helps, but you can have multiple hold codes defined as breakable in your import order set with a little extra configuration:

http://www.tessituranetwork.com/Help_System/Default_Left.htm#CSHID=TR_IMPORT_ORDER_SET|StartTopic=Content%2FOrder%20Import%2FCreating%20an%20Order%20Import%20Set.htm

The relevant info is under the hold code section.

We've automated much of the order import process to the point an agency just needs to send us a nightly email with that day's sales attached and the orders appear in Tessitura by the morning, but we still need staff to carefully set up the relevant system tables and ensure our ticketing build is correct. We don't do any programmatic manipulation of the performance we are importing into, for instance, hold code conflict might be an indication the agent is selling the wrong seat.

Cheers,

Patrick.

Sorry, URL got cut off, try this:

http://bit.ly/1oM5Bpp

Sorry, URL got cut off, try this:

http://bit.ly/1oM5Bpp

Hi Patrick,

Thanks for sharing this link. Using this documentation I can now define hold codes in TR_IMPORT_ORDER_SET system table which makes hold codes breakable while importing seats. 

Thanks again!

Renu.