What does this Error in my import validation mean?

When importing information into Prophet you can run into certain errors during the validation process that you may not understand or which do not make sense to you. A specific example of this type of message is the error: Error

what-does-this-error-in-my-import-validation-mean-figure-1

A severity of Error indicates that the entire listed row will not be imported. The reason for this exclusion is listed within the Message area.

In the example above you can see that the Message area states “Duplicate row in the input file. The row will not be imported”. This means that the listed row, Row 28, has a duplicate/matching row within the same spreadsheet.

To resolve this:

  • Review the spreadsheet to determine where the duplicate row information is located and remove the duplicate.
    • For Contact this would be duplicated Prophet ID OR External ID OR First Name, Last Name, & Email Address OR First Name, Last Name, & Business Phone OR First Name, Last Name, & Home Phone OR First Name, Last Name, & Cell Phone.
    • what-does-this-error-in-my-import-validation-mean-figure-2
    • For Company this would be duplicated Prophet ID OR External ID OR Company Name.
    • what-does-this-error-in-my-import-validation-mean-figure-3
    • For Opportunity this would be duplicated Prophet ID OR External ID.
    • what-does-this-error-in-my-import-validation-mean-figure-4