I've somehow managed to make a mess out of my addressbook and I'm looking for a good way to put things back in place.
I've been running an unlocked 2G iphone for a while and have tried to get the MobileMe functionality to work.
At the time I didn't know push notification needed to work for the sync to happen, so I decided to apply the sync feature for contacts and calendars.
At first I selected to not merge any contacts, which had the effect of creating a copy of all my contacts to a new group called 'MobileMe'. The sync didn't work and I didn't think anything of it and continued adding/removing contacts.
The problem came to light as none of the newly edited/added contacts would show up on Outlook - After a bit of investigation it became clear that all of the contacts I've added/edited were within the MobileMe group the iPhone had created for me and therefore wouldn't correspond to the PC group that was previously there.
I tried to turn off the mobileMe group, but since it was never truly on, you can't turn it off. Tried to do a 'Merge contacts' thinking it would recognize similar contacts and prevent duplicates, but that failed miserably.
Long story short, I'm now left with an iPhone that has 3x the contacts (each contact is in the addressbook 3 times) and none of the contacts can be sync'd to Outlook since the PC group hasn't seen any updated in the past 3/4months!
Any solution would be greatly appreciated.
ps: As a side note I downloaded the SQLite Manager extension for firefox and ran the following query:
This seems to be showing the correct list of contacts, but I'm not sure how I can export this or remove the un-needed groups from the SQLite Manager.
SELECT t1.First, t1.Last, t2.value from ABPerson as t1, ABMultiValue as t2 WHERE t2.record_id = t1.ROWID group by t2.value order by t1.First, t1.Last
Is there a good ERDiagram of the addressbook floating around to help me clean this up?