The following table details some of the common data import errors that can occur and the recommended action to resolve them.
Error or symptom | Recommended action |
Import is taking a long time | We recommend a limit of 1000 rows per imported file. If more than 1000 rows are populated in the import template, break the file into subsets of 1000 rows each, uploading them one at a time. |
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. |