PDA

View Full Version : Excel Push Pin Problem.



mppete
07-21-2011, 02:37 PM
Every once and a while when I import a file from excel mappoint won't have the location for a specific entry. I'll just approximate a manual one on the map, but my manual pushpin cannot be added to the pushpin set from excel. Can anyone help?

Eric Frost
07-22-2011, 10:57 AM
Hello and welcome to the forum!

There are some different things you can do.

You could add a separate step in your process to "geocode" and get lat/lon's for all your locations first. There's a simple but effective geocoder in the Power Tools spreadsheet ($99) http://www.mapforums.com/mappoint-power-tools-spreadsheet-8080.html Alternatively you could import and then export the pushpins with lat/lon's using something like the Pushpin Tool ($75) Pushpin Tool Add-in - MP2K Magazine (http://www.mp2kmag.com/downloads/pushpin.tool/) Then, you would fill in the lat/lon's manually for the ones that didn't match, and then finally when you import, match using the lat/lon's you have compiled.

Or, for the records that don't match, swap in an address close by that you know will match. Then move it if necessary to the correct location.