Can I therefore request as an enhancement to Totara, that a new admin section be added for the site admin (or possibly even an expansion of Totara Sync) which allows an upload of a CSV file of user IDs, course IDs and completion dates which can then be written to the Course Completion part of the database?

Thanks

Dan

I have been successful in importing data directly to the mdl_course_completions table. This allows for a system level report of completions import and reporting, however the completion records do not show up in a user's record of learning and in some other places. I have realized that the courses for which the historical data is imported must not only exist, but the user must also be enrolled in the course and the course must have completions enabled and at least one completion criteria set. This means also importing data into the mdl_course_completion_crit_compl table.

A few things: I am hoping the import feature Totara adds will account for:

1) import via CLI: the clients I am dealing with have hundreds of thousands of records to import and this would not be a good thing to perform via the user interface

2) that the import tool will account for the existence of courses for the record, the enrollment, and the completion settings ie: mdl_course_completion_crit_compl database table.

At this point I am still unsure if additional relational data must be imported to make the import I have performed more robust. If anyone has more knowledge of this I would certainly appreciate your input.

Thanks!