適用於 SDS 的 Clever 格式 CSV 檔案Clever format CSV files for SDS

您可以使用聰明格式的 CSV (逗點分隔值) 檔案與 Office 365 同步處理學校資訊系統 (SIS)。當使用學校資料同步處理的聰明格式的 CSV 檔案,必須適當地設定格式檔案。本節說明 SDS 搭配使用的格式設定需求。您必須具備下列 5 名為完全作為詳細下方的 CSV 檔案。用於 SDS 不接受 admins.csv。You can use CSV (comma separated value) files in the Clever format to synchronize your School Information System (SIS) with Office 365. When using Clever 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 5 CSV files named exactly as detailed below. The admins.csv is not accepted for use in SDS.

schools.csvschools.csv

students.csvstudents.csv

teachers.csvteachers.csv

sections.csvsections.csv

enrollments.csvenrollments.csv

Clever-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:

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

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

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

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

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