• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 27 views
  • Users 0 members are here
Related

What's base and what's custom in T_KEYWORD

Levi Sauerbrei
$organization

Is there a copy of, or a spreadsheet that lists what values are pre-populated in T_KEYWORD, T_KWCODED_VALUES, TR_QUERY_ELEMENT, and TR_QUERY_ELEMENT_PARAMETERS?  I'm no longer sure what records are original, which have been added and which have been modified.

 

Thanks

  • $organization

    There is not.  You can probably discern this though by sorting by the Create Dt or Last Update Dt column.  The Last Updated  By column should also be of some help.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Friday, February 05, 2010 2:10 PM
    To: Kevin Sheehan
    Subject: [Tessitura Technical Forum] What's base and what's custom in T_KEYWORD

     

    Is there a copy of, or a spreadsheet that lists what values are pre-populated in T_KEYWORD, T_KWCODED_VALUES, TR_QUERY_ELEMENT, and TR_QUERY_ELEMENT_PARAMETERS?  I'm no longer sure what records are original, which have been added and which have been modified.

     

    Thanks




    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!

    No virus found in this incoming message.
    Checked by AVG - www.avg.com
    Version: 8.5.435 / Virus Database: 271.1.1/2661 - Release Date: 02/05/10 07:35:00

  • Former Member
    Former Member $organization

    Hi Levi

    You probably should get yourself a fresh copy of the installation database to play with . It should contain the original data for those reference tables for comparison.

    We did that when we were doing a whole lot of testing in the context of moving the databases to a new server - Might be useful in Your Situation to have a reference copy to hand for other scenarios as well?

     

    Ken McSwain Business solutions Manager

    kmcswain@sydneyoperahouse.com

    T+61 2 9250 7876  F+61 2 9251 7821  M 0418 659 360

     

    SYDNEY OPERA HOUSE BENNELONG POINT

    GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

    SYDNEYOPERAHOUSE.COM

     

    Please consider the environment before printing this email.
=====This message is intended for the addressee(s) named and may contain confidential information.
If you are not the intended recipient, please delete it and notify the sender.
Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====