I receive the following error message when running a data import task:

Header has an empty/null field.

This causes the import task to fail.

Perform one of the following actions to resolve the error by open the CSV file in a text editor;

• Remove the extra comma from the end of the column header row
• Remove the double quotes from the row of column headers
• Remove the invalid header column(FileColumName) from the CSV file

Check the end of each row of data as well to ensure any extra commas or double quotes are removed before re-importing the file.

The following are three possible causes of this error message:

• The comma-separated values (CSV) file contains an extra comma at the end of the column headers, which leads the site to expect an additional column name. When a null value appears for an expected column name, the data import task fails automatically.
• The entire row of column headers in the CSV file is encapsulated in double quotation marks ("). This also causes immediate failure of the data import task, as the site expects the full list of required columns for that CSV file; the site cannot recognize the long, encapsulated string as a column header.
• There is a FileColumnName included on the CSV which is not supported by the task per the realm's the Data Dictionary. There are values under the invalid header and the system cannot recognize the change requirement.

Catalog Management
Core Procurement > Core Administration > Core Administration Import/Export
Invoicing