• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 40 views
  • Users 0 members are here
Related

tr_citystate default indicator

Former Member
Former Member $organization

Hi,

We have two different cities with the same zip5 and default ind 'Y'.  If I change the default of one to "N", will that city-state no longer be assigned to new accounts with that zip5?  And will changing the default have any adverse impact on accounts with that city?

Thanks in advance for clarification.

Jeri

  • $organization

    Unknown said:

    We have two different cities with the same zip5 and default ind 'Y'.

    I believe this will cause a city to no longer be auto-filled for that zip.

     If I change the default of one to "N", will that city-state no longer be assigned to new accounts with that zip5? 

    No longer auto-filled/auto-assigned, yes.

    And will changing the default have any adverse impact on accounts with that city?

    No. We refresh TR_CITYSTATE regularly, and have many addresses assigned to city/zip combinations that are valid, but not defaults. No adverse impacts.

     

  • Former Member
    Former Member $organization
    Great, thanks so much Chris!
    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Thursday, August 18, 2011 3:08 PM
    To: Jeri Henderson
    Subject: Re: [Tessitura Technical Forum] tr_citystate default indicator

    Jeri Henderson:

    We have two different cities with the same zip5 and default ind 'Y'.

    I believe this will cause a city to no longer be auto-filled for that zip.

     If I change the default of one to "N", will that city-state no longer be assigned to new accounts with that zip5? 

    No longer auto-filled/auto-assigned, yes.

    And will changing the default have any adverse impact on accounts with that city?

    No. We refresh TR_CITYSTATE regularly, and have many addresses assigned to city/zip combinations that are valid, but not defaults. No adverse impacts.

     

    From: Jeri Henderson <bounce-jerihenderson2389@tessituranetwork.com>
    Sent: 8/18/2011 12:50:20 PM

    Hi,

    We have two different cities with the same zip5 and default ind 'Y'.  If I change the default of one to "N", will that city-state no longer be assigned to new accounts with that zip5?  And will changing the default have any adverse impact on accounts with that city?

    Thanks in advance for clarification.

    Jeri




    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!
  • $organization in reply to Chris Jensen

    Curious about refreshing tr_citystate: do you get new zips from a vendor? I'd love to have a regular way to update that table with data from USPS or something like that.

  • Former Member
    Former Member $organization
    I found out about the new zips from our ticket office then confirmed with USPS.  An automated way would be great and I would also be interested if anyone is doing that. 

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Friday, August 19, 2011 10:51 PM
    To: Jeri Henderson
    Subject: RE: [Tessitura Technical Forum] tr_citystate default indicator

    Curious about refreshing tr_citystate: do you get new zips from a vendor? I'd love to have a regular way to update that table with data from USPS or something like that.

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 8/18/2011 2:14:40 PM

    You're welcome!




    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!
  • $organization in reply to Brian Graham

    Unknown said:

    Curious about refreshing tr_citystate: do you get new zips from a vendor?

    We use zip-codes.com, which is a very reasonable source for a monthly downloadable USA postal code file. They have a lot of optional stuff, but we do the most basic subscription. Updating every month is probably overkill, but it's inexpensive and pretty easy to do.

    As far as my process goes, it's not completely automated: zip-codes sends me an alert e-mail, I download their newest data in XLS format, save it as tab delimited text, import it into a custom table via an SSIS package, and then massage it into a shape acceptable to TR_CITYSTATE. A quick truncate and insert, and our zips are up-to-date.

    Please e-mail me if anyone would like more details.

  • $organization in reply to Chris Jensen

    Thanks Chris!  Does anyone have a similar vendor for foreign countries? Formatting etc?