Peter 'Happy' Thomas (happypete) wrote,
Peter 'Happy' Thomas

  • Mood:

A complex query...

Over time, various at least one misbehaving synchronization engines have has mangled my address book terribly.

With Access and the Outlook ODBC driver, I can construct queries like this one:

SELECT Contacts.[Email Address], Contacts.First, Contacts.Last, Contacts.Title, Contacts.Company
FROM Contacts
WHERE (((Contacts.[Email Address]) In (SELECT [Email Address] FROM [Contacts] As Tmp GROUP BY [Email Address] HAVING Count(*)>1 )))
ORDER BY Contacts.[Email Address];
With ugly UNION queries, I can even find all the entries where a phone number is duplicated, even if say it appears as "work phone" in one entry and "mobile phone" in another.

What I haven't been able to figure out how to do is to construct a good user interface and update process whereby I can take a look at each group of conflicts and decide:
  • that it's okay [for example, a triad or quad who share a home phone number], in which case I would take no action

  • it's not okay, and I know which one is the correct number [by memory or by context...for example a 703 number shared by three contacts where two of them are not in Virginia]

  • it's not okay, and I have no way of knowing, in which case I might flag it for a follow-up call ["Pardon me...I know you are someone I know, but I have no idea who you are!" Yeah, that'll be fun].

In any event, I'm stumped...Are there any COTS, open-source, or home-brewed apps out there that might help me?
Tags: projects

  • Farewell

    photognome died of heart failure yesterday. I don't have words right now.

  • My tweets

    Tue, 11:00: Pulling a full 250 KW and over 1,000 miles per hour charge rate at the new Reston teslamotors #SuperCharger. @ Wieh……

  • My tweets

    Fri, 19:57: Mixed meat meatballs, sauteed vegetables, loaded mashed potatoes with da_valentine and friends @ Corolla, North Car……

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.