Troubleshooting steps for Importing Issues
Here’s a tip for anyone who may be experiencing an importing issue. Try these 3 troubleshooting steps below. The majority of cases we see fall into one of these buckets.
- Change your file to a Comma Separated Values (CSV) format. There are many versions of excel that format things differently and cause importing issues.
- Drop a sample of your import file into a notepad. Your file should not contain:
- Extra commas
- Invisible characters
- Symbols (e.g. $, %)
3. All dates should be in DD/MM/YYYY format (e.g. 14-Jan-2012)
Let us know your importing troubleshooting tips below!