Topic: Export User Details only from SME6 to SME7

[netdesignns]

Is it possible to export only the user details: Username, Surname, FirstName, Group, Password in say comma delimited form from SME6 so that they can be imported into SME7?

[jfarschman]

Only the user?  Sure, with the Lazy Admin Tool.  LAT is written for 6.x, but runs on 7 as well.  You will still see some errors, but the author knows about these and will address if pretty soon.  In the meantime, you can create some symlinks that will address most of the errors with these line:

ln -s /home/e-smith/db/accounts /home/e-smith/accounts
ln -s /home/e-smith/db/configuration /home/e-smith/configuration
ln -s /home/e-smith/db/domains /home/e-smith/domains
ln -s /home/e-smith/db/hosts /home/e-smith/hosts
ln -s /home/e-smith/db/networks /home/e-smith/networks

Find it here
http://mirror.contribs.org/smeserver/contribs//mblotwijk/Contribs/

NB: as of this writing I believe it has some trouble with domain migration, but you only want the users... right?  Should work fine.

[netdesignns]

Thanks for that.
Using lat-dump it does pick up the user list with all the detail - except their passwords?
Looking at the file in Excel their is a column with the Password header but it is blank. All the other user information is there.
The passwords also do not appear to have been dumped along with the other config files. I am looking at transferring some 400 users and unless I can get these in then it is going to be a very long night or nights?
Also with the restrictions on passwords in SME7 will the existing ones be accepted as a block transaction or will they all have to be redone to fit the new password rules in any case?

[gordonr]

Is it possible to export only the user details: Username, Surname, FirstName, Group, Password in say comma delimited form from SME6 so that they can be imported into SME7?

Just perform an upgrade. Or backup, install, restore.

[gordonr]

Only the user?  Sure, with the Lazy Admin Tool.  LAT is written for 6.x, but runs on 7 as well.  You will still see some errors, but the author knows about these and will address if pretty soon.  In the meantime, you can create some symlinks that will address most of the errors with these line:

No, please don't. Talk with the author of LAT and ask them to make it compatible with SME7. The tools should be using the standard libraries to access the databases and would then not even notice the relocation of the dbs.

[jfarschman]

Gordon,

  I have talked with the author.  He is making changes.

NetDesigns,

  It doesn't export the passwords.  Passwords are hash-ed so they are one-way.  It's virtually impossible to retrieve a password from a hash, but if someone types the password for authentication it can be compared to the hash and confirmed as good or bad.