|
|
|
Course administrators can add, update and delete learning modules in bulk at module, session and class level via the Course CSV Loader. The Course CSV Loader imports a comma—or semicolon—separated values (CSV) file containing a heading row and any number of data rows. Additional headers and data can be included for custom module and session attributes.
An extract of the first five fields in a Course CSV file as it would appear in a text editor
Action,ModuleID,ModuleLearningType,ModuleTitle,ModuleDescription
A,MOD-0123,O,Ethics in the Workplace,"The course is about the application of moral principles, standards of behavior, or set of values regarding proper conduct in the workplace as individuals and in a group setting. It teaches the learners to distinguish between right and wrong in the workplace."
You do not need to add values for every heading to import a Course CSV file, but certain fields must have values, depending on the action and learning module type. You can continue to configure learning modules created or updated from a CSV import in the Catalog Editor.
To add a new learning module, the following fields in your course template CSV file must have values:
The fields that must be populated with values to update or delete an existing learning module, session or class are as follows:
To update or delete a specific class, the ModuleID, SessionID, and the ClassStart and ClassEnd dates must be specified.
To update or delete a specific session, only the ModuleID and SessionID need to be specified.
To update or delete a learning module, only the ModuleID is required.
To prepare a Course CSV file for import, you can download a template CSV file from the Course CSV Loader page and populate the fields as required, or you can run report R246 or R247 to export one or more courses to a CSV file and update the field values. The CSV file template you download from the Course CSV Loader page includes any custom module and session attributes.
Note that CSV files are likely to be opened by Microsoft Excel if it is installed on your system. If you encounter any problems with importing a CSV file into the LMS, it could be caused by Microsoft Excel applying extra formatting to the file. Alternatively, you can edit CSV files in a text editor instead of Microsoft Excel. The data should conform to the formatting required by the template as specified in the corresponding CSV Formatting Help.
The values for text area fields, such as ModuleDescription, must be enclosed in double quotation marks (" ") so that they can include punctuation. Do not include commas or semi-colons in other fields as they could be interpreted as a field delimiter (depending on your choice of delimiter at import).
Additional Information
