Import Erroring out while using Skip First Line

Description of Issue

Excel or CSV file matches template and have imported in other files but this import is still erroring out instantly after define and execute.

Error Detail mentions a cell in Row 1 where the header row currently is in the file.

<Exception Type="Application" Message="DateTime data found with invalid format at cell D1, value: Y" Timestamp="2022-01-28 11:28:29.67000">

Context
  • Enterprise ERP Payroll

  • Employee Import

  • Import/Export

  • Flexible Templates

Cause

Import is not recognizing Skip First Line checkbox while defining the import.

Resolution

Remove the header from the import file completely and uncheck the Skip First Line checkbox.