Configurable Reports

Maintained by Sara Arjona, Juan Leyva
This block is a Moodle custom reports builder. You can create custom reports without SQL knowledge. It's a tool suitable for admins or teachers.
Price option: Free

Supports Moodle 1.9-5.2 See all versions
Latest release: 2 months ago
Installations: 16046
Downloads (last 90 days): 3416

Frankenstyle name: block_configurable_reports
Blocks

Comments

Comments are no longer open for new posts. Existing comments remain available to read.

Nice one
A new version of the plugin (3.8.0) has been released today and it should work with the most recent Moodle versions. Besides, a separate version (3.3.0) has been also released for 3.3 downwards, in order to fix https://github.com/jleyva/moodle-block_configurablereports/issues/125.
Of course, there are still some remaining issues, but you can search and report and even work on them in the tracker (https://tracker.moodle.org/browse/CONTRIB-7882?jql=project%20%3D%20CONTRIB%20AND%20component%20%3D%20%22Block%3A%20Configurable%20report%22%20and%20resolution%20%3D%20Unresolved%20) or in the GitHub issues, as you prefer (https://github.com/jleyva/moodle-block_configurablereports/issues). Any help will be appreciated and patches are always welcomen wink
If you have any question, you can send it to the community forum: http://moodle.org/mod/forum/view.php?id=7979 (in order to make it easier, please, avoid to send them duplicated to several places).
And remember, if you're experiencing any issue, I would suggest to check if it has been reported previously in the tracker and, if not, create it smile
Thanks in advance for your compresion and help! smile
@Brandon Jimenez: we worked out that in fact the users that were being reported as started but not yet completed on activity 1, yet had completed activity 2 were due to restarting activity 1 to refresh their knowledge. The plugin in fact reads their last attempt, despite having already completed and this completion showing in the completion progress block and in the tickbox.
This may be a useful aspect of the plugin that could be updated going forward to avoid confusion for anyone else.
There is a problem with Moodle Site Admin menu on Moodle 3.8 with this plugin verion 3.7.0 (corresponding to MOODLE_36_STABLE branch on GitHub). Presumably, improper javascript isues caused by this plugin is preventing javascript of Moodle Core to be properly executed. Please see bug tracker: https://tracker.moodle.org/browse/CONTRIB-7909
@Jonny Galvez: A couple of questions, are you having an issue just with a single user in a single activity in a single course, or is it more an issue with the activity and the completion settings. And, have you tried running the query directly on Maria/MySql?
We are having an issue with the user module outline stats where the report is returning that a user has been started but not yet completed, despite the user having completed the element. This seems to be happening inconsistently.
Do you have any suggestions on how we can fix this? We find this plugin extremely valuable when it's returning the correct completion status.
Simon, you should rather search and post in the forum: https://moodle.org/mod/forum/view.php?id=7979
See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
Simon, you should rather search and post in the forum: https://moodle.org/mod/forum/view.php?id=7979
See if the solution on https://tracker.moodle.org/browse/CONTRIB-7786 works for you.
Subj. Custom template bug in latest version.
Not sure if this is the correct place to message this but I'm really enjoying the flexibility of this tool but I believe there is a bug in the latest version whereby choosing custom template simply generates the following in the report view:
ArrayArrayArrayArrayArrayArrayArray
Is this correct?
Good day,
I would have a query for this filter %% FILTER_COURSEMODULEFIELDS%. Does anyone know its exact syntax in SQL? I try to integrate it into the SQL query, but after entering the filter nothing happens at all. Specifically, I would need to filter out all users by institution. I use the Configurable Reports module.
Thank you for your help.
I think it's fair to say that, if the data is in the Moodle database, then you can report on it with Configurable Reports. You just need to know how to get at the data. There are no built in report templates for activities like surveys and questionnaires. Just to say, those activity modules do have their own reporting capabilities for users with elevated rights in the courses in question, though.
Hello and thank yall for making this plugin. I am currently having our Moodle admin install this plugin to our server and by the looks of it, this seems to be able to do everything we would like. My only question is concerning surveys / questionnaires. Will this plugin allow us to be able to create reports for surveys / questionnaires?
Hello @SUNRISER SETH
The main purpose of this plugin is to make SQL queries that could potentially be exported as reports. Since you have those logs stored in external files, that can't be done directly. that being said, maybe you could create a new logs table in the DB and then create a SQL report. If done properly, i think it could give you the desired results. Other than that, custom plug-in is your answer.
Hi,
I need an academic plugin for Moodle 3.7 that will take in calculations
the promotions (that are formed from 3 universitary years, i.e.: univ.
years 2019-2020, 2020-2021, 2021-2022 will make part from promotion
2019-2022), the universitary years like in above example, courses from
universitary years by semesters(sem.1, sem.2) and users that access/have
activities (or not) on that courses.
Reports that I need to display and save in csv, MS Excel or pdf are:
-Numbers of courses per semester in a selected universitary year(i.e.:
2019-2020) from a selected promotion (i.e.: 2019-2022), how much users
participate/had activities on each course, role (student, teacher, etc.),
and of course in a timeline (from beginning of logs until present day).
The plugin would be great if will work with already acumulated logs.
Can anyone help me with that? This plugin can be customized to do what I
need?
Of course I need that graphics displayed to be in form of bars & pie for
an unadvised audience.
@ Mr. Miguel González Laredo
I installed Moodle in october 2018 and from then we had various activities and in its logs/journals are recorded that informations until in present day, now from the beginning I opted to save logs in files on hardisk, NOT IN DATABASE.
I hope to fully clarify you this answer.
Hi Sunriser. I think this is a plugin properly for doing that. One doubt about your requirements is what does it mean "work with already acumulated logs"... Have you got some special LOG tables different to the "official" ones? If so, maybe the challenge would be a little bit more complex, but anyway possible. This is my opinion.