The following file matrix image shows how each D2L Standard CSV column maps from one CSV file to the next. The codes in identical color-coded cells should match to create a successful link from one action to the next. For example, in the Department CSV file, the UPDATE action for code: testdepartment should map to the UPDATE action for department_code: testdepartment in the Course Template CSV file.
Figure: A file matrix that shows how each Brightspace column maps from one CSV file to the next.
Orgs - Other
The following lists 3 rows of sample content for Other org units (along with the required header line). The file consists of 12 mandatory columns, each must be populated with a valid value or left empty depending on the file format.
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code school,UPDATE,school101,Brightspace School,,,1,,,,, program,UPDATE,program101,Brightspace Program Beginner,,,1,,,,,school101 program,UPDATE,program201,Brightspace Program Advance,,,1,,,,,school101 |
Column | Field | Required | Possible Values | Notes |
1 | type | Required | Name of other org unit set up in IPSIS Admin – Config | Must be lowercase. Must be mapped in IPSIS Configuration. |
2 | action | Optional | CREATE, UPDATE, DELETE | Case insensitive. If not specified, default is UPDATE |
3 | code | Required | The code you use must be a unique value to identify one specific Org Unit and is case sensitive. it can be any alphanumeric value, however should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
|
4 | name | Required | Name of Other org unit. |
|
5 | start_date | N/A | ignored | |
6 | end_date | N/A | ignored | |
7 | is_active | N/A | ignored | |
8 | department_code | N/A | ignored | |
9 | template_code | N/A | ignored | |
10 | semester_code | N/A | ignored | |
11 | offering_code | N/A | ignored | |
12 | custom_code | Optional | Specifies a parent by Other Org Unit code. Supports pipe separation for multiple parents. |
Orgs - Department
The following lists 3 rows of sample content for a Department (along with the required header line). The file consists of 12 mandatory columns, each must be populated with a valid value or left empty depending on the file format.
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code
department,UPDATE,dept_comb,Brigthspace Combined,,,,,,,,program101|program201|school101 |
Column | Field | Required | Possible Values | Notes |
1 | type | Required | Name of other org unit set up in IPSIS Admin – Config | Must be lowercase. |
2 | action | Optional | CREATE, UPDATE, DELETE | Case insensitive. If not specified, default is UPDATE |
3 | code | Required | The code you use must be a unique value to identify any one specific Org Unit and is case sensitive. it can be any alphanumeric value, however should not include commas. Codes with more than 50 characters will be truncated. |
|
4 | name | Required | Name of Department | |
5 | start_date | N/A | ignored | |
6 | end_date | N/A | ignored | |
7 | is_active | N/A | ignored | |
8 | department_code | N/A | ignored | |
9 | template_code | N/A | ignored | |
10 | semester_code | N/A | ignored | |
11 | offering_code | N/A | ignored | |
12 | custom_code | Optional | Other Org Unit code. Supports pipe separation for multiple parents. |
Orgs - Semester
The following lists 3 rows of sample content for a Semester (along with the required header line). The file consists of 12 mandatory columns, each must be populated with a valid value or left empty depending on the file format.
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code
semester,UPDATE,sem_2020,2020 Semester,,,,,,,,program101|program201 |
Column | Field | Required | Possible Values | Notes |
1 | type | Required | semester | Must be lowercase. |
2 | action | Optional | CREATE, UPDATE, DELETE | Case insensitive. If not specified, default is UPDATE |
3 | code | Required | The code you use must be a unique value to identify any one specific Org Unit and is case sensitive. it can be any alphanumeric value, however should not include commas. Codes with more than 50 characters will be truncated. |
|
4 | name | Required | Name of Semester | |
5 | start_date | N/A | ignored | |
6 | end_date | N/A | ignored | |
7 | is_active | N/A | ignored | |
8 | department_code | N/A | ignored | |
9 | template_code | N/A | ignored | |
10 | semester_code | N/A | ignored | |
11 | offering_code | N/A | ignored | |
12 | custom_code | Optional | Other Org Unit code. Supports pipe separation for multiple parents. |
Orgs - Course Template
The following lists 3 rows of sample content for a course template Org Unit (along with the required header line). The file consists of 12 mandatory columns, each must be populated with a valid value or left empty depending on the file format.
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code course template,UPDATE,ct_bright,BP Beginner,,,,dept_bright,,,,program101 course template,UPDATE,ct_space,BP Advance,,,,dept_space,,,,program201
Courses,,,,dept_bright,,,,program101|program201 |
Column | Field | Required | Possible Values | Notes |
1 | type | Required | course template | Must be lowercase. |
2 | action | Optional | CREATE, UPDATE, DELETE | Case insensitive. If not specified, default is UPDATE |
3 | code | Required | The code you use must be a unique value to identify any one specific Org Unit and is case sensitive. it can be any alphanumeric value, however should not include commas. Codes with more than 50 characters will be truncated. |
|
4 | name | Required | Name of course template | |
5 | start_date | N/A | ignored | |
6 | end_date | N/A | ignored | |
7 | is_active | N/A | ignored | |
8 | department_code | Required | Department Org Unit code Supports pipe separation for multiple parents |
|
9 | template_code | N/A | ignored | |
10 | semester_code | N/A | ignored | |
11 | offering_code | N/A | ignored | |
12 | custom_code | Optional | Other Org Unit code. Supports pipe separation for multiple parents. |
Orgs - Course Offering
The following lists 4 rows of sample content for a course offering (along with the required header line). The file consists of 12 mandatory columns, each must be populated with a valid value or left empty depending on the file format.
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code
course offering,UPDATE,brightbeg102,Beginner Course Name2,2020-01-01,2020-12-02,1,dept_bright,ct_bright,sem_bright|sem_2020,,program101|school101 course offering,UPDATE,brightadv201,Advance Course Name1,2020-01-01,2020-12-02,1,dept_space,ct_space,sem_space|sem_2020,,program201|school101
|
Column | Field | Required | Possible Values | Notes |
1 | type | Required | course offering | Must be lowercase. |
2 | action | Optional | CREATE, UPDATE, DELETE |
Case insensitive. If not specified, default is UPDATE. |
3 | code | Required | The code you use must be a unique value to identify any one specific Org Unit and is case sensitive. it can be any alphanumeric value, however should not include commas. Codes with more than 50 characters will be truncated. |
|
4 | name | Required | Name of course offering | |
5 | start_date | Optional | yyyy-mm-dd yyyy-mm-ddThh:mm:ss.fff | If no time is specified default time is T00:00:00.000 |
6 | end_date | Optional | yyyy-mm-dd yyyy-mm-ddThh:mm:ss.fff | If no time is specified default time is T00:00:00.000 |
7 | is_active | Optional | 1, 0, TRUE, FALSE | If not specified, default is 1. Case insensitive. |
8 | department_code | N/A | ignored | |
9 | template_code | Required | Course template Org Unit code Supports pipe separation for multiple parents |
|
10 | semester_code | Required | Semester Org Unit code Supports pipe separation for multiple parents | |
11 | offering_code | N/A | ignored | |
12 | custom_code | Optional | Other Org Unit code. Supports pipe separation for multiple parents. |
Orgs - Course Section
The following lists 5 rows of sample content for a course section (along with the required header line). The file consists of 12 mandatory columns, each must be populated with a valid value or left empty depending on the file format.
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code course section,UPDATE,sec101,Beginner Course Name AM,,,,,,,brightbeg101, course section,UPDATE,sec102,Beginner Course Name,,,,,,,brightbeg102, course section,UPDATE,sec103,Beginner Course Name PM,,,,,,,brightbeg101, course section,UPDATE,sec201a,Advance Course Name,,,,,,,brightadv201, course section,UPDATE,seccomb,Combined Course Name,,,,,,,brightcomb, |
Column | Field | Required | Possible Values | Notes |
1 | type | Required | course section | Must be lowercase. |
2 | action | Optional | CREATE, UPDATE, DELETE | Case insensitive. If not specified, default is UPDATE |
3 | code | Required | The code you use must be a unique value to identify any one specific Org Unit and is case sensitive. it can be any alphanumeric value, however should not include commas. Codes with more than 50 characters will be truncated. |
|
4 | name | Required | Name of course section | |
5 | start_date | N/A | ignored | |
6 | end_date | N/A | ignored | |
7 | is_active | N/A | ignored | |
8 | department_code | N/A | ignored | |
9 | template_code | N/A | ignored | |
10 | semester_code | N/A | ignored | |
11 | offering_code | Required | Course offering org code Pipe separation not supported |
|
12 | custom_code | N/A | Not supported. Must be null. |