Importing your data

If you subscribe to Emap Advanced you may have content stored in databases, spreadsheets, or other sources that you'd like to display on Emap; for example you might have a customer list or a set of assets at specific locations. You can import this content into Emap provided it has coordinate information associated with it and is in a file format Emap can read, such as a .csv file (comma separated values) which has uniformly fixed width fields up to 255 characters in length.

Click here to view how your file needs to be formatted.

For files containing addresses but with no X/Y co-ordinates or location references, you can contact our call centre on 0800 355 355 to discuss matching (or geocoding) of your address information (so they can be placed on the map).

To import data use the "Import your data" option in Emap.

To select a file to import first choose Tool box menu > Import your data.

You are then presented with the Import your data option.

To browse for a file to import

Select 'Upload File'

In the File Open dialog box, browse for your files with a .csv, extension. Once you've chosen a file, the Import Wizard will display that the file is uploading.

You should see the following results for your import.

Trouble shooting file importing

When importing a file you have to make sure your CSV or ZIP file have the correct fields for your data to be displayed with Emap. Emap has certain display fields which are listed below. If you put in 'Company Name' as a field, instead of 'Title' for example (which is the supported field), the import wizard will not recognise 'Company Name', the data cannot be mapped and therefore will not be displayed in Emap.

There are 14 fields available for imported data in Emap. These fields are used by CSV imports. CSV imports have an additional two fields to specify the coordinates of each imported point.

Only the field names below may be specified in the import file. Emap will not import a CSV file with unknown fields. The first row of a CSV file states the fields to be imported and their order.

Empty fields may be omitted. For example, if your data does not have any post office box information, then you do not need to include PO_BOX in your import data.

The maximum length of most fields is 200 characters. The exceptions are: ST_NUM is limited to 25 characters, DESCRIPTION and NOTE1 can import 255 characters each.

Text fields should be quoted. Emap will attempt to convert unquoted numbers into dates.

Field

Notes

Example

TITLE

The title is searchable within Emap. It also becomes the header of the data you have imported.

Te Papa

STYLE

The black default icon will be used unless one of the following (case sensitive) is used: style1, style2, style3.

Style for points as an example:

style1 = red dot

style2 = green triangle

style3 = blue square

REFERENCE

The reference is searchable within Emap.

Museum001

DESCRIPTION

Longer values can be entered in Emap but the import and export is limited to 255 characters.

Te Papa is New Zealand's national museum, renowned for being bicultural, scholarly, innovative, and fun.

ST_NUM

Street numbers may include units, such as 55a. This field is limited to 25 characters.

55

STREET


Cable Street

SUBURB


Te Aro

CITY


Wellington

PO_BOX


PO Box 467

CONTACT_PERSON


Wira Gardiner

CONTACT_DETAILS

This field usually contains an email address or a phone number.

mail@tepapa.govt.nz

VALUE1


$300 million

DATE1

Dates must be in one of the following nine formats: 31/12/99, 31/12/1999, 31-12-99, 31-12-1999, 31.12.99, 31.12.1999, 31-Dec-99, 31-Dec-1999, 311299.

14/02/1998

NOTE1

Longer values can be entered in Emap but the import and export is limited to 255 characters.

Te Papa is a landmark building in the heart of Wellington, with spectacular views of the harbour.

POINT_X

NZTM Easting coordinate.

1749210.1

POINT_Y

NZTM Northing coordinate.

5427470.2

What happens if my data doesn't have coordinates?

You can call our call centre here and they will be happy to help sort out the geo-coding of your data. Please call 0800 355 355.

Does Emap support different projections other than NZTM for import?

Emap does not currently support projections other than NZTM (New Zealand Transverse Mercator).

What if I want to change the fields to better reflect my data?

Emap can support alias fields, but for importing purposes you need to follow the above set of fields.

I've created a file based on your instructions but it still won't import?

Please give us a call if you are having difficulty importing your data. We have a set of messages that we can have a look at here to help ascertain what the issue may be.

Can I use symbols in Emap?

Use of symbols in imports is supported in text fields, such as the Description and Reference fields. It should also be noted that text fields need the contents quoted - i.e. "your data content goes here".

Is there a file limit when importing?

5mb of data is supported for Emap Advanced.

What happens if I import the same file?

Currently all imports are handled as "add to existing" import, that is data will be duplicated if it is the same as data that already exists in Emap. For example, if you already have data located at 6 Buick Street, and this is re-imported, 2 "Your data" items will exist at this location.

We suggest to avoid this duplication, that you do not import data that has already been previously loaded into Emap. We are working on offering a "replace all" or "append to existing" service in the near future.

What happens if I have imported my data but cannot see it?

You will need to refresh your application to see the imported data on Emap - this is simply done by a pan or zoom action.

Note: Emap does not automatically zoom to the location of the data that has been imported.