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
5 downloads
25 fans
Release 0.2
Moodle 2.2, 2.3, 2.4, 2.5, 2.6
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