We are using External Database authentication (Moodle 1.7.1) for all user accounts. Currently, we have 1800+ user accounts in the mdl_user table (auth=manual).
When I go to Administration > Users > Permissions > Assign roles and attempt to assign all users the "Student" role, it only adds 132 users at a time. Is there any way to assign ALL users at once during the import...am I missing something here?
My reason for doing it this way are based on the following:
1. We have only 2-3 administrator users in the system.
2. We have only ~20 trainers
By assigning all users the "student" role, I'm hoping I can then go in and cherry pick the 23 or so users that will be assigned to other roles...admin, trainer, etc. and assign them to other roles. This would be much easier than going through 1800+ users and assigning each a role individually. I'm sure I'm missing something pretty basic here.
Also, how do I assign roles during user import into my database? I currently import all user accounts using uploadusers.php and a .csv file which populates the mdl_user table nicely. However, role assignments are stored elsewhere in the database. How can I kill two birds with one stine here...import all users and assign all appropriate roles based on the criteria described above?
Any insight would be greatly appreciated.
Kind regards,
Brian