Common errors when importing CSV files
Description
Cause
Resolution

Expand the error message below

 

▼Not a valid column heading

Row 1 of the CSV file contains an invalid column heading.

The column headings must read as:

Column A = CODE

Column B = LEDGER NAME

Column C = CONTROL ACCOUNT

Column D = CATEGORY

Column E = PART RECOVERABLE PERCENTAGE

Column F = NON RECOVERABLE LEDGER ACCOUNT

Rename the column headings to match the list above and then try again.

 

▼CODE must be unique

Row 1 of the CSV file contains an invalid column heading.

The column headings must read as:

Column A = CODE

Column B = LEDGER NAME

Column C = CONTROL ACCOUNT

Column D = CATEGORY

Column E = PART RECOVERABLE PERCENTAGE

Column F = NON RECOVERABLE LEDGER ACCOUNT

Rename the column headings to match the list above and then try again.

 

▼Not a valid column heading

Row 1 of the CSV file contains an invalid column heading.

The column headings must read as:

Column A = CODE

Column B = LEDGER NAME

Column C = CONTROL ACCOUNT

Column D = CATEGORY

Column E = PART RECOVERABLE PERCENTAGE

Column F = NON RECOVERABLE LEDGER ACCOUNT

Rename the column headings to match the list above and then try again.

 

▼CODE must be unique

There’s a duplicated code within the CSV file. Check for duplicates in the CSV file and change the code in the indicated cell to a unique code. Try the import again.

 

▼Not a number

The indicated cell contains information in the wrong format. Change it to a number and try the import again.

 

Steps to duplicate
Related Solutions