How to Fix Import Errors

Your data import failed or imported incorrectly.

Common causes

1. Column headers don’t match field names. HARi maps CSV columns to entity fields by header name. If your column says “Company Name” but the field is labeled “Company”, the mapping will fail.

2. Date format mismatch. HARi expects dates in ISO format (YYYY-MM-DD). Formats like MM/DD/YYYY or DD/MM/YYYY will cause errors or incorrect dates.

3. Required fields are empty. If the entity has required fields and your CSV has blank values in those columns, those rows will be rejected.

4. Lookup values don’t exist. If a field references another entity (e.g., Company on a Contact), the referenced record must already exist in HARi.

5. File encoding issues. Files saved with non-UTF-8 encoding may produce garbled characters or parsing errors.

Step-by-step fix

1. Open your CSV file and verify the column headers match the field labels in HARi exactly.
2. Convert all dates to YYYY-MM-DD format.
3. Ensure all required fields have values for every row.
4. For lookup fields, either import the referenced entity first (e.g., import Companies before Contacts) or use the display value that matches an existing record.
5. Save the file as UTF-8 CSV. In Excel: File > Save As > CSV UTF-8.
6. Re-run the import. Review the error report for any remaining row-level issues.

Also see Common Import File Format Issues for detailed formatting guidance.

Still stuck?

Download the import error report — it lists each rejected row with the specific validation error. Fix those rows in your CSV and re-import only the failed rows. If the error message is unclear, contact support with the error report attached.