Your Moodle version

Blocks: Course Status Tracker

block_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.
2k
3
Moodle 2.5, 2.6, 2.7, 2.8

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

Screenshots

Screenshot
Screenshot
Screenshot

Contributors

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 Paul Burgo
    Fri, Feb 27, 2015, 8:38 PM
    Thanks for the response. I uninstalled the plugin and I am still having the same issue of not being able to open the site administration. Everything was working fine until I installed this plugin. This issue occured immediately following the install when I tried to access site administration. I would appreciate any help you can give.
  • Picture of 3i Logic LMS
    Fri, Feb 27, 2015, 9:28 PM
    Dear Paul,

    We will investigate and look into it more closely and get back to you soon.

    Regards,
    3i Logic LMS Team.
  • Picture of Steven Swanepoel
    Tue, Mar 10, 2015, 7:53 AM
    Hello,

    This plugin would be most useful to our version of Moodle, however I have encountered a major issue when I've installed it. I can't get back to the homepage after I've installed it. I was able to uninstall it by going to /admin/blocks.php .

    Regards
    Steven
  • Picture of 3i Logic LMS
    Tue, Mar 10, 2015, 6:36 PM
    Dear Steven,

    Thank you for raising issue. We have resolved issue and uploaded it. Kindly download latest version. If you need any further information feel free to contact us.

    Regards,
    3ilogic LMS Team
  • Picture of Yogesh Nahar
    Wed, Mar 11, 2015, 2:23 PM
    Hello,

    The new version of the plugin solves the admin panel access issue. Thank you for this.

    But I am still getting the block displaying duplicate course completion and in progress data. I have a student with only one enrollment. But the block displays courses in progress as '13' and courses completed as '14'. When clicking on the '14' link it duplicates the single course enrollment that many times.

    Please advice.

    Regards,
    Yogesh Nahar
  • Picture of 3i Logic LMS
    Fri, Mar 13, 2015, 10:40 AM
    Dear Yogesh,

    Sorry for delaying. We will diagnose this problem and its better to provide following screenshots.

    1) Overview report of User
    2) Course Status Tracker block
    3) List of enrolled courses
    4) List of completed courses

    You may directly send us at lms@3ilogic.com.

    Regards,
    3i Logic LMS Team.
  • Picture of Ratna Parashar
    Fri, Apr 17, 2015, 3:16 AM
    Today I installed this block plugin and I am also getting the block displaying duplicate course completion and in Enrolled Courses. I have a student with only one enrollment. But the block displays courses in progress as '6' and when I click on link I am getting data base related error "Error reading from database".

    Please advice.

    Regards,
  • Picture of 3i Logic LMS
    Fri, Apr 17, 2015, 1:17 PM
    Hi Ratna,

    Thank you for using course status tracker.

    We have gone through your query related to our plugin and diagnosed that you are using 'Self completion' criteria for activity completion or may be other criteria. Course Status Tracker worked on 'Course Grade' condition.
    We also want to know that in which link you clicked.

    Regards,
    3i Logic LMS Team.
  • Picture of Ratna Parashar
    Sat, Apr 18, 2015, 12:32 AM
    Thanks for quick response!!
    Yes! For activity completion we are using different criteria. For your question, I clicked on 'number' linked to 'Enrolled Courses' in COURSE STATUS TRAKER block on 'My home' page.
    Is there any other way for tracking course progress for various completion criteria?

    Thanks and regards,
  • 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.

    Regards,
    3iLogic LMS Team
  • Picture of Ratna Parashar
    Tue, Apr 21, 2015, 1:10 AM
    Thank you for your direction!
  • Picture of Ratna Parashar
    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.

    Regards,
    3iLogic LMS Team
  • Picture of Ratna Parashar
    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));

    thanks,
1 2 3
Please login to post comments