Click to buy RouteWriter

Guided Tour

Latest News:

Oct 21st: MPRouteWriter v3.7 released

Aug 12th: MPRouteWriter v3.6 released

Jul 9th:
Buy MapPoint 2013 for US$249

Links:

Guided Tour of MPRouteWriter: Handling Duplicate Pushpin Names

MPRouteWriter matches waypoints with the pushpins used to create them. Waypoint data is then written with the corresponding pushpin data fields. Here we look at how the pushpins are matched and how MPRouteWriter handles duplicate names.

Sample data with duplicate pushpin names

Duplicate Names

A route will often have pushpins (and hence waypoints) with duplicate names. This often occurs if pushpins represent business locations and the names are the business names. A company with multiple locations will have multiple pushpins with identical names.

The spreadsheet on the right lists some sample data which demonstrates this. Each company has multiple business locations with identical names.

Sample route based on this data with duplicate waypoint names

The map on the right shows the same data loaded into MapPoint. A route has been constructed that visits multiple customers - many from the same company. This results in pushpins (and waypoints) with duplicate names.

MPRouteWriter panel set to write pushpin data fields

MPRouteWriter has two methods for matching waypoints with their parent pushpins. These are controlled with the Resolve duplicate matching pushpins check box on the main RouteWriter panel (see image to the right).

The fastest option is to clear this check box. This will cause MPRouteWriter to match pushpins according to their names only. This will not work correctly if the map contains pushpins with duplicate names.

Set the Resolve duplicate matching pushpins check box if the map contains duplicate pushpins. This will cause MPRouteWriter to match pushpins according to both their names and the distances. Although this option is more reliable, it can be much slower if the map contains large numbers of pushpins.

RouteWriter results in Excel

Here is an example. This spreadsheet (see right) was created using the above data but with the Resolve duplicate matching pushpins check box cleared.

Note that the names, distances, and travel times look correct; but with closer inspection, the other data fields are interchanged. This is because the waypoints were mis-matched with their parent pushpins.

RouteWriter results in Excel

Here are the correct results with the Resolve duplicate matching pushpins check box set. Note that the waypoint data is now correct, and has not been mixed up.

Next, we look at the MPRouteReader component of MPRouteWriter. MPRouteReader is used to create a MapPoint route from pushpins in a pre-determined order.

Buy MPRouteWriter Now!