MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




routing and scheduling stops using imported data

This is a discussion on routing and scheduling stops using imported data within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; This is a tricky one; I am importing data from an application that logs appointments for properties. The map shows ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-11-2003
Junior Member
White Belt
 
Join Date: Dec 2003
Posts: 1
routing and scheduling stops using imported data

This is a tricky one; I am importing data from an application that logs appointments for properties. The map shows the properties for which a new appointment exists as pushpins, located by UK postcode.

The data set I am importing also contains a start and end time for the appointment.

I am then using the route finder function, and I am selecting all the pushpins on the map and adding them to the route as stops.

What I want to know is; is there any way in which I can get the routing functions to read the 'start time' of the appointments (held in the data set) and to then order the stops by start time, before calculating the route?

Or am I just mad?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 12-16-2003
Junior Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 28
I have the North America Version, but see if you can use the PreferredArrival property of the Waypoint object when you add the waypoints to the map.

Quote:
Returns or sets the preferred arrival time at a stop or the end point on a route; similar to clicking Schedule Stop on the Route menu. Returns an error for the start point. Returns midnight if not set. Read/write Date.
Code:
  'Set the time you'd like to arrive at the end point
  objRoute.Waypoints.Item(2).PreferredArrival = TimeValue("1:00:00 PM")
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
data, imported, routing, scheduling, stops


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Editing Imported Data Rpirong MapPoint 2006/2009 Discussion 1 07-08-2006 05:07 PM
Routing & Scheduling Anonymous MapPoint 2006/2009 Discussion 1 03-01-2004 12:35 PM
printing routing stops Anonymous MapPoint 2006/2009 Discussion 0 10-21-2003 01:49 PM
sequence of imported data changes Harv MapPoint 2006/2009 Discussion 1 05-27-2003 05:09 PM
When I imported data at the county level for MA as.... Anonymous MapPoint 2006/2009 Discussion 1 08-20-2001 10:18 PM


All times are GMT -5. The time now is 01:26 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


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