Your Moodle version

Blocks: Course Status Tracker

Maintained by Picture of 3i Logic LMS 3i Logic LMS
A plugin to track the status of enrolled & completed course of student.
Moodle 2.0, 2.1, 2.2, 2.3, 2.4

The plugin shows the number and list of enrolled courses and completed courses. It also shows the number of courses which are in progress.


Screenshot #0
Screenshot #1
Screenshot #2


Picture of 3i Logic LMS
3i Logic LMS (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of 3i Logic LMS
    Mon, Apr 20, 2015, 1:01 PM
    Dear Ratna,

    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.

    3iLogic LMS Team
  • Picture of Ratna Lal
    Tue, Apr 21, 2015, 1:10 AM
    Thank you for your direction!
  • Picture of Ratna Lal
    Thu, Apr 23, 2015, 6:46 AM
    Got the source of error. This block is using SQL server 2012, while we are using SQL server 2008. So when I am clicking on link in 'course status tracker' this is generating lots of error:

    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?
  • Picture of 3i Logic LMS
    Thu, Apr 23, 2015, 1:17 PM
    Dear Ratna,

    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.

    3iLogic LMS Team
  • Picture of Ratna Lal
    Fri, Apr 24, 2015, 4:52 AM
    Thanks 3i Logic LMS,
    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));

  • Picture of Jean-Kristof Lord
    Tue, May 12, 2015, 4:37 AM

    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.
  • Picture of 3i Logic LMS
    Tue, May 12, 2015, 7:18 PM
    Dear Lord,

    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.

    3i Logic LMS Team
  • I don't realy look like this.Honest!
    Fri, Jun 5, 2015, 9:57 PM
    We have downloaded and installed course status tracker.
    It shows enrolled courses but progress and completed are 0.
    It's 0 for both users and admins.

    Moodle 2.5.8 (Build: 20140908)
  • Picture of 3i Logic LMS
    Wed, Jun 10, 2015, 2:25 PM
    Dear James,

    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.
    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

    3i Logic LMS Team
  • Picture of József Somogyi
    Mon, Aug 3, 2015, 8:32 PM
    Hi smile
    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.
  • Picture of 3i Logic LMS
    Tue, Aug 4, 2015, 7:40 PM
    Dear Josef,

    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).

    3i Logic LMS Team
  • Picture of Sam McCullough
    Thu, Sep 24, 2015, 9:00 AM

    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,
  • Picture of 3i Logic LMS
    Thu, Sep 24, 2015, 6:43 PM
    Dear 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

    See details on Plugin documentation:

    3i Logic LMS Team
  • Picture of Nidhi Tiwari
    Wed, Oct 7, 2015, 8:27 PM
    I want to display this detail in my home page.
  • Picture of Nidhi Tiwari
    Wed, Oct 7, 2015, 8:34 PM
    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.

1 2 3 4
Please login to post comments