Author Topic: [Update] Squirrelmail usercopy - database support  (Read 5007 times)

Offline jingo

  • Jr. Member
  • **
  • Posts: 15
[Update] Squirrelmail usercopy - database support
« 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
« Last Edit: December 03, 2009, 06:46:11 AM by jingo »

Offline lacri

  • Full Member
  • ***
  • Posts: 179
    • http://www.php-lexikon.de
[Update] Squirrelmail usercopy - database support
« Reply #1 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 !!!

Offline jingo

  • Jr. Member
  • **
  • Posts: 15
[Update] Squirrelmail usercopy - database support
« Reply #2 on: December 04, 2009, 10:32:47 AM »
You're welcome.

Hopefully someone will review and test my work and commit it to svn.

Offline Granada

  • Jr. Member
  • **
  • Posts: 34
[Update] Squirrelmail usercopy - database support
« Reply #3 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

Offline osos

  • Jr. Member
  • **
  • Posts: 11
[Update] Squirrelmail usercopy - database support
« Reply #4 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

Also an updated version of the squirrelmail_usercopy is at:
#1486517 (squirrelmail_usercopy plugin - multiple identity and Database support) ? Roundcube Webmail

Offline Granada

  • Jr. Member
  • **
  • Posts: 34
[Update] Squirrelmail usercopy - database support
« Reply #5 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

Offline osos

  • Jr. Member
  • **
  • Posts: 11
[Update] Squirrelmail usercopy - database support
« Reply #6 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.

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.

Offline Granada

  • Jr. Member
  • **
  • Posts: 34
[Update] Squirrelmail usercopy - database support
« Reply #7 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

Offline osos

  • Jr. Member
  • **
  • Posts: 11
[Update] Squirrelmail usercopy - database support
« Reply #8 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

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.
« Last Edit: May 12, 2010, 05:35:53 AM by osos »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,543
    • http://SKaero.com/
[Update] Squirrelmail usercopy - database support
« Reply #9 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".

Offline Granada

  • Jr. Member
  • **
  • Posts: 34
[Update] Squirrelmail usercopy - database support
« Reply #10 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

Offline rcorrigal

  • Newbie
  • *
  • Posts: 1
[Update] Squirrelmail usercopy - database support
« Reply #11 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?

Offline v2mody

  • Newbie
  • *
  • Posts: 2
[Update] Squirrelmail usercopy - database support
« Reply #12 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???????????