How Do I Apply Mass Edits to Imported Location Data in MapBusinessOnline?

Once you have imported location-based or address data into MapBusinessOnline you may decide you want to update that data. Updating data semi-automatically can be done using MapBusinessOnline but you must plan ahead to accomplish this.

Remember to download the Map App for MAC or PC and avoid Flash Player

MapBusinessOnline includes an imported data Update Process through the Map and Data tab. Find your imported data is listed in Map and Data with a Checkbox next to it. Hover over the data layer and click the Edit Gear when it pops up. Under General, at the bottom of the panel you will see two Data Update options – on is From File (on your desktop) and the other is From your Server.  You may want to touch base with your IT department about internal access to stored data used for business mapping purposes.

Now, here’s the ‘planning ahead’ part. For the imported data update process to work, you must have a column in your data for a Record ID or, as we like to call it, a Unique ID. That data column could be a list of Unique ID’s exported you get from your business system, ERP or CRM. A customer number is a good example if the data you’ve imported is customer data. You can always assign your own Unique ID just start with 100 and then move down the column – 101, 102, 103… Simply pull those numbers down the column which should add a 1 to each number.

So, because MapBusinessOnline needs that Unique ID to enable mass record updates, you’ll have to reimport your data into your map. You will not be able to use files you’ve already imported. Once your data is deleted in the current map and the original spreadsheet is updated to include that unique ID column, you are ready to reimport the data and you’ll be all set for updates in the future.

Special Note: Unique ID updating does not apply to territory imports. Territory updates are a manual process

The Mass Update Process

After your Unique has been applied and your data imported into a business map, semi-automated updates can take place. To conduct a mass update:

  1. In Map and Data hover over the target imported data layer and click the Edit Gear
  2. At the bottom of the General Panel Chose from one of the two data update options
    1. Update Dataset from File – this means the file is stored on your desktop or laptop
    2. Reload Dataset from Server – this means you access the data from a shared network

Choose the appropriate button and process the update. MapBusinessOnline will present a status notification after the update is complete. The notification will tell you how many records were updated, added, or deleted.

A Unique ID Column in Excel

The Incremental Update Process

Users can always choose to update one record at a time in the Data Window or by selecting the individual location point on the map.

  1. In the Data Window hover over the far-left colored dots of the data row you would like to edit
  2. Click the Pencil Icon
  3. Choose either to edit the Address or Location or Choose to edit the Properties and Data
  4. Choose Properties and Data to edit a record
  5. Make the Adjustments
  6. Save the Data Adjustment and Exit

Or select the point on the map itself and in the mini Toolbar choose the Edit Location Properties and Data button.  Edit your data in the resulting dialogue box.

Editing the Format of Your Imported Data

Perhaps you want to add a column or change the field formatting of an imported dataset. Well, you can do that. Keep in mind adding or editing columns and formatting is likely to break your Unique ID required formatting, disabling your semi-automatic updates.

  1. Go to Map and Data
  2. Hover over the target imported data layer and click the Edit Gear
  3. Click Customize Dataset
  4. Use the dropdown to select the right pathway. To adjust formatting for:
    1. Location columns choose General
    2. Your imported business data choose Custom
    3. Calculated Data Columns choose Calculated
  5. Save and Exit

Please note at the bottom of the dialogue pages you have the ability to add a column to your data.  Just be aware adding columns can break the Unique ID update process.

Updating and editing data in a business map is important. Perhaps a little boring, but important for efficiency and accuracy.


Are you using the MapBusinessOnline Desktop App for MAC or PC? It’s hipper than Instagram and it comes with your subscription. Impeach Adobe Flash Player!

Value-Added Resellers – Offer the tool to your customers as a reseller. Make money on training and consulting. Contact us with further interest in reselling MapBusinessOnline.

Win a $20 Gift Card! Refer a business associate to MapBusinessOnline in exchange for a $20 Amazon Gift Card!


This entry was posted in Business Mapping Software blog post, How to instruction and tagged , , , . Bookmark the permalink.

Leave a Reply