SDS OneRoster® 1.0 格式 CSV 檔案OneRoster® 1.0 format CSV files for SDS

您可以使用 OneRoster® 格式的 CSV (逗點分隔值) 檔案與 Office 365 同步處理學校資訊系統 (SIS)。時使用學校資料同步處理的 OneRoster 1.0 格式 CSV 檔案,必須適當地設定格式的檔案。本節說明 SDS 搭配使用的格式設定需求。您必須具備的下列 7 OneRoster 1.0 CSV 檔案中的第一個 6 名為完全詳細下方。Demographics.csv 是嚴格選用,且不需要 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.csvorgs.csv

users.csv 儲存至users.csv

courses.csvcourses.csv

classes.csvclasses.csv

enrollments.csvenrollments.csv

academicSessions.csvacademicSessions.csv

demographics.csvdemographics.csv

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

每個 CSV 檔案必須包含所有必要的欄位反白顯示為藍色。每個 CSV 也包含任何所列的選擇性欄位。下表列出根據檔案的檔案的必要及選用屬性: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

Demographics.csv 檔案是完全選用的上傳到 SDS。則不需要。The demographics.csv file is completely optional for upload into SDS. It’s not required.

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

如需有關 OneRoster 1.0 CSV 格式的詳細資訊,請移此處For more information on OneRoster 1.0 CSV format, please go here.