Moodle plugins directory: Course Status Tracker | Moodle.org
Course Status Tracker
Blocks ::: block_course_status_tracker
Maintained by 3i Logic LMS
A plugin to track the status of enrolled & completed course of student.
Latest release:
160 sites
16 downloads
35 fans
Current versions available: 2
The plugin shows the number and list of enrolled courses and completed courses. It also shows the number of courses which are in progress.
Contributors
3i Logic LMS (Lead maintainer)
Please login to view contributors details and/or to contact them
Currently our plugin is not supporting all criteria. Moodle completion criteria can track all conditions. you may use this criteria but you can see course status in course page by completion block instead of viewing all course status on single place.
Regards,
3iLogic LMS Team
Debug info: SQLState: 42000
Error Code: 195
Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]'concat' is not a recognized built-in function name.
SELECT concat(firstname," ",lastname) as name,department, timecreated as date FROM mdl_user WHERE id = '2'
[array (
0 => '2',
)]
Error code: dmlreadexception
Stack trace: ◦line 423 of \lib\dml\moodle_database.php: dml_read_exception thrown
◦line 260 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
◦line 367 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
◦line 788 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
◦line 836 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
◦line 1397 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_records_sql()
◦line 124 of \blocks\course_status_tracker\lib.php: call to moodle_database->get_record_sql()
◦line 56 of \blocks\course_status_tracker\view.php: call to user_details()
any suggestion or help?
Thank you for diagnose this issue. Plugin currently support MySQL database, however you need to replace following lines for SQL server database.
Goto your moodledirectroy/blocks/course_status_tracker/lib.php
Search 'concat' keyword
Replace whole line with following line
$result = $DB->get_record_sql('SELECT (firstname+ " " + lastname) as name,department, timecreated as date FROM {user} WHERE id = ?', array($id));
We hope problem would be resolved after replacing above line.
Regards,
3iLogic LMS Team
but the suggested code is also not worked.
Finally, this is what worked for me, in case if this is use full for others too with SQL Server
$result = $DB->get_record_sql('SELECT '.$DB->sql_concat('firstname', "' '" , 'lastname').' as name, department, timecreated as date FROM {user} WHERE id = ?', array($id));
thanks,
We are also experiencing a Count issue and duplicated lines in the view page. I don't know if it is a fluke, but we have 3 activity completion criteria and plus the grade criteria, which is adding up to 4, and it is what the block calculates:
Completed Courses : 4 --> The student has only completed 1 course (fact)
The view shows 3 redundant rows:
Serial No. Titre du cours Course Completion Date Notes
1 CourseNameA 30 mars 2015 0%
2 CourseNameA 30 mars 2015 0%
3 CourseNameA 30 mars 2015 0%
4 CourseNameA 30 mars 2015 100%
Is it possible that the Block is adding up the Activity completion criteria to?
Thanks for your time.
Thanks you for using this plugin.This issue occurs when selecting other criteria inseated of grading criteria. Currently this plugin support only grade criteria and we may consider your query if we update this plugin.
Regards,
3i Logic LMS Team
It shows enrolled courses but progress and completed are 0.
It's 0 for both users and admins.
Moodle 2.5.8 (Build: 20140908)
You need to enable course completion criteria. Please follow the steps below to enable course completion tracking.
1. Login with admin account and click on 'Advanced features' under site administration
2. Check ' Enable completion tracking' and save the setting
3. Go to the course setting where you want to enable tracking and set 'completion tracking' under student progress section and click on 'save changes' button
4. Now click on completion tracking under 'course administration'
5. Set the value ‘Course is complete when ANY of the conditions are met’ in ‘Completion Requirements’
6. Set the value in ‘Course grade’ condition and click on 'save changes' button
After course completion you need to run cron script. To run cron script follow bellow steps.
1. Login with admin account and click on 'Notifications' under site administration
2. Click on ‘cron.php maintenance script’
Note : you may directly run the following URL.
http://yourmoodlesite.com/admin/cron.php
Remember to change ‘yourmoodlesite’ in the link with your Moodle site name.
If you have still any problem, Please feel free to contact us. You may also directly reach as at lms@3ilogic.com
Regards,
3i Logic LMS Team
I have a simple question/problem. Please help me, how can I change the user first and last names in the report (for example: "Test User" => "User Test") ? What are (and where) the PHP codes what need to change or modify?
Thanks and regards
Somogyi J.
Thank you for using Course Status Tracker plugin. If you want to do some change in name, you just search this line "concat(firstname," ",lastname)" on lib.php and replace with concat(lastname," ",firstname).
Regards,
3i Logic LMS Team
I'm helping a client with your plugin. The version of the plugin is: 2014051200
When viewing a Course Completion Report for a user if they hit the next button they get an error. I logged into their site and turned on debugging mode. I retrieved the following stack dump.
Debug info:
Error code: missingparam
Stack trace:
line 463 of /lib/setuplib.php: moodle_exception thrown
line 545 of /lib/moodlelib.php: call to print_error()
line 29 of /blocks/course_status_tracker/view.php: call to required_param()
They are also having issues with the completion report returning multiple rows of course completion for a single course. Sometimes on days the user was never even in the course.
Best Regards,
Sam
Thanks you for using Course Status Plugin.The version that you are using is too older, please use version (2015020201).
Returning multiple rows in course completion report issue mostly occurs when using others course completion criteria instead of 'grade' criteria. Please set course completion criteria on specific grade as this Plugin based on 'grade' criteria for course completion.
If you still facing problem, please feel free to contact us. You may reach us directly too at lms@3ilogic.com.
See details on Plugin documentation:
http://3ilogic.com/plugindoc/Course%20Status%20Tracker.pdf
Regards,
3i Logic LMS Team
I want to display this result on user's dashboard. Any idea to do this ? Also my department name are missing also I am not getting job title. Please help me to fulfill my requirement.