Another salutation question

Jane, your question intrigued me, and I put together a query that would add a salutation to a group of customers. You could create a new salutation type of “web” and apply it to all accounts built by your web user, then set the salutation insert to run as a nightly job. Or if you want this salutation for all individual accounts, you could add it to those. This wouldn’t be the default salutation, but you could pull this type of salutation in your letters/reports/eblasts. The only thing a bit tricky about the code is that it requires a cursor so that it can put in a new salutation_no (and update the T_NEXT_ID table) for each row in the TX_CUST_SAL table that holds salutations, and it won’t insert a salutation if that customer already has a salutation of the same type.

I ran the code on my test system and added 20,000 salutations that are addressed to, say, “John” or “Mrs. Smith” based on whether or not there is a prefix in the account. The update took about 35 seconds. I’d be happy to share if you think this would work for you.

Lucie

______________________________
Lucie Spieler
IT Development and Training Manager

FLORIDA GRAND opera
8390 NW 25th Street
Miami, FL 33122

Direct Line: 305.403.3291
Switchboard: 305.854.1643 x. 1521
Box Office: 800.741.1010
To Give a Gift: 305.403.3315
www.FGO.org

2013-2014 | 73RD SEASON
A NEW VISION WITH PROVOCATIVE REPERTOIRE
MOURNING BECOMES ELECTRA • NABUCCO • TOSCA • THAÏS

Many of our new accounts get set up on the web, and get entered as "John Smith" rather than "Mr. John Smith".

We would like the "Dear" salutation to default to "John" if there is no title, but "Mr. Smith" if there is a title.  I've studied up on the documentation for TR_SALUTATION_FORMAT, but haven't found a way to do this.  Am I missing something, or has someone come up with a way to make this happen?

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

I just uploaded code that will allow you to insert specific salutations for all accounts built online (or within a date range or in a particular list, depending on how you edit the code) to my profile: http://www.tessituranetwork.com/Community/members/luciespieler8144/files/default.aspx

It’s called INSERT_TX_CUST_SAL.sql

This should be edited by someone who understands your database, and tested on your test system first, as it does add data to your database.

Lucie

______________________________
Lucie Spieler
IT Development and Training Manager

Florida Grand Opera

Thank you Lucie.

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dot Krebs
Sent: Tuesday, October 14, 2014 5:42 PM
To: Dot Krebs
Subject: RE: [Tessitura Development Forum] Another salutation question

Lucie,

Trying to do something similar in my system.  Would you share your code with me?

Thanks,

Dot