Migrating old users from an entrenched system like SquirrelMail to Roundcube can be a bit of a problem when it comes to the address book. These are the quick and dirty steps to move a users address book into RoundCube.

• Add the Address Import/Export plugin to Squirrel Mail
• Export the Contacts
• Convert to vCard
• Import into RoundCube.

Add the Address Book Import/Export plugin

1. SSH into your box and download and install the Import/Export plugin
   Dirty Code
   
cd /usr/local/cpanel/base/3rdparty/squirrelmail/plugins
wget http://squirrelmail.org/countdl.php?fileurl=http%3A%2F%2Fwww.squirrelmail.org%2Fplugins%2Fabook_import_export-1.1-1.4.4.tar.gz
tar -xvf abook_import_export-1.1-1.4.4.tar.gz
rm -rf abook_import_export-1.1-1.4.4.tar.gz
../config/config.pl

2. Choose option 8. Plugins
3. Choose the number for  abook_import_export which will move it from avaliable to installed plugins.
4. S for save
5. Q for quit

Export the Contacts

1. Login to the users Squirrel Mail, click Addresses and the bottom of the page will now have an “Address Export” option.
2. Choose a custom text delimiter and make the box blank. This may not work for a complex address book, so you may have to play around here.
3. Export and save the file.

Convert to vCard

1. Visit http://homepage.mac.com/phrogz/CSV2vCard_v2.html and copy and use the site to convert to a vCard
2. Again this works for a simple address book, one with more complex input will need more complex tools.
3. Save the resulting file with a vcf extension.

Import into RoundCube

1. Click “Address Book”
2. Click the Import Button
3. Choose your vcf file and import.