First journal line is excluded from import when using Standard Excel import template - Header was removed from import file

Description of Issue
  • User imports a journal using the standard excel import format in Import Journals
  • User removed the header from import file
  • User is expecting first line to be included
Context

Import Journals

Standard Excel Import Format

Cause

Header was removed from import file

Resolution

To resolve:

  1. Highlight and copy the import lines
  2. Paste the lines (values only) to the second row of a new Standard Excel import template 
  3. Do not delete the headers when saving the Excel file  

Rerun the import process 

Additional Information

Skip first line cannot be unchecked when Standard Excel is selected for the Import format