Error:

Contact Record Status:

Error Message:

• Required Column has NULL value: External ID:
• UPLOADCONTACT_FIRSTNAME_EMPTY_ERROR: First Name
• UPLOADCONTACT_LASTNAME_EMPTY_ERROR: Last Name
• UPLOADCONTACT_RECORD_TYPE_NULL_ERROR: Record Type:

NOTE: Contact Upload file failure error messages may be viewed under Contacts >  Uploads > . Clicking on the . icon next to the desired upload file brings you to the Upload Results page where information about the upload is displayed. Next, select the Not Loaded - critical error tab to see the contacts with the error. 

Root Cause:

This error means the contact record in the upload file is missing one or more required fields (First Name, Last Name, External ID & Record Type). Check the Error Message column for the contact to see which required fields are missing a value. 

Solution:

Update the contacts in the upload file with the missing required fields. The solution is best illustrated with an example.

Example 1:

For example, the following file would cause these errors:

Note that one contact is missing all four required fields and the other contacts are each missing one required field. The solution in this case would be providing a value for each of the required columns (First Name, Last Name, External ID & Record Type) for each one of the contacts. The file example below has the missing values corrected.