Courses - Creating Import Files for Course Import (Administrator)
TABLE OF CONTENTS
Introduction
Creating all courses at the start of the school year is time-consuming. Many schools therefore use an integration with their administration system. With an integration, courses can be created automatically and participants can be added to them. For schools without an integration, itslearning can run an import on request. In that case, the school must supply an import file.
1 Import file format
The import file is an Excel file (.xlsx) and can contain the following columns:
| Column | Required | Description |
|---|---|---|
| course title | Yes | The title of the new course (max. 64 characters). |
| course code | No | The code of the new course (max. 64 characters). |
| course synchronisation key | Yes | The synchronisation key of the new course. |
| teacher synchronisation key | No | The synchronisation key of the teacher to be added to the course. |
| hierarchy group synchronisation key | Yes | The synchronisation key of the folder in the hierarchy under which the new course is placed. |
| template course synchronisation key | No | The synchronisation key of the course to be used as a template for the new course. |
2 Using template courses
You can also create courses based on a template course. For this, the option Share with <site name> must be ticked in the settings of the template course (More > Settings > Course properties and features):
The template course must also have a synchronisation key. For courses that were created manually, the key must be entered in the course settings. This option is made available on request by itslearning support:
Add the synchronisation key you entered in a separate column. The finished file then looks like this:
3 FAQ
3.1 Can I also import the descriptive name of a course?
No. The descriptive name can only be set manually in the course itself, under More > Settings > Course properties and features.
3.2 Can I add several teachers to one course?
Yes. Each row can contain at most one teacher. To add more teachers to the same course, use several rows:
More Help Resources
Have more questions? Please start with asking your school administrator.
Product Release notes
Stay updated with itslearning latest releases: https://itslearning.com/product-updates
Service Status
Check the current status of itslearning services: https://status.itslearning.com/
Ideas Portal
Share your ideas and help shape the future of itslearning: https://ideas.itslearning.com/
Roadmap
Check out our roadmap: https://itslearning.com/global/roadmap/