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!

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

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.

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