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
Like Tree1Likes
  • 1 Post By Eric Frost

Import a Route with Stoptimes

This is a discussion on Import a Route with Stoptimes within the MapForums Plus Downloads forums, part of the MapForums Plus category; This tool allows you to import a route with stoptimes. Each of the stops has a separate column to specify ...

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

    Import a Route with Stoptimes

    This tool allows you to import a route with stoptimes.

    Each of the stops has a separate column to specify stop time in minutes.

    This has been tested with MapPoint 2009 North America, but could easily be modified to work in any version of MapPoint.

    Work on this was originally started for a question in this forum here:
    Importing Data for stop scheduling

    It is very similar actually to the Route Optimization Tool in the MapPoint Power Tools Spreadsheet and the layout was patterned after that.

    The Route Optimization and this StopTime tool could be combined if so desired, it should not be too hard for a VBA programmer to make the modification.

    Depending on your needs if you are working with routing in MapPoint, you should also take a look at RouteWriter / RouteReader.
    RouteWriter: Export Microsoft® MapPoint® Route WayPoints to Excel®

    Eric
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Eric Frost; 04-20-2011 at 10:16 AM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    bwbjr is offline Junior Member White Belt
    Join Date
    Mar 2011
    Posts
    4

    Re: Import a Route with Stoptimes

    How about importing depart at times?

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

    Re: Import a Route with Stoptimes

    I don't know how that would work. So you would specify a time of day at which you would depart from a stop? Or just specify the time you leave the Starting waypoint?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  4. #4
    bwbjr is offline Junior Member White Belt
    Join Date
    Mar 2011
    Posts
    4

    Re: Import a Route with Stoptimes

    Yes, I want the depart to time to be filled in from the imported data. It would be be helpful tool to audit drive time and miles completed. Route Reader does a great job importing the addresses in order of time with the waypoint order. Now if we can just push that same time to the depart at field in MapPoint. Then I can see down time between stops. In other words how early one arrives at a stop with a set depart time.

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

    Re: Import a Route with Stoptimes

    I think this could be accomplished with some custom work, I'll send you a PM.

    From my understanding, essentially the program would determine the "stop time" on the fly based on the time the vehicle arrives at a stop and the depart time.

    (If the depart time is earlier that the arrival time, the stop time would be 0.)

    Let me know if this makes sense.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

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

    Re: Import a Route with Stoptimes

    A very similar tool to this one has now been posted here --

    Import a Route with Stoptimes and Depart Times

    The only tricky thing in code is that the last item in the Route cannot have it's Depart Time set in code, it says "Permission denied". So it has to go back afterwards and fill in the .PreferredDeparture properties after all the Waypoints are set up.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Route Planner II ; Import Wizard
    By sbktex in forum Development
    Replies: 1
    Last Post: 10-03-2007, 08:19 PM
  2. adding a pushpin to route when dragging the route
    By stephenmillington in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-31-2007, 11:44 AM
  3. Import stops in route order using excel
    By bpow in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 07-13-2007, 02:16 PM
  4. Import a new map
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-11-2003, 02:42 PM
  5. How do I calculate a route distance without displaying route
    By spideybud in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 09-09-2003, 11:14 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