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 don't match the values in the Lead Sources list, for example, typographical errors.
-
The lead source in your CSV isn’t in the Lead Sources list.
-
If Marketing Automation is enabled, you’ll find the list 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 your CSV to make sure every record has an email address in the email column, and that it’s in the correct format (for example, abc123@yahoo.com).
This entity already exists.
If you’re updating the external ID for leads, prospects, or customers, you’ll get this error if another entity 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.