Imports and Exports MapPoint waypoints and pushpins in route-order. MapPoint always re-arranges pushpins when it does this. Exports routes directly to Excel, or you can create a route from pushpins in a pre-determined order.
Version: 2.11The RouteWriter add-in imports and exports waypoints for Microsoft MapPoint routes whilst maintaining their route order.
License: Free To Try $75.00
Operating System: Windows
Although MapPoint can import and export waypoints as pushpins, their order is usually re-arranged.
RouteWriter exports waypoints and their matching pushpins to Excel 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).
RouteWriter includes 'RouteReader' 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 (eg. customers) to be imported at once. RouteReader is then run multiple times creating each required route (eg. for each day).
Version 2.11: RouteWriter bug fixes for text output options
Version 2.10: RouteWriter bug fixes: Better support for corrupt data fields and locations.
Version 2.9: RouteReader bug fixes: Better support for counting non-conventional data fields.
Version 2.8: Currency data fields can be exported; better support for Excel timing issues.
Version 2.5: Support for Excel Add-ins; RouteReader Group Feature
Version 2.2: Improved error messages
Version v2.0: Addition of RouteReader to create Routes
Version 1.3: Can distinguish between pushpins with duplicate names
Version 1.2: Option to export Rest breaks