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

您可以使用 OneRoster® 格式的 CSV (逗號分隔值) 檔案與 Office 365 同步處理您的學校資訊系統 (SIS)。You can use CSV (comma separated value) files in the OneRoster® format to synchronize your School Information System (SIS) with Office 365. 時使用 School Data Sync 的 OneRoster 1.0 格式 CSV 檔案,檔案必須是適當的格式。When using OneRoster 1.0 format CSV Files for School Data Sync, the files must be appropriately formatted. 本節說明搭配 SDS 使用的格式需求。This section describes the formatting requirements for use with SDS. 您必須具有的下列具名下方完全一樣詳細 7 OneRoster 1.0 CSV 檔案的第一個 6。You must have the following the first 6 of the 7 OneRoster 1.0 CSV files named exactly as detailed below. Demographics.csv 是嚴格選用的且不需要 SDS。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 檔案必須包含所有必要的欄位反白顯示為藍色。Each CSV file must contain all required fields highlighted in blue. 每個 CSV 也可能包含任何一個列出的選擇性欄位。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 格式的詳細資訊,請移至IMS OneRoster™: CSV 資料表For more information on OneRoster 1.0 CSV format, please go to IMS OneRoster™: CSV Tables.