| 3 minute read |

Mango offers a four useful ways to integrate your information stored in an external database. Here are some ways you can set it up.

Scenario 1
Link from Mango to records, files or images stored in other online systems such as a content management system

If you have documents, such as title deeds, photos or inspection reports stored in an online document management system, you can link these to features in a map in Mango. In the example below, three URLs are available to the user to access information about a property.

Using the Mango custom popup tool you can build custom URL’s that include values from the selected feature. For example, if in our dataset we have a column called ID that contains the id for the deed we can build a URL from within the Mango custom popup tool that links to our deed document in the following format:

https://orange-county.com/deeds?id={ID}

The {ID} will be replaced by the ID of the feature clicked by the user, e.g:

https://orange-county.com/deeds?id=019865

When clicked the user will be taken to the specific deed in the County’s external deed management system. For more information please see the following section in our documentation.

Scenario 2
Link from a record in a content management system to a feature on your map

In this scenario, we have some form of existing content or records management system and we would like records in that system to have a clickable link that when clicked opens your map then zooms to the feature, highlights it and opens the attribute popup..

To achieve this the first step is to upload our GIS data to Mango and retrieve the URL template for that layer as shown below.

Mango Layer settings panel

Then in your content management system you can insert the relevant variables into the URL template in order to make a URL that links to that feature in Mango. For example, we change:

https://mangomap.com/orange-county/maps/49891/parcel-map?field=field-name&value=field-value&layer=8eea8876-e11e-11e5-aad8-22000bb3a3a1&preview=true

To:

https://mangomap.com/orange-county/maps/49891/parcel-map?field=pin&value=9799028061.212&layer=8eea8876-e11e-11e5-aad8-22000bb3a3a1&preview=true

Where pin is the name of the attribute (or column in a spreadsheet or database) and 9799028061.212 is the value of the PIN column for the record we want to open in Mango.

Tip: You will likely need to ask your web developer to create the links in this format in your content management system.

Clicking the link in your content management system will then open a web browser and take you to that record in Mango, highlighting the feature and showing information in a popup, as shown in the example below.

direct link to feature permalink

For step-by-step instructions on how to enable linking from an external database, please read this help article.

Scenario 3
Automatically update data layers in Mango with Data Sync

If you maintain geographic information in a GIS or database (typically point locations in the latter case) and you want to update that information in Mango automatically, then our Data Sync tool is the way to go.

All you need to do is upload your data to Mango, then configure Data Sync to point to the same data stored in a Dropbox folder on your local computer or server. Each time a change is detected, the layer will automatically update in Mango. Note: If you don’t already have a Dropbox account, you can create one for free with a 2Gb storage allowance.

To further automate your workflow, you could write a script to regularly export your spatial data from a GIS database to the Dropbox folder.

For step-by-step instructions on how to setup data sync, please read this help article.