Points of Interest CSV File Preparation
Uploading points of interest (POI) files in bulk allows you to create or replace multiple addresses for a customer. The first row in a comma-separated value (CSV) file lists the field names for the object that you are processing. Each subsequent row corresponds to a record in the database. A record consists of fields that are delimited by commas. A CSV file can contain multiple records and constitutes a batch.
- Bulk processing does not support any delimiter except a comma.
- Verify that all required fields exist.
- Files must be in UTF-8 format.
customerid,location type,purgeFor example:
1234567,7,trueThis adds all the addresses to customer 1234567; addresses are created with a location type of 7, and existing addresses with location type 7 are removed.
longitude,latitude,<name>,"<extra>"<name> represents the name of the company, for example, Walmart. The value of <extra> is optional; it may include details of the location, such as cross streets or an exact address. For example:
-85.206844,35.008629,"Walmart","Skurlock Rd & Cornelison Rd" -85.217847,34.998767,"Parkridge East Hospital","941 Spring Creek Rd"