In this section, we’ll cover how each D2L Standard CSV column maps from one CSV file to the next.
Across the Orgs files, the key field is code. This field is the primary identifier of an org unit in the CSV files. The other code fields (department_code, template_code, semester_code, offering_code, and custom_code) each refer to a primary identifier for an org unit.
In the Users file, the key field is either username or org_defined_id, depending on which is setup in IPSIS Administration > Configuration for your source system.
Lastly, the Enrollments file connects a user identified in the child_code field with an org unit identified in the parent_code field.
We can illustrate this relationship with an example:
- A custom org unit called Willow College (and school number 90775).
- It will contain a department called Math and Science.
- There will be one course called Introduction to Natural Numbers 101 F24 Mr. Baily with two sections named 101A and 101B.
- The offering will be part of semester 2023-2024.
- The offering will belong to a course template called Natural Numbers 101 Models.
- We’ll create user named Satish Anand (with limited access) and enroll the user with the role, Learner, in section 101B.
To setup the org units, user, and enrollment, the CSV files have the field values as shown in the table below.
|
Note: Only the relevant fields are shown for illustration of the relationships between key fields in the CSV files. You may need to populate other fields of the fields based on your exact requirements. |
| File |
Field |
Value |
|---|
| 1 - Other |
type
code
name
|
college
college 90755
Willow College
|
| 2 - Departments |
type
code
name
custom_code
|
department
Math and Science
Math and Science
college 90775
|
| 3 - Semesters |
type
code
name
|
semester
2023-2024
2023-2024
|
| 4 - Templates |
type
code
name
department_code
|
course template
models-natural numbers-101
Natural Numbers 101 Models
Math and Science
|
| 5 - Offerings |
type
code
name
template_code
semester_code
|
course section
M-NN-101-F24
Natural Numbers 101 F24 Mr. Baily
models-natural numbers-101
2023-2024
|
| 6 - Sections |
type
code
name
offering_code
type
code
name
offering_code
|
course section
M-NN-101-F24-101A
101A
M-NN-101-F24
course section
M-NN-101-F24-101B
101B
M-NN-101-F24
|
| 7 - Users |
type
username
role_name
|
user
satish.anand.03
Learner-Limited
|
| 8 - Enrollments |
type
child_code
parent_code
role_name
|
enrollment
satish.anand.03
M-NN-101-F24-101B
Learner
|