Troubleshooting Import Errors
FollowThe 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. |
Product group name cannot contain commas | Remove any commas from your product group name. |