Wednesday, September 16, 2009

Importing Contacts to Blackberry with Google

I found another method for doing this in the crackberry forums that I admittedly did not try because this method seemed easier.  Every other way seemed to rely on MS Outlook, which is not necessarily an option for us Linux/ Open Source users.  This how to is from the perspective of populating an empty address book.

First, backup your current GMail contacts.  Make sure a few of them have phone numbers associated with them so that the necessary fields are there.  In Gmail, go to contacts then Select Export and choose All and the Google CSV format.  Save As google_backup.csv.

Next make sure you have google sync installed on your blackberry, but do not sync yet, or at least not contacts.

Now you have several choices for the contacts on your current phone.  Basically you need to get them into spreadsheet format the easiest way possible.

Now open google_backup.csv (using Open Office Calc of course)and Save As google_bb.csv so that changes you make to this file won't screw up your backup.  Now cut and paste from your current contact spreadsheet into the relevant fields below your current contacts.  Finally, erase the non phone contacts above.  It's better to do it in this order so you have something to use as a reference when cutting and pasting.  Remember to delete the whole row(s) when getting rid of the contacts you don't want on your phone.  Finally, save this file.

Now go back into Gmail contacts, choose all and Delete Contacts (don't worry, you have your backup!).  Now choose Import from the upper right and import the google_bb.csv.  Now open up google sync on your blackberry and under options choose to sync contacts and then sync now.  Viola!

Now uncheck sync contacts if you want and re-import your original contact list.  I actually took the opportunity to go through the file and clean it up.  Again, leave the original backup file intact!!!!!!!   ie  DON'T CHANGE THE ORIGINAL BACKUP!  This saves you lots of time if you mess up.

The whole process takes about as much time as, or less, than reading this how-to.  Let me know how it goes!

1 comment:

jimscafe said...

I found your blog looking at installing Puppy linux in virtual box. Your entry is 2007 so may not work with current versions of Puppy - did you continue to use linux in a virtual box?
I found your list of free software very interesting. I use Comodo myself (without virus as I thought it came with one) and Firefox, though the current problem with loading times has prompted me to try alternatives - mainly opera.
I had not heard of Fatstone Image Viewer so I downloaded that to try and followed the tutorial. It seems very good as an altrnative to Picasa.
Thank you for your blog entry.