• 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

    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!

Reply
  • $organization

    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!

Children