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?
…I meant sort T_KEYWORD. Oy!
______________________________
From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Lucie SpielerSent: Wednesday, September 10, 2014 2:52 PMTo: Lucie SpielerSubject: RE: [Tessitura Customer Service Forum] Mailing Address Formatting Issues
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
______________________________Lucie SpielerIT Development and Training Manager
Thank you Lucie, thank you Sandra! This has helped me a lot and now I know where to make some changes. Much appreciated!
Aaron.