This guide addresses common import errors users may encounter when importing files into their system. Each error is followed by a solution to help you quickly resolve the issue, ensuring smooth imports and accurate data handling. Follow the steps to troubleshoot and fix common import errors, making the process more efficient.
Q1: How do I fix the "Invalid option selected for multi-select or dropdown field" error?
A1: To resolve this error:
1. Check Your Import File:
Open the import file and review the values in the multi-select or dropdown fields.
2. Verify Options:
Ensure that the values match the options available in the system. If you find any mismatched options, either update them to match existing choices or add them as custom options in your system.
3. Re-import the File:
Once the values are corrected, save your file and re-upload it for import.
Tip:
Always double-check that the data in your import file aligns with the predefined values in your system to avoid mismatches.
Q2: What should I do if I receive the "Invalid Contact ID" error?
A2: To fix this error:
1. Check the Contact ID:
Verify that the Contact ID in the file exists within the system. If it doesn’t, the system will flag it as invalid.
2. Remove the Contact ID:
If you are not updating an existing contact, remove the Contact ID from the import file.
3. Re-import:
After correcting or removing the Contact ID, save your changes and try re-importing the file.
Tip:
Ensure that you are only updating existing contacts with valid Contact IDs to avoid this error.
Q3: How can I resolve the "Could Not Parse Date" error?
A3: To resolve this error:
Check Date Fields:
Open the import file and review all date fields.Ensure Correct Format:
Confirm that the dates are in one of the accepted formats:
mm/dd/yyyy
yyyy/mm/dd
mm-dd-yyyy
yyyy-mm-dd
Re-upload the File:
After correcting the date formats, save the file and re-import it.
Tip:
Be consistent with the date format used throughout the file to avoid parsing errors.
Q4: How do I fix the "Duplicate Unique Property Value" error?
A4: To fix this error:
Identify Unique Fields:
Check the fields in your import file marked as unique, such as emails or IDs.Look for Duplicates:
Search for any duplicate values in those fields.Remove or Correct Duplicates:
If duplicates are found, either remove or modify them to ensure each value is unique.Re-import the File:
After resolving the duplicates, save and re-upload the file for import.
Tip:
Always ensure unique fields contain no repeated values before importing to prevent this error.
Q5: What should I do if I get the "File Not Found" error?
A5: To resolve this error:
Check File Type and Format:
Verify that the file type is correct (e.g., .csv, .xlsx) and the format matches the system's requirements.Re-upload the File:
If the file is correct but was not uploaded properly, re-upload it.
Tip:
Ensure your file is in the correct format before uploading to avoid this error.
Q6: How do I fix the "Required Fields Missing" error?
A6: To fix this error:
Check for Missing Required Fields:
Review the file for missing mandatory fields like Opportunity Name, Email, Phone, or Name (depending on the import type).Add the Missing Fields:
Fill in any missing mandatory fields with the appropriate data.Re-import the File:
Once the required fields are added, save the file and re-upload it for import.
Tip:
Ensure all mandatory fields are populated before initiating the import to prevent errors.