MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Exporting Data for Matched Records

This is a discussion on Exporting Data for Matched Records within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I am trying to use MapPoint to verify addresses in a database. When I import the addresses, I go through ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-09-2006
Junior Member
White Belt
 
Join Date: Jun 2006
Posts: 4
Exporting Data for Matched Records

I am trying to use MapPoint to verify addresses in a database. When I import the addresses, I go through the match process to verify the ambiquous addresses. When I export from the MapPoint map that is created, I get the data I imported not the matched data. This is most noticeable when I don't have a city, state, or zip code in the file being imported. Out of a file with 246 records missing these fields, I was able to match 205 on street address alone. When I exported the resulting dataset, the city, state, and zipcode columns were present but blank.

Thank you,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 06-12-2006
Member
Green Belt
 
Join Date: Mar 2005
Posts: 96
Hi,

I am not sure I understand very well the question!
You import 246 addresses and 205 only are found by MapPoint.
When you export the map there is no zipcode and other information for the unmatched data.

I think it's normal because the unmatched addresses are added in the center of your country without a complete address information.

You can have some control on that if you use the ResultsQuality Property and the ParseStreetAddress Method. But that needs some Activex Programming!


Ciao
__________________
Mohamed
www.AtlasCouscous.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 06-12-2006
Junior Member
White Belt
 
Join Date: Jun 2006
Posts: 4
I did not have any updated information in the matched records. The reason I was trying to import these records was to: 1) verify records that had complete information (street address, city, state, and zipcode) and 2) "fill in" records where the information was incomplete. This didn't happen because the dataset that was exported was identical to the spreadsheet that was imported from.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 06-13-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,055
Hi,

It is not clear to me if you use mappoint standalone program, or programming yourself. Can you elaborate ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 06-13-2006
Junior Member
White Belt
 
Join Date: Jun 2006
Posts: 4
I am using it standalone. I could program a routine to export a dataset from matched records if I have to. I just don't see why I should have to. I did my non-functional export from the dataset rather than from a selected section of a map. That shouldn't make a difference - should it?

Thanks,
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 06-14-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,055
Hi,

Dont know. I never used mappoint standalone.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7 (permalink)  
Old 06-14-2006
Junior Member
White Belt
 
Join Date: Jun 2006
Posts: 4
I am not adverse to taking a shot at a programmed solution. It seems to me that a simple data dump should do the trick - if it includes the data acquired through matching.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


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

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Obtaining corrected matched data jamesvdale MapPoint 2006/2009 Discussion 0 12-03-2004 03:02 PM
Imported data 132 addresses not matched stevewilson MapPoint 2006/2009 Discussion 1 10-04-2004 05:25 PM
Records matched to Zip Code don't have Pushpins Anonymous MapPoint 2006/2009 Discussion 0 08-26-2004 03:12 PM
Matching Un-matched Records to Zip Code Anonymous Products: Pushpin Tool, Single State Mapper 1 08-26-2004 02:26 PM
Exporting an address matched file bob everett MapPoint 2006/2009 Discussion 0 06-27-2003 06:30 PM


All times are GMT -5. The time now is 01:58 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Cheap Flights Amsterdam
Looking for cheap flights to Amsterdam? Your search is over. Holiday Hypermarket searches a range of airlines and operators to bring you the latest great offers.

Cyprus Holidays
Find great Cyprus Holidays with Travel Counsellors. A personal Travel Counsellor can help you plan the perfect holiday to Cyprus.

Holidays to Cuba
Situated between Jamaica and the Bahamas, Cuba has a delightful tropical climate and warm, clear waters with beaches of white sand. Check for cheap holidays to Cuba.

Holidays to Jamaica
Holidays to Jamaica are about taking things easy. Forget your watch and chill out beneath the clear Jamaican sky.

Portugal
As well as providing some great weather Portugal has much to offer culturally. There are numerous museums, monuments and places of historical interest to explore. Despite the rich history there is a buzzing nightlife and great shopping too.

All inclusive holiday
Travel.co.uk is a travel comparison service which makes it easy to search and find your all inclusive holiday.

Cyprus Holidays
Fancy a Mediterranean holiday? Get information on Cyprus holidays at On The Beach.


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