CSV Imports - Useful Tips
When importing a CSV file in GeoDirectory, there are certain tips to bear in mind:
- You cannot import abbreviated states; for example TX. You need to have the full names for states in the CSV file. The reason for this is simple -- abbreviated states, when imported, break Google Maps API calls.
- CSV file should not have blank lines.
- CSV file should not have #NAME as address. Even though it is theoretically not an error to have "John" as the address, it is an incorrect address that will break Maps API.
- Date should not be 00-00-00 -- perchance you do not have an expiry date, it is better to leave it blank than set it to zero.
Learn more about Importing and Exporting data here.