Search our Help.

Troubleshooting Import Errors

Follow

Troubleshooting Import Errors 

The table details some of the common data import errors and the recommended action.

Error Recommended Action

Duplicate “[Product,Customer,Supplier]” codes

Update the duplicate values and ensure that they are unique.

Random Characters in Cell A1

Delete all random characters in Cell A1 prior to the asterisks (*).

Duplicate sales order transaction numbers 

Update the duplicate values and ensure that they are unique.

Mandatory fields missing 

Mandatory fields displayed with a * must have a value.

Date value formatting

Ensure the dates are formatted as dd/mm/yyyy.

The default template column headers are changed or deleted

The template columns cannot be changed or deleted. Compare to the templates provided within Unleashed

Data formatting (i.e; Excel converts long numbers to scientific category)

Ensure you change your data formatting to text format only.
Was this article helpful?
0 out of 0 found this helpful