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

MP2006 - Importing data question

This is a discussion on MP2006 - Importing data question within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello, I seem to have run into a problem which I am sure there is an easy fix but I ...

  1. #1
    BlackOut777 is offline Junior Member White Belt
    Join Date
    May 2007
    Posts
    2

    MP2006 - Importing data question

    Hello,
    I seem to have run into a problem which I am sure there is an easy fix but I am having a rough time finding it. Hopefully somebody has an answer.

    I am trying to import about 2000 address doing pushpins on a map. To test out the import function, I created dummy xls file that had names, street address, state, zip for 20 people. On purpose I have #14 and #18 as bad addresses. I start the import and it goes through and stop at 14 asking to correct it or skip and does the same at 18 and finishes and looks great.

    What I would like to do is import 2000 users and have it skip/tag all the bad addresses (without me hitting a key each time) and finish and possible tell me which ones are bad in some format (do care how it lets me know about the bad enteries). This way I can fix the bad enteries and import them back in.

    Any thoughts or guidance would be greatly appreciated.

    Thanks in advance!

  2. #2
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    Re: MP2006 - Importing data question

    Unfortunately, there is no easy solution for this behavior.

    Programmatically, you would write your own import routine which buffers skipped records until reaching the end of importable records. This is non-trivial coding, however. You will need programming skills/staff with familiarity of the MapPoint, ADO and Excel APIs.

    I've been toying with writing a COM AddIn to handle the new Office2007 extended file formats. If I do eventually release the utility, it will help resolve the issue you mention. Please don't ask for a completion date however, as this is an unfunded, personal project.

    HTH
    Paul

  3. #3
    BlackOut777 is offline Junior Member White Belt
    Join Date
    May 2007
    Posts
    2

    Re: MP2006 - Importing data question

    Paul:
    Thanks for the info. Glad to know that you are working on something that will help me. I am a volunteer working on this project and although I have 13 years of IT experience I am NOT a programmer so it is beyond my level of understanding!

    Well dang - I guess I'll have to do it the hard way!

    Thanks again for the info! Good luck on your project I am sure the community at large will be greatful for it.

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

    Re: MP2006 - Importing data question

    This is probably a laborious way of going about things but when I have a list of addresses I first of all give the column of index/identification numbers the title ‘name’ on the excel worksheet. I then read them into Mappoint using the Import Data Wizard in the package (as opposed to code). When it’s finished reading them in I then skip all the unmatched records. I then go to the matching part of the data properties and that gives me a list of what’s been matched with the index number. Some will be classified as unmatched but others will be classified as matched against city or country so take care with these. In the UK the only satisfactory matches are by address or postcode – otherwise they need checking. I then do a copy and paste of unsatisfactory matches into an Excel file (just the index number is copied across). Depending on the number I either eyeball the problems there and then or use MS Access to match against the original database and get the full records for all unsatisfactory matches.

    Sad I know but it kind of works

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Importing or linking data
    By alwasl8 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-21-2005, 01:47 PM
  2. Newbie Question - Importing XLS data
    By Messier in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-09-2004, 08:17 AM
  3. Importing Data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-06-2003, 11:27 PM
  4. Help with Mappoint importing data with data ranges
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-31-2003, 11:28 AM
  5. Importing Data
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 10-05-2002, 12:49 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 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