Uploading the USPS CITYSTATE Data to the Personify Database

The ZIP Code Upload process (ZIP100) uploads the latest United States Postal Service (USPS) data to the Personify APP_POSTAL_CODE table. This process utilizes the Address Information System (AIS) product CITYSTATE.

 

The USPS files (Address Information System (AIS) product CITYSTATE) will be ready for download from the TMA Resources FTP website on 25th of every month.

Note.pngPlease note this is NOT applicable to hosted clients as your file gets automatically downloaded every month.

The AIS CITYSTATE product’s CD-ROM contains a file consisting of a comprehensive list of ZIP codes with corresponding city names and state codes. The product is offered on an annual basis and is available on a monthly or bi-monthly update cycle.

 

For up-to-date AIS product information, visit www.usps.com.