14 Oct 2010

Moving Contacts from Cpanel SquirrelMail to RoundCube

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
    [dirtycode]
    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
    [/dirtycode]
  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.

Share this

© 2018 Green-Light. All rights reserved.