Import Address Book from Squirrelmail Table

[daddyfix]

This is what I did to insert my email addresses from Squirrelmail into roundmail, providing yuor squirrelmail address are saved into a MySQL table


Just change your owner name from Michael to <your owner name> and your user_id to <your roundcube user_id>

INSERT INTO roundcube.contacts(
name,
firstname,
surname,
email,
user_id
)
SELECT nickname, firstname, lastname, email, '2'
FROM squirrelmail.address
WHERE owner = 'michael'
ORDER BY lastname ASC

Hope this helps someone.