In this video, you will learn how to access the error logs associated with a specific Contact Import Bulk Action and how to address and resolve any errors that may arise during the process.
Master Bulk Importing Error Code List
Error ID 1001:
Error code: Unknown error
What the error means: It cannot process the file due to an unknown error, and the data was not imported.
Steps to resolve the error: Confirm that the file meets all requirements, and try re-importing after clearing your browser cache or using another browser.
Error ID 1002:
Error code: The import file contains an Owner value that matches more than one user in the account.
What the error means: The affected records were imported, but the Owner's property does not contain a value.
Steps to resolve the error: Replace the owner's name with their email address in the import file, or manually update the Owner property value in the affected records.
Error ID 1003:
Error code: Invalid sheet count
What the error means: The import file contains more than one sheet, and the data was not imported.
Steps to resolve the error: Remove additional sheets from the import file and re-import. Review additional file requirements for importing.
Error ID 1004:
Error code: Invalid required property
What the error means: A required property in the import file contains an invalid value, and the data in that row was not imported.
Steps to resolve the error: Confirm the format requirements for the specific property, update the file to match the correct format, and re-import.
Error ID 1005:
Error code: Invalid enumeration option
What the error means: The import file contains a value that does not match an existing option in an enumeration property.
Steps to resolve the error: Identify the incorrect value, update the import file to match an existing option or add the value as a custom option, and re-import or manually update the property value in the affected records.
Error ID 1006:
Error code: Invalid contact ID
What the error means: The import file contains a Contact ID that does not match an existing ID, and the records were not imported.
Steps to resolve the error: Ensure the Contact IDs are correct, and if not updating or associating existing contacts, do not select the checkbox during the import process.
Error ID 1007:
Error code: File not found
What the error means: The selected file was not found, and the data was not imported.
Steps to resolve the error: Verify that the file is saved on your computer and is the correct file type, then re-upload the file.
Error ID 1008:
Error code: Failed validation of Email
What the error means: The import file contains an email address that does not conform to the typical format.
The steps to resolve the error are to update the import file with the correct email format and re-import or manually update the property value in the affected records.
Error ID 1009:
Error code: Empty unique property value in the file
What the error means: The import file contains a row with data without a value for its unique identifier (primary column).
Steps to resolve the error: Verify that the data value matches the correct format for the property and re-import or manually update the property value in the affected records.
Error ID 1010:
Error code: Duplicate unique property value.
What the error means: The same value of the primary column is present against multiple records.
Steps to resolve the error: Choose a different column header as the primary column, fix any mistakes, and re-import the file.
Error ID 1011:
Error code: Duplicate unique property value in the file
What the error means: The same unique value is used multiple times within the import file.
Steps to resolve the error: Choose a different column header as the unique value, fix any mistakes, and re-import the file.
Error ID 1012:
Error code: Duplicate Contact ID in the file
What the error means: The same Contact ID is used multiple times within the import file.
Steps to resolve the error: Update the import file so there is only one row with that Contact ID, and re-import the file.
Error ID 1013:
Error code: Could not parse the phone number
What the error means: The import file contains a value for a number property with non-numeric characters or numbers not formatted as per E.164 format.
The steps to resolve the error are to update the import file with the correct numerical value and re-import it or manually update the property value in the affected records.
Error ID 1014:
Error code: Could not parse the date
What the error means: The import file contains a date value that does not match the selected format during the import process.
The steps to resolve the error are to update the import file with the correct date value and re-import it or manually update the property value in the affected records.
Error ID 1015:
Error code: Could not find the owner
What the error means: The import file contains a record owner that does not match a user.
Steps to resolve the error: Update the data in the Owner column of the import file to include the user's first and last name or email, or add the user as a user in the account and re-import with their name or email.
Error ID 1016:
Error code: Ambiguous enumeration option
What the error means: The same record matches more than one existing option for an enumeration property.
Steps to resolve the error: Identify the incorrect value and update the import file to match only one existing option, re-import the file, or manually update the property value in the affected records.
Error ID 1017:
Error code: Location does not allow duplicate contacts - use 1010 & 1011
Error ID 1018:
Error code: CustomField not supported -> validate while mapping itself - file and signature
Error ID 1019:
Error code: Invalid Custom Field value -> use 1005 instead
Error ID 1020:
Error code: Failed to create a contact
Error ID 1021:
Error code: No email, phone, first name, and last name
Navigating to Error Logs for Bulk Actions:
Go to the "Contacts" section.
Select "Bulk Actions."
Choose the specific bulk action you want to review.
Click "Show Stats."
Click the three dots (ellipsis).
Select "Show Error Log." This will direct you to the list of errors during the CSV import.
Accepted Custom Field Format Requirements
Depending on the records you are importing, your file could include the following columns:
Date Picker:
Acceptable formats for date entries are mm/dd/yyyy (e.g., 10/28/2020) and yyyy/mm/dd (e.g., 2020/10/28).
You can also use alternative separators like '-' or '.' instead of '/' to represent the date (A feature available in our future release!).
Multiple Options, Checkbox, Textbox List:
Acceptable formats for multiple options, checkboxes, and textbox lists are values separated by commas (e.g., Blue, Yellow, Green) or other separators like ';', '.'.
Radio, Single Option:
The acceptable format for radio or single option fields is a single value (e.g., Blue).
File Upload, Signature:
Not supported in the import process.
Contact Owner:
To assign an owner to your contacts during the import, use the name of the 'User.'
Acceptable formats are FirstName LastName (e.g., Logan Paul or logan paul) or LastName FirstName (e.g., Paul Logan or paul logan).
Note: The system will not recognize the owner if both first and last names are not provided.
Tags:
Acceptable tag formats are values separated by commas (e.g., Blue, Yellow, Green) or other separators like ';', '.'.
Tags (example formats):
DoNotDisturb:
Acceptable formats for DoNotDisturb field are True or False (true or false) or Yes or No (yes or no).
Phone Number:
For most cases, use E.164 format (e.g., +1 1234567890) for phone numbers. The system will recognize it as valid, regardless of the default country setting at the sub-account level.
If the default country is set to the US, other formats like 123-456-7890, (123) 4567890, and 1234567890 will also work fine.
For international numbers, checking the format using a tool like https://libphonenumber.appspot.com/ in conjunction with country codes is recommended.
Numerical:
Acceptable formats for numerical fields include 1.23.4, 1234, and .123.
Monetary:
Acceptable formats for monetary fields include 1234 and 1,234,234,333.