?

Log in

No account? Create an account
A complex query... - A Suburbs Boy Living a Country Life [Pete and Pam's pages (photos and some commentary)] [Pam's journal] [Our company] [My Flickr Photos] [Arisia]
August 4th, 2007
09:39 pm

[Link]

Previous Entry Share Next Entry
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?

Current Mood: aggravatedaggravated
Tags:

(3 comments | Leave a comment)

Comments
 
From:technoshaman
Date:August 5th, 2007 04:31 am (UTC)
(Link)
To do that kind of ubercomplex sorting? I would use something like (if you wanna pay the piper) Visual Basic or ... I'm not sure if Open Office has a UI capability like that or not, but I think it might... or if you wanted to get really fun, Perl*Tk (which will run on anything, including Windows)...

But, no, I think you're gonna have to write something. That's how most good software projects get done, is somebody's got an itch they gotta scratch...
[User Picture]
From:happypete
Date:August 5th, 2007 11:28 am (UTC)

Yeah...

(Link)
That's what I'm afraid of...
[User Picture]
From:madbodger
Date:August 5th, 2007 11:51 pm (UTC)
(Link)
That's what iSync is for. It's not perfect, but it does let me hand-pick between conflicting entries.
Pete, Pam and Quinn's pages Powered by LiveJournal.com