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.

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

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.

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

You're welcome!

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.

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.

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