[opencms-dev] Webusers migration

[Pere Torrodellas]

Hello Michael,  thanks for the lead.

Unfortunately, the new system we need to move the webusres to is already in
place, so we need to solve this in the next couple of days, and can't
justify a version update.

Any comment to my thoughts about extracting/inserting CMS_USERS records? If
this direct table data migration is not possible, I guess I could extract
the webuser information from CMS_USERS, write a OpenCms program to create
new webusers in the new system using this data and dummy passwords, and then
update the passwords in the new table with the old data, but I'd prefer to
save the effort...

Thanks,

Pere

----- Original Message -----
From: "Michael Moossen" <m.moossen at alkacon.com>
To: "The OpenCms mailing list" <opencms-dev at opencms.org>
Sent: Tuesday, March 21, 2006 1:59 PM
Subject: Re: [opencms-dev] Webusers migration


> Hi Pere!
>
> A new 'export webusers' option has been added to the db export tool in
6.2beta.
>
> Kind Regards,
> Michael
>
> -------------------
> Michael Moossen
>
> Alkacon Software GmbH  - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
>
>
>
>
> Zitat von Pere Torrodellas <ptorrodellas at fihoca.com>:
>
> > Hello,
> >
> > Every information I've found about migrating OpenCms users from one
system
> > to another refers to "regular" users. Our present problem is to migrate
> > Webusers, and these are not included when you do a database export with
> > "Include account data".
> >
> > Can it be done just by extracting their data from the origin CMS_USERS
table
> > (USER_TYPE = 2 ?) and inserting it "as is" in the destination one, or is
> > there something else? In particular, I'm worried about the complex
structure
> > of the USER_ID, e.g. "1a54a631-97b9-11da-8b77-bb967f5326f1". Does it
have a
> > meaning that is not "exportable"? Could we get duplicate key errors when
> > inserting it?
> >
> > Or is there an official way to do this? Thanks for any suggestion,
> >
> > Pere
> >
> >
> >
> > _______________________________________________
> > This mail is sent to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please
visit
> > http://lists.opencms.org/mailman/listinfo/opencms-dev
> >
>
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev