There are several types of Org formats:
- Orgs - Other
- Orgs - Department
- Orgs - Semester
- Orgs - CourseTemplate
- Orgs - Course Offering
- Orgs - CourseSection
Orgs - Other
The following lists 3 rows of sample content for other org units along with the required header line. The file consists of 11 to 13 mandatory columns, depending on the version of D2L Standard CSV that you're using. Each must be populated with a valid value or left empty depending on the file format.
|
Note: Custom org units outside of the standard D2L org structure is supported in D2L Standard CSV version 2.0 or higher. |
type,action,code,name,start_date,end_date,is_active,department_code,template_code,semester_code,offering_code,custom_code,discover
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 |
Max Length: 50 |
The code you use must be a unique value to identify one Org Unit and is case sensitive. It can be any alphanumeric value. It should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
| 4 |
name |
Required |
Max Length: 128 |
Name of 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 |
|
Other Org Unit code. Supports pipe separation for multiple parents. Column required in D2L Standard CSV version 2.0 and higher. |
| 13 |
discover |
N/A |
|
Ignored. Column required in D2L Standard CSV version 3.0 and higher. |
Orgs - Department
The following lists 3 rows of sample content for departments along with the required header line. The file consists of 11 to 13 mandatory columns, depending on the version of D2L Standard CSV that you're using. 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,discover
department,UPDATE,dept_bright,Brightspace Beginner,,,,,,,,program101|school101,
department,UPDATE,dept_space,Brightspace Advance,,,,,,,,program201|school101,
department,UPDATE,dept_comb,Brigthspace Combined,,,,,,,,program101|program201|school101,
| Column |
Field |
Required |
Possible Values |
Notes |
|---|
| 1 |
type |
Required |
department |
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 |
Max Length: 50 |
The code you use must be a unique value to identify one Org Unit and is case sensitive. It can be any alphanumeric value. It should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
| 4 |
name |
Required |
Max Length: 128 |
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. Column required in D2L Standard CSV version 2.0 and higher. |
| 13 |
discover |
N/A |
|
Ignored. Column required in D2L Standard CSV version 3.0 and higher. |
Orgs - Semester
The following lists 3 rows of sample content for semesters along with the required header line. The file consists of 11 to 13 mandatory columns, depending on the version of D2L Standard CSV that you're using. 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,discover
semester,UPDATE,sem_bright,Beginner Semester,,,,,,,,program101,
semester,UPDATE,sem_space,Advance Semester,,,,,,,,program101,
semester,UPDATE,sem_2020,2020 Semester,,,,,,,,program101|program201,
| Column |
Field |
Required |
Possible Values |
Notes |
|---|
| 1 |
type |
Required |
semester |
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 |
Max Length: 50 |
The code you use must be a unique value to identify one Org Unit and is case sensitive. It can be any alphanumeric value. It should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
| 4 |
name |
Required |
Max Length: 128 |
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. Column required in D2L Standard CSV version 2.0 and higher. |
| 13 |
discover |
N/A |
|
Ignored. Column required in D2L Standard CSV version 3.0 and higher. |
Orgs - Course Template
The following lists 3 rows of sample content for course templates along with the required header line. The file consists of 11 to 13 mandatory columns, depending on the version of D2L Standard CSV that you're using. 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,discover
course template,UPDATE,ct_bright,BP Beginner,,,,dept_bright,,,,program101,
course template,UPDATE,ct_space,BP Advance,,,,dept_space,,,,program201,
course template,UPDATE,ct_comb,BP Combined Courses,,,,dept_bright,,,,program101|program201,
| Column |
Field |
Required |
Possible Values |
Notes |
|---|
| 1 |
type |
Required |
course template |
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 |
Max Length: 50 |
The code you use must be a unique value to identify one Org Unit and is case sensitive. It can be any alphanumeric value. It should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
| 4 |
name |
Required |
Max Length: 128 |
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 |
N/A |
|
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. Column required in D2L Standard CSV version 2.0 and higher. |
| 13 |
discover |
N/A |
|
Ignored. Column required in D2L Standard CSV version 3.0 and higher. |
Orgs - Course Offering
The following lists 4 rows of sample content for a course offerings along with the required header line. The file consists of 11 to 13 mandatory columns, depending on the version of D2L Standard CSV that you're using. 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,discover
course offering,UPDATE,brightbeg101,Beginner Course Name1,2020-01-01,2020-12-02,1,,ct_bright,sem_bright|sem_2020,,program101|school101,
course offering,UPDATE,brightbeg102,Beginner Course Name2,2020-01-01,2020-12-02,1,,ct_bright,sem_bright|sem_2020,,program101|school101,1
course offering,UPDATE,brightadv201,Advance Course Name1,2020-01-01,2020-12-02,1,,ct_space,sem_space|sem_2020,,program201|school101,0
course offering,UPDATE,brightcomb,Combined Course Name,2020-01-01,2020-12-02,1,,ct_comb,sem_bright|sem_2020,,program101|program201|school101,
| Column |
Field |
Required |
Possible Values |
Notes |
|---|
| 1 |
type |
Required |
course offering |
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 |
Max Length: 50 |
The code you use must be a unique value to identify one Org Unit and is case sensitive. It can be any alphanumeric value. It should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
| 4 |
name |
Required |
Max Length: 128 |
Name of course template |
| 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. Column required in D2L Standard CSV version 2.0 and higher. |
| 13 |
discover |
Optional |
1, 0, TRUE, FALSE |
If not specified, the course's discover setting is unchanged for existing courses and set to false for new courses. Case insensitive. Column required in D2L Standard CSV version 3.0 and higher. |
Orgs - Course Section
The following lists 5 rows of sample content for course sections along with the required header line. The file consists of 11 to 13 mandatory columns, depending on the version of D2L Standard CSV that you're using. 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,discover
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. Must be mapped in IPSIS Configuration. |
| 2 |
action |
Optional |
CREATE, UPDATE, DELETE |
Case insensitive. If not specified, default is UPDATE. |
| 3 |
code |
Required |
Max Length: 50 |
The code you use must be a unique value to identify one Org Unit and is case sensitive. It can be any alphanumeric value. It should not include commas or invalid characters. Codes with more than 50 characters will be truncated. |
| 4 |
name |
Required |
Max Length: 128 |
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 |
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 separation for multiple entries |
| 12 |
custom_code |
N/A |
|
Not supported. Must be null. Column required in D2L Standard CSV version 2.0 and higher. |
| 13 |
discover |
N/A |
1, 0, TRUE, FALSE |
Ignored. Column required in D2L Standard CSV version 3.0 and higher. |