Version: Kora Courses, July 23, 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.
- 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).
- Once the file uploads, the system will automatically display a preview of the initial lines of data (3).
- 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.
- 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.
- Click IMPORT OPTIONS (7) to set the course timezone (8).
- 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).
Data columns
When creating a new course, the following columns are required:
-
- Sync ID
- 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 |
If no value is given, "Add only" is used. |
|
Sync ID |
Unique ID for the course Example: ENGL3320 |
Yes |
Any Unicode characters
|
|
Course Type |
The type of Course or Group being created. |
No |
COURSE COMMUNITY ASSESSMENT_GROUP 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. |
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. |
Comments
Please sign in to leave a comment.