View Full Version : New, and Stuck on 2 things

04-14-2009, 11:02 PM
Hi all,

I have MapPoint 2009 and use it to map peoples' home addresses (from Excel) so that I can better plan my travels for my job (I meet people in their homes--or nearby--across my 4-state territory). At this point I mostly use MapPoint as a visual aid while I am at my desk calling people for appointments. In my car I use a separate GPS unit.

I have been mapping some financial data (let's call it home value) by street address to end up with multi-colored pushpins to help me quickly spot my highest-value people in the area. The problem is that I only have P.O. Boxes for some of my people, and I can't figure out how to get MapPoint to just dump those people somewhere in the zip code (I can figure out the rest--I just need to understand who lives in the same general area). Same problem when MP doesn't recognize an address. When the data-mapping wizard provides suggested alternatives for each "problem" record and I select the option of mapping to the zip code, they don't always show up on the map.

I've poked around in the Help menu; I also did the basic tutorial but it was VERY basic.

The other thing I'm stuck on is this: how do I add just a handful of new people to my map? Do I have to remap everybody, or is there a way I can just add 4 new records from a new Excel sheet?

Thank you in advance! We finally got this software but nobody on my team really knows how to use it--believe it or not, I am the most adept among my group! Would love to find a really good online tutorial.

04-15-2009, 07:23 AM
It is possible the zipcode isn't in MapPoint's database. US postcodes have their own zipcode - with a post office housing many such postcode zipcodes. I doubt MapPoint has those.

If you use the Data Link wizard instead of the Data Import wizard, you can refresh the map from the source spreadsheet - so adding the new locations.


Eric Frost
04-15-2009, 08:49 AM
I have noticed that - when you are doing a DataMap such as a multiple symbol map from an address and the point only matches to the zip code level, then it doesn't show up on the map. I think it's a bug.

I'd recommend to do it in two stages. First determine the lat/lon or the best lat/lon for each address. You can geocode and then export the lat/lon using a tool like the Pushpin Tool Pushpin Tool Add-in - MP2K Magazine (http://www.mp2kmag.com/downloads/pushpin.tool/)

Then import your list and create the data map matching on lat/lon instead of address.


04-15-2009, 09:12 AM
Aha! I thought there was something "buggy" about some points not showing up on the map. Glad you think so, too. I have been able to "find" some people on the map where there was no pin. Once I find them, I select "show information" and leave the balloon in place so I don't lose them again. Not ideal, but better than nothing.

The idea of converting my info to lat/lon sounds more complex than I am willing to try. It's probably going to be simpler for me to manufacture a street address--something I have been experimenting with, with mixed success.

I am also going to try to link the data to my Excel sheet rather than import from Excel, per the other writer's suggestion. Many thanks, I'll let y'all know how it goes.

Eric Frost
04-15-2009, 09:14 AM
manufacture a street address--something I have been experimenting with, with mixed success.

Ahh good idea. Yes this would be simpler.