• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 42 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

Parents
  • 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!
Reply Children
  • $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.

  • $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?