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 10 of 10

Plotting all the address as pushpins not working.

This is a discussion on Plotting all the address as pushpins not working. within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a windows vista ultimate with mappoint 2006. When i import data to mappoint, all the address shows as ...

  1. #1
    mastaBH is offline Junior Member White Belt
    Join Date
    Jul 2007
    Posts
    7

    Plotting all the address as pushpins not working.

    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~
    Attached Files Attached Files
    Last edited by mastaBH; 08-20-2007 at 06:11 PM.

  2. #2
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Plotting all the address as pushpins not working.

    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
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  3. #3
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    Re: Plotting all the address as pushpins not working.

    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.

  4. #4
    mastaBH is offline Junior Member White Belt
    Join Date
    Jul 2007
    Posts
    7

    Re: Plotting all the address as pushpins not working.

    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!

  5. #5
    peteryt is offline Junior Member White Belt
    Join Date
    Sep 2007
    Posts
    3

    Re: Plotting all the address as pushpins not working.

    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

  6. #6
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Plotting all the address as pushpins not working.

    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
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  7. #7
    peteryt is offline Junior Member White Belt
    Join Date
    Sep 2007
    Posts
    3

    Re: Plotting all the address as pushpins not working.

    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

  8. #8
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Plotting all the address as pushpins not working.

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

    Rgds, David
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  9. #9
    peteryt is offline Junior Member White Belt
    Join Date
    Sep 2007
    Posts
    3

    Re: Plotting all the address as pushpins not working.

    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

  10. #10
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: Plotting all the address as pushpins not working.

    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.
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Efficiently loading address based pushpins
    By ANDYL in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-19-2006, 12:06 PM
  2. Plotting Pushpins
    By Gianmaria in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 09-08-2006, 03:17 PM
  3. Multiple Pushpins for One Address, Possible?
    By Jeff Nelson in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 05-31-2005, 04:20 PM
  4. I am plotting the different address in mappoint in US .
    By PeriSen in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-12-2002, 03:11 PM
  5. How can I manually put in pushpins for address tha....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-27-2001, 07:10 PM

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