News

Welcome to End Point’s blog

Ongoing observations by End Point people

Gmail Contacts Notes Converter

As I mentioned previously, I recently got a Google Ion phone running Android. I recently began using it as my main mobile phone, and thus needed to finally migrate the contacts from my Nokia 6126 phone to Android.

This is apparently easy to do by first copying all the contacts from the Nokia 6126 internal memory to the SIM card, then moving the SIM card to the Ion and importing the contacts. But that only works if all your contacts fit on the SIM card. If not, they're truncated, and you have to delete many contacts on the Nokia to fit more, which would be a nonreversable move.

Several posts describe ways to do the export and import, such as this one that didn't really apply to my phone, and this one that involves VCF export & import which I didn't see a way to do.

Ultimately I found an article that described Nokia's PC Suite software that I'd never heard of before, which I downloaded on an old Windows machine and used to download the contacts from the phone via Bluetooth, then export to a CSV file and import into Gmail. So far, so good.

Except as this post and another post describe, then all the contact data showed up in a single Notes field, useless for dialing or emailing.

I decided it would be easiest to convert the Notes data into normal phone fields since I already had some contact information in the phone and couldn't find any other reasonable way.

I came up with this Gmail Contacts Notes Converter script to solve the problem. It takes Gmail-exported CSV as input, converts any Notes field data into standard Work or Personal contacts, and outputs CSV that can be re-imported into Gmail. It requires Perl 5.10.0 and I've only tested it on Linux. (It could be modified to work with earlier Perl versions fairly easily.)

Perhaps it will be useful to someone else as well.

3 comments:

Paulo Pinto said...

PC Suite is always available with Nokia phones, when you buy them.

Strange that you never heard of it, even if you happen to not use Windows as main OS.

Jon Jensen said...

Paulo, I guess it's probably because I didn't "shop" for my Nokia phone. I ordered it from AT&T customer service over the phone when my old TDMA phone quit working, and it was a basic GSM phone that I didn't worry too much about.

Paulo Pinto said...

Hi,

then I guess US customer service leaves a bit to be desired.

In Europe, you would always get the mobile in a neat package with all required stuff.

Anyway, not a big deal. Keep on blogging.