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

Data Import Wizard?

This is a discussion on Data Import Wizard? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I need to import ~100 objects from an xls file. Fine... I can do that, but all it seems to ...

  1. #1
    PigSnack is offline Junior Member White Belt
    Join Date
    May 2004
    Posts
    3

    Data Import Wizard?

    I need to import ~100 objects from an xls file. Fine... I can do that, but all it seems to do is plot the pushpins on the map. I use Mappoint 2004 to do multi-point trip optimization and what I want to see is a pulldown list of all imported objects to select from in Route Planner. Right now, I have to manually add each object to route planner via pushpin. They stay once added, but is there a way to add all?

  2. #2
    Syd
    Syd is offline Member Yellow Belt
    Join Date
    Aug 2003
    Posts
    42
    Hi there,

    First thing that came into my mind was, that you just select all pushpins (rectangle around alle pushpins ), then make a right click and then click left on "add pushpins as waypoints" or something like that.

    I'll check on the other thing, but I guess, to add adresses directly as waypoint is not that simple, unless you use a script to do so.

    Greetings,
    Syd

  3. #3
    PigSnack is offline Junior Member White Belt
    Join Date
    May 2004
    Posts
    3
    Syd...Yes... I have been using the rectangle to try and select waypoints, but this is inprecise and doesn't work if you are all over the map. I need to be able to select 5 or 6 objects out of the ~100 as waypoints and optimize for a daily route.

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Do you want to select all of them or "just five or six scattered around"?

    If the former, then use a selection rectangle.
    If the latter, then select them manually - there are only 5 or 6.

    How do you propose to distinguish between them if the selection process is further automated?

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  5. #5
    PigSnack is offline Junior Member White Belt
    Join Date
    May 2004
    Posts
    3
    Quote Originally Posted by winwaed
    Do you want to select all of them or "just five or six scattered around"?
    5 or 6 scattered around. They are locations spanning a ~100 mile radius of a home base. So I have imported these 100 or so objects and currently have to select from the pushpins on the map in order to plot my route. I zoom the map view to include all of my objects/territory. Then I have to hunt and peck through the pushpins till I find the names that I am looking for for that day. I think I want a dropdown list of all imported objects, perhaps listed alphabetically, to select my waypoints from the imported objects available.

  6. #6
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    An add-in could be written to let you select a pushpin from a large listbox.

    Personally, I'm not sure if it would be that much quicker - I guess it depends how meaningful the names are vs. the distribution of the pushpins
    (I know it can be difficult to select pushpins that are very close together)

    I could be hired to write it for you, but I don't know if your budget can cover a programmer?


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Possible to batch file/macro Import Data Wizard?
    By Oyjord in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-31-2005, 06:05 PM
  2. Link Data Wizard fails
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-24-2004, 09:03 PM
  3. Data Import Wizard showing after drag and drop.
    By matnace in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-22-2004, 06:08 PM
  4. I want to use the import wizard to map the address....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-27-2002, 10:01 AM
  5. Using the Import wizard with an excel spreedsheet.....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-27-2002, 09:44 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