用於 SDS 的英國 CSV 檔案格式UK CSV file format for SDS

您可以使用 SDS 格式 CSV (逗號分隔值) 檔案與 Office 365 同步處理您的學校資訊系統 (SIS)。You can use CSV (comma separated value) files in the SDS format to synchronize your School Information System (SIS) with Office 365. 詳細資訊如下的英國結構描述就像是標準的 School Data Sync 格式,使用中的某些必要的屬性名稱的一些次要差異。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. 當使用 School Data Sync SDS 格式 CSV 檔案,檔案必須適當格式。When using SDS format CSV Files for School Data Sync, the files must be appropriately formatted. 本節說明搭配 SDS 使用的格式需求。This section describes the formatting requirements for use with SDS. 唯一的絕對必要欄位以綠色標示以下方式反白顯示。The only absolutely required fields are highlighted in green below. 這也會繫結透過我們的CSV 檔案範例頁面上的範例資訊。This also ties over to the example information on our CSV File Samples page. 您必須具備下列 6 名稱完全相同詳細下方的 CSV 檔案。You must have the following 6 CSV files named exactly as detailed below. 若要檢閱並下載英國 SDS 格式的 CSV 檔案範例集,請參閱 < SDS GitHub 儲存機制To review and download sample set of CSV files in the UK SDS format, see the SDS GitHub Repository.

students.csvstudents.csv

teachers.csvteachers.csv

schools.csvschools.csv

sections.csvsections.csv

studentenrollment.csvstudentenrollment.csv

teacherroster.csvteacherroster.csv

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

每一個 CSV 檔案必須包含所有必要的欄位反白顯示以綠色標示下方。Each CSV file must contain all required fields highlighted in green below. 每一個 CSV 檔也可能會包含任何也列出的選擇性欄位。Each CSV file may also contain any of the optional fields listed as well. 如果 CSV 檔案中包含任何不受支援的字元,才能加以取代的內嵌在同步處理期間選取 [在 SDS 同步處理設定檔設定精靈 」 取代不受支援的特殊字元 」 選項。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. 這不過不會移除 「 空白字元 」 也不是有效。This however will not remove "white spaces" which are also not valid. 下表列出檔案的檔案為基礎的必要與選用屬性:The tables below list the required and optional attributes on a file by file basis:

UK-School-Data-Sync-format-CSV-files-for-SDS-2.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-6.png

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

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