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 validation mode, files run but do not process any changes in Brightspace. A summary of the run is provided in the IPSIS Administration dashboard.
Use the Mode selector in the IPSIS Administration > D2L Standard CSV page to choose between the available modes (Enable, Disable, Validation).
The validation process includes:
- ZIP includes CSV files and manifest when required (v1.1, v2.0, 2.1, and 3.0)
- File naming convention meets requirements (orgs, users, enrollments)
- Column headers meet requirements
- Appropriate number of commas, correct escaping of data
- Formats meet requirements (such as date)
- Required fields are populated
- Encoding is UTF-8
- Org unit codes and names do not include unsupported characters
- Orgs and users do not contain unsupported characters
- Attributes file headers begin with 'LMS Username'
- Files do not have empty rows
The validation process does not include:
- Validation of data in file as it would run against the Learning Environment or with each file. For example, if a Course Template has a parent Department, and the Department was not sent in the Department file, it does not result in an error.
Run the CSV validation process
- Access the IPSIS administration dashboard.
- Select D2L Standard CSV.
- Choose Validate from the mode selector.
- Use drag and drop or the SFTP server to upload the file for validation.
Files are processes immediately when uploaded using the drag and drop function. Files uploaded to the SFTP server are triggered to run periodically.
- If the D2L Standard CSV file does not include any issues, switch to Enabled in the mode selector and run the file again.