MapForums

mastaBH · #1 (**permalink**) 08-20-2007

I have a windows vista ultimate with mappoint 2006.

When i import data to mappoint, all the address shows as only one pushpin. I put a similar topic here a month ago but i did not get any help.

I have about 200 address to plot. All the addresses dont work. When I do plot the addresses, the one pushpin is located on the middle of the city. And when I double click on the push pin, it shows all the addresses. I tried the same thing with older version of mappoint in windows xp, and it worked fine. Except it did not have some streets available.

I put the addresses in mappoint as, Address, City, State.

Im attatching a sample file with the addresses on it. If someone could help me what the problem is, I would be really thankful. I couldnt upload excel file by it self so i had to zip it up.

I need to finish this work ASAP.. Thanks for all the help~

**davidb** · #2 (**permalink**) 08-27-2007

Can’t really understand why MapPoint is plotting all 200 addresses by city instead of address. Try reading them in via Import Data Wizard, then on the table that immediately appears check that the data type for your first column is Address. Also that the “First Row Contains Column Headings” box is checked. Beyond that I don’t know. I run MP Europe 2006 and abbreviating the second part of the address sometimes leads to problems eg 55 Spearmint Rd, Epsom would be plotted correctly but 55 Spearmint Ro, Epsom would be plotted at the city centre. You may have problems with abbreviations like Cir but I can’t see any reason why 68 Sparrow Rd isn’t located by address.

David

**Wilfried** · #3 (**permalink**) 08-31-2007

Hi,

I assume the format of the address is not right, so mappoint does not recognize the street and plot in the middle of the city.

mastaBH · #4 (**permalink**) 08-31-2007

I found the problem. It was because the region was set as multi...so i switched it to United states and it works like a charm.

Thank You all that tried to help me!

peteryt · #5 (**permalink**) 09-05-2007

i have the same problem. However I set up the territory I canot import an excel file to show my customers as individual pinpoints on a map based on post code sectors - they always come through as one pinpoint on a UK wide territory.
Would much appreciate some help!
Peteryt

**davidb** · #6 (**permalink**) 09-05-2007

Hi Peteryt

On import data wizard specify your input file. It then shows you some sample data records. Country/Region should obviously be set to United Kingdom. For the rest of the address check that the column headings are right

eg 145 Alexandra Road, Epsom, Surrey, KT17 8MX

The Data type for 145 Alexandra Road should be Address1, for Epsom should be City, for Surrey should be County and for KT17 8MX should be postcode. If you just want to plot by postcode (which is often preferable in MapPoint) set the other elements of the address to Other Data in the data type box .

Hope this works

David

peteryt · #7 (**permalink**) 09-06-2007

Hi David

That's great I can now work it a treat! However the balloons, when I hover
over them, do not reveal the customers name only "Custom Territories" and
the name of the territory. Do you or anyone else know of a quick fix for this?
I really appreciate your help. Many thanks

Peter

**davidb** · #8 (**permalink**) 09-06-2007

To get the information box to show you have to double left click on a pushpin. Hover doesn't work.

Rgds, David

peteryt · #9 (**permalink**) 09-07-2007

Hi
Sorry I didn't explain myself very well.
My balloons DO show when I hover over them! But, the name they reveal is not the one I want, they just reveal "Custom Territories" and the name of the territory, not the name of the customer.
Peter

**davidb** · #10 (**permalink**) 09-07-2007

You explained yourself fine. As far as I’m aware when you plot data in MapPoint, - eg shaded areas, multiple symbols and territory definitions – then when you hover the cursor over them you see a “data tip.” However this isn’t the case for pushpins. So in your example what you’re seeing is the data tip for the territory, which will show up if you rest the cursor at any point on the territory including on a pushpin. As I said you need to double left click to see the pushpin balloon. If you’re very keen to see a data-tip for a pushpin then you’ll have to set them up as a data-set, which has the drawback that you will only be able to see one piece of data. For example if you have a particularly key piece of data - eg sales – you can read the worksheet in, then specify ‘multiple symbol’ on data mapping wizard, then sales as the variable to be plotted, then restrict number of ranges to one. On the resulting map, when hovering on a symbol the data tip should show you your name variable (presumably contact name) and sales.

Hope that helps.

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/plotting-all-address-pushpins-not-working-6172.html
Posted By	For	Type	Date
box plot - Zymboo	This thread	Refback	06-16-2008 12:10 PM
Tracking P.F. Chang’s in the Midwest - MapPoint Articles - MP2K Magazine	This thread	Refback	08-28-2007 04:28 PM
Merging Multiple Routes - MapPoint Articles - MP2K Magazine	This thread	Refback	08-25-2007 05:27 AM
The Magazine for MapPoint - MP2K Magazine	This thread	Refback	08-21-2007 02:03 PM
Map Visitors - Powered by Virtual Earth	This thread	Refback	08-21-2007 12:59 PM
The Magazine for MapPoint - MP2K Magazine	This thread	Refback	08-20-2007 10:57 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Efficiently loading address based pushpins	ANDYL	MapPoint 2006/2009 Discussion	1	10-19-2006 11:06 AM
Plotting Pushpins	Gianmaria	MapPoint 2006/2009 Discussion	2	09-08-2006 02:17 PM
Multiple Pushpins for One Address, Possible?	Jeff Nelson	MapPoint 2006/2009 Discussion	6	05-31-2005 03:20 PM
I am plotting the different address in mappoint in US .	PeriSen	MapPoint 2006/2009 Discussion	1	09-12-2002 02:11 PM
How can I manually put in pushpins for address tha....	Anonymous	MapPoint 2006/2009 Discussion	1	06-27-2001 06:10 PM

MapForums

Plotting all the address as pushpins not working.

Plotting all the address as pushpins not working.

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/plotting-all-address-pushpins-not-working-6172.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

Plotting all the address as pushpins not working.

Plotting all the address as pushpins not working.

LinkBacks (?) LinkBack to this Thread: http://www.mapforums.com/plotting-all-address-pushpins-not-working-6172.html

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/plotting-all-address-pushpins-not-working-6172.html