How to use the GeoJSON/CSV 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 for Maps Marker Pro version 4.9 or higher!

The tutorial for version 4.0 to 4.8 can be found at https://www.mapsmarker.com/kb/user-guide/import-export-40-to-48/

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 supports GeoJSON and CSV for export and import.

back to index

Copying maps from another site

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

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 or CSV format.

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

Select the file type you would like to export, and optionally choose which 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 in CSV or GeoJSON format and start the import by clicking the button “start import”. The available options will be explained below.

back to index

File type

• Download example CSV (data from demo.mapsmarker.com)
• Download example GeoJSON file (data from demo.mapsmarker.com)

Additional remarks:

• A CSV file must contain at least latitude and longitude columns
• If other colums are missing, the values for new marker defaults are used

back to index

Test mode

Marker mode options

• “Add markers”:
  Every entry in your input file will be used to create a new marker.
• “Update Markers”:
  If the ID of an entry in your input 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 input 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 input 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).

Assign to map options

• “Off”:
  markers will only be assigned according to their assignment info in the input file
• “Missing”:
  markers with missing assignment info in the input file will be assigned to this map
• “On”:
  all markers will be assigned to this map, even if they have assignment info in the input file

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/CSV
• 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)

{
    "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"
            }
        }
    ]
}

back to index