SDS 的 CSV 檔案格式CSV File Format for SDS

您可以使用 SDS 格式的 CSV (逗點分隔值) 檔案與 Office 365 同步處理學校資訊系統 (SIS)。時使用學校資料同步處理的 SDS 格式 CSV 檔案,必須適當地設定格式的檔案。本節說明 SDS 搭配使用的格式設定需求。您必須具備下列 6 名為完全作為詳細下方的 CSV 檔案。若要檢閱並下載範例組 SDS 格式的 CSV 檔案,請參閱SDS GitHub 存放庫You can use CSV (comma separated value) files in the SDS format to synchronize your School Information System (SIS) with Office 365. When using SDS 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 6 CSV files named exactly as detailed below. To review and download sample set of CSV files in the SDS format, see the SDS GitHub Repository.

school.csvschool.csv

student.csvstudent.csv

teacher.csvteacher.csv

section.csvsection.csv

studentenrollment.csvstudentenrollment.csv

teacherroster.csvteacherroster.csv

School-Data-Sync-format-CSV-files-for-SDS-1.png

每個 CSV 檔案必須包含所有必要的欄位反白顯示為藍色。每個 CSV 檔案可能也包含任何選擇性欄位,以及列出。下表列出根據檔案的檔案的必要及選用屬性。如果您的 CSV 檔案包含任何不受支援的字元,他們可以取代的內嵌期間同步處理],選取 [SDS 同步處理設定檔安裝精靈] 中的 [取代不受支援的特殊字元] 選項。Each CSV file must contain all required fields highlighted in blue. Each CSV file may also contain any of the optional fields listed as well. The tables below list the required and optional attributes on a file by file basis. If your CSV files contain any unsupported characters, they can be replaced inline during sync, by selecting the Replace Unsupported Special Characters option within the SDS Sync Profile Setup Wizard.

School-Data-Sync-format-CSV-files-for-SDS-2.png

School-Data-Sync-format-CSV-files-for-SDS-3.png

School-Data-Sync-format-CSV-files-for-SDS-4.png

School-Data-Sync-format-CSV-files-for-SDS-5.png

School-Data-Sync-format-CSV-files-for-SDS-6.png

School-Data-Sync-format-CSV-files-for-SDS-7.png