Uploaded file has parse errors

Edit online

Files are scanned by the connector before they are loaded and parse errors are displayed in the Parse Errors page.

Problem

The Parse Errors page lists errors for an uploaded file.

Cause

The following list includes some of the possible reasons for parse errors:
  • A record row does not match the specification for a row.
  • Invalid date format was found in date fields.
  • Empty rows were found.
  • Some rows were skipped, in accordance with the specification.
  • Column header row was found.
  • A summary line with the total number of rows was found in the file.

Solution

Fix formatting issues and resubmit:
  1. On the File Processed - Accounts & Setup page, select a file and click Actions > View parse errors & skipped rows.
  2. Review the errors and correct the file as necessary:
    • Correct invalid date formats and ensure that rows conform to the specification.
    • Remove empty rows and summary lines.
    • Ensure that the header row is identified correctly and is not counted as a data row.
    Note: For parse and load errors, a maximum of 10 errors of the same type are shown on the page. The total number of errors of the same type is displayed in each message, for example, 8 of 24 errors of this type.
  3. Resubmit the file for loading.