Configurable Reports

Can this produce a report of all users NOT in a course? ie to delete spam accounts?

Juan : thanks for this quick and good solution !

Go to Administration Plugins Blocks Configurable reports, there should be an option called Highlight SQL syntax, disable that option
New versions come with this option disabled

Hi,
Since version 2.3 released in december 2013 (and even with 2.3.2), i've got a big problem : on SQL query tab, no area shows anymore to enter/modify SQL query
I've just got numbers (corresponding to each line i think) showing.
Tested with default theme in Moodle 2.4.8.
It seems it's what Chris Chapman talked about on 17 december 2013.
Hope you'll can make something to repair that.

Thanks Juan!
Tested out the version on GitHub and it all looks great. Thank you for your prompt response and the fixed version.
Best regards,
Michael

Hi Michael,
i thought the Warning was solved in the previous release.
I just added the format_string, you can download the last version from github
I'll try to release a new version these days

Hi Juan,
As long as you are editing the code, I was wondering if you could also put the course names in the "Manage Reports Course" column of the "Manage Reports" page through the format_string() function (http://docs.moodle.org/dev/Output_functions#format_string.28.29) so that multilingual course names get filtered. Let me know if you have any questions.
Thanks again!
Best regards,
Michael Milette

Hi Juan,
Thank you for making such a useful plugin available.
I wanted to let you know that I got the same error as Toni when displaying the block in 2.3.1 on Moodle 2.6 after upgrading the plugin on an existing site:
"Warning: First parameter must either be an object or the name of an existing class in /www/moodle/blocks/configurable_reports/block_configurable_reports.php on line 124 ".
I managed to get rid of the warning but it should really be handled in the source code.
To work around the issue, turn on page editing and then edit the Configurable Reports block. You need not do anything but click save. The variable will then be initialized and the warning message will not return (unless you create another block I would imagine).
Hope this helps you resolve the issue.
Best regards,
Michael

Hi Juan,
I was translating the configurable reports English language strings in AMOS and I found a strange-looking string:
2.6 [filtercoursecategories_summary,block_configurable_reports] Filter courses by their any parent category
Should't this rather be 'by their parent category' or 'by any category' ?
Also, there are two English language strings that are not in English, but in Hebrew:
2.6 [filtersemester_list,block_configurable_reports] סמסטר א,​סמסטר ב,​סמסטר ג,​סמינריון
2.6 [filtersemester_summary,block_configurable_reports] מאפשר סינון לפני סמסטרים (בעברית, למשל: סמסטר א,​סמסטר ב)
Should't they be in English ?
Thanks in advance,
Saludos desde la Ciudad de México
S

Hi Juan, I'm still experiencing the same issue when choosing the XLS export option. Your new CSV export works perfectly though. Any ideas?

Hi Juan and Happy New Year!
I installed configurable_reports in my 2.5.3+ this morning and everything was OK. The only think I realized is that, when in debugging mode it displays this message:
"Warning: First parameter must either be an object or the name of an existing class in /var/www/moodle/blocks/configurable_reports/block_configurable_reports.php on line 124 ".
The message appears in one course where I have a configurable report block activated. I hope it helps to debug.
As always... Great Job Juan!

Just updated to 2.3.1- cant enter an sql query into the area- I had enabled syntax highlighting, this worked in my 2.5.3 dev but not working in my 2.5 Stable production- shame as those improvements are amazing!

Hi Michael, I'm glad that you find useful the plugin.
I've fixed a problem related to download XLS files but I'm not sure if the one you have seen (for me, downloading XLS files works fine)
I will release a new version with some fixes during today

Hi Juan, thanks for your work on this block. Our institution couldn't survive without it now! Just one thing, in the latest build (release 2.3) using Moodle 2.6+ stable, the "Download as XLS" option no longer works. In Chrome, it just says "Webpage not found", even with moodle debugging messages set to full. The ODS option works OK I think.

I have just installed the latest version (moodle25_2011040105) on a 2.6 (Moodle 2.6+ (Build: 20131122) and installs fine. However, if you upgrade it for 2.6 maybe I'll wait for that version to start the serious testing
Merry Xmas / Feliz Navidad