EBS: Contact Upload Error Messages in Everbridge 360™

Topic

Contact Upload Error Messages in Everbridge 360™.

Description

There are two types of contact upload failures. The File Status indicates which type occurred: 

  1. Failed
    The file did not upload successfully. No records were processed.
Failed.png
  1. Done
    The file uploaded successfully, but some records may not have loaded or may have loaded with errors.
Done.png

When a CSV file containing Contacts is uploaded to Everbridge, the upload file is listed on the Contacts tab under the Uploads sub-tab in the Everbridge Manager Portal. Choose the User-added image icon next to the desired upload file to view the Upload Results page. See the two tables below for explanations of common issues and steps to resolve them.

Contact Upload Errors When the File Fails to Load

Error Troubleshooting Steps

Error Code: Encryption is Turned On but file is not encrypted or encrypted incorrectly

  • Error Description: Encryption is turned on but the file is not encrypted or is encrypted incorrectly
  • Error Message: Encryption is Turned On but file is not encrypted or encrypted incorrectly

This can occur if file encryption is enabled for the organization but the contact upload file is not encrypted or is encrypted with the wrong key.

  1. Navigate to Settings > Contacts/Assets > Upload Options.
  2. The File Encryption subtab will open by default.
  3. To continuing using File Encryption:
    1. Choose the Download button to download a copy of the Encryption Key. NOTE: Everbridge cannot troubleshoot encryption issues with any third-party encryption tools.
    2. If desired the option to Generate a New Key, which will render any upload files using the previous key invalid. Use with caution!
  4. ​To disable File Encryption:
    1. Change the Encryption Status option to Off.

Error Code: Required Column Not Found

  • Error Description: The file was not loaded because a required column is missing and/or the delimiter is not supported.
  • Error Message:
    • External ID
    • Record Type
    • First Name
    • Last Name

This error can occur because of one of the three root causes below:

  • Required Column Missing - The upload file is missing one or more required columns. The column may also exist in the file, but the header is missing or does not exactly match the required format.
  • Misspelled Column Header - Column headings must match the required format exactly, letter for letter and space for space. Unsupported headers must not be added to the contact file.
  • Delimiter Setting- If errors appear for all four required columns and the file was uploaded via SFTP, the Organization delimiter setting may not match the delimiter used in the file.
Error Message: Organization name required for account level upload: Organization Name

This error indicates that the Organization Name column header is missing from the contact upload file while the file is being uploaded at the Account level.

When contacts are uploaded at the Account level, the file must include an Organization Name column. Each contact record must also contain a value in this column.

Valid values are the names of the Organizations configured within the Account.

Error Message: Organization name is incorrect: Organization Name

This error means that one or more contacts contain a blank or invalid value in the Organization Name column and the contact upload file is being uploaded at the Account level.

When uploading contacts at the Account level:

  • Each contact must have a value in the Organization Name column

  • The value must exactly match an existing Organization name in the Account

  • The value is case-sensitive

(Other)

If the file appears to be formatted correctly or the contact upload is not listed in the Uploads tab, the following actions may help resolve the issue:

  1. Clear the web browser cache and cookies. Instructions for clearing the browser cache are available in the knowledge article EBS: The Manager Portal Page Is Not Loading Correctly in Everbridge Suite.
  2. Attempt the contact upload again using a different web browser.

Contact Upload Errors After the File Loads

Two types of record-level errors may appear when a contact upload file completes processing:

  • Loaded With Error - Records contained incorrect or incomplete data, but enough valid information was present for the contact to be loaded or updated. 

  • Not Loaded with Critical Error - Records containining critical errors will prevent the contact from being loaded or updated.

Records Loaded With Error

Error Message Troubleshooting Steps
Value is Invalid: Postal Code This error occurs when a US zip code is missing one or more digits. Often, zip codes that start with 0 will have the leading zero trimmed by Microsoft Excel. 
Value is invalid: Country Please ensure that the contact's value for the Country column is in an acceptable format. Values accepted can either be the two character alpha code as defined by ISO 3166 or the full country name as it appears in any Country field of the Everbridge Suite web portal. 
Phone number is not formatted correctly for specified country This error occurs when a phone number provided in the CSV upload file does not meet country-specific formatting rules. Phone numbers provided in an upload file are validated against formatting and rules specific to the country given for the phone number, and any invalid numbers will cause an error.
Phone column is empty for defined country This error displays when a contact record has a value in the Phone Country field but no value is in the corresponding Phone number field.
There are already too many addresses (5) for the contact This error occurs when an address is added to a contact record that already has the maximum amount (5) of addresses allowed. Addresses (or locations) are not overwritten during uploads, and must be removed before any new addresses are added. The following article describes how to remove location information: EBS: Deleting or Replacing Static Location Data for Contacts via a CSV Contact Upload in Everbridge Suite.
Additional Information/Attribute name is not defined This error means that the value given in the CSV upload file for an Additional Information field has not been predefined in the settings. Additional Information fields that have a display format type of 'Single Selection List' or 'Multiple Selection List' require that the values are predefined before they can be used in a CSV upload file. 
Additional information/attribute value is invalid This error occurs when a contact record in the CSV has a custom value entered incorrectly.
Additional Information and/or Attribute Name is not defined within this Organization This error means that the Custom Field name in the CSV upload file for an Additional Information field is misspelled or has not been defined in the settings. Additional Information fields must be defined in the settings before they can be used in a CSV upload file.
Value is invalid: Location Id {#}

This error can occur for a couple of different reasons:

  • Location ID Does Not Match Predefined Values - The location Id value given in the CSV upload file does not precisely match that of a predefined building External ID
  • Safety Connection Buildings Are Not Active - The organization does not include the Safety Connection premium feature. 

Value is invalid: Country

This error occurs when the value in the Country column is not in a supported format. Accepted values include the two-character ISO 3166 country code or the full country name as defined in the Everbridge Suite.

Value is too long: Groups:

This error occurs when a group name in the Groups column exceeds the maximum length of 260 characters.

Records Not Loaded with Critical Error

Error Troubleshooting Steps

Error Code: Missing value in the following required column: First Name

  • Contact Record Status: Not loaded - critical error

Ensure that each contact in the upload file includes a value in the First Name column.

Error Code: Missing value in the following required column: Last Name

  • Contact Record Status: Not loaded - critical error
Ensure that each contact in the upload file includes a value in the Last Name column.

Error Code: Missing value in the following required column: External ID

  • Contact Record Status: Not loaded - critical error

Ensure that each contact in the upload file includes a value in the External ID column.

External IDs must be unique for each contact and can consist of email addresses or other alpha, numeric, or alphanumeric combinations. Everbridge does not automatically generate External IDs during the upload process.

Error Code: Missing value in the following required column: Record Type

  • Contact Record Status: Not loaded - critical error

Ensure that each contact in the upload file includes a value in the Record Type column.

The Record Type identifies the type of contact being uploaded and is required for contact imports. A valid record type value must be provided for each contact record in the upload file for the upload to process successfully.

Error Code: Required column is not found in organization: Record Type:

  • Contact Record Status: Not loaded - critical error
  • Error Message: Record Type is Not Defined: Record Type: {Record Type name}

This error should only prevent specific contacts from being uploaded where the "Record Type" field contained a value not configured for your org. Check the Not loaded - critical error tab on the Upload Result page to see the list of contacts that had this issue.
If you wish to add a new record type to your organization:

  1. Choose the Settings tab from the top of the page.
  2. From the Organization tab, choose the Contacts and Groups menu.
  3. Choose the Contact Record Types menu option.
  4. Add the desired Record Type, then choose Add to save.
Error Message: Required column is not found in organization: External ID

This error occurs when a Delete upload is performed, but the External ID values in the CSV upload file do not match the External ID values for the contacts stored in the organization. 

This can occur in the following situations:

  • The contact was already deleted from the organization.

  • The External ID in the CSV upload file is incorrect or misspelled.

  • The External ID does not exactly match the value stored in the Manager Portal.

When using the Delete upload option, ensure that the External IDs in the CSV upload file exactly match the External IDs for the contacts in the organization.

NOTE: External IDs are required for a Delete upload to be successful, and the values must match exactly, including spelling and letter casing.

Error Message: Your file either contains line breaks or the number of columns does not match the number of headers

This error can occur for a few different reasons:

  • Line Break - A line break in the contact row in the CSV upload file.  The line break could be an unintentional Line Feed, Carriage Return, or 'enter' within the contact's row.   
  • Backslash - A backslash " \ " at the end of a value in the CSV upload file.
  • Empty Value - An empty value or cell at the end of a row in the CSV. This is expressed as a comma after the last value in a row. 
  • Comma in Value - A value in the CSV file that contains a comma and has no quotes around the value. 
Was this article helpful?
0 out of 0 found this helpful