Follow

Bulk Upload Courses

An administrator can upload multiple courses via a .csv file.

In addition to creating new courses, this functionality may also be used to update or delete courses, or import content from another course.

Upload Files

Mandatory Fields

Your CSV file must include:

  • fullname: this is the course full name and is visible to learner in the course catalogue and record of learning
  • shortname: this is the course shortname and is visible to learner in the course page breadcrumbs
  • category: this is the category the course will sit in

Important points:

  • Column headings must match the field name in the Totara database e.g. fullname not Fullname
  • The file must be saved as a .csv file
  • The Category column requires the Category ID. This can be found in the category URL e.g. Category ID is 82 from this URL: http://sandpit.kineo.com.au/course/index.php?categoryid=82

Other available fields

The other fields that can be included in the upload are:

CSV Field Name

Course Setting

Configuration Settings

shortname

Course Shortname

1-100 characters

fullname

Course Fullname

1-250 characters

idnumber

Course ID Number

1-10 characters

category

Category ID Number

Numbers only

visible

 

1 if the course is visible, 0 if hidden

startdate

Course Start Date

The value is passed to the PHP function strtotime to generate a timestamp. Example 01.12.2014 (1st December 2014)

summary

Course Summary

Unlimited characters

format

Format

E.g. weeks, topics.

Perform Import

  1. Navigate to Upload Courses in Site administration > Courses
  2. The Upload courses page appears
  3. Upload the .csv file to File
  4. CSV delimiter, Encoding and Preview rows fields should be left as default values
  5. Set Upload mode
    1. Create new courses only, skip existing one: Where a course in the .csv has the same shortname as an existing course the course is skipped
    2. Create all, increment shortnames if needed: Where a course in the .csv has the same shortname as an existing course the shortname has a _X added to the end of the shortname to make it unique.
    3. Create new courses, or update existing ones: Where a course in the .csv has the same shortname as an existing course the settings are updated to match the file, new courses are created
    4. Only update existing courses: Where a course in the .csv has the same shortname as an existing course the settings are updated to match the file, new courses are skipped
  6. Set Update mode (This field is only available when using Create new courses, or update existing ones or Only update existing courses in the Upload Mode)
    1. No change: No updates will occur
    2. Update with CSV data only: The upload will update fields in the CSV file
    3. Update with CSV data and defaults: The upload updates fields in the CSV file and from the Course default settings
    4. Fill in missing data with CSV and defaults: The upload updates fields that are blank in the course settings either from the CSV or Course default settings.
  7. Set Allow deletes
  8. Set All renames
  9. Set Allow resets
  10. Select Preview
  11. The preview shows you a first 10 rows
  12. Courses automatically pick up the system defaults unless the defaults are specified in the CSV file or these can be set here for all courses in the upload.
  13. Select Upload courses
  14. Report of upload displays, select Continue
Have more questions? Submit a request

Comments

Powered by Zendesk