The items in this article refer to all import files. For specific tips and tricks for an individual import, refer to the imports tips and tricks file.
Avoid Commas - Import files are loaded as CSV files (listing of data records, where each column is separated by commas). Given that commas are used to separate the columns, they can't be used in number formats.
- 20275.25 (instead of 20,275.25)
If you need to include a comma (like in a company name for instance), then make sure it's enclosed in speech or quotation marks.
- example - "White Cloud, Inc"
These are the common error codes - and the resolutions for each: