Besides adding new places to your map manually, it’s also possible to batch import your data from Excel or Google spreadsheets. And beleive us…if adding tens or hundereds of places, this feature can save you quite some time!


With this new tool, it is not necessary to add places manually. The tool will also automatically update the map information. For that, you will need a well structured table in Excel, CSV format. It is also possible to use KML or KMZ formats to import data from Google “My maps”.



How to Import Data into Mapotic

Its easy to import data into Mapotic, here are step by step instructions.
Before you start working with an import tool, you must have a map that is first established properly.
To successfully complete the first steps, we recommend reading through the following instructions first. These instructions will guide you through the map settings and are important for import.

Once you’ve set up the map and the basic structure of the category and attributes you can import the data.

 

Create a file

To start the import process, you need to have a file containing geolocation data in CSV format ( UTF-8 encoding) . The file can easily be exported from a classic excel spreadsheet, XLS format. If you have source data in a different format, you can try to convert them to CSV using online converters. In this case, however, it is necessary to beware of the consistency of the data, which in some cases may distort the transfer. The structure of the file should match your map categories and attributes, respectively. For inspiration you can download sample files in CSV or XLS format below.

 

How to convert XLS to CSV

MS Office 365

Usually, you have data in an excel table, so it’s easy to convert the file to CSV format. You just click “File”> “Save As” and select Comma-separated values (.csv) from the menu. You can now use this file to import data into Mapotic.


Google documents

Use the following steps in Google Docs. “File”> “Download As” and select “Comma Separated Values” (.csv Current Sheet) from the menu.
How to Import Data into Mapotic

 

Using the import tool

In the left administration menu, select “Content” and “Data import”. Here you can see the history of imports.

To create a new import, click the “New Import” button. After pressing the button, you will be prompted to upload the file (the file must be CSV, KML or KMZ format). There is also a choice of whether the file contains a header. If you check that the file has a header, the import will ignore the first line of the source file and it will be able to read the correct data from the columns. 
Data Columns
Once you have uploaded the file, you will be taken to the import progress page where you will see several rows in your file. Here, you need to assign the individual data columns to the map data. Clicking the “Select” button will bring up a popup menu with the option of assigning data types. Data types are divided into several groups, “Compulsory Data”, “Geolocation Data”, “Special Data” and “Custom Data”.


TIP : If you do not import one of the columns, you can choose “Do not import” in the data type selection.


Mandatory data

  • Name – Place Name
  • Categories – Category to which a place belongs. Category must already be pre-established on the map
 

Geolocation data

The location of a map location can be determined in two ways, either by GPS coordinates (exact) or by address (less accurate, danger of misspellings and not finding the correct address). For successful import, at least one type of location determination must be completed.

  • Latitude – Latitude eg 50.120740
  • Longitude – Longitude in format eg 14.469517

Or

  • Address – in the correct format – Road / Town / PostCode
 

Special Data

  • ID – Unique location ID, ID can be updated in future locations (see import update)
  • Rating – Rating of places in format 1 – 5.

Main image

You can import a main image for individual places. It has to be a link to an image that is accessible for public. For example:

http://obrazky.superia.cz/1280/hamburger.png

You can also import images from Google Drive but you need to:

  • You need to use a link created with the Google Drive’s in-built Share feature that will create a working link for you. Just copy-pasting a link from your address bar will not work
  • When creating/copying a link to the image, make sure it is set to be shared for Public
  • You need to paste a link to the exact image you want to import – not a folder that’s containing the image
 

Custom data

Here, you will see all the attributes that are based on the map setting.
IMPORTANT : If you want to import multiple options for “Select” or “Multiple Choice” attributes, you should separate the options with an exclamation mark. (see sample file below)
TIP : If you do not have a given category or attribute on the map during the data pairing process, you can do so at any time and then return to the import menu in the Import menu.
Once you’ve successfully assigned all the columns, click the Import button. The import tool analyzes whether all data are assigned and there is no mandatory field missing. If an assignment error occurs, the import tool will tell you where and what kind of error it is. You can then simply repair your data in the source file and click on “Upload file again” on the import page.
If the analysis is OK, the “Import” button is activated. When you click Import, you will be redirected to the import progress page. Here are the possible reasons why import failed (these can usually be errors in image addresses, duplicate IDs, etc.). If errors occur when importing, correct the sample file and open an unfinished import on the “Import” page and upload the file again.
If the import is successful, you will be redirected to the main page of the map. Here you can quickly check that all the information about the places has been imported correctly.

 

Delete

If you have at least one successful import in the “Import” menu, the “Delete” action will appear in the action box. When you click on this action, you will be prompted to confirm the action, warning that this will permanently delete all the places created by the import. Be careful if you have also updated the location import, only new locations will be deleted and the updated locations will remain unchanged.

 



Updating existing locations
If you own a set of data that you regularly update in the source file, and you want to keep it up to date on the map, you will not have to delete it or edit it manually when you change it. It is important to assign a column with a unique ID when you first import a site. For each location, you must fill in the ID (values 1 – “n”). Every time you import the updated data, you need to keep this ID in place. Locations with the same IDs will be updated, not created again. 
Sample files
Sample file in. gsheet format
Sample file in .gsheet format (with help header)
Sample file in .xlsx format
Sample file in .xlsx format (with help header)

Related Posts

mpt-logo-white3_

Work with maps like never before. Build your structure, visualise data and let people interact. Use maps to get you mission fullfiled.

eu-logo
EUROPEAN UNION

European structural and investment funds Operation programme Prague – Growth Pole Czech Republic.

praha-logo
In 2020, the company Mapotic, s.r.o received support from the European Structural and Investment Funds, implemented through the Operational Program Prague – Growth Pole of the Czech Republic and drawn through II. call of specialized vouchers (reg. no. CZ.07.1.02 / 0.0 / 0.0. / 16_027 / 0000607). The support was aimed at the participation of the Mapotic s.r.o. at the Prague implementation site in order to increase the competitiveness. The expected output is innovation and launch of other services and products of the company.

© Mapotic 2020 All rights reserved.