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

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

نظریې وښیئ
  • 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