The file formats accepted by D2L Standard CSV are:
- Orgs
- Users
- Enrollments
- Manager Dashboard and Learning Groups Attributes
- Manifest (required when using version 1.1 or higher or D2L Standard CSV)
Files are uploaded in a zip archive. The recommended naming convention is:
- D2LStdCSV-{YYYYmmddHHMMSS}.zip
|
Note: Only .zip (case sensitive, lowercase only) archives are permitted to be uploaded to SFTP. |
Files are processed in alphabetical order. D2L recommends sending the files in the following order:
- orgs
- users
- enrollments
- attributes
The recommended naming convention for individual D2L Standard CSV files are:
- 01- Other - {YYYYmmddHHMMSS}.csv
- Processing of custom org units outside of the standard D2L org structure is supported in D2L Standard CSV 2.0 or higher.
- 02 - Departments - {YYYYmmddHHMMSS}.csv
- 03 - Semesters - {YYYYmmddHHMMSS}.csv
- 04 - Templates - {YYYYmmddHHMMSS}.csv
- 05 - Offerings - {YYYYmmddHHMMSS}.csv
- 06 - Sections - {YYYYmmddHHMMSS}.csv
- 07 - Users - {YYYYmmddHHMMSS}.csv
- 08 - Enrollments - {YYYYmmddHHMMSS}.csv
- 09 - Attributes - {YYYYmmddHHMMSS}.csv
- manifest.json
Common CSV file content rules
- Values in files are case-sensitive. The instructions will detail the required case.
- An empty value is represented with two commas with no spaces between them. (for example, ,, indicates blank value, whereas , , indicates a space character, which is parsed as an invalid value).
- The CSV files must have a header (first line) that must be an exact match (casing and commas) to that listed in <link to page that defines each file with examples>. Subsequent lines in the file contain the data to be processed (created, updated, deleted).
- CSV files must be UTF-8 encoded.
- CSV files should contain differential SIS data (deltas) rather than complete SIS data drops.
- Sending an UPDATE action when the object does not exist results in a CREATE request. Common behavior is to use only the UPDATE or DELETE actions.
- CSV files and the manifest must be contained in the zip archive.
- A manifest is required when using version 1.1 or higher of D2L Standard CSV. The manifest is a JSON file that announces the version of D2L Standard CSV you are using. For more information, view the Manifest topic.
- As a best practice, do not include Personally Identifiable Information (PII), such as users' names or social security numbers, in Org-defined IDs (sourcedIds) for users.
Rules for supported Org Unit Types
The following Org Unit Types are supported in the integration:
- Other org units (custom org units outside of the standard D2L org structure is supported in D2L Standard CSV version 2.0 or higher)
- Departments
- Semesters
- Course Templates
- Course Offerings
- Sections
The D2L Standard CSV integration can create, update, and delete Org Units at the levels listed above.
If sending many Org Unit Types in one CSV file, ensure that hierarchy is respected in the file (for example, Departments should be sent before Course Templates). Failing to send a parent Org Unit before the creation of the child will result in the child Org Unit failing.
If sending user relationships, ensure that the auditors and/or parents/guardians hierarchy is respected in the file (for example, parents/guardians must be sent before learners). Failing to do so results in the relationship failing.
The Org Unit naming conventions (Name/Code) should follow that described in your SIS. Brightspace can accept as many Org Units as needed, Org Unit names and codes can be fed as-is through the csv files if names or codes respect Brightspace illegal character requirements and are unique across different Org Units.
Org unit codes are limited to 50 characters. If they are longer, the org unit code is automatically truncated to 50, and could lead to duplication of org unit codes in Brightspace or failure to create an org unit.
|
Note: Org unit codes do not support the following characters: , : % & # * ? < > | \ " ' and leading or trailing spaces. |
Rules for other supported org unit types
Departments, semesters, course templates, course offerings, and course sections are also supported. Processing these org units creates the org structure in your Brightspace instance. These must be sent at least once to instruct D2L Standard CSV on which org units it can control. Once the integration controls an org unit, all future changes to that org unit must be made only through the D2L Standard CSV integration to ensure accurate ownership of the data.
|
Warning:You should only resend org units when they are newly created or updated in your SIS/HRIS.
|
D2L Standard CSV can do the following:
- Create a new org unit if it doesn’t exist.
- Map to an existing org unit if it was created by a source other than D2L Standard CSV and the option to map to existing is selected in the configuration.
- Update the name of an org unit that it controls.
- Assign and remove custom org units as parents to other custom org units, departments, semesters, course templates, course offerings and course sections (applicable to D2L Standard CSV version 2.0 or higher).
- Course template: assign and update parent Department based on the Department code.
- Course offering: assign and update parent course template and semester based on the parent code.
- Course offering: Update all course details including course offering name and dates. Inactivate Course Offering.
- Course section: Deleting a course section automatically unenrolls users from the deleted section.
- Delete an org unit that it controls.
D2L Standard CSV cannot do the following:
- Update org unit codes.
- Delete manually created org units unless they are mapped with D2L Standard CSV.
- Delete an org unit if it has children linked to it (children must be deleted first). One exception occurs if sections are set up for deletion in the interface, course offerings can be deleted if a section is linked to it.
Rules for User types
Processing the user type creates, updates, inactivates, or deletes users in Brightspace. The user type could also create, update, or delete the parent-child relationship in Brightspace (D2L Standard CSV version 1.1 or higher). Users must be sent at least once to instruct the integration on which users it is able to create, update, or delete and manage enrollments.
|
Note: User's First Name and Last Name do not support the following characters: \ / : * ? " < > | @ , ; Username and Org Defined ID do not support the following characters: / : * ? " < > | ' , ; Users email address does not support the folllowing characters: ( ) < > [ ] | \ ; : , “ |
D2L Standard CSV can:
- Create a new user if it doesn’t already exist and enroll it in the organization.
- Map a user to an existing user with same Org Defined ID or Username.
- Update Username, First Name, Last Name, Password, and Email.
- Update Preferred First Name and Preferred Last Name (D2L Standard CSV version 2.0 or higher).
- Update Sortable Last Name (D2L Standard CSV version 2.1 or higher).
- Update Pronouns (D2L Standard CSV version 3.0 or higher).
- Password is not required and recommended not to be sent if using Single-Sign-On (SSO).
- Update the org level role.
- Activate, inactivate, or delete a user.
- Create, update, or delete parent/guardian-child relationships for Brightspace Parent & Guardian (D2L Standard CSV version 1.1 or higher).
- Update an auditor-auditee relationship (D2L Standard CSV version 2.0 or higher).
D2L Standard CSV does not:
- Update Org Defined ID; however, this can be done manually in the IPSIS administration interface.
- Delete manually created users unless they are mapped with D2L Standard CSV.
|
Note: For users in countries including the Netherlands, Belgium and Sri Lanka, some surnames (such as Van der Speigle or Van Gogh) have one or more prefixes (known in Dutch as Tussenvoegsel) that are part of the formal last name. In some cases, the sortable last name should not include those prefixes. Administrators can indicate if a user's Legal Last Name differs from the Sortable Last Name. If clients include a Sortable Last Name, Brightspace uses the Sortable Last Name when alphabetizing user lists. Sortable Last Name is available in D2L Standard CSV version 2.1 or higher. |
Rules for Enrollment type records
Processing the enrollment type records enrolls or unenrolls users in a specific org unit in Brightspace. Enrollments should be sent when changes are made in the information system to accurately reflect those changes in Brightspace. An unenrollment should only be sent once. Resending the same unenrollment records warnings in your IPSIS log.
D2L Standard CSV can:
- Enrolls and unenroll users in org units (version 2.0 or higher) or just course sections (version 1.0 and 1.1).
Rules for Manager Dashboard and Learning Groups Attributes
Using D2L Standard CSV, Manager Dashboard and Learning Groups Attributes can:
- Establish the reporting structure that is used within Manager Dashboard
- Provide attributes to allow for automatic membership rules to be created in Learning Groups
Manager Dashboard and Learning Groups Attributes via D2L Standard CSV does not:
- Create new user accounts.