OneRoster® 1.0 format CSV files for SDS

You can use CSV (comma separated value) files in the OneRoster® format to synchronize your School Information System (SIS) with Office 365. When using OneRoster 1.0 format CSV Files for School Data Sync, the files must be appropriately formatted. This section describes the formatting requirements for use with SDS. You must have the following the first 6 of the 7 OneRoster 1.0 CSV files named exactly as detailed below. The demographics.csv is strictly optional, and not required for SDS.

orgs.csv

users.csv

courses.csv

classes.csv

enrollments.csv

academicSessions.csv

demographics.csv

OneRoster-format-CSV-files-for-SDS-1.png

Each CSV file must contain all required fields highlighted in blue. Each CSV may also contain any of the optional fields listed. The tables below list the required and optional attributes on a file by file basis:

OneRoster-format-CSV-files-for-SDS-2.png

OneRoster-format-CSV-files-for-SDS-3.png

OneRoster-format-CSV-files-for-SDS-4.png

OneRoster-format-CSV-files-for-SDS-5.png

OneRoster-format-CSV-files-for-SDS-6.png

OneRoster-format-CSV-files-for-SDS-7.png

The demographics.csv file is completely optional for upload into SDS. It’s not required.

OneRoster-format-CSV-files-for-SDS-8.png

For more information on OneRoster 1.0 CSV format, please go to IMS OneRoster™: CSV Tables.