• Replies 7 replies
  • Subscribers 336 subscribers
  • Views 124 views
  • Users 0 members are here
Related

TR_COUNTRY phone and zip masking

Former Member
Former Member $organization

Hi,

Has anyone updated TR_COUNTRY so all countries have phone and zip masking?  If so, would you be willing to share since we want to provide database consistency and also include masking on our website.

Also, for our own clarification, was phone and zip masking supplied only for most commonly used countries?  Just wondering why the majority of countries do not have it.

Any insight on this topic is appreciated.

Thanks!

 

Parents
  • $organization

    You might find this page of Documentation helpful.

     

    http://www.tessituranetwork.com/Help_System_v125/Content/System_Tables/TR_COUNTRY.htm

     

    My sense is that you want to look at all of the following fields.

    Zip Mask – The format used when postal code data is displayed. The @ symbol represents a character of the data, all other characters are displayed directly. For example, a US address is formatted @@@@@-@@@@ which displays as 45215-7653.

    @@@@@@

    might work.

    Are there any spaces or other characters in there?

    Zip Editstring – The format to which postal code data must conform when entered. Edit strings are composed of # to represent a numeral, ! to represent an uppercase letter, ^ to represent a lowercase letter, and/or x to represent any character. Putting a tilde (~) before one of the special characters removes its function and makes it act like a regular character. For example, a Canadian postal code is formatted !#! #!# which translates to A1B 2C3.

    ####!!

    Or Maybe

    ####^^

    Zip Valid Lengths – The valid number of characters that can be used for a postal code. Multiple values can be entered, delimited by commas.

     

    6

     

    My table is currently not well filled out here in the US or I’d share mine.  If you get something that works for you I would love to have a copy so that I could add this to our table.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Summer Hirtzel
    Sent: Thursday, August 25, 2016 1:38 PM
    To: Thomas Brown
    Subject: RE: [Tessitura Technical Forum] TR_COUNTRY phone and zip masking

     

    Thanks everyone! This is all a little bit over my head, so could someone explain how to use this to get Netherlands addresses to work? Their zipcodes are alphanumeric -- 4 numbers followed by 2 letters -- so we're having some trouble getting a customer going on TNEW.

     

    Would I edit the Netherlands entry in TR_Country to have @@@@ in the Zip field?

    From: David Stadel <bounce-davidstadel1912@tessituranetwork.com>
    Sent: 2/25/2016 5:17:14 PM

    Sandra, this is great.  I appreciate the help!

    Dave

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sandra Ashby
    Sent: Wednesday, February 24, 2016 10:45 PM
    To: dstadel@milwaukeeartspartners.org
    Subject: RE: [Tessitura Technical Forum] TR_COUNTRY phone and zip masking

     

    Hi David

     

    This is what we mostly use in AUS/NZ if the country code is going to be used as part of the phone format. Just remember area codes have the zero removed when the country code is included (ie 02 becomes 2)

     

    The Ids used for States in TR_STATE for Australia are: NSW – New South Wales, SA – South Australia, VIC – Victoria, TAS – Tasmania, QLD – Queensland, ACT – Australian Capital Territory, WA – Western Australia. Note Western Australia has the same id (WA) as Washington and may cause an issue if you have any reports etc that just looks at id of the state and not in conjunction with the country.

     

    For NZ – there are no States. The city name goes in the State field, the City field is sometimes populated with the suburb of the city, if the city has  suburbs.

     

    A sample NZ address:

    ·         7 Waterloo Quay (street1)

    ·         Pipitea (City – which is the suburb)

    ·         Wellington (State – which is the city)

    ·         6011 (postal code)

     

    Hope that helps.

    Sandra

     

    description

    short desc

    phone mask

    Phone edit

    zip mask

    zip edit string

    phone code

    use state field

    require postcode

    zip valid length

    use avs

    require city

    New Zealand

    NZ

    +64 @@@@@@@@@@@

    +64 ###########

    @@@@

    ####

    NULL

    optional

    Y

    4

    N

    N

    Australia

    AUS

    +61 @ @@@@ @@@@

    +61 # #### ####

    @@@@

    ####

    NULL

    Yes

    Y

    4

    N

    Y

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Stadel
    Sent: Thursday, February 25, 2016 4:05 AM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: Re: [Tessitura Technical Forum] TR_COUNTRY phone and zip masking

     

    We ran into this a couple years ago and added the Netherlands.  Now we're looking at more of Europe, Australia and NZ.  Were you ever able to get a list a find a quick way to accurately populate the table? 

    From: Jeri Henderson <bounce-jerihenderson2389@tessituranetwork.com>
    Sent: 11/19/2010 10:20:07 AM

    Hi,

    Has anyone updated TR_COUNTRY so all countries have phone and zip masking?  If so, would you be willing to share since we want to provide database consistency and also include masking on our website.

    Also, for our own clarification, was phone and zip masking supplied only for most commonly used countries?  Just wondering why the majority of countries do not have it.

    Any insight on this topic is appreciated.

    Thanks!

     




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




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




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

Reply
  • $organization

    You might find this page of Documentation helpful.

     

    http://www.tessituranetwork.com/Help_System_v125/Content/System_Tables/TR_COUNTRY.htm

     

    My sense is that you want to look at all of the following fields.

    Zip Mask – The format used when postal code data is displayed. The @ symbol represents a character of the data, all other characters are displayed directly. For example, a US address is formatted @@@@@-@@@@ which displays as 45215-7653.

    @@@@@@

    might work.

    Are there any spaces or other characters in there?

    Zip Editstring – The format to which postal code data must conform when entered. Edit strings are composed of # to represent a numeral, ! to represent an uppercase letter, ^ to represent a lowercase letter, and/or x to represent any character. Putting a tilde (~) before one of the special characters removes its function and makes it act like a regular character. For example, a Canadian postal code is formatted !#! #!# which translates to A1B 2C3.

    ####!!

    Or Maybe

    ####^^

    Zip Valid Lengths – The valid number of characters that can be used for a postal code. Multiple values can be entered, delimited by commas.

     

    6

     

    My table is currently not well filled out here in the US or I’d share mine.  If you get something that works for you I would love to have a copy so that I could add this to our table.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Summer Hirtzel
    Sent: Thursday, August 25, 2016 1:38 PM
    To: Thomas Brown
    Subject: RE: [Tessitura Technical Forum] TR_COUNTRY phone and zip masking

     

    Thanks everyone! This is all a little bit over my head, so could someone explain how to use this to get Netherlands addresses to work? Their zipcodes are alphanumeric -- 4 numbers followed by 2 letters -- so we're having some trouble getting a customer going on TNEW.

     

    Would I edit the Netherlands entry in TR_Country to have @@@@ in the Zip field?

    From: David Stadel <bounce-davidstadel1912@tessituranetwork.com>
    Sent: 2/25/2016 5:17:14 PM

    Sandra, this is great.  I appreciate the help!

    Dave

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sandra Ashby
    Sent: Wednesday, February 24, 2016 10:45 PM
    To: dstadel@milwaukeeartspartners.org
    Subject: RE: [Tessitura Technical Forum] TR_COUNTRY phone and zip masking

     

    Hi David

     

    This is what we mostly use in AUS/NZ if the country code is going to be used as part of the phone format. Just remember area codes have the zero removed when the country code is included (ie 02 becomes 2)

     

    The Ids used for States in TR_STATE for Australia are: NSW – New South Wales, SA – South Australia, VIC – Victoria, TAS – Tasmania, QLD – Queensland, ACT – Australian Capital Territory, WA – Western Australia. Note Western Australia has the same id (WA) as Washington and may cause an issue if you have any reports etc that just looks at id of the state and not in conjunction with the country.

     

    For NZ – there are no States. The city name goes in the State field, the City field is sometimes populated with the suburb of the city, if the city has  suburbs.

     

    A sample NZ address:

    ·         7 Waterloo Quay (street1)

    ·         Pipitea (City – which is the suburb)

    ·         Wellington (State – which is the city)

    ·         6011 (postal code)

     

    Hope that helps.

    Sandra

     

    description

    short desc

    phone mask

    Phone edit

    zip mask

    zip edit string

    phone code

    use state field

    require postcode

    zip valid length

    use avs

    require city

    New Zealand

    NZ

    +64 @@@@@@@@@@@

    +64 ###########

    @@@@

    ####

    NULL

    optional

    Y

    4

    N

    N

    Australia

    AUS

    +61 @ @@@@ @@@@

    +61 # #### ####

    @@@@

    ####

    NULL

    Yes

    Y

    4

    N

    Y

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of David Stadel
    Sent: Thursday, February 25, 2016 4:05 AM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: Re: [Tessitura Technical Forum] TR_COUNTRY phone and zip masking

     

    We ran into this a couple years ago and added the Netherlands.  Now we're looking at more of Europe, Australia and NZ.  Were you ever able to get a list a find a quick way to accurately populate the table? 

    From: Jeri Henderson <bounce-jerihenderson2389@tessituranetwork.com>
    Sent: 11/19/2010 10:20:07 AM

    Hi,

    Has anyone updated TR_COUNTRY so all countries have phone and zip masking?  If so, would you be willing to share since we want to provide database consistency and also include masking on our website.

    Also, for our own clarification, was phone and zip masking supplied only for most commonly used countries?  Just wondering why the majority of countries do not have it.

    Any insight on this topic is appreciated.

    Thanks!

     




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




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




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

Children
No Data