Mailing Address Formatting Issues

Sounds like you might have the Address/Name fixing script in your LP_CUSTOMER_RANK procedure – as Tessitura doesn’t do that natively.

It was designed to fix bad data entry from the Web and was a popular shared report that many sites implemented. I can’t remember the ins and outs of the script, but it could possibly be modified to ignore accounts with a certain attribute. Unless your org would prefer to remove it completely instead of course.

Cheers

Sandra

From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Aaron Waapu
Sent: Wednesday, 10 September 2014 3:21 PM
To: Sandra Ashby
Subject: [Tessitura Customer Service Forum] Mailing Address Formatting Issues

Dear Community,

We have a strange occurrence when we're trying to save CAPITAL details in the 'Optional' field.
As an example, say we're trying to save the following: "ABC Alphabet", Tessitura will save this as "Abc Alphabet".

This is very embarrassing when we're sending direct mail and the formatting is a bit askew.

We've also noticed this happens with the Suffix in the Name section. Eg: "Aaron McBaron AO" will be saved as "Aaron McBaron Ao"

Is there an easy fix for these formatting woes?

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

If you in fact do have Brian Grundstrom’s famous procedure on your system (as we do), all you need to do is to put an attribute into the account telling the auto-correct feature to ignore the account. I don’t know what the attribute would be named on your system (ours is called Auto Address Correction, but we renamed it from whatever it was called in the shared report setup), but it exists in the T_KEYWORD table. The detail table is TX_CUST_KEYWORD, the detail column is !.key_value, and the ref table is TR_GOOESOFT_DROPDOWN. If you sort your columns in T_DEFAULT by the detail table column and then, holding your control key, sort by the ref table column, it should be easy to find. In our system, this attribute is the only one that matches this description.

Lucie

…I meant sort T_KEYWORD. Oy!