RouteWriter

The MPRouteWriter add-in imports and exports waypoints for Microsoft MapPoint routes whilst maintaining their route order. Although MapPoint can import and export waypoints as pushpins, their order is usually re-arranged.

MPRouteWriter exports waypoints and their matching pushpins to Excel (or a text file) with their waypoint distance, time, coordinate, address data, and all available pushpin data fields. Routes can also be optimized. Pushpins can be matched to waypoints using two different methods. They can be matched on name (unreliable if duplicate names exist); or name and distance (slower but reliable). Data fields can be sorted by name to ensure consistency.

MPRouteWriter includes MPRouteReader which is used to import routes from pushpins in a pre-determined order. This order is specified by a pushpin data field (typically a column that is imported using the Data Import Wizard). This field can be text or number, although it is usually a simple sequence number. Sorting can be in both ascending or descending order. Pushpins can also be selected by 'group' within a pushpin set. This feature allows all locations (e.g. customers) to be imported at once. MPRouteReader is then run multiple times creating each required route (e.g. for each day).