Troubleshooting Import Errors
Follow
George Sutton
Updated : Created :
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. |
| Product group name cannot contain commas | Remove any commas from your product group name. |