• Replies 6 replies
  • Subscribers 415 subscribers
  • Views 143 views
  • Users 0 members are here
Related

Mass Format Change to Salutations

Matthew Hodge
$organization

Hi,

Our Development team just noticed that there were a few people where the standard salutation wasn't quite correct - in this case, people with the prefix "The Honourable".

If the prefix was "Mr", for instance, we could just use a Dear saluation of "Dear Mr Smith".

But you never say "The Honourable Smith". You would say "The Honourable Rob Smith".

Now, I can make a new salutation format without any trouble - what I wanted to know was if there was any easy way using SQL to change all our Honourables without having to go in, and right-click on the Gen. Sal. button on each record.

Or is that my only option?

  • $organization

    You should be able to do it with SQL.  I think you will need to update lsal_desc in tx_cust_sal.  Probably want to do it in test first to make sure. Sounds like you will need to concatenate salutation + t_customer.fname + t_customer.lname to get where you need to go, but it shouldn't be to tough.

  • $organization

    Or if you can isolate the ones that need rebuilding into a list, you can run UP_REBUILD_SALUTATIONS. See this document for more information.

  • $organization in reply to Levi Sauerbrei

    The procedure UP_REBUILD_SALUTATIONS will rebuild salutations using the defined format.  This procedure uses a list parameter as well.

    Check out the section on this procedure in the Tessitura Database Utilities documentation:

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Database%20Utilities.aspx

     

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Wednesday, November 25, 2009 9:52 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Ticketing Forum] Mass Format Change to Salutations

     

    You should be able to do it with SQL.  I think you will need to update lsal_desc in tx_cust_sal.  Probably want to do it in test first to make sure. Sounds like you will need to concatenate salutation + t_customer.fname + t_customer.lname to get where you need to go, but it shouldn't be to tough.

    From: Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com>
    Sent: 11/24/2009 10:12:24 PM

    Hi,

    Our Development team just noticed that there were a few people where the standard salutation wasn't quite correct - in this case, people with the prefix "The Honourable".

    If the prefix was "Mr", for instance, we could just use a Dear saluation of "Dear Mr Smith".

    But you never say "The Honourable Smith". You would say "The Honourable Rob Smith".

    Now, I can make a new salutation format without any trouble - what I wanted to know was if there was any easy way using SQL to change all our Honourables without having to go in, and right-click on the Gen. Sal. button on each record.

    Or is that my only option?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 in reply to Ryan Creps (Past Staff Member)

    Resurrecting a long ago conversation:

    When you invoke UP_REBUILD_SALUTATIONS, how does the procedure know which format to pick from TR_SALUTATION_FORMAT.  I had assumed that there would be a link between the records in TR_SIGNOR and TR_SALUTATION_FORMAT which would control this, but I haven't seen anything like that or anything the database utility that would let me specify it.

  • $organization

    Format would be picked up by the type of customer, as defined in tr_cust_type.

     

    From: Levi Sauerbrei [mailto:bounce-levisauerbrei8271@tessituranetwork.com]
    Sent: Friday, November 19, 2010 1:47 PM
    To: Lucie Spieler
    Subject: RE: [Tessitura Ticketing Forum] Mass Format Change to Salutations

     

    Resurrecting a long ago conversation:

    When you invoke UP_REBUILD_SALUTATIONS, how does the procedure know which format to pick from TR_SALUTATION_FORMAT.  I had assumed that there would be a link between the records in TR_SIGNOR and TR_SALUTATION_FORMAT which would control this, but I haven't seen anything like that or anything the database utility that would let me specify it.

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/25/2009 9:05:35 AM

    The procedure UP_REBUILD_SALUTATIONS will rebuild salutations using the defined format.  This procedure uses a list parameter as well.

    Check out the section on this procedure in the Tessitura Database Utilities documentation:

    http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Database%20Utilities.aspx

     

     

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Levi Sauerbrei
    Sent: Wednesday, November 25, 2009 9:52 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Ticketing Forum] Mass Format Change to Salutations

     

    You should be able to do it with SQL.  I think you will need to update lsal_desc in tx_cust_sal.  Probably want to do it in test first to make sure. Sounds like you will need to concatenate salutation + t_customer.fname + t_customer.lname to get where you need to go, but it shouldn't be to tough.

    From: Matthew Hodge <bounce-matthewhodge3604@tessituranetwork.com>
    Sent: 11/24/2009 10:12:24 PM

    Hi,

    Our Development team just noticed that there were a few people where the standard salutation wasn't quite correct - in this case, people with the prefix "The Honourable".

    If the prefix was "Mr", for instance, we could just use a Dear saluation of "Dear Mr Smith".

    But you never say "The Honourable Smith". You would say "The Honourable Rob Smith".

    Now, I can make a new salutation format without any trouble - what I wanted to know was if there was any easy way using SQL to change all our Honourables without having to go in, and right-click on the Gen. Sal. button on each record.

    Or is that my only option?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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 in reply to Lucie Spieler

    Thank you Lucie!  That was the missing piece for me.