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:
32 sites
22 downloads
26 fans
Current versions available: 3
Download

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

Useful links

More documentation on this plugin
Source control URL
Bug tracker

Screenshots

Screenshot #0
Screenshot #1

Contributors

Maxime Pelletier (Lead maintainer)
View other contributions
Alistair Spark
View other contributions
Please login to view contributors details and/or to contact them

Awards

Automated testing support
Automated testing support
Privacy friendly
Privacy friendly

Comments

Erakutsi iruzkinak
  • MD shot of me from his iphone4
    Aparup Banerjee
    ig., 2012(e)ko aza.ren 4(e)an, 00:53(e)tan
    Hi
    Could you consider adding urls for :
    - issue tracker
    - documentation (if any)


  • Educational Technology
    Moien Abadi
    ar., 2014(e)ko aza.ren 18(e)an, 14:20(e)tan
    Does it work with 2.7 ?
  • Maxime Pelletier
    Maxime Pelletier
    ar., 2014(e)ko aza.ren 18(e)an, 22:31(e)tan
    Not tested yet with 2.7 and 2.8.

    If you do, let me know,
  • William Michael
    William Michael
    ig., 2016(e)ko urt.ren 10(e)an, 06:34(e)tan
    I'm guessing this doesn't work with Moodle 2.9. Not working for me.
  • Gabe G
    Gabe G
    az., 2016(e)ko ots.ren 3(e)an, 01:59(e)tan
    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
    jussi tuominen
    og., 2016(e)ko ots.ren 11(e)an, 17:38(e)tan
    How about Moodle 3?
  • Just wondering . . .
    Derek Chirnside
    az., 2016(e)ko mai.ren 25(e)an, 10:38(e)tan
    I'm also interested in Moodle 3.1. Any update on this from anyone?

    -Derek
  • cross
    Michael Talken
    lr., 2016(e)ko eka.ren 4(e)an, 22:23(e)tan
    Interested for use in Moodle 3.0X - anyone try it?
  • Kerry Ang
    Kerry Ang
    ar., 2018(e)ko mai.ren 22(e)an, 12:32(e)tan
    Anyone know how to run this with scheduled tasks?
  • Madhu Avasarala
    Madhu Avasarala
    lr., 2018(e)ko aza.ren 3(e)an, 01:44(e)tan
    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
    Alistair Spark
    lr., 2019(e)ko abe.ren 7(e)an, 07:24(e)tan
    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
    Maxime Pelletier
    lr., 2020(e)ko urt.ren 11(e)an, 05:37(e)tan
    Hi Alistair, please send me a private message to talk about it.
  • Carlos Souquett
    Carlos Souquett
    az., 2021(e)ko ira.ren 29(e)an, 11:10(e)tan
    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
    Viviana Carnemolla
    og., 2022(e)ko aza.ren 24(e)an, 20:20(e)tan
    Hi! Who can give more information about settings If I want to use CSV file as database type?
  • Živana Komlenov
    Živana Komlenov
    og., 2023(e)ko urt.ren 12(e)an, 18:25(e)tan
    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