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:
44 sites
5 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

Vis kommentarer
  • MD shot of me from his iphone4
    søn., 4 nov. 2012, 00:53
    Hi
    Could you consider adding urls for :
    - issue tracker
    - documentation (if any)


  • Educational Technology
    tir., 18 nov. 2014, 14:20
    Does it work with 2.7 ?
  • Maxime Pelletier
    tir., 18 nov. 2014, 22:31
    Not tested yet with 2.7 and 2.8.

    If you do, let me know,
  • William Michael
    søn., 10 jan. 2016, 06:34
    I'm guessing this doesn't work with Moodle 2.9. Not working for me.
  • Gabe G
    ons., 3 feb. 2016, 01:59
    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
    tor., 11 feb. 2016, 17:38
    How about Moodle 3?
  • Just wondering . . .
    ons., 25 mai 2016, 10:38
    I'm also interested in Moodle 3.1. Any update on this from anyone?

    -Derek
  • cross
    lør., 4 jun. 2016, 22:23
    Interested for use in Moodle 3.0X - anyone try it?
  • Kerry Ang
    tir., 22 mai 2018, 12:32
    Anyone know how to run this with scheduled tasks?
  • Madhu Avasarala
    lør., 3 nov. 2018, 01:44
    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
    lør., 7 des. 2019, 07:24
    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
    lør., 11 jan. 2020, 05:37
    Hi Alistair, please send me a private message to talk about it.
  • Carlos Souquett
    ons., 29 sep. 2021, 11:10
    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
    tor., 24 nov. 2022, 20:20
    Hi! Who can give more information about settings If I want to use CSV file as database type?
  • Živana Komlenov
    tor., 12 jan. 2023, 18:25
    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