Jump to Content

Objective HTML

Google Maps for ExpressionEngine

The complete geolocation and mapping toolkit

Importer Reference

The .CSV import utility is a highly configurable utility that allows users to convert any .CSV into channel entries. The big different between this utility and the others are that Google Maps for ExpressionEngine will geocode the data from the .csv before the entry is created. These responses can be saved and then later searched. The importer can save people a lot of time when the situation arises.


ID required

This setting is required and assigns a human readable ID to each schema. Since you can create multiple data schemas, these ID's are used to keep things organized.

Back to Top


This setting allows you to override the delimeter, which by default is a comma (,).

Back to Top


This setting allows you to override the EOL (end of line) character, which by default is a newline and return character.(\n\r).

Back to Top

Channel required

You must select the desired channel in which you wish to upload your data.

Back to Top

Map Field required

If you want to use the fieldtype, you must select the desired map field in which you wish to store your geocoder response. If you map a latitude and longitude in the map field itself, these too will get populated.

Back to Top

Latitude Field required

If you do not want to use the field, you may store the coordinates in specified channel fields. Select the field you wish to store the latitude.

Back to Top

Longitude Field required

If you do not want to use the field, you may store the coordinates in specified channel fields. Select the field you wish to store the longitude.

Back to Top

Geocode Fields required

You can define multiple columns and fields to use for geocoding data. If multiple fields are defined, they will be concatenated with a space between each value, and then sent to Google as one string. If there is a problem with the location that is sent to the geocoder, it will be logged.

Back to Top

Author ID required

This is the author id that will be assigned to the imported entries. You must assign an author_id if you have no username stored in your .csv.

Back to Top

Username Column required

This is the name of the column in your .csv that stores the usernames. This allows you to import your data and not assign them all to the same author.

Back to Top

Channel Fields required

Use this field to pair up your channel fields with the columns in the .csv file. Be sure to make sure the names are an exact match. The fields do not need to be in any specific order.

Back to Top

Group By

This is the unique identifier for each row that will group your entries together. If there are duplicate rows, define the column in the .csv that stores the ID.

Back to Top

Duplicate Data

Defines fields and columns used to check for duplicate data. If multiple fields are defined, they must all match an entry to trigger an update vs. creating a new record.

Back to Top

Status required

This is the status that is assigned to each entry that is imported.

Back to Top

Title required

This is the title assigned to each entry. It can be a combination of channel fields, or a static string. The idea is use simple EE variables to build your own entry title. Be sure to use real fields from the channel you are importing.

	{your_channel_field_1} {your_channel_field_2} - {your_channel_field_3}
Back to Top

Title Columnrequired

This option allow you not use the dynamic title functionality, but rather store the title in a column in the .csv. Simply define the extact column name you wish to use to store your entry title.

Back to Top

Title Prefix

This is the prefix that gets prepended to the title if the title contains only numbers.

Back to Top

Category Column(s)

This is the name of the column(s) that stores the category. You can have a data file with categories stored in multiple columns, or just one.

Back to Top

Category Boolean Value for TRUE

If your catagories are stored in multiple columns, with the columns header being a category name, chances are the values are stored as boolean. So if "X" represents true what is the value of "X"? Leave the field blank if it does not apply.

Back to Top

Category Column Type

This is the type of data stored in the category column(s).

Back to Top

Create Category

Creates a category if one doesn't exist based on the category column type. Be sure your category is stored as a Category Name for the best results.

Back to Top

Category Group ID

If creating a category, you need to define a group_id to which it will be assigned.

Back to Top