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

Feedback Please - Can MapPoint achieve this?

This is a discussion on Feedback Please - Can MapPoint achieve this? within the MapPoint Desktop Discussion forums, part of the Map Forums category; We have roughly 280 operational locations across the US. Locations are divided into both divisions and regions for management purposes ...

  1. #1
    madcrabber is offline Junior Member White Belt
    Join Date
    Feb 2007
    Posts
    3

    Feedback Please - Can MapPoint achieve this?

    We have roughly 280 operational locations across the US. Locations are divided into both divisions and regions for management purposes (however, regions are not a subset of divisions). In addition, there are three types of locations: stores, branches, and warehouses.

    Does MapPoint 1) allow this many data sets, and 2) allow you to toggle quickly between them? This will mostly be used to schedule site visits, so we may want to highlight all Store locations in Div: West, or all Whse locations in Region: Reg 04. Will MapPoint provide this functionality?

    Here is a sample of what the data subsets will look like:

    Num Type Div Region Address City State Zip
    01 Store West Reg01
    02 Branch West Reg01
    03 Branch West Reg02
    04 Whse West Reg04
    05 Store North Reg01
    06 Branch North Reg02
    07 Whse North Reg04
    08 Store North Reg04
    09 Branch South Reg03
    10 Branch South Reg03
    11 Whse South Reg04
    12 Store South Reg04
    13 Store East Reg02
    14 Store East Reg02
    15 Whse East Reg04

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Feedback Please - Can MapPoint achieve this?

    Hello Mr. Crab,

    Yes, this can all be done using MapPoint.
    MapPoint won't let you 'toggle' between datasets without automation code.
    It is easy enough to program this functionality using VB/VBA, though.
    Personally, I would use Access or even Excel to handle it.

    Mike Mattys

  3. #3
    madcrabber is offline Junior Member White Belt
    Join Date
    Feb 2007
    Posts
    3

    Re: Feedback Please - Can MapPoint achieve this?

    Thanks for the quick reply, Mike. When you say you would use Access or Excel, do you mean linking to MapPoint, or stand-alone? Pretty proficient at both, just looking for a breadcrumb as to how to get this done. Are there any tutorials or such that could be used to walk through the VBA scripting?

    Found a co-worker has a license for the program, so got to sit down with it this afternoon. Surprised at how similar it is to Streets & Trips 2006. We used Streets & Trips at my prior employer, but never was able to make it do what I'm asking about above.

    Any advice appreciated, if even a good book or website for tutorials.

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Feedback Please - Can MapPoint achieve this?

    Hi. The Magazine for MapPoint is where you want to look. Also search through the posts on this site. S&T and MapPoint are the same, except that MapPoint is programmable.

    As for a breadcrumb (no, not talking about linking), you would
    declare each of you datasets and then use the .ImportData method.

    Mike Mattys

  5. #5
    madcrabber is offline Junior Member White Belt
    Join Date
    Feb 2007
    Posts
    3

    Re: Feedback Please - Can MapPoint achieve this?

    Thanks again, Mike. Will start doing some research and hopefully will be able to get something working.

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

    Re: Feedback Please - Can MapPoint achieve this?

    One thing you can do without programming, is have all your datasets linked in and then delete the ones you don't want to see, or if you want to be able to switch back, you could temporily set the pushpin for a layer to be a 1x1 pixel custom symbol so it doesn't show on the map.

    Eric

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. feedback
    By djarts in forum General Chat
    Replies: 2
    Last Post: 04-05-2006, 01:21 PM
  2. Mapoint feedback
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 06-28-2004, 09:12 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 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96