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

您可以使用 CSV (逗號分隔值,) OneRoster®格式的檔案,以將您的學校資訊系統 (SIS) 與 Office 365 同步。You can use CSV (comma separated value) files in the OneRoster® format to synchronize your School Information System (SIS) with Office 365. 使用 OneRoster 1.0 格式的 CSV 檔案進行 School Data Sync 時,檔案必須具有適當的格式。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.csvusers.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

注意

如果您要使用 Sync to Insights – Preview,並且想要傳遞學生和/或教師的評分值,您必須使用 正確的列舉If you are using Sync to Insights – Preview and you wish to pass grade values for Student and/ or Teachers, you must use the correct ENUM. 如果您不使用正確的列舉,您會收到錯誤。If you do not use the correct ENUM, you will receive an error. 如需詳細資訊,請參閱 SDS ErrorsFor more information, please see SDS Errors.

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

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

注意

當建立新使用者時,需要在 OneRoster 檔案轉換成 SDS CSV 檔案格式後新增密碼欄。When creating new users a column for password will need to be added after the OneRoster files have been converted to the SDS CSV file format.

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.