Upload course completions

You can import historical completion records from a CSV file and enrol users into the specified courses. All completions imported that relate to courses that currently exist on the system will be added as Record of Prior Learning (RPL Completions). This will be indicated in reports which include these imported completions.

Evidence can optionally be created for any courses in the import which do not exist in the system.

1. To access the upload area, go to Quick-access menu > Courses and categories > Upload completion records > Upload course records / Upload certification records.
2. The CSV import file is created outside of Totara and imported. The date format, delimiter and encoding type will be selected before importing. The CSV file should contain the following columns in the first line of the file:
   • username: The username from the learner’s profile.
   • courseshortname: The course short name found on the Course settings page.
   • courseidnumber: The course ID number found on the Course settings page.
   • completiondate: The date the learner completed the course. The date format can be specified in the upload settings.
   • grade: The grade the learner received in the course.
3. You can drag and drop the file onto the page or click the Choose a file button to select the CSV file.
   • Create evidence: If you check this box then any courses/certifications that aren't found in the system will be recorded as evidence in the Record of Learning.
   • CSV Date format: Select the format dates will use.
   • CSV Grade format: Select the grade format used.
   • CSV Values separated by: Select the delimiter used in the file. Comma, semi-colon, colon or tabs can be used.
   • CSV Text Delimited with: Select the delimiter used for text values. Single quote, double quote or no delimiter can be used.
   • CSV file encoding: Select the type of encoding used for the file.
   • Override current course completions: Select if you want the uploaded course completions to replace the existing course completion records all the time, never, or only if more recent.
   • Case insensitive shortnames: When enabled, course short names will be matched case insensitively. We strongly advise any case issues be corrected in the uploaded file as this will cause performance issues.

4. Click the Upload button.

After you have uploaded the file the import will be processed on the next cron run. To view more detail about the import, click the Course import report link. You can also access imported records by navigating to Quick-access menu > Courses > Upload completion records > Course import report.