SDS 英國 CSV 檔案格式UK 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. The UK schema detailed below is like the standard School Data Sync format, with a few minor differences in some of the required attribute names. 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 UK 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

UK-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.

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

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

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

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

UK-School-Data-Sync-format-CSV-files-for-SDS-student-enrollment.png

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