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. Also very soon it will be possible to import data from GPX files that use different tracking applications or KML 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 or categories and attributes, respectively. For inspiration you can download sample files in CSV or XLS format.
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 Data Import. This map shows the import history map. Here, you can see imported imports as well as imported 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 format). There is also a choice of whether the file contains a header. Select this option to check if you have columns with their names titled. 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, typing or not finding the location). 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://pictures.superia.cz/1280/hamburger.png
Here, you will see all the attributes that are based on the map.
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)
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 is assigned and there is no mandatory field. If an assignment error occurs, the import tool will tell you which column the error is and what type 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 a site map page. 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 action will permanently delete all the places that created 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. When importing, new locations will not be created, but only original locations will be updated.
Sample file in. gsheet format
Sample file in .gsheet format (with help letter)
Sample file in .xlsx format
Sample file in .xlsx format (with help header)