How Do I Automate Imported Location-Data Updates?

Location-based address or latitude-longitude datasets are a vital element of business mapping. Map creators import location data to display relevant points of interest, define areas of interest, or add relevant resources to a business map.

Imported location datasets can be color-coded and symbolized in ways that add value to your map. These symbolized plotted points might define territory areas customer locations or depict the density of physical placements by subject.

But imported data means, sooner or later, the map creator must consider updating the data or reimporting the data because, just like the weather, data changes.

MapBusinessOnline has a map plotting feature that lets users import an address or latitude-longitude spreadsheet onto the map. The business mapping software provides a datasheet view in the Data Window. It offers a variety of symbology and color-coding options to maximize the map creator’s impact on her target map viewer.

But what of data updates? Imported data ages. Location records are added, deleted, and changed. How can you avoid a reimport process and automate the update process for imported location datasets?

Northern NE Territory Maps for One-Stop Brewery Depot

A few years back, MapBusinessOnline started supporting data updates by allowing users to select or create a Unique ID column in their imported data. The application would use that Unique ID to facilitate updating imported location data accurately. But the process required the map user to process the update. You had to click a button.

Automatic Updates

Our development team recently added several controls that enable full automation of location data updates. The user must store the data at its original location and assign a Unique ID column.

A map creator has two places to adjust settings to make this update process happen. The first control sets up automatic updates to occur or not. Both of these update controls are in Map and Data.

Updates Allowed

  1. In Map and Data, click the Map Options button at the top of the front menu.
  2. Choose the Map Updates tab.
  3. At the bottom of the Map Updates dialogue, check on the box labeled Update Datasets  This means updates to imported data layers are allowed.

Updates Enabled

Next, return to the front page of Map and Data. Here we will address the specific process for updating imported data layers.

  1. Hover over the imported dataset layer and click the Edit Map Layer Properties
  2. On the dialogue page, navigate to the third-lowest section focused on Updates.
  3. Click the Options button:
    1. Use this button to assign a Unique ID. It could be a unique ID column you added or a unique ID column included with the data.
    2. If you already have a Unique ID column assigned, go to the next step.
  4. For general data updates, click the Quick Update. If you’ve already adjusted your Update Datasets button as described in the top section above, you’re all set for MapBusinessOnline to automatically update your location dataset.

Now, take the rest of the day off.

Automatic data updates are convenient, saving the user time. Automatic updates also assure enhanced accuracy as your imported data can be relied upon to be up-to-date.

Read more about imported data:


Find out why over 25,000 business users log into for their business mapping software and advanced sales territory mapping solution. The best replacement for Microsoft MapPoint happens to be the most affordable.

To access MapBusinessOnline, please register and download the Map App from the website –

After installing the Map App, the MapBusinessOnline launch button will be in the Windows Start Menu or Mac Application folder. Find the MapBusinessOnline folder in the Start Menu scrollbar. Click the folder’s dropdown arrow and choose the MapBusinessOnline option.

The Map App includes the Map Viewer app for free non-subscriber map sharing.

Please read customer reviews or review us at Capterra or g2crowd.

Contact: Geoffrey Ives or Jason Henderson

*Yeah. You got Rick Rolled.

About Geoffrey Ives

Geoffrey Ives lives and works in southwestern Maine. He grew up in Rockport, MA and graduated from Colby College. Located in Maine since 1986, Geoff joined DeLorme Publishing in the late 1990's and has since logged twenty-five years in the geospatial software industry. In addition to business mapping, he enjoys playing classical & jazz piano, gardening, and taking walks in the Maine mountains with his Yorkshire Terrier named Skye.
This entry was posted in Business Mapping Software blog post, How to instruction and tagged , , , . Bookmark the permalink.

Leave a Reply