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

Programmatically selecting Unmatched results?

This is a discussion on Programmatically selecting Unmatched results? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I often need to import thousands of records (constantly changing data) into a map. I usually have a hit rate ...

  1. #1
    mschoonmaker is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    9

    Programmatically selecting Unmatched results?

    I often need to import thousands of records (constantly changing data) into a map. I usually have a hit rate of about 95% or so, but that still leaves ~500 unmatched records per 10,000 database records!

    I'm working through this in VB6, and have much of it working, EXCEPT the part about handling the unamtched records. My questions are,

    1. can I get a subset of the entire dataset that was imported, but only the unmatched records? How is this done?

    2. I'd like to do some SIMPLE comparisons (in code) to see if the street/city/state/zip match up. If so, I'd like to stick a pushpin there anyway.

    3. For items that do not match up the street/city/state/zip, I would typically just match the last item in the "Potential Locations" dialog if I were doing this through Mappoint's interface. This turns out to the the ZIP code only match, which is OK as a last resort. Any thought on this?

    Thanks in advance,
    Mike
    Mike Schoonmaker

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

    1. Dont know, sorry
    2, 3. If your question was 'is this good idea', then my answer is Yes ! if you wanted some example code then please repost

    Still a note for the pushpin. Be aware that this is terribely slow, so if you have many records (10000) you need a supercomputer or soon a psycho

  3. #3
    mschoonmaker is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    9
    re: q's 2 & 3, yes I was looking for some sample code that might get close to this (sorry for not being clear).
    Mike Schoonmaker

  4. #4
    cwrude is offline Junior Member Yellow Belt
    Join Date
    Nov 2004
    Posts
    19
    One option is to spin through the recordset and look at the IsMatched property of each record

  5. #5
    mschoonmaker is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    9
    Yes, that would be one choice (however inefficient). Seems like there should be a FILTER property that could get set on the recordset to obtain ALL records that were not matched.
    Mike Schoonmaker

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

    Quote Originally Posted by mschoonmaker
    Yes, that would be one choice (however inefficient).
    Unless you do that when adding the records one by one and then check the property. Not sure but I dont think you loose much cpu time.

    Filters ofthen do the same. When set they walk trough each record to check if it is valid.

  7. #7
    mschoonmaker is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    9
    So you think adding records one by one is as efficient as a ImportData() method? Surprising.
    Mike Schoonmaker

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

    I'm definitively not sure, but it is wodth to try it in a small separate test case. Could be that there is almost no difference, depending on how it is internally constructed.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unmatched records
    By fletch in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-09-2005, 10:24 AM
  2. Selecting Shape Based on Name
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-07-2004, 11:01 AM
  3. Matching unmatched items after import into VB6 app
    By abaker in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 01-20-2004, 08:39 AM
  4. export unmatched records
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-17-2003, 02:51 PM
  5. Selecting pushpins within a shape
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-26-2002, 09:11 AM

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 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96