General Relationship Import Errors
This section describes errors that you might see on a relationship import. See the following:
Invalid Lead Source Reference Key
The error can occur when importing entity records that include assigning lead sources.
Common causes of this error include the following:
-
The values in the CSV file do not match the values in the Lead Sources list, for example, typographical errors.
-
The lead source value in the CSV file does not exist in the Lead Sources list.
-
If Marketing Automation is enabled, the list can be found in Lists > Marketing > Marketing Campaigns. To add a new Lead Source, create a campaign.
-
If Marketing Automation is disabled, go to Setup > Sales > CRM Lists > New. To add a new Lead Source, click Lead Source.
-
-
The lead source value in the CSV file does not match the naming convention in the Lead Sources list. If the Lead Source name contains Campaign ID + Title, then the CSV file must have the same value.
For example:
1 LeadSource
34 OnlineForm
You have entered an Invalid Field Value incoming for the following field: email
When importing entity records or performing a relationship import type, the following error appears when you click Next on the Field Mapping page:
Column : Email. Value : null. Error : You have entered an Invalid Field Value incoming for the following field: email
Check the CSV file to ensure that an email address exists in the email column for each record, and its format is correct (for example, abc123@yahoo.com).
This entity already exists.
When performing an import to update the external ID of leads, prospects, or customers, the error occurs if there is another entity that already uses that external ID.
To find the record that uses that external ID, create a saved search for an entity:
-
Go to Lists > Search > Saved Searches > New.
-
Click Entity.
-
Enter a title for the search.
-
On the Criteria > Standard subtab, add the filter: External ID is XXXXX (where XXXXX is the external ID used in the CSV file that had the error)
-
On the Results > Columns subtab, add the fields to display in the search result, for example:
-
ID
-
Name
-
Type
-
-
Click Save & Run.
The duplicate external ID can be edited in the CSV file to add a character.