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

您可以使用 SDS 格式的 CSV (逗號分隔值) 檔案, 以將您的學校資訊系統 (SIS) 與 Office 365 同步。You can use CSV (comma separated value) files in the SDS format to synchronize your School Information System (SIS) with Office 365. 下列所述的 UK 架構就像是標準的 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. 使用 SDS 格式的 CSV 檔案進行 School Data Sync 時, 必須適當格式化檔案。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. 您必須具有如下所述的下列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.

users.csvstudents.csv

教師 .csvteachers.csv

學校 .csvschools.csv

各節 .csvsections.csv

studentenrollmentstudentenrollment.csv

teacherrosterteacherroster.csv

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

每個 CSV 檔案都必須包含以藍色反白顯示的所有必要欄位。Each CSV file must contain all required fields highlighted in blue. 每個 CSV 檔案也可以包含任何列出的選用欄位。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. 如果您的 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.

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

請注意, 特定的學生屬性最近已被取代。Note that certain student attributes have recently been deprecated. 如需詳細資訊, 請參閱簡化學生架構的文章。Please see article on Simplifying Student Schema for more details.

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-6 .png

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

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