I am using roundcubemail-0.3.1 and I notice the global address book plugin is very useful and I was wondering is there possible to pull all the mail user to the global address list same as the ldap global address book? I am using MySQL as backend.
logon to mysql or to phpmyadmin and run:
INSERT INTO roundcubemail.contacts (changed,del,name,email,firstname,surname,user_id)
SELECT CURDATE() as changed, '0' AS del,name,username,SUBSTRING_INDEX(username,'.',1) AS firstname,SUBSTRING_INDEX(SUBSTRING_INDEX(username,'@',1),'.',-1) AS lastname,'115' AS user_id FROM vmail.mailbox
< INFO >
I don't know if this is a global ID for global address book. First i inserted an user trough roundcube global addressbook interface, after this i cheked the inserted user_id value. CAUTION! You may have other id in here, please make one manual insert FIRST and check it.
I got '115' AS user_id .
The firstname and last name is extracted like this because my emails are like: firstname.lastname@example.org