Record of Course Activities
OpenOlat records course activities of participants and course authors in log files.
Within a course, you archive the log files in the Archiving & Reporting tool under:
Course > Administration > Archiving & Reporting > Log files
The following log files are available:
- Admin log file with personalized data of the course authors
- Statistics log file with the anonymized data of the participants
- Participants log file with detailed, personalized data of the participants
Privacy protection
For privacy reasons, the participants log file with the personalized data of the participants is only available to system administrators.
Owners of the course and persons with the course right "Archive tool" can archive log files. OpenOlat stores the selected log files as a ZIP file (e.g. CourseLogFiles_2010-01-28_14-55-55.zip) in the personal files in the folder private/archive. The ZIP file then contains the selected files course_statistic_log.xlsx, course_admin_log.xlsx and course_user_log.xlsx.
Please note that in the file course_statistic_log.xlsx the participants are anonymized as follows:
Each participant receives a randomly generated number (e.g. *7FFBA8C371B1A3DACCF5F12227A75CE82D6C4CE6), which remains constant within a course. This allows you to track the activities of participant X in course Y, but not to compare them with their activities in course Z, since participant X receives a new number in course Z.
Possible entries in the log file columns actionCrudType (database operation), actionVerb (action) and actionObject (course object handled) (grouped alphabetically):
| actionCrudType | actionVerb | actionObject |
|---|---|---|
| c | add | calendar, chat, course, cpgetfile |
| r | copy | editor, efficency |
| u | denied | feed, feeditem, file, folder, forummessage, forumthread |
| d | do | glossary, gotonode, groupmanagement, group, grouparea, groupareaempty |
| e | edit | help |
| exit | ||
| hide | ||
| launch | ||
| lock | ||
| move | ||
| open | ||
| remove | ||
| view | ||
The column actionCrudType summarizes the actions performed in basic database operations. Since these are further broken down in the actionVerb column, actionCrudType is not further relevant.
Nevertheless, here is the key:
- C=Create
- R=Read / Retrieve
- U=Update / Modify
- D=Delete
- E=Exit
The column actionVerb then examines in more detail which action the users under "userName" performed on the course object from the actionObject column. The entry in the actionObject column is thus the object that was "changed", at least from a database perspective.
The third row
u / add / participant / [group name] / [username]
is read as follows (database operation: update / modify):
Add user [username] to [group]
Further information
Course administration - Archiving & Reports >
Personal tools: File Hub >
Members management >