hey.. I'm just tring to instal your plugin but I have problem. When Im trying to instal REPORT it's show information that I need to instal BLOCK before.. but when Im trying instal BLOCK it's show me message I need to have REPORT before.

You need to put both plugins into their folders and then try and install them together. They both have a dependency of each other to exist and install.

Hi, great plugin;)

A couple of things:

Can we change the title from GSM to something more meaningful?

How about a loop to process all courses at once so we can just download the Spreadsheet? By processing each category it makes it almost unusable if you have many courses with sub-category after sub-category.

My feeling is that the real value of this plugin isn't necessarily the badge element but rather what resources each course has, something Moodle is very lacking in.

Hi Jamie,

Thanks for your kind words. I plan on doing what you have said as part of the next release along some funky new features so keep your eyes peeled. You can rename the block title by changing the language string in the front end of moodle under Site Administration > Language > Language Customisation and search for gsb and change the neccessary language string.

Thanks again for your feedback.

Hi RIchard,

I have installed both the block and report successfully. However, when I run a report I get the following SQL error:

Error reading from database
Debug info: ERROR: operator does not exist: bigint = character varying
LINE 2: ..._course INNER JOIN mdl_block_gsb ON mdl_course.id = mdl_bloc...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
SELECT mdl_block_gsb.id AS gb, mdl_course.id, mdl_course.shortname, mdl_course.fullname, mdl_block_gsb.gsb, mdl_block_gsb.enrolnum, mdl_block_gsb.gsboverride
FROM mdl_course INNER JOIN mdl_block_gsb ON mdl_course.id = mdl_block_gsb.ids
WHERE (((mdl_course.category)=52))
ORDER BY mdl_course.id;
[array (
)]
Error code: dmlreadexception
Stack trace:
line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 248 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 753 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 251 of /report/gsb/gsb_by_department.php: call to pgsql_native_moodle_database->get_records_sql()

I've tried deleting the block/report plugins and re-installed but get the same error when running a report.

Thanks in advance.
Majid.

The new Version should fix this as I have looked at using less MySQL reliant queries however, I do not have a Postgres or MS SQL setup so please do feed back any issues. Thanks

Small bug fix today to take into account another MS SQL change.

Small bug fix pointed out earlier which mean't it was only displaying one course per category. Now fixed.

Hey,

Were planning to upgrade to 2.7 soon, has anyone tested this plugin in 2.7? If not I will do so later this month.

I've tried this on one of our instances, and noticed that it doesn't handle subdirectories. We have some categories that then have subcategories where the courses actually sit - and when you choose the main category (top level) from the list, it doesn't even offer a list of subcategories for that category to report on them. Are there plans to expand this so it either lets you choose each subcategory, or recursively searches the main category and shows each subcategory title in the list showing the report for that category?

Thanks for the pm for the enable subcategories tickbox.
Features suggestion - list the reports for subcategories that are in a category on the report page (like how the Manage Courses page does it)

Hello all,

I'm currently using moodle 2.7 and was wondering how to enable the auto calculate feature. I think i read somewhere that this had been disabled on the 2.7 version and was wondering what settings/code would need to be changed to auto calculate my courses.

Kind regards,
Tim.

Richard will you be updating for Moodle 2.7?

Hi Bill, I am not a developer in the day job anymore but hope to get it to work in the future with 2.7 and 2.8. I think the code needs be updated to take advantage of the new logging API but as of yet, I haven't found the time to familiarise myself with it.

AS this thread is not updated, can I assume this is no longer supported?