Import completion records

The Import completion records page is used for managing the importation of completion records to IOMAD, either from Moodle or from a file.

Go to the IOMAD dashboard.
Choose the company you'd like to edit from the Select a company dropdown (or use the company selector at the top right of the page).
Click on the Courses tab.
Select Import completion records.

Actions

There are three actions that can be taken from the Import completion records page:

Check course settings for import: When clicked, this action will display two values: the Number of courses which do not have completion enabled and the Number of courses which have no completion criteria. Clicking their respective View button will toggle a list of these courses, if there are any.

Import stored completion information from Moodle tables: Since IOMAD sits on top of Moodle, the two databases can occasionally fall out of sync. This action will update completion data in the IOMAD databases using data from some of the Moodle databases.

Import completion information from file: This link allows the admin or manager to upload a file specifying user completion data. The structure of this file is explored below, in the Importing from a File section.

The following columns can appear in the CSV file to be uploaded:

username: The unique Username of the user (not to be confused with their First/Last name, which is not unique).
userid: The unique id of the user.
coursename: The unique Course short name of the course that the completion records are to be attached to.
courseid: The unique Course ID number of the course that the completion records are to be attached to.
timeenrolled: The date that the user was enrolled in the course. This field uses the YYYY-MM-DD date format.
timestarted: The date that the user started the course. This field uses the YYYY-MM-DD date format.
timecompleted: The date that the user completed the course. This field uses the YYYY-MM-DD date format.
timeexpires: The date that the user's completion will/has expire(d). This field uses the YYYY-MM-DD date format.
finalscore: The final grade that the user achieved for the course.
licensename: The unique license name that the user was allocated.
company: The unique Shortname of the company that the user belongs to.
department: The unique Department short name that the user belongs to.

The required fields are: