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 架構類似于「標準學校資料同步處理」格式,有些必要的屬性名稱有一些細微差別。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. 以下為絕對必要欄位的反白顯示為綠色。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. 下列六個 CSV 檔案的名稱必須嚴格如下所述。You must have the following 6 CSV files named exactly as detailed below. 若要以 UK SDS 格式複查和下載 CSV 檔案的範例集,請參閱SDS GitHub 存放庫To review and download sample set of CSV files in the UK SDS format, see the SDS GitHub Repository.

student.csvstudent.csv

teacher.csvteacher.csv

school.csvschool.csv

section.csvsection.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:

注意

Microsoft 建議針對 SDS CSV 檔案中的所有日期欄位使用ISO 8601 格式,格式為 YYYY-MM-DD 或 YYYYMMDD。Microsoft recommends using the ISO 8601 format for all dates fields in the SDS CSV files, in the form of YYYY-MM-DD or YYYYMMDD. SDS 計畫于未來的幾個月內引入功能,此格式需要在下列所述字詞的開始和結束日期欄位內進行此格式。SDS is planning to introduce features in coming months which will require this format within the Term Start and End Date fields noted below.

  • Students.csv > 生日Students.csv > Birthdate
  • Sections.csv > 字詞 StartDateSections.csv > Term StartDate
  • Sections.csv > 字詞 EndDateSections.csv > Term EndDate

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

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