Moodle in English: Need to make a bulk change to 500+ accounts that isn't listed

General help

Need to make a bulk change to 500+ accounts that isn't listed

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

Need to make a bulk change to 500+ accounts that isn't listed

by Robert Hough - Tuesday, October 6, 2009, 8:42 PM

Hi

I really hope you can help. We currently have 11500 users on Moodle, and all but 550 of them use LDAP authentication.

The other 550 accounts are set to "Manual Accounts" as they were added to Moodle via a csv file. Already this is causing a problem, as these users forget their password, and it isn't their network accounts.

I can find these accounts easy enough, by filtering out the LDAP authenticated accounts, but I cannot seem to change them using a bulk action, as the authentication method is not listed in the drop down list.

Is this something I can do quickly, or will I have to edit each account manually ?

Thanks
Rob
IT Support
The Oldham College

Re: Need to make a bulk change to 500+ accounts that isn't listed

by M. N. - Wednesday, October 7, 2009, 8:14 AM

If you are comfortable directly modifying the database you can do this with a simple query. First backup your database and files. This should always be the first step when making direct changes to the database. It would probably be wise to do this change in maintenance mode during off-peak hours as well.

Then in the user table ie. mdl_user, set the `auth` column to 'ldap' instead of 'manual' with a query on the users you want to change.

Be cautious when changing the database directly.

Re: Need to make a bulk change to 500+ accounts that isn't listed

by Robert Hough - Wednesday, October 7, 2009, 9:32 PM

Thank you very much.

Just tried this on a copy of the server I have, when I want to try dangerous things ! - and it worked fine. I also added a part to only select users with numeric characters (ie the students) so I didn't change the admin account authentication.

I will do this on the live server after a backup. Thank you very much for your help.

Rob