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 6 of 6

Importing Coordinates as Stops

This is a discussion on Importing Coordinates as Stops within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a group of Lat/Lons in Excel in a certain order. I copy those into MapPoint and it creates ...

  1. #1
    vbmike73 is offline Junior Member White Belt
    Join Date
    Oct 2011
    Posts
    3

    Importing Coordinates as Stops

    I have a group of Lat/Lons in Excel in a certain order. I copy those into MapPoint and it creates the pins. I need to get a route based on the order the coordinates are in Excel. This seems so simple, but yet impossible to do so far. If I select all the pins, and add to route, it does them in some other order, but definitely not the order I have them. Any way to do this?

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,829
    Blog Entries
    55

    Re: Importing Coordinates as Stops

    This is a common problem, and the "MPRouteReader" half of our MPRouteWriter product was written to solve it.

    Add a column to your data and use this to specify the order (eg. simple sequence numbers 1,2,3,4). Import into MapPoint as before. Import the sequence number field as "Other Data". Then use MPRouteReader (when installed it sits on the Tools Menu) to create a route from the imported pushpin set, sorting the pins by the sequence number field.
    There are other options that let you do things like select a subset of the pins (allows you to import the pins for multiple routes at once), etc.

    MPRouteWriter itself does the opposite - write a route's waypoints to Excel in route order.

    Licenses cost US$75 but there's a free 14 day trial. See RouteWriter: Export Routes from Microsoft MapPoint for further details, downloads, and purchase links.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    vbmike73 is offline Junior Member White Belt
    Join Date
    Oct 2011
    Posts
    3

    Re: Importing Coordinates as Stops

    Thanks for the reply, but this is enough for me to find another mapping software. This is very typical of Microsoft, not thinking enough about the design to miss something so simple as this. I appreciate your help though!

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,829
    Blog Entries
    55

    Re: Importing Coordinates as Stops

    It is perhaps a gap that should have been filled by Microsoft (and that's definitely the case for the MPRouteWriter side of things), but I think you're going to be hard pressed to find any map software with similar capabilities and reasonably upto-date road data for the price of MapPoint+MPRouteWriter...
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  5. #5
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,088
    Blog Entries
    4

    Re: Importing Coordinates as Stops

    I agree with Richard (Winwaed). For a lot of the custom logistics/routing solutions I write for clients, there really is no other platform to which to compare MapPoint for functionality and affordability. And it is very easy to automate for people familiar with Office VBA macros.

    By the way, it just so happens that just a few days ago someone posted a similar question and posted a very simple Excel VBA macro that accomplishes this.

    Import Addresses from Excel using VBA

    There are also a lot more sophisticated routing macros with full source code in the MapForums Downloads section ($99).

    hope this helps,
    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  6. #6
    vbmike73 is offline Junior Member White Belt
    Join Date
    Oct 2011
    Posts
    3

    Re: Importing Coordinates as Stops

    This was perfect!!! I use VBA in Excel all the time, and until you mentioned it, did not think about that being a benefit of MapPoint. Awesome! Worked perfect! THANKS!!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Give Name to Stops.
    By shrikantc in forum Development
    Replies: 1
    Last Post: 01-05-2011, 07:51 AM
  2. Help with scheduled stops
    By apgriffiths in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 11-13-2007, 05:26 AM
  3. sorting stops when importing from excel?
    By zb61 in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 11-01-2007, 09:48 AM
  4. Optimizing a lot of stops
    By mundiz in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 08-22-2005, 11:53 AM
  5. Importing X and Y Coordinates
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-10-2004, 04:13 PM

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 68 69 70 71 72 73 74 75 76 77 78 79 80 81