## Enrolment: Enrol by user profile fields

enrol_attributes
Maintained by Nicolas Dunand
This plugin allows users to be enrolled according to any value stored in their user profile.
376 sites
23 fans

This plugin allows users to be enrolled according to any value stored in their user profile. If you use an external authentication scheme (LDAP, Shibboleth), you can store values in hidden user fields of the users' Moodle profile, and then use these values to automatically enrol users if some courses.

### Contributors

• Thu, 4 Aug 2016, 3:01 PM
Hi Andras,

I've just sent you a private message to sort this out. Once this is sorted I'll post back here if some relevant info came up for other users of this plugin.
• Thu, 4 Aug 2016, 8:50 PM
To people using this plugin on a Moodle where the database type is Oracle or MSSQL, be aware that there is a known bug that prevents the enrollments to occur properly.

I'm currently working on this, and will hopefully provide a new release addressing this issue soon.

• Mon, 8 Aug 2016, 12:24 PM
It appears the plugin doesn't take into account that not all Moodle databases use the old mdl_ prefix. I'm getting an error saying that table 'moodle.mdl_user' doesn't exist which is correct, we have never used the mdl_ prefix. I have edited your source code to get it working so far but it would be good if this could be fixed in the plugin. Cheers
• Mon, 8 Aug 2016, 5:22 PM
Hi Narissa,

Thanks, but this has been corrected in recent versions. Which version of the plugin are you using?
• Sat, 3 Sep 2016, 1:18 AM
Hi,

A *VERY* silly question: does this plugin automatically enrols anyone matching conditions, or is it "enroling as user accesses" - kind of the Self Enrolment builtin plugin? Because I believed it was the second option, and unfortunately all my students share the same extended profile field value ("Student") so all of sudden, in every course that uses your plugin, we have around 3,000 people enroled, to my teacher's dismay lol!
• Sun, 18 Sep 2016, 3:00 PM
It would be perfect if this plug-in would work with any profile field, not only custom fields.
• Tue, 20 Sep 2016, 4:38 PM
Hi Fidel,

It is :

- enrol as user logs into Moodle (if it matches, obviously)
- enrol during cron job, every 6 hours
• Tue, 20 Sep 2016, 4:38 PM
Hi Jürgen,

Thanks for your feedback – yeah it would be great, I really have to look into this as soon as I have a moment.
• Wed, 21 Sep 2016, 12:07 AM
Hi Nicolas!

let me join Jürgen's idea, and hope you will have that moment soon

András
• Wed, 21 Sep 2016, 2:17 PM
Hi Nicolas!

great plugin that saves our trainer some time

It would really be great, if it would work with the standard Moodle profile fields as well

Regards, Dietmar
• Thu, 22 Sep 2016, 4:23 AM
I agree with Jürgen that it would be great if other fields could be used, as well. In fact, my wish is just slightly more complicated: I would like to be able to use the email domain or subdomain. For example, all of our students emails end in @student.ourschool.com and our employees end in @ourschool.com. I'd love to be able to auto-enrol students and teachers. We've got a custom "usertype" field (for some reason unknown to me), but I don't know how to populate it automatically, so it's not useful with this plugin, unless we manually enter the data.
• Fri, 23 Sep 2016, 5:49 PM
Hello Nicolas,

you mentioned, that the enrolment happens in two ways:
- enrol as user logs into Moodle (if it matches, obviously)
- enrol during cron job, every 6 hours

I have the problem, that my users cannot login anymore, when i define many (more than 20) criterias with the "OR" operator, to enrol in one course. It seems that during the login process some SQL querries run in infinite loop preventing the login going on. Only when the Admin purges the SQL queries users can continue to login.

We use Moodle 2.9.2+ with 4.800 Users.

Any ideas?

As the enrolment triggered by the cron job seems to work without problems, is there a way to exclude the enrol process as user logs into Moodle? Where would I have to make changes?

Best regards, Dietmar

• Fri, 23 Sep 2016, 7:30 PM
Hello Dietmar,

Thanks for reporting this.

Indeed it seems that you are hitting performance limits – these can arise when the number of users is high (not so much in your case) or the complexity of the rules increase.

As a first step, you could prevent the execution of the login hook by modifying the code as follows, in the file enrol/attributes/lib.php . After the function declaration public static function process_login, on the next line, simply add a line that contains return true; (without the quotes).

I hope this helps, le me know!

Nicolas
• Mon, 28 Nov 2016, 8:27 PM
Dear Colleagues!

I am using shibboleth authentication. I have created a custom user profile field named 'courses' and I map the shibboleth attribute 'niifEduPersonCourse' to it.
I receive the courses IDs separated by semicolons from the authentication server. (e.g.: niifEduPersonCourse: BMEGT20M002;BMEVIMH9O02;BMETE11MX01;)
Unfortunately, only the first course ID is mapped correctly and the others are lost. Therefore, I cannot use correctly the 'enroll by user profile fields module' (only for the first course) .
Anyone else meet this problem as well?
Could you please help me to resolve this problem? How can I enroll the users automatically to the right courses based on the course IDs received by shibboleth?

Best regards,
Zoltán
• Tue, 29 Nov 2016, 4:24 PM
Dear Zoltán,

This plugin was actually initially developed with this exact idea in mind (Shibboleth attributes, and semicolon-separated values). So it should work as you expect.

To investigate, you would need to turn on debugging (at least temporarily) on your Moodle site, and then display the enrolment method that you're trying to get to work. Below the form should then be displayed some debugging information, containing actual SQL queries that should return corresponding users. This could help you narrow down the problem.

Please do not post sensitive information in public places, but if you're comfortable with it, you can PM me with this additional information, and I'll try to help you out.

Best regards,
Nicolas