• Replies 5 replies
  • Subscribers 339 subscribers
  • Views 41 views
  • Users 0 members are here
Related

Will Tessitura blow up if I change an order_dt with SQL?

Matthew Hodge
$organization

Quick question - my box office has asked me to change an order_dt on a particular order for a customer, but the order has been saved, so it can't be modified any further from within Tessitura.

The question is, if I update the order_dt via the back end in T_ORDER, will it cause any issues that I don't know about?

 

Cheers,

 

Matt

  • Former Member
    Former Member $organization

    Good day, Matt

     

    We’re relatively new to Tessitura, making the final switch this past July.

    Then, in July, we completed a messy rollover process.

    Because of the messy process, we had many orders with a “bad” order date (and bad data in other fields).

     

    Using SQL, I updated *many* fields in T_ORDER to clean things up.

    Unsure how others will respond, but we haven’t seen any negative effects.

    It certainly resolved problems with T-Stats.  Mgmt is finally seeing something useful.

     

    Let me know if I can help, and …

     

    Good Luck

     

    Wendell Baskin

    Bass Hall – Fort Worth

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
    Sent: Thursday, August 29, 2013 02:23
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Will Tessitura blow up if I change an order_dt with SQL?

     

    Quick question - my box office has asked me to change an order_dt on a particular order for a customer, but the order has been saved, so it can't be modified any further from within Tessitura.

    The question is, if I update the order_dt via the back end in T_ORDER, will it cause any issues that I don't know about?

     

    Cheers,

     

    Matt




    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!

  • $organization

    Hey Matt,

    I did a quick once-over in my most common order related tables and I *think* that order_dt is only stored in T_ORDER. But I haven't tried changing it myself. :)

    I am leaning towards agreeing with Wendell that it should be okay for you. But as always, test it first to be sure!!

    Good luck!

    Beth

  • $organization

    Particularly at season renewal time we have updated, cleared, and/or modified many order_dt's via SQL over the years. No issues.

  • $organization

    Ditto. Orders that get entered with order dates in 2016 I routinely edit via SQL.

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

  • $organization in reply to Lucie Spieler

    Thank you ladies and gentlemen of Tessitura, you are all champions!