User role assignment from external database

Enrolment ::: enrol_dbuserrel
Maintained by Maxime Pelletier, Alistair Spark
This plugin allows you to configure automatic synchronisation of relationships between users from an external database. It is mainly used to assign Parent/Mentor rôle.
Latest release:
34 sites
17 downloads
24 fans
Current versions available: 3

If you need to massively assign user role like Parent or Mentor, this plugin will help you.

Based on an external table containing the Parent-child or Mentor-Mentee relationship, this plugin will add new relationship and also remove old ones.

For more details go to: http://docs.moodle.org/23/en/DB_User_role_assignment

Screenshots

Screenshot #0
Screenshot #1

Contributors

Maxime Pelletier (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

إظهار التعليقات
  • MD shot of me from his iphone4
    الأحد، 4 نوفمبر 2012، 12:53 AM
    Hi
    Could you consider adding urls for :
    - issue tracker
    - documentation (if any)


  • Educational Technology
    الثلاثاء، 18 نوفمبر 2014، 2:20 PM
    Does it work with 2.7 ?
  • Maxime Pelletier
    الثلاثاء، 18 نوفمبر 2014، 10:31 PM
    Not tested yet with 2.7 and 2.8.

    If you do, let me know,
  • William Michael
    الأحد، 10 يناير 2016، 6:34 AM
    I'm guessing this doesn't work with Moodle 2.9. Not working for me.
  • Gabe G
    الأربعاء، 3 فبراير 2016، 1:59 AM
    Worked in 2.9 with me, with a few tweaks:
    -Integrate the pull request from github to allow assigning of role on user login (no cron job required): https://github.com/mfuhrmeisterDM/moodle-enrol_dbuserrel/commit/97621be22aefdc11bec10ebb135ef9f8656fd0d5
    -Integrate second pull request to allow mixed-case column names in the external database table: https://github.com/primmy13/moodle-enrol_dbuserrel/commit/df9e542903168315ce68211a567bd2b12ad2951b
  • jussi tuominen
    الخميس، 11 فبراير 2016، 5:38 PM
    How about Moodle 3?
  • Just wondering . . .
    الأربعاء، 25 مايو 2016، 10:38 AM
    I'm also interested in Moodle 3.1. Any update on this from anyone?

    -Derek
  • cross
    السبت، 4 يونيو 2016، 10:23 PM
    Interested for use in Moodle 3.0X - anyone try it?
  • Kerry Ang
    الثلاثاء، 22 مايو 2018، 12:32 PM
    Anyone know how to run this with scheduled tasks?
  • Madhu Avasarala
    السبت، 3 نوفمبر 2018، 1:44 AM
    Works in 3.4 with a few modifications, available at https://github.com/spinozarabel/moodle-enrol_dbuserrel the modifications include removing enrol_sync on login (now done via CLI or using a CRON, very easy to setup), corrected database driver defaults. Started from Gabe G's work, indebted to him for that. Not thoroughly tested so usual caveats, use at your own risk! For a detailed look at implementing the external database see my documentation at https://sritoni.org/blog/implementing-a-parent-portal-in-moodle/
  • Alistair Spark
    السبت، 7 ديسمبر 2019، 7:24 AM
    This plugin is essentially abandoned with no updates in 5 years. We've done a major refactor which picks up profile fields & additional profile fields and running it on Moodle 3.7. Seems like it's time to pass on the maintainer torch Max if you don't have time for this anymore.
  • Maxime Pelletier
    السبت، 11 يناير 2020، 5:37 AM
    Hi Alistair, please send me a private message to talk about it.
  • Carlos Souquett
    الأربعاء، 29 سبتمبر 2021، 11:10 AM
    Hi there. I think if it were not for you, this area would be orphaned. I have been looking for a way to massively assign parents to their children and have not found a solution. I would appreciate your support in this regard. Many successes in the future.
  • Viviana Carnemolla
    الخميس، 24 نوفمبر 2022، 8:20 PM
    Hi! Who can give more information about settings If I want to use CSV file as database type?
  • Živana Komlenov
    الخميس، 12 يناير 2023، 6:25 PM
    Will this plugin be available for 4.x versions? It has been very valuable for my projects and I would love to keep using it. Thanks a lot.
Please login to post comments