PDA

View Full Version : MapPoint and UK Postcodes



mad-martin
02-27-2013, 07:15 AM
Hi guys,

I am new to MapPoint and could do with a few pointers.
I have imported a list of repair agents in MapPoint and that works fine, no issues there!

Now, we also use a few National repairers and I would like them shown in the results even-though they may be outside of the postcode area. Would it be possible to use a GB/UK postcode that would always show those particular repair agents?

I am also interested in finding out if it is possible to link MapPoint to an Excel workbook containing all data (basically so I don't have to import the spreadsheet if it gets updated at any point).

Thanks for reading!

mad-martin

Winwaed
02-27-2013, 08:13 AM
You can perform a "Link" using the Link Data Wizard (instead of the Data Import Wizard). This works the same way but maintains a reference to the original data source (ie. spreadsheet). It is then just one click to refresh the data from the source. It remembers things like column assignments/etc - so be sure to keep them the same in the data source.

I'm not sure what you are asking about the national repairers. You can import multiple datasets. Perhaps the national repairers could be in their own pushpin set which you could toggle on/off as required?

mad-martin
02-27-2013, 08:38 AM
That's very helpful thank you!
I assume MapPoint looks at the postcodes in my data sheet, however for 'national' repairers I don't have a postcode.
Let me try to give an example of how I envision it to work.. I enter a postcode (or a partial postcode) and have set the radius to 40 miles, I then want to see all repair agent based in that 40 mile radius. The problem occurs if a repair agent doesn't have a postcode in that area. Could I use a wildcard in those cases?

Thanks again!

mad-martin

Winwaed
02-27-2013, 10:32 AM
You should be able to locate many repairers by street address without postcode (less accuracy of course), also OS Grid reference; or Longitude, Latitude coordinates. Not to state the obvious, but you need location information to locate them :-)
If you only have city,county (say), then that is as accurate as it is going to get.

Getting them to display within a specific radius is more difficult. Assuming you don't have too many, you are probably better off displaying them for the entire area. You can the draw a radius circle for the 40 miles radius. Right click on the radius circle, and select "Export to Excel" to extract the pushpins that are within the circle. It isn't displaying them on a map, but you are getting a list of the pushpins.

This could be automated - especially if you are going to have a lot of circles. Eric Frost (owner/mod of mapforums.com ) has produced a template I believe that will draw many radius circles. Alternatively, my MPMileCharter product ( MPMileCharter: Home Page (http://www.mpmilecharter.com) ) can find find pushpins within a specific distance (as the crow flies, or driving distance/time) of another set of customers.