The columns of the summary report (Summary per participant screen, Excel, CSV and PDF exports of the summary reports) are defined in the Output columns in the summary report option of the plugin settings. They can be overridden for a given course by the report_trainingsessions_summarycolumns custom course field.

One column per line, in the form key,format. The suffix determines the data format in Excel outputs:

• A line starting with # is ignored: this is the way to disable a column without deleting it.
• Columns are produced in the order of the list.
• Empty lines are ignored.
• In a course custom field, the value default (or an empty field) falls back to the global list.

The last column tells whether the column is active in the list delivered by default.

The enrolment dates used are those of the last active, widest enrolment period that starts before the end of the report period. Future and earlier periods are discarded.

Times are durations (format d). The notions of course time, time assigned to no course and complementary times are explained in the technical guide.

These columns count trace events rather than durations. They are only filled for site administrators.

These keys are not in the list delivered by default, but can be added to it:

• city (a): user's city;
• firstcourseaccess (t): first access to the course;
• firstip (a): IP address of the first access to the course;
• profile_field_shortname: value of a custom profile field, for example profile_field_service,a;
• extrauserinfo1 and extrauserinfo2 (a): profile fields designated in the plugin settings, Additional user information option (legacy method, prefer profile_field_);
• With the Learning Time Check module, when the course has pedagogical contract tracking: ltcprogressinitems and ltcprogressinmandatoryitems (progress percentage on all items, or on mandatory items only), ltcitems and ltcdone (items and completed items), ltcmandatoryitems and ltcmandatorydone (same on mandatory items).

id,n
idnumber,a
firstname,a
lastname,a
email,a
#institution,a
#department,a
#groups,a
#lastlogin,t
#firstaccess,t
lastcourseaccess,t
activitytime,d
#othertime,d
#coursetime,d
#uploadtime,d
elapsedoutofstructure,d
elapsed,d
#extelapsed,d
extotherelapsed,d
#items,n
#hits,n
#exthits,n
#extotherhits,n
#visiteditems,n
#elapsedlastweek,d
#extelapsedlastweek,d
#extotherelapsedlastweek,d
#hitslastweek,n
#exthitslastweek,n
#enrolstartdate,t
#enrolenddate,t
workingsessions,n

Component technical section index - Back to the plugin index - Back to the catalog