Point of Interest CSV File Preparation

Uploading bulk POI files allows you to upload or replace multiple point of interests or addresses for a customer. The first row in a CSV file lists the field names for the object that you're processing. Each subsequent row corresponds to a record in Money Mobiliser. A record consists of fields that are delimited by commas. A CSV file can contain multiple records and constitutes a batch.

All the records in a CSV file must be for the same object. Note the following when processing CSV files:

Bulk processing does not support any delimiter except for comma.
All required fields when you create a record.
Files must be in UTF-8 format.

The POI data header must include:

customerid,location type,purge

For example:

1234567,7,true

This adds all the address to customer 1234567, the addresses are created with a location type of 7, and existing addresses of the same type with location type 7 are removed.

In addition to the header, the body of the bulk file should contain:

longitude,latitude,name,"extra"

The name entry is used for the name of the company, for example Star Bucks Coffee. The "extra" is optional and includes more details of the location, such as the 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"

Note: You can download pre-made CSV files containing coordinates for points of interest from http://www.poi-factory.com/.