How to use the GeoJSON import and export feature

Maps Marker Pro allows you to easily perform bulk updates on markers by using the integrated import/export feature. Below you will find the documentation for these features. If anything is unclear, please open a support ticket at https://mapsmarker.com/helpdesk and we will be glad to help!

Attention: this tutorial is only valid up for Maps Marker Pro version 4.0 or higher – the tutorial for the (retired) CSV/XLS/XLSX/ODS import&export feature for version 3.1.1 or lower can be found at https://www.mapsmarker.com/import-export-archive


Supported formats

By default, the import and export feature only supports GeoJSON for export and import. You can convert your GeoJSON file to CSV or XLSX though and vice versa for better handling. 

How to convert GeoJSON to CSV or XLSX

  1. Go to http://www.convertcsv.com/geojson-to-csv.htm
  2. Select your GeoJSON input file:
  3. Choose the output options:
  4. Generate the output file:

    You can either save your output file as CSV or XLSX file by using the related buttons.

How to convert CSV to GeoJSON

  1. Go to http://www.convertcsv.com/csv-to-geojson.htm
  2. Select your CSV input file:
  3. If your CSV file does not have latitude and longitude values yet, you also need to open the output options and set which field contains the value latitude and which field contains the value longitude:
  4. Save your result as .geojson file in order to be able to use it later for the importer.

How to convert XLSX to GeoJSON

The process is similar to converting a CSV file to GeoJSON – depending on your input file it can be though, that the migration tool requires additional options:

  1. Go to http://www.convertcsv.com/csv-to-geojson.htm
  2. Select your XLSX input file:

    Due to a current bug in the migration tool, it can be that you see the columns A to K although the input option “First row is column names” is checked. To workaround this issue, please set “Skip # of Lines” to 1
  3. Generate the output by clicking the button “Convert CSV to GeoJSON”:
  4. Save your result as .geojson file in order to be able to use it later for the importer.

back to index


Copying maps from another site

If you want to transfer your maps from one site to another, it is recommended to use the “Backup/Restore database”-feature from the tools page:

back to index


Permissions / Capabilities

By default, only administrators can use the import and export feature on the tools page. If you want other users to also use these features, please navigate to Settings / Capabilities and enable the capability “Use tools” for the required role:

back to index


Export markers

Existing markers can be exported to GeoJSON format, which then can be converted to CSV or XLSX (see tutorials above).

In order to export your markers, please navigate to “Import & Export” and select the Export-tab first:

 

You can either choose to export all markers (default) or use the “Filter mode” to export markers from selected maps only or exclude markers from selected maps.

Finish the export by clicking the “Start export” button.

back to index


Import markers

You can use the import feature to bulk add or update markers. 

In order to import your markers, please navigate to “Import & Export” and select the Import-tab:

 

Choose your import file and start the import by clicking the button “start import”. The available options will be explained below.

back to index


Marker mode options

  • “Add markers”:
    Every entry in your GeoJSON file will be used to create a new marker.
  • “Update Markers”:
    If the ID of an entry in your GeoJSON file exists, the existing marker will be updated, if the ID does not exist, the marker will be skipped.
  • “Update existing, add remaining”:
    If the ID of an entry in your GeoJSON file exists, the existing marker will be updated, if the ID does not exist, a new marker will be created.

back to index


Geocoding options

  • “Off”:
    If the values for coordinates (latitude or longitude values) are missing, geocoding for this marker will be skipped
  • “Missing”:
    If the values for coordinates (latitude or longitude values) are missing, the address will be used for geocoding
  • “On”:
    The address given in the GeoJSON file will be used for geocoding, regardless of latitude or longitude values available (existing latitute and longitude values will be overwritten by the geocoding results).

Test mode

When running an import, by default the option “Test mode” is turned on:

It is recommended to first make a “dry run” with test mode on before turning it off. With test mode on, the import file will be checked for warnings and errors. You will be told exactly which values are not valid and be able to correct those before saving the changes to the database:
 
 
If no errors or warnings are found, set “Test mode” to “Off” and start the import again.
 

Error handling

We integrated several checks which should prevent the import to fail. Anyway if something goes wrong, you will be shown exactly what went wrong, e.g.

Available error messages

  • Security check failed:
  • File missing
  • File could not be read
  • File could not be parsed
  • Invalid GeoJSON
  • No geographical data found
  • Missing geometry type
  • Missing or incomplete coordinates
  • Missing address for geocoding

If you cannot resolve the issue by yourself, please open a support ticket at https://mapsmarker.com/helpdesk and we will be glad to help!

back to index


FAQ (Frequently asked questions)

How to assign a marker to a map when using the GeoJSON importer

If you want to assign a marker to a map when using the GeoJSON import feature, you have to add the map ID of the marker in the maps properties-attribute. Example where marker is added to the maps with the ID 1 and 2:

 
{
    "type": "FeatureCollection",
    "features": [
        {
            "type": "Feature",
            "geometry": {
                "type": "Point",
                "coordinates": [
                    "16.372500",
                    "48.208300"
                ]
            },
            "properties": {
                "id": "56",
                "name": "Headquarters",
                "address": "Main Street",
                "zoom": "10.0",
                "icon": "",
                "popup": "This is our company headquarters",
                "link": "",
                "maps": "1,2"
            }
        }
    ]
}

 

If marker should not be assigned to any map when using the GeoJSON importer, please use the value null

1
1
1921
Rate this FAQ answer

Thanks for your feedback, please add a comment to help us improve this post.

Can I use an export file from v3.1.1 or lower and import it in v4 or higher?

No, as v4.0 is a complete new plugin with an optimized database schema, (CSV/XLS(X)/ODS) import files created with Maps Marker Pro v3.1.1 or lower are not compatible with the import in Maps Marker Pro v4 or higher.

0
0
1871
Rate this FAQ answer

Thanks for your feedback, please add a comment to help us improve this post.

How do I convert other formats like KML to GeoJSON?

The free online tool at https://geoconverter.hsr.ch/ allows you to convert formats like KML and others into GeoJSON, which can then be used be the Import & Export tool in Maps Marker Pro:

2
0
1953
Rate this FAQ answer

Thanks for your feedback, please add a comment to help us improve this post.

back to index

1
0
1629
Rate this user guide

Thanks for your feedback, please add a comment to help us improve this post.