Register users in courses with CSV import

Version: Kora Courses, July 23, 2022 or later

Permissions required: Administrator

Registration import

The registration import is used to enroll users in courses and remove users from 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 Registration Import

Import and review CSV file

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

5715-1.png

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

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

    5715-3.png
  • During the import process, you can 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 of your columns. 
  • If your header row follows the default naming convention, the system will automatically map all columns. However, if your headers have different names, click on the dropdown menu to view all available column headers. You should confirm that the correct headers are mapped to their respective columns before finishing the import.

    5715-4.png
  • If there is an issue with any columns in your import file, they will be highlighted in red text (6). To proceed with the import, all highlighted problems must be corrected. The Import button will only be clickable once all issues have been addressed.

    5715-5.png

Registration import options

  • Click "Import Options" (1) to enable or disable “Overwrite registration data.”

5715-6.png

When to enable “Overwrite Registration Data”

  • If your import file consistently includes all current users, and you wish to unenroll users who are no longer present in the import file, it is recommended to enable the “Overwrite registration data”.
  • Enabling this option ensures that users not listed in the import file will be removed from the respective Digication course.
  • You can toggle the “Overwrite registration data” (2) to enable or disable this option in the popup window and click save (3).

5715-7.png

NOTES:

  • If “Overwrite registration data” is enabled (4), the Action column is NOT required (5) in your Registration Import CSV.

5715-8.png

5715-9.png

  • Once your file is ready, click import (6)

5715-10.png

  • Your file will be added to the queue for processing, and you will be taken to the Import logs page (7), where you can see the progress (8) of your import file.

5715-11.png

  • A download icon (9) will appear in front of each file name, and you can click it to save the original file to your device.

5715-12.png

  • Check the "Error Entries" column (10); if errors exist, a download icon (11) will appear next to the error count, allowing you to click it and download the error log. If no errors are present, the download icon will not be shown (12).

5715-13.png

Data columns

When enrolling users in a course, the following columns are required:

    • Course Sync ID
    • User Sync ID
    • Faculty
    • Action

NOTE: In the table below, values denoted with an asterisk (*) in the "Possible Values" column are case-sensitive. Eg:-Enroll, Unenroll, Unenroll (ignore if manually added)

Column Title

Column Description

Required

Possible Values

Course Sync ID Unique ID for the course
Example: ENGL3320 
Example: 2023FA_ENGL3320
Yes Any Unicode characters

User Sync ID

The unique, permanent identifier for the user being added or dropped from the course. 


Example: 48562739

Yes

Any Unicode characters

Faculty

Designates the course role for the user. 



If the user is to be enrolled as faculty in the course, enter “1” if the user is a student in the course enter “0" 

Yes

1

0

Action

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



No (if “Overwrite registration data” is enabled)

Yes (if “Overwrite registration data” is disabled)

Enroll*

 

Unenroll*

 

Unenroll (ignore if manually added)*

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.