Contacts

Troubleshoot import errors

Last updated: July 25, 2019

When importing records into HubSpot, you may encounter errors. You can download an error file or view the error details to ensure that the import file was set up correctly or correct issues in Salesforce. 

File import errors

  • In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.
  • In the upper right, click Import.
  • Hover over a file import with errors and click the Actions dropdown menu, then select Download error file.
  • Extract the CSV file from the downloaded zip file, then open the CSV file.
  • In the file, identify the error code under the Error code header, the reason for the error under the Reason column, and the details of the object with the error in the subsequent columns.

The following is a list of error codes, details for the error, and possible steps for resolution.

Invalid Enumeration Option

Details: the import file contained an invalid value that does not match an existing option in the enumeration property. The import will still create or update a record, but the enumeration property will not contain a value.

Resolution: update your import file with the correct value and re-import the file, or update the property value in the affected record directly.

Failed Validation (Invalid Email)

Details: the import file contained an email address that did not conform to the format of a typical email address (e.g., name@domain.com). The import will not create a record or update an existing record. 

Resolution: update your import file with the correct email value and re-import the file.

Failed Validation (Deal Stage or Pipeline)

Details: the import file contained an invalid value for the Deal Stage property that does not match an existing deal stage in HubSpot. The import will not create a record or update an existing record.

Resolution: update your import file with the correct deal stage and re-import, or add the deal stage to HubSpot.

Could Not Parse Number

Details: the import file contained a value for a number property with non-numeric characters. The import can still create or update a record, but the number property will not contain a value.

Resolution: update your import file with the correct value and re-import, or update the property value in the affected record directly.

Could Not Parse Date

Details: the import file contained date values that did not match the format you selected during the import process. The import can still create or update a record, but the date property will not contain a value.

Resolution: update your import file with the correct value and reimport, or update the property value in the affected record directly.

Duplicate Row content

Details: the import file contained duplicate objects. The import will not create a new object.

Resolution: remove the duplicate in the import file and re-import.

Header and row sizes don’t match

Details: the import file contained data appears in a column without a header. The data under columns without headers will not be imported.

Resolution: ensure that the data in the column should be imported. If so, add an appropriate header to the import file and re-import.

Multiple companies with this domain

Details: the import file contained a Company Domain Name  value that matches multiple companies in your HubSpot account. The import will not update the company record.

Resolution: search for the Company Domain Name value in your companies dashboard to find the duplicate companies. Merge the company records or delete one of them, then re-import the file.

Invalid Alternate ID

Details: the import file contained an invalid value imported as an email address. The import will not create a new record or update an existing record.

Resolution: update your import file with the correct email value and re-import.

Unknown bad request

Details: the import file contained an invalid record ID that does not match any existing record in your HubSpot account. The import cannot update the record, as the data does not match any existing record.

Resolution: update your import file with the correct object ID.

Multiple owners found

Details: the import file contained an Owner value that matches more than one user. This usually occurs for names (e.g., there are two John Doe users in your HubSpot account, and the import file contained the name "John Doe"). The import can create a new record, but the Owner property will be left blank.

Resolution: update your import file by replacing the name of the owner with their email address and re-import the file, or update the property value in the affected record directly.

Invalid Object ID

Details: during the import, the checkbox to update existing records using object IDs was selected. However, the object ID listed in the file did not match an existing ID in HubSpot.

Resolution: ensure that the object IDs are correct. If you're not updating existing objects in HubSpot, do not select the checkbox during the import process.

 

Salesforce import errors

salesforce-import-errors-view-details

The right panel will show a description of the error, along with resolution information. You'll also see a list of records affected by the error. Click a record link to access the record and make changes as needed. 

salesforce-import-error-details