Roundcube Community Forum

Third Party Contributions => API Based Plugins => Topic started by: jingo on December 01, 2009, 09:22:28 AM

Title: [Update] Squirrelmail usercopy - database support
Post by: jingo on December 01, 2009, 09:22:28 AM: Hi All

I have updated the squirrelmail_usercopy plugin to support copying userpreference and addressbook from squirrelmail database.

Added some fields in config. Driver should be set to 'sql' to use the database backend.

Please test and apply.

Regards

Jingo

PS: Off course remove ".txt" extension from the attached files.

PPS: Also sent to the dev-list: RoundCube Mailing Lists (http://lists.roundcube.net/mail-archive/dev/2009-11/0000143.html)
Title: [Update] Squirrelmail usercopy - database support
Post by: lacri on December 02, 2009, 08:02:51 AM: thanks for this ;)

i think many users need this to port users from old unstylish Squirrelmail to great RoundCube !!!
Title: [Update] Squirrelmail usercopy - database support
Post by: jingo on December 04, 2009, 10:32:47 AM: You're welcome.

Hopefully someone will review and test my work and commit it to svn.
Title: [Update] Squirrelmail usercopy - database support
Post by: Granada on May 12, 2010, 03:09:33 AM: I am just about to migrate thousands of accounts from Squirrelmail to Roundcube and did some testing with the script.
It works fine with RC 0.4b after removing line 122 from the script. The field "note" no longer exists in RC.

Regards
Ruediger
Title: [Update] Squirrelmail usercopy - database support
Post by: osos on May 12, 2010, 03:25:09 AM: The note field is missing due to very limited adressbook of RC.

I use this extended addressbook patch:
#1486377 (extended addressbook patch) ? Roundcube Webmail (http://trac.roundcube.net/ticket/1486377)

Also an updated version of the squirrelmail_usercopy is at:
#1486517 (squirrelmail_usercopy plugin - multiple identity and Database support) ? Roundcube Webmail (http://trac.roundcube.net/ticket/1486517)
Title: [Update] Squirrelmail usercopy - database support
Post by: Granada on May 12, 2010, 03:42:48 AM: erm... quite inconsistent! Would be nice to know whether an extended address book will find it's way into official releases of Roundcube or not. I'd like to have more fields, you can leave them empty if unused. And when one knows about the extended address book the squirrelmail_usercopy-plugin could easily be adopted. The current state is neither fish nor fowl. :rolleyes:

Regards
Ruediger
Title: [Update] Squirrelmail usercopy - database support
Post by: osos on May 12, 2010, 03:49:18 AM: Quote from: Granada;27398
erm... quite inconsistent! Would be nice to know whether an extended address book will find it's way into official releases of Roundcube or not.

I'm quite sure an extended address book will find it's way. The question is when and which.

See the Roadmap ? Roundcube Webmail (http://trac.roundcube.net/roadmap).

I would very much like the RC to at least have identical addressbook with squirrelmail by 0.4-stable. Further extension can wait until 0.5 or later.
Title: [Update] Squirrelmail usercopy - database support
Post by: Granada on May 12, 2010, 04:23:51 AM: I just want to be sure to not have to edit the code of an existing plugin (here: squirrelmail_usercopy) to get it to work with whatever version of RC we use. Setting the correct variables in the according config file must do the job right.
The current version of squirrelmail_usercopy does not run out of the box ...

Regards
Ruediger
Title: [Update] Squirrelmail usercopy - database support
Post by: osos on May 12, 2010, 05:27:37 AM: Quote from: Granada;27400
I just want to be sure to not have to edit the code of an existing plugin (here: squirrelmail_usercopy) to get it to work with whatever version of RC we use. Setting the correct variables in the according config file must do the job right.
The current version of squirrelmail_usercopy does not run out of the box ...

Regards
Ruediger

Good point. Please put your comments on this issue in the bugreport.
#1486517 (squirrelmail_usercopy plugin - multiple identity and Database support) ? Roundcube Webmail (http://trac.roundcube.net/ticket/1486517)

Hopefully the squirrelmail_usercopy update will be ready for 0.4-stable.

Edit: Actually looking at the code, the squirrelmail plugin should work even if not using an extended addressbook. Unfortunately I don't have the time to test it at the moment.
Title: [Update] Squirrelmail usercopy - database support
Post by: SKaero on May 12, 2010, 05:40:12 AM: A better address book should be part of RoundCube 0.5 beta as part of the "VCard data for rich contact information".
Title: [Update] Squirrelmail usercopy - database support
Post by: Granada on May 12, 2010, 05:50:19 AM: Quote from: osos;27401

Edit: Actually looking at the code, the squirrelmail plugin should work even if not using an extended addressbook. Unfortunately I don't have the time to test it at the moment.

You're right! V1.2 works without removing the line that defines the non existing filed 'note' in line 164.

Regards
Ruediger
Title: [Update] Squirrelmail usercopy - database support
Post by: rcorrigal on May 27, 2010, 11:32:41 AM: Any way it can be updated to support Squirrelmail's "Address Book Grouping and Pagination" plugin so it can bring any pre-existing groups over as well?
Title: [Update] Squirrelmail usercopy - database support
Post by: v2mody on May 31, 2010, 06:41:00 AM: i have version .3.1 and i wonder how can i use this plugin , i think i am using older version of this plugin which came by default with roundcube dir

what i want to do is just move all users .abook files to roundcube address book ? how to do that???????????