SDS V2 CSV File Format

You can use CSV (comma separated value) files in the SDS V2 format to synchronize your School Information System (SIS) with Office 365. When using the SDS V2 format, the files must be appropriately formatted. This article describes the formatting requirements and supported attributes for use with SDS. You must upload all 4 files, named exactly as detailed below. To review and download sample set of SDS V2 CSV files, see the SDS GitHub Repository.

csv-file-v2-1.png

Each CSV file must contain all required fields highlighted in green below. The field not highlighted are optional. Additionally, the attributes with a defined Enum values as marked in the Types column have a specific set of values they support. See the support set of enumerated values for each enum attribute in the next section.

csv-file-v2-2.png

csv-file-v2-3.png

csv-file-v2-4.png

csv-file-v2-5.png

Enumerated Values (Enum) Supported

In the new SDS V2 format, there are several attributes defined as Enumerated values, which means you can only provide a selected set of values within the CSV files. Anything other than values specified will result in an error during sync processing. The section below defines the enum values supported in the SDS V2 Format.

The users.csv contains the “role” attribute supports the enum values below.

csv-file-v2-6.png

The users.csv contains the “grade” attribute and supports the enum values below.

csv-file-v2-7.png

The orgs.csv contains the “type” attribute and supports the enum values below.

csv-file-v2-8.png

The enrollments.csv contains the “role” attribute and supports the enum values below.

csv-file-v2-9.png