You can now import data into Mapotic from Excel or Google spreadsheets.
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.
Use the following steps in Google Docs. “File”> “Download As” and select “Comma Separated Values” (.csv Current Sheet) from the menu.
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.
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.
- Name – Place Name
- Categories – Category to which a place belongs. Category must already be pre-established on the map
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
- Address – in the correct format – Road / Town / PostCode
- ID – Unique location ID, ID can be updated in future locations (see import update)
- Rating – Rating of places in format 1 – 5.
- Image – The main image of the site in the link format eg http://obrazky.superia.cz/1280/hamburger.png
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.
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 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)