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

Newbie Fail - Please Help

This is a discussion on Newbie Fail - Please Help within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am trying to do a basic import of addresses into MP 2006. I have approx 200 addresses in two ...

  1. #1
    JetStarCourier is offline Junior Member White Belt
    Join Date
    Jun 2009
    Posts
    4

    Newbie Fail - Please Help

    I am trying to do a basic import of addresses into MP 2006. I have approx 200 addresses in two different zip codes.

    I get through the import process, but on my map there are only 2 push pin points (one for each zip code). I can click on the push pin and a list of all the addresses in that zip code comes up. So, I guess it is sorting by zip.

    I need all of the addresses to show on the map individually. What am I doing wrong? Please help.

    thx!

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Newbie Fail - Please Help

    Hi JetStarCourier,

    Is this via the Data Import Wizard?
    After you've selected what type the columns will be,
    the Wizard indicates how it will import your data:
    By Coordinates
    By Zip Code
    By Address
    etc.

    It's also possible that your columns are incorrect.
    What type of file are you importing from (XLS?, CSV?)

    Mike Mattys
    Mattys Consulting - Custom Programming

  3. #3
    JetStarCourier is offline Junior Member White Belt
    Join Date
    Jun 2009
    Posts
    4

    Re: Newbie Fail - Please Help

    Hey "Mattys Consulting",

    Thanks for your reply. I am importing an excel file with the "Import Data Wizard".

    It is a VERY simple spreadsheet with 5 columns:
    1. Address 1 (Street number)
    2. Address 2 (Street name)
    3. City
    4. State
    5. Zip

    I associate the correct value for each column. It imports, but puts all the addresses under the zip codes.

    I did find out one thing. All of the addresses I have only list the street names. The don't say "street", "lane", "drive", etc. I made a test spreadsheet at put in all the "streets", "lanes" & "drives", etc. and it worked.

    So, now my question is: Do I have to have all the "streets", "lanes" & "drives", etc. or can I just use the street names?

    In case I am not clear... My list consists of addresses like:
    1240 | Main | Frisco | TX | 75034 and that does not work.

    But, it does work if I do it like this:
    1240 | Main Street| Frisco | TX | 75034

    THX!

  4. #4
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Newbie Fail - Please Help

    Hi - You should concatenate columns 1 and 2.
    Your results aren't going to be 100% matches, maybe 85%.

    Mike Mattys

  5. #5
    JetStarCourier is offline Junior Member White Belt
    Join Date
    Jun 2009
    Posts
    4

    Re: Newbie Fail - Please Help

    I have combined rows 1 & 2, but it still does not work. It only seems to work if I add "street", "drive", etc. Is there anything else I am missing?

  6. #6
    JetStarCourier is offline Junior Member White Belt
    Join Date
    Jun 2009
    Posts
    4

    Re: Newbie Fail - Please Help

    It is working now. Thanks for the help.

  7. #7
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: Newbie Fail - Please Help

    Hi JetStarCourier,

    You're welcome ...

    Mike Mattys
    Mattys Consulting - Custom Programming

  8. #8
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Newbie Fail - Please Help

    JetStarCourier: See how much easier it is on a forum than on Twitter!

    You need the "Street", "Lane", etc because there are often streets with the same main name but differ because they are a road, street, avenue, etc. This is very common in the UK, for example.

    The need for the number and street to be together is more of a MapPoint peculiarity, although to be fair, it is never going to auto-recognise a number as a street number (it is more likely to be data).

    Richard
    (aka geowebguru @ twitter)
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Newbie :)
    By hill2000 in forum Introduce Yourself
    Replies: 0
    Last Post: 03-24-2009, 09:10 AM
  2. Hi to all - newbie here
    By whisperjet in forum Introduce Yourself
    Replies: 1
    Last Post: 03-10-2009, 04:02 PM
  3. VB6 error "Method 'QueryShape' of object 'DataSet' fail
    By David J in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 12-07-2005, 01:13 PM
  4. NEWBIE needs help!!
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-08-2004, 01:27 PM
  5. Newbie - please help
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-05-2002, 04:48 AM

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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102