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

Automating matching postcodes

This is a discussion on Automating matching postcodes within the MapPoint Desktop Discussion forums, part of the Map Forums category; Of the 1500 addresses I am importing from an Excel spread sheet about 10% always need matching - however I ...

  1. #1
    robertaw is offline Junior Member White Belt
    Join Date
    Jul 2004
    Posts
    3

    Automating matching postcodes

    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

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    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.

  3. #3
    Mohamed is offline Member Green Belt
    Join Date
    Mar 2005
    Posts
    97
    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

    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

  4. #4
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi Mohamed,

    Thanks for supplement, it has been a while, welcome home
    I understeand about the camels, they have many advantages

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help matching data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-01-2005, 04:53 PM
  2. Automating Mappoint using VB
    By vennamreddy in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-07-2004, 06:19 AM
  3. Automating Mappoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 07-26-2004, 03:29 PM
  4. Automating MapPoint with Perl
    By Eric Frost in forum MP2K Magazine Articles
    Replies: 12
    Last Post: 07-15-2004, 03:44 PM
  5. Automating MapPoint with the .NET SDK
    By Anonymous in forum MP2K Magazine Articles
    Replies: 2
    Last Post: 10-21-2002, 06:41 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