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:
36 sites
7 downloads
24 fans
Moodle 2.2, 2.3, 2.4, 2.5, 2.6

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

Show comments
  • MD shot of me from his iphone4
    Sun, Nov 4, 2012, 12:53 AM
    Hi
    Could you consider adding urls for :
    - issue tracker
    - documentation (if any)


  • Educational Technology
    Tue, Nov 18, 2014, 2:20 PM
    Does it work with 2.7 ?
  • Maxime Pelletier
    Tue, Nov 18, 2014, 10:31 PM
    Not tested yet with 2.7 and 2.8.

    If you do, let me know,
  • William Michael
    Sun, Jan 10, 2016, 6:34 AM
    I'm guessing this doesn't work with Moodle 2.9. Not working for me.
  • Gabe G
    Wed, Feb 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
    Thu, Feb 11, 2016, 5:38 PM
    How about Moodle 3?
  • Just wondering . . .
    Wed, May 25, 2016, 10:38 AM
    I'm also interested in Moodle 3.1. Any update on this from anyone?

    -Derek
  • cross
    Sat, Jun 4, 2016, 10:23 PM
    Interested for use in Moodle 3.0X - anyone try it?
  • Kerry Ang
    Tue, May 22, 2018, 12:32 PM
    Anyone know how to run this with scheduled tasks?
  • Madhu Avasarala
    Sat, Nov 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
    Sat, Dec 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
    Sat, Jan 11, 2020, 5:37 AM
    Hi Alistair, please send me a private message to talk about it.
  • Carlos Souquett
    Wed, Sep 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
    Thu, Nov 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
    Thu, Jan 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