-
About D2L Standard CSV
As a product in the Integration Pack for Student Information Systems (IPSIS platform, D2L Standard CSV is a source system that integrates Student Information System (SIS) or Human Resource Information System (HRIS) into Brightspace. It uses simple D2L defined comma separated values (CSV) that extract data from the…
-
Manager Dashboard and Learning Groups Attributes
The following lists 3 rows of sample content for an Attributes file (along with the required header line). The file consists of 13 columns, each of which must be populated with a valid value or left empty depending on the file format. LMS Username,Company Employee Id,Company Name,Department,Division,Employee Role,Hired…
-
Access the D2L Standard CSV dashboard
IPSIS Administration is an interface in Brightspace used for configuring and reviewing the status of SIS integrations with Brightspace. Once you set up an integration in IPSIS Administration, a dashboard for that integration becomes available for you to process jobs, view log messages, review the audit log, make changes…
-
Getting Started with D2L Standard CSV
The following sections describe how to initially set up and configure D2L Standard CSV integration. You must complete these tasks before you can use the D2L Standard CSV integration to import information from your SIS to Brightspace.G Before you begin Important:If you are currently using the D2L Standard CSV integration,…
-
Manifest
A manifest is required for D2L Standard CSV versions 1.1 and higher. The manifest is a JSON file that announces the version of D2L Standard CSV you are using, the version in the JSON files should match the version of IPSIS to which your CSV outputs are currently aligned. The following data structure is expected in the JSON…
-
About D2L Standard CSV Validation Mode
D2L Standard CSV Validation Mode Validation mode is available to IPSIS clients using D2L Standard CSV to help validate CSV files before loading them into IPSIS. Running a ZIP file in validation mode allows the IPSIS platform to run all files and provide feedback on missing columns and enumeration (enum) issues. When in…
-
D2L Standard CSV file relationships
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…
-
Orgs
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…
-
Uploading CSV files and re-running a batch
Upload CSV files for processing After you create CSV files from the data in your SIS and add them to a ZIP file, you can upload the ZIP file from the Dashboard tab in IPSIS Administration. You can also upload ZIP files to the SFTP site you created during your initial set up. Brightspace monitors the SFTP site on ten-minute…
-
CSV file format rules
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…