This was fairly tedious, so I thought I’d share it with you, my loyal blog readers 
Over time, my address book has become unmanageable. Until today, what I had managed to achieve was a curious fusion of useful family postal address data, mostly from the pre-social network, pre-email, pre-mobile days of 10-15 years ago when I had loaded it all into Evolution on Linux; several personal and work mobile phone SIMs worth of numbers in various formats, covering probably a 10 year period judging from the names and numbers in there; and lots and lots of email addresses, covering a similar period, but recently bloated by the habits of Gmail and Apple Mail of storing some data automagically.
In short: a total mess. I had multiple entries for several of my close friends and family; original home addresses of university friends I have not been in contact with for 12 years (!); and outdated information for many other folks.
The iPhone was really the final catalyst for sorting all of this out. More than once recently, I’ve tried to find a number for a friend, and had several entries for that person, several of which were out of date. I’ve called a good friend’s brother on a phone he gave him more than seven years ago, twice in the past 6 months. That’s how useless I’ve become at managing this stuff.
Since the iPhone was core to the issue, and since it syncs with the Address Book, I decided to use that as my core tool for fixing the problem.
Here’s more-or-less what I ended up doing:
- Cleaned up multiple entries in Address Book, merging into a single entry for any one contact, including work and personal data, and adding company names where possible.
- Deleted redundant entries such as the university addresses which I knew were going to be wrong.
- Read through the various hints on this page for information on how I could get contact data from LinkedIn and Facebook and elsewhere…
- Exported my LinkedIn Contacts as a .vcf file for import into Address Book… imported and checked the merge information.
- Grabbed my Facebook Contacts phone details using a Greasemonkey script and a tool called AddressBooker (see the above linked hints page for details). At this point I had an issue. Downloading from AddressBooker as .vcf caused all the names to be exported as just FirstName fields, so when I tried to merge into Address Book everyone came up as a “new” contact. A better solution turned out to be to import directly from AddressBooker into Google Mail Contacts first; do any data merging and cleanup there (GMail Contacts has a nice “merge contacts” capability if you have multiple entries for one person); and then export as .vcf, and import into Address Book, checking the merge information as before with LinkedIn. Sounds long-winded, but it would have taken longer to manage manually in Address Book.
- At this point, Apple Address Book contained my “authoritative” contact list. To get it back into GMail, I scrubbed my whole GMail contacts list (slightly scary, but necessary), and then played around with the Automator action described in the Maciverse tips page, trying to use Numbers instead of Excel. Ultimately that was a disaster as it just couldn’t encode the tab-separated to CSV files correctly. The final answer turned out to be a brilliant little (free / donationware) utility called A to G. Get it. Use it. Donate.
- Result! And next time, I’ll try not to let this get so out of hand…
I see another wrinkle in this whole space. Although tools like Google Voice tend towards centralising all your contact details behind a single number you control (great idea – dear Google, when can we get it in Europe? hint hint!), the proliferation of social networks means that we all have multiple profiles and IDs. In particular, I find Skype and Twitter addresses hugely useful. Apple’s Address Book, of course, doesn’t provide “official” spots for those… there’s no entry for Skype in the IM drop-down list, and no space for arbitrary URLs, you have to edit and maintain a list of them. Something more extensible and easy to keep in sync would be very useful.
Update: the broken part
Google Talk appears now to have completely lost my contact list. Gah. So if you were connected to me on Gtalk then you may need to reconnect, or you may get a new connection request from me. Sorry about that…
6 responses so far ↓
An Eclectic Mind » Interesting Links, May 20, 2009 // May 21, 2009 at 6:00 |
[...] Up or Lose ItFive Tips for Composing a More Effective Social Networking Bio Interesting on the WebThe Great Address Book CleanupShepard Fairey Ripped Off My Picture FirstBathtub IV on VimeoThe Life and Death of a Twitter [...]
Mark Cathcart // May 22, 2009 at 14:53 |
It’s interesting that there isn’t an Address Book Manager SaaS. After battling through having Windows Mobile+Lotus Notes(synced), converting that to Win Mobile+Thunderbird(synced) then to Office 2007+nothing, then to Office 2007+Blackberry synced in my move from IBM to Dell, I lost all sorts of valuable contact information plus got loads of duplicates etc.
Sure, I have all the original data in different places, I still have my NAB.NSF unencrypted, etc. etc.
In my 30-day furlo I did start coding with a view to trying to make a service, load your addressbook, sync and then export in any of the supported formats. However, with the distraction of immigration, tax and other issues, never made any thing that actually did anything useful. I’m surprised there isn’t a service for this though, it’s certainly something I’d pay for…
and yes, before anyone suggests it, I know there are various software programs you can buy, download and install to do conversions, but when your whole digital life is moving platforms, software, hardware, and mobile, installing something isn’t very practical.
Andy Piper // May 22, 2009 at 16:19 |
I think Plaxo aimed to be that kind of service, but over time it has become yet another social network with status updates etc as well as address book and calendar sync. MobileMe aims to do it as well… but, as I’ve said many many times on podcasts and in presentations – sync is HARD. So far I’ve not come across any service or technology that has really got a good handle on it. I agree that it would be a useful service to have.
Dogear-Nation - Episode 103 - Early Adopters, Shiny Things » Dogear Nation // May 25, 2009 at 12:04 |
[...] party (uncommonman) Early Adopters and Finding “The Next Shiny Object” (andypiperuk) The Great Address Book Cleanup [...]
May 2009 Links // August 8, 2009 at 15:06 |
[...] The Great Address Book Cleanup – Some tips for cleaning up your Mac OS X Address Book file By Andy Piper on The Lost Outpost. [...]
Brent Musat // November 19, 2009 at 5:36 |
Snow Leopard (10.6) now supports syncing your address book with your google/gmail contacts. I set it up a couple days ago and it seems to work fine. So now I sync my iphone to mobileme, and my mac address book to both mobileme and google.
http://googlemac.blogspot.com/2009/09/improved-contact-sync-in-snow-leopard.html
I’ve been trying to maintain a single address book for 10 years between my online accounts, email clients, and cell phones and it has been a royal pain in the arse. It’s not perfect and I’ve found a handful of minor issues, but I think this solution is the best I’ve ever found… Adding a person to the “My Contacts” group in gmail now syncs with my mac and iphone automatically. The hardest part was merging all my contacts between my iphone and gmail.