A complex query... - A Suburbs Boy Living a Country Life
[Pete and Pam's pages (photos and some commentary)]
[My Flickr Photos]
A complex query...|
various at least one misbehaving synchronization engine s 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.CompanyWith 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.
WHERE (((Contacts.[Email Address]) In (SELECT [Email Address] FROM [Contacts] As Tmp GROUP BY [Email Address] HAVING Count(*)>1 )))
ORDER BY Contacts.[Email Address];
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:
In any event, I'm stumped...Are there any COTS, open-source, or home-brewed apps out there that might help me?
- 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].
Current Mood: aggravated
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...
|Date:||August 5th, 2007 11:28 am (UTC)|| |
That's what I'm afraid of...
That's what iSync is for. It's not perfect, but it does let me hand-pick between