MapForums

robertaw · #1 (**permalink**) 11-12-2005

Of the 1500 addresses I am importing from an Excel spread sheet about 10% always need matching - however I fiddle around with the layout and contents of the addresess. In 99% of cases the first selection offered is perfectly acceptable and I won't worry about the 1% left.

However, I have to select each one and accept the change individually, which is a pain as I have to do this exercise on a weekly basis!!

Is there any way, even via VB, that I can do this automatically in one go - even if I have to press a button to set the process running?

Regards

Roberta

**Wilfried** · #2 (**permalink**) 11-13-2005

Hi,

I hope I understeand what you want to do.

What you could do is programatically place the pushpins, check if it is on an address, and if not then find the nearest address by means of a vector, increasing the radius until you find an address on the circumfence. Then move it there. This for every position.

Mohamed · #3 (**permalink**) 11-13-2005

Hi,

This is a supplement to Wilfried suggestion.
(Hi Wilfried, you undestand now why I am using camels in my delivery system, no chance to make them burning !!!!

)

2 things:

1°- Programmatically

Quote:

In 99% of cases the first selection offered is perfectly acceptable

If you add the PushPins programmatically, just use the ResultsQuality property

geoFirstResultGood = It's what you are using
geoAmbiguousResults = One of the 2 first results is good.
(it's what you should choose. Programmatically you can get one of them )

as in this example:

Code:

Sub AddPushpinToGoodFindMatch()
    
Dim objApp As New MapPoint.Application
Dim objFR As MapPoint.FindResults
      
'Configure l'application
objApp.Visible = True
objApp.UserControl = True

'Get a FindResults collection
Set objFR = objApp.ActiveMap.FindResults("Seattle")
    
'If one of the two first results is good
If objFR.ResultsQuality = geoAmbiguousResults Then           objApp.ActiveMap.AddPushpin objFR.Item(1)
Else
    MsgBox "More than 2 choices"
End If

End Sub

2° Pragmatically :

If you correct your adresses once manually, and if your 1500 addresses
are not changing, just export the corrected Pushpins from Mappoint to Excel. Now, you have cleaned addresses in your Excel file. The next time you will not have to correct them again.

Ciao

**Wilfried** · #4 (**permalink**) 11-15-2005

Hi Mohamed,

Thanks for supplement, it has been a while, welcome home

I understeand about the camels, they have many advantages

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help matching data	Anonymous	MapPoint 2006/2009 Discussion	0	03-01-2005 04:53 PM
Automating Mappoint using VB	vennamreddy	MapPoint 2006/2009 Discussion	1	10-07-2004 06:19 AM
Automating Mappoint	Anonymous	MapPoint 2006/2009 Discussion	3	07-26-2004 03:29 PM
Automating MapPoint with Perl	Eric Frost	MP2K Magazine Articles	12	07-15-2004 03:44 PM
Automating MapPoint with the .NET SDK	Anonymous	MP2K Magazine Articles	2	10-21-2002 06:41 PM

MapForums

Automating matching postcodes

Automating matching postcodes

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

Similar Threads

MapForums

Automating matching postcodes

Automating matching postcodes

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

Similar Threads