Optional Address & Street 2 in V11 Migration

Thanks for the shout out, Ken IT God, but credit where it’s due – it was Byron at Opera Australia with the eagle eyes that spotted this in the help documentation, I merely implemented.

Cheers

Kim

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Ken McSwain
Sent: Thursday, 27 September 2012 2:04 PM
To: Kim Lee
Subject: Re: [Tessitura Next Generation Forum] Optional Address & Street 2 in V11 Migration

Hi Nicholas

We have a different change in place to hold business names.

We discovered that there is a magical code to use in the TR_SALUTATION_FORMAT table, which locks the value against being updated by the GenSal function. It's mentioned in the Help, but you have to read very carefully to see it. Luckily Kim Lee has eagle eyes.

If you put just an exclamation mark in the format field, that means 'Manual entry only", effectively, and locks the value to whatever is entered manually, protecting it from the dreaded Gen Sal.

So what we did was

• rename the Salutation 2 textbox as "Organisation", and 
• put a "!" in all of the individual Single Name L2 format fields in TR_SALUTATION_FORMAT. 

That gives us a Business Name field, effectively, although we had to sacrifice the L2 salutations - nobody in the UCSS consortium had a problem with that, but other orgs might feel differently.

You also have to enable the LSal2 field to be included in label salutations, in T_DEFAULTS, to make it editable..via this setting below...

Hello all,

I see that the 'Opt. Address' value in v10 is now 'Street 2' in v11. My org has used 'Opt. Address' for business names that needed to be in the postal address. That made sense when the business name was above the Street Address, but is now confusing when moved below.

I know that in T_DEFAULTS you can change the order of Street 1/2/3, but I am hesitant to create a potentially confusing view to the operator where Street 2 is above Street 1.

I am assuming that you cannot rename Street 2 to 'Business Name' or back to 'Optional Address'?

Has anyone else changed the order of the Street  and had good experiences, or found some interesting results to share?

Best,

Nicholas

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Click here to report this email as spam.

Thanks for the shout out, Ken IT God, but credit where it’s due – it was Byron at Opera Australia with the eagle eyes that spotted this in the help documentation, I merely implemented.

Cheers

Kim

From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Ken McSwain
Sent: Thursday, 27 September 2012 2:04 PM
To: Kim Lee
Subject: Re: [Tessitura Next Generation Forum] Optional Address & Street 2 in V11 Migration

Hi Nicholas

We have a different change in place to hold business names.

We discovered that there is a magical code to use in the TR_SALUTATION_FORMAT table, which locks the value against being updated by the GenSal function. It's mentioned in the Help, but you have to read very carefully to see it. Luckily Kim Lee has eagle eyes.

If you put just an exclamation mark in the format field, that means 'Manual entry only", effectively, and locks the value to whatever is entered manually, protecting it from the dreaded Gen Sal.

So what we did was

• rename the Salutation 2 textbox as "Organisation", and 
• put a "!" in all of the individual Single Name L2 format fields in TR_SALUTATION_FORMAT. 

That gives us a Business Name field, effectively, although we had to sacrifice the L2 salutations - nobody in the UCSS consortium had a problem with that, but other orgs might feel differently.

You also have to enable the LSal2 field to be included in label salutations, in T_DEFAULTS, to make it editable..via this setting below...

Hello all,

I see that the 'Opt. Address' value in v10 is now 'Street 2' in v11. My org has used 'Opt. Address' for business names that needed to be in the postal address. That made sense when the business name was above the Street Address, but is now confusing when moved below.

I know that in T_DEFAULTS you can change the order of Street 1/2/3, but I am hesitant to create a potentially confusing view to the operator where Street 2 is above Street 1.

I am assuming that you cannot rename Street 2 to 'Business Name' or back to 'Optional Address'?

Has anyone else changed the order of the Street  and had good experiences, or found some interesting results to share?

Best,

Nicholas

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Click here to report this email as spam.