EBS: Contact Upload Error Code: 'UPLOADCONTACT_ADDRESS_US_POSTAL_ERROR'

Error:

Contact Record Status:

Loaded with error

Error Message:

     UPLOADCONTACT_ADDRESS_US_POSTAL_ERROR: Postal Code {#}: {Zip code provided in file}

NOTE: Contact Upload file failure error messages may be viewed under ContactsUploads > User-added image. Clicking on the User-added image icon next to the desired upload file brings you to the Upload Results page where the error is displayed.

Root Cause:

This error occurs when a US zip code is missing one or more digits. This issue often occurs with zip codes that start with 0 and have the leading zero trimmed by Microsoft Excel. The Postal Code {#}: {Zip code provided in file} portion of the error message will let you know which zip code in the CSV upload file is missing digits. 

When preparing your CSV file for upload using a simple text editor such as Notepad, any leading zeros in the Postal Code or other columns should be preserved without taking any additional precautions.

Some spreadsheet editors such as Excel will format numerical values to drop leading zeros, which will prevent any postal codes with leading zeros from being uploaded to Everbridge (the contacts should still upload, but they will be missing postal codes).

Solution:

 Please make sure that the zip codes in your CSV upload file are complete. If the issue is caused by leading zeros being dropped, then follow these steps to format the postal codes correctly using Excel (other spreadsheet editors should have similar steps):

  1. Select the Postal Code column by clicking on the column header above the first row "Postal Code" cell.
  2. Right-click on any cell in the highlighted column, then choose the Format Cells option.
  3. From the Category menu, choose the Special option.
  4. From the Type menu, choose the Zip Code option.
  5. Choose the OK button to complete the formatting.
Format Cells

Please note that this will only set the cell formatting while you have the file open in your spreadsheet editor. Once your contact data is saved as a CSV file, all formatting will be removed. This is OK for uploading, but you will need to reformat the Postal Codes any time the file is opened in your spreadsheet editor.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.