The Power Add On allows you to import CSV files with several options. One of those options is “duplicates handling”. Duplicates handling determines how to deal with locations in your CSV file that may match pre-existing locations on your site.
The location imports have been updated with the Power add on in order to simplify and speed up the import process. The CSV file format remains as the preferred import method for locations.
CSV File Format
The CSV file should be a UTF-8 encoded file with proper quotes around strings and commas between fields.
Special characters should be stripped or converted to proper UTF-8 format. In our experience many applications such as Numbers and Excel will not strip special characters properly during a UTF-8 CSV file export. Google Sheets has been a good application for importing those CSV files and re-exporting them with special characters removed.
The CSV file must have a header row defining field names as the first row of the file. All other rows must contain proper CSV data. Rows cannot contain more columns (fields) that defined by the header row. That is often an indicator that special characters exist in your file and is used as a safety stop mechanism in the import processor.
CSV File Headers
All location import files must start with a field name header. This is the first line of the CSV file that contains the name of each locator field at the top of the column. The option to “not include a header + is no longer optional in the Power add-on.
Header field names are not case sensitive. The field names will be stripped of any character that is not a letter, number, hyphen, or underscore. If it makes your file more readable you can use a name such as “Address 2” which will be changed to “address2” , then the file is processed. Keep in mind the “sanitized key” version of whatever you use as the header MUST match the list of field names below. Continue reading “Location Imports With Power Add On”→