Optional Address & Street 2 in V11 Migration

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

  • Former Member
    Former Member $organization

    Hello Nicholas

    You can rename the Street1/2/3 labels!

    Just CTL ALT Click on the label you wish to change and PRESTO! A pop up box will appear for you to change the label from Street 1 etc to Street Address (for example)

     

    Hope this helps!

     

    Cheers, Jade

     

    From: Nicholas Hudson-Ellis [mailto:bounce-nicholashudsonellis2615@tessituranetwork.com]
    Sent: Thursday, 27 September 2012 1:12 PM
    To: Jade Moore
    Subject: [Tessitura Next Generation Forum] Optional Address & Street 2 in V11 Migration

     

    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!

  • Nicholas

     

    If you do the following you can change it back to Opt. Address

     

    Press Control + Shift and Click on the Street2 field. A window should open and you should be able to enter your own label for this field. This will be changed for all users.

     

     

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Nicholas Hudson-Ellis
    Sent: Thursday, 27 September 2012 1:14 PM
    To: Sandra Ashby
    Subject: [Tessitura Next Generation Forum] Optional Address & Street 2 in V11 Migration

     

    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!

  • Thank you Jade and Sandra, that's supercool! I had not stumbled across that before, we must have that locked down to just users in the System Admins group!

    I suddenly feel the urge to move Street 2 to position 1, and rename it to 'Business Name' (to look nice below Business Title'), and then rename 'Street 3' to 'Street 2', does that sound crazy?

  • Former Member
    Former Member $organization

    Might be worth noting that you can only do this if you are logged in as System Admin!

     

    Cheers,

    Jade

     

    From: Sandra Ashby [mailto:bounce-sandraashby2064@tessituranetwork.com]
    Sent: Thursday, 27 September 2012 1:35 PM
    To: Jade Moore
    Subject: RE: [Tessitura Next Generation Forum] Optional Address & Street 2 in V11 Migration

     

    Nicholas

     

    If you do the following you can change it back to Opt. Address

     

    Press Control + Shift and Click on the Street2 field. A window should open and you should be able to enter your own label for this field. This will be changed for all users.

     

     

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Nicholas Hudson-Ellis
    Sent: Thursday, 27 September 2012 1:14 PM
    To: Sandra Ashby
    Subject: [Tessitura Next Generation Forum] Optional Address & Street 2 in V11 Migration

     

    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!




    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!

  • Former Member
    Former Member $organization

    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...

    LABEL USE ESAL2

    The default action of the system is to ignore the Salutation 2 field when generating label salutations, which also locks this field for editing on the General tab if the default salutation is a label salutation. Changing the default value to Yes causes the second salutation field to be included when generating salutations and makes the field editable on the General tab.

     

    Ken

     

  • Thanks Ken, I will share that with our key CRM users, very nice.

    I feel we will stick with renaming and moving Street 2 as this won't involve any aditional data mapping, but Salutation 2 will come in handy in the future I am sure, currently we have that made inactive.

     

  • 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...

    LABEL USE ESAL2

    The default action of the system is to ignore the Salutation 2 field when generating label salutations, which also locks this field for editing on the General tab if the default salutation is a label salutation. Changing the default value to Yes causes the second salutation field to be included when generating salutations and makes the field editable on the General tab.

     

    Ken

     

    From: Nicholas Hudson-Ellis <bounce-nicholashudsonellis2615@tessituranetwork.com>
    Sent: 9/26/2012 10:04:29 PM

    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.