Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 2 of 2

Export in Optimized Order to Excel

This is a discussion on Export in Optimized Order to Excel within the Wish List forums, part of the MapPoint Desktop Discussion category; We are trying to use MapPoint for routing delivery vehicles, however, we are encountering another problem. After we optimize the ...

  1. #1
    erkorb is offline Junior Member White Belt
    Join Date
    Jul 2003
    Posts
    3

    Export in Optimized Order to Excel

    We are trying to use MapPoint for routing delivery vehicles, however, we are encountering another problem. After we optimize the route, we then
    highlight all the pushpins and right click to export the data Excel, the
    resulting table is NOT in the optimized order. Can anyone tell us how to
    export the data in the "optimized" order?
    erkorb

  2. #2
    James is offline Junior Member White Belt
    Join Date
    Nov 2003
    Posts
    4
    Hi,

    If you are still interested, I have a commandline utility st2gpx that may help. It can extract the data from your saved mappoint file into GPX format (there is a second tool that can convert this to csv for Excel if needed).

    This would give you the waypoint data for the route in the calculated order, as well as other info.

    You can find st2gpx at http://sourceforge.net/projects/gpsbabel

    Let me know if you need help with this.

    Cheers,
    James

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Printing pins that are highlighted in optimized order
    By dwedrick in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-12-2005, 05:24 PM
  2. strange order in the exported Excel flile
    By pileggi in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-29-2005, 11:08 AM
  3. Export Optimized Route
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-04-2005, 07:34 AM
  4. Export to excel
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-23-2003, 05:29 AM
  5. export to excel
    By gsully in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-08-2003, 10:39 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67