Create, update, and delete courses with CSV import

Version: Kora Courses, July 2023 or later
Permissions required: Administrator

Course Import

The course import is used to create new courses, update course information, and delete courses. 

In order for the files to process correctly, CSV files for automated imports must use the CSV headers provided in our CSV import templates.

Download a template for the Course Import

Import and Review CSV File Using the Admin Interface

  • To access the CSV imports, go to the Kora administration area and click "Import"(1) then Upload. 

5710-1.png

  • Once you’ve created your CSV file, import it by either selecting the file or dragging and dropping it into the courses import area (2).

5710-2.png

  • Once the file uploads, the system will automatically display a preview of the initial lines of data (3).

5710-3.png

  • During the import process, you have the option to review and map your columns and headers. The drop-down menu (4) in the first row allows you to select the appropriate headers (5) for each column. 

The dropdown shows you all of the available column headers. You should confirm that the correct headers are mapped to your columns before finishing the upload.

5710-4-v1.png

  • If there is an issue with any columns in your import file, the columns that need to be corrected will be highlighted in red text (6). You will not be able to click the Import button until you correct any issues highlighted in red.

5710-5.png

  • Click IMPORT OPTIONS (7) to set the course timezone (8).

5710-6.png

5710-7.png

  • Once your file is ready, click IMPORT (9). Your file will be added to the queue for processing, and you will be taken to the Import Logs page (10), where you can see the progress of your import file (11).

5710-8.png

5710-9.png

Data Columns

When creating a new course, the following columns are required:

    • Title
    • Start Date
    • End Date

The course import also includes other optional columns to import additional information for each course. There is no required order for the columns. 

Column Title

Column Description

Required

Possible Values

Action

This column will determine how Digication processes the data in the import file.

No

  • Add only
  • Add or update
    If the course exists, the record will be updated with the data on the file.
  • Add or update (Ignore if exist)
    If the course exists, the data will not be overwritten with the data on the file.
  • Add or update (Skip if blank)
    If a field is empty, the import will skip that field. Existing fields will be updated with the data on the file.
  • Update only 
  • Update only (Ignore if exist)

If no value is given, "Add only" is used.

Sync ID

Unique ID for the course


Example: ENGL3320

Yes during update or deletion of course

Any Unicode characters

 

If no value is given, this is left blank.

Course Type 

The type of Course or Group being created.

No

COURSE

COMMUNITY

ASSESSMENT_GROUP SHELL


If no value is given, "COURSE" is used.

Title

Course Title


Example: English 3320 - Shakespeare and his world

Yes

Any Unicode characters

Course Number

Number of the course from your institution’s registration data. 

No

Any Unicode characters

 

If no value is given, no change occurs with this information.

Description

Description of the course. Will appear on the Course Settings page.


Example: The plays and poems of Shakespeare, their historical and cultural background, and their continuing significance in interpretation, appropriation, and performance.


No

Any Unicode characters

 

If no value is given, no change occurs with this information.

Active

Identifies whether the course is active or inactive.


If a course is inactive, it will not appear for users in the system. Administrators can still access the course via the course URL or the course list in the administration area.

No

1 (for active)

0 (for inactive)

 

If no value is given, "1" is used.

Start Date 

Course Start Date


Example: 2023-08-31T00:00

Yes

Date Format: YYYY-MM-DDT00:00

End Date 

Course End Date


Example: 2023-12-31T23:59

Yes

Date Format: YYYY-MM-DDT00:00

Section Number

Section number of the course from your institution’s registration data.



No




Any Unicode characters

 

If no value is given, no change occurs with this information.

Department Code

Department code of the course from your institution’s registration data.

No

Any Unicode characters

 

If no value is given, no change occurs with this information.


Import Assignments Using Course IDs

If you want to import assignments from another course in your system, you can provide the course ID and have the assignments imported into the course you’re creating. 


Example: `01F4YGRBPPF7ZN4RPDDD8SP1V4`

No

Course IDs for existing courses in your system

 

If no value is given, no change occurs with this information.

Import Assignments Using Assignment IDs

If you want to import specific existing assignments in your system, you can provide the assignment ID and have the assignments imported into the course you’re creating. 


Example: `01F4YGRBPPF7ZN4RPDDD8SP1V4`

No

Assignment IDs for existing assignments in your system

 

If no value is given, no change occurs with this information.

Custom Metadata

Course metadata is used to categorize courses with information that isn’t already in the course settings. Many schools use course metadata to create datasets of specific users for assessment purposes. 


For example, a department collecting student work from 1000 students in 50 classes may be interested in specifically assessing student submissions from Biology classes that are required for a degree. A metadata category for “Required for Degree” would enable this type of data collection.


This column enables you to create a column for course metadata and add metadata for individual courses.

Example:

Title example Metadata: Required for Degree

Cell value example:
Biology



No

Format: 


Metadata: <Your Custom Metadata>

 

If no value is given, no change occurs with this information.

Enable Notification

This column enables you to send an email notification to new users upon account creation.


You can decide on a per user basis whether or not to send a welcome email.


Only newly created users will be notified. There is no way to email existing users through this CSV import


If you do not want to email the user, leave this column blank.


1 (Enables Notification Email)


0 (Disables Notification Email)



No

1 (Enables Notification Email)


0 (Disables Notification Email)

 

If no value is given, "0" is used.



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.