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.

1. Go to the IOMAD dashboard.
2. 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).
3. Click on the Courses tab.
4. 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.

Importing from a File

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:

• userid OR username;
• courseid OR coursename;
• timeenrolled;
• timestarted;
• timecompleted;
• finalscore;