Troublesbleshooting Bulk Imports via CSV

Use this guide if a CSV bulk import shows errors, warnings, or incomplete records after uploading contacts.

Note: If an error shows Line 1, it refers to the first contact row in your CSV file (not the header).

1001 – Unknown error
The system is unable to process the file due to an unknown error.
Your data was not imported.
​Fix: Confirm that your file meets all requirements. Try to re-import after clearing your browser cache or using another browser.

1002 – Multiple owners found in the system
The import file contains an Owner value that matches more than one user in the account. This usually occurs for names (e.g., there are two John Doe users in your account, and the import file contained the name "John Doe"). The affected records were imported, but the Owner's property does not contain a value.
​Fix: Replace the name of the owner with their email address in your import file, then re-import the file. You can also manually update the Owner property value in the affected records.

1003 – Invalid sheet count
The import file contains more than one sheet. Your data was not imported.
​Fix: Remove any additional sheets from your import file, then re-import.

1004 – Invalid required property
A required property in the import file contains an invalid value. The data in that row was not imported.
​Fix: Confirm the format requirements of your specific property or the property type, update your file to match the correct format, then re-import.

1005 – Invalid enumeration option
The import file contains a value that does not match an existing option in an enumeration property. This applies to multi-select, dropdown select, radio select, and checkbox-type properties. The affected records were still imported, but the enumeration property does not contain a value.
​Fix: Identify the incorrect value by comparing your import file against the property.. You can choose to update the value in your import file to match an existing option or add the value as a custom option to your property. Once you're done, re-import the file or manually update the property value in the affected records.

1006 – Invalid contact ID
During the import, the checkbox to update existing records using Contact IDs was selected. However, the Contact ID listed in the file did not match an existing ID in the software. The records were not imported.
​Fix: Ensure that the [object] IDs are correct. You may need to export your existing records to get the correct object IDs. If you're not updating or associating existing objects here, do not select the checkbox during the import process.

1007 – File not found
The file you selected was not found. Your data was not imported.
​Fix: Verify that you have saved your file to your computer and that it is the correct file type. Once you've done that, re-upload the file.

1008 – Failed validation of Email
The import file contains an email address that does not conform to the format of a typical email address (e.g., [email protected]). The import did not create or update the records.
​Fix: For contacts, update your import file with the correct email to make sure your format is correct with '@' '.com, then re-import the file.

1009 – Empty unique property value in the file
The import file contains a row with data that cannot be processed because there is no value against the record of its unique identifier (primary column).
​Fix: Verify that your data value matches the correct format for the property you are importing, then re-import the file. You can also manually update the property value in the affected records.

1010 – Duplicate unique property value
The same value of the primary column is present against multiple records. Your data was imported against all records but there may be duplicates of the same record
​Fix: Choose a different column header to act as your primary column or fix any mistakes, then re-import the files.

1011 – Duplicate unique property value in the file
The same unique value was used multiple times within your files. Your data was imported but there may be duplicates of the same record. If you were trying to associate, your records were not associated.
​Fix: Choose a different column header to act as your unique value or fix any mistakes, then re-import the files.

1012 – Duplicate Contact ID in the file
The same Contact ID was used multiple times within your files. The affected records were not updated or associated here.
​Fix: Update your import file so that there is only one row with that Contact ID. Keep the row with the most up-to-date information that you want to be included in your account. Once you've removed duplicates, re-import the files.

1013 – Could not parse the phone number
The import file contains a value for a number property with non-numeric characters or numbers not formatted as per E.164 format. The affected records were imported, but the number property does not contain a value.
​Fix: Update your import file with the correct numerical value and re-import, or manually update the property value in the affected records.

1014 – Could not parse the date
The import file contains a date value that does not match the format you selected during the import process. The affected records were imported, but the date property does not contain a value.
​Fix: Update your import file with the correct value and re-import, or manually update the property value in the affected records.

1015 – Could not find the owner
The import file contains a record owner that does not match a user here. The affected records were imported, but the Owner field does not contain a value.
​Fix: Update the data in the Owner column of your import file to include the first and last name or email of a user in your account. If the person you want to assign the record to is not yet a user in the account, add them as a user, then re-import with their name or email as it appears in the account.

1016 – Ambiguous enumeration option
The same record matches more than one of the existing options defined for an enumeration property. This applies to multi-select, dropdown select, single-choice select, and checkbox-type properties. The affected records were imported, but the enumeration property does not contain a value.
​Fix: Identify the incorrect value by comparing your import file against the property. Update the value in your import file to match only one existing option, then re-import the file. You can also manually update the property value in the affected records.

1017 – Location does not allow duplicate contacts

Fix: Use 1010 & 1011.

1018 – CustomField not supported

Fix: Validate while mapping itself - file and signature

1019 – Invalid Custom Field value

Fix: Use 1005.

1020 – Failed to create a contact

1021 – No email, phone, firstName and lastName, and type are created

1022 – Contact was not found

1023 – Failed to update a contact

1023 – Failed to add campaign/workflow