This article covers Exporting and Importing Your Markers with the WP Google Maps Pro Addon. This feature requires WP Google Maps Pro. This documentation is current for WP Google Maps version 6.
With WP Google Maps, you can export and import your marker data. This allows you to update your markers with quick editing and to move your marker data from one site, to another. This document is based on Version 6 of WP Google Maps.
Exporting your Markers
Export your Marker Data to a CSV file.
Select the Marker Data tab
To export your data, select the “Download ALL marker data to a CSV file” option.
Editing your Markers
Open your CSV file in Excel or an equivalent program for quick editing. We suggest using Google Sheets. Using Excel or a Mac may insert extraneous characters upon download.
Your marker data should display as follows:
Your column heading must be in row 1 of the sheet, starting with id and ending with other_data.
The horizontal order of your columns are as follows (no caps):
(For the purpose of readability, these fields will be explained in two tables below. However, please note that your marker data must identical to the horizontal structure and order indicated in the image and information above.)
- id: Your id column must be blank before saving your marker data.
- map_id: Each line MUST have a “map_id” assigned to it. This is the ID of the map that you want the marker to be associated with. You can find this ID in the shortcode of the map you want to use (example: [ wpgmza id=”1″ ] – where 1 is the ID.
- address: Your marker location.
- description: Can contain simple HTML with only single quotes (no double quotes). Please be sure to encapsulate your description with double quotes.
- pic: This is the image that will show up in the InfoWindow. Must be a link to an image including “http://”.
- link: This is the link that will show in the InfoWindow. Must be a link including the “http://”.
- icon: The map icon. Must be a link to an image including “http://”.
- Lat & lng: If you do not have the Lat or LNG for your marker, you will need to ensure that you select “Automatically Geocode Addresses to GPS co-ordinates” (WordPress Dashboard → Maps → Advanced → Marker Data tab), as well as ensure that you have a valid GEOCODING API key from Google. Read our tutorial on how to generate a Google Geocoding API key here.
- anim: 0 = no animation, 1 = bounce, 2 = drop.
- title: This is the title of your marker.
- infoopen: 0 = info window is closed on load. 1 = infowindow will automatically open once the map is loaded.
- category: This is the ID of the category your marker belongs to and can be found in your WordPress Dashboard → Maps → Categories → ID. 0 = no category.
- approved: Set this to 1 to have the marker set to ‘approved’ – this is for the VGM add-on and allows markers to be approved/disapproved by the admin.
- retina: Set this to 1 to acknowledge this marker icon as a retina-ready icon. See http://samcroft.co.uk/2011/google-maps-marker-icons-for-iphone-retina-display/ for more information.
- type: Always set this to 0.
- did: Your device ID. Leave this empty.
- other_data: This is data used by the editor and for advanced users only; please leave empty otherwise.
Once you are done editing, download your marker data to a CSV file.
Importing your Markers
Before importing your CSV file, ensure the following:
- The headings are in row 1.
- The headings are in horizontal order (as illustrated above).
Select the Marker Data tab
Click on “Select File” and choose your CSV file to import your marker data.
Important note: You have the option of overriding your existing marker information when uploading. If you select this option, all your marker data will be deleted first and then the CSV file will attempt to be uploaded. Please backup your marker data before doing this.
Was this article helpful to you?