常見問題集Frequently Asked Questions

什麼是 School Data Sync?What is School Data Sync?

學校資料同步處理是從您 SIS 讀取名冊並建立類別的 Microsoft 小組、 Intune 的教育和協力廠商應用程式的 Office 365 教育版的免費服務。Microsoft 小組結合交談、 內容及應用程式適用於教育界的 Office 365 中。School Data Sync is a free service in Office 365 Education that reads the rosters from your SIS, and creates classes for Microsoft Teams, Intune for Education, and third party applications. Microsoft Teams brings conversations, content, and apps together in Office 365 for Education.

School Data Sync 支援哪些 SIS/MIS 廠商?What SIS/MIS vendors does School Data Sync support?

學校資料同步處理會匯入 CSV 檔案中的資料,因為它支援幾乎每 SIS 市場上。SDS 也支援透過 PowerSchool API 及業界標準 OneRoster API 名冊資料匯入。客戶已部署 SDS 超過 70 SIS 廠商與資料提供者,包括下列:Because School Data Sync imports data in CSV files, it supports virtually every SIS on the market. SDS also supports importing roster data via the PowerSchool API, and the industry standard OneRoster API. Customers have deployed SDS with over 70 SIS vendors and data providers, including the below:

AeriesAeries ITCSSITCSS SEEMiSSEEMiS
山楊Aspen JMCJMC 資深系統Senior Systems
AtlasAtlas 木星Jupiter SEQTASEQTA
ATSATS KAMARKAMAR SIMSIMS
AxiosAxios MagisterMagister Skolplatsen (Gotit)Skolplatsen (Gotit)
BannerBanner 迷宮Maze SkolPulsSkolPuls
BlackbaudBlackbaud MMS 索引產生MMS Generations SkywardSkyward
畫布Canvas MyclassboardMyclassboard SomTodaySomToday
CMISCMIS MyED BCMyED BC 星星STARS
CobaCoba OncourseSystemOncourseSystem SunGardSunGard
羅盤Compass Oracle 校園解決方案Oracle Campus Solution SycamoreSycamore
基石/TADSCornerstone/TADS ParnassysParnassys Sycamore 教育Sycamore Education
CSIU eSchoolDataCSIU eSchoolData PC 學校PC School SynergeticSynergetic
DeltaLinkDeltaLink PlurilogicPlurilogic 分工合作Synergy
真假難Eco PowerSchoolPowerSchool 塔絲TASS
Ed 系統Ed-Admin PrimusPrimus TCS MiddleTCS iON
Edgear JCampusEdgear JCampus ProEcoProEco TeacherEaseTeacherEase
EduarteEduarte ProgressbookProgressbook 小組 Pro 邏輯Teams Pro logic
EdupointEdupoint ProgressoProgresso 協力廠商Third party
連絡聯合Engage United 從索引教育 pronotePronote from Index Education TrilliumTrillium
eSchoolPLUSeSchoolPLUS Prosolution (羅經 [副本])Prosolution (Compass CC) TxEISTxEIS
esemtiaesemtia QQ TylerSISTylerSIS
eTapeTap 即時 SISRealtime SIS VeracrossVeracross
ExtensExtens RedikerRediker 與 ERPVersus-ERP
會議狀態Focus RenWebRenWeb Visma FlytVisma Flyt
發生Genesis 尺規連線Ruler Connect Visma Primus/WilmaVisma Primus/Wilma
GRICSGRICS 集中存取由 SAM SpectraSAM Spectra by Central Access WCBS 脈衝WCBS Pulse
IbisIbis SapphireSapphire WengageWengage
IlluminateEdIlluminateEd 學校工具School Tool 工作指導書網頁WIS WEB
iluminateiluminate SchoolBaseSchoolBase WisenetWisenet
無限校園 & ScholarshipInfinite Campus & Scholarship SchoolmasterSchoolmaster
iPASSiPASS SchoolonlineSchoolonline
iSAMSiSAMS SchoolToolSchoolTool

我可以在哪裡使用 School Data Sync?Where is School Data Sync available?

學校資料同步處理中但不包括中國及德國全世界的所有區域是目前可用的。School Data sync is currently available in all regions worldwide except for China and Germany.

School Data sync 能搭配哪些應用程式使用?What apps work with School Data sync?

學校資料同步處理從匯入學校、 區段、 學生、 老師、 和名冊資料 SIS 至 Office 365,讓它可以使用許多 1st 廠商和 3rd 廠商應用程式。請造訪http://sds.microsoft.com查看 Office 365 和學校資料同步處理資料使用單一登入與 Rostering 整合 EDU 應用程式的清單。School Data Sync imports school, section, student, teacher, and roster data from a SIS to Office 365 so it can be used by numerous 1st party and 3rd party applications. Visit http://sds.microsoft.com to see a list of the EDU apps that use Office 365 and School Data Sync data for Single Sign-on and Rostering integration.

SDS 能自動同步處理變更嗎?還是我必須在變更發生時重新啟動同步處理?Will SDS automatically sync changes or do we have to restart sync to synchronize changes as they occur?

同步處理執行持續之後建立的同步處理設定檔時,除非已手動停止。PowerSchool API 和 OneRoster API、 SIS 連線是連續和一律輪詢資料要同步處理中的變更。如果您正在執行的同步處理設定檔以使用其中一個可用的 CSV 基礎同步處理方法、 變更內資料以進行同步處理的上傳新的 CSV 檔案包含的資料變更。您可以上傳新的檔案透過 SDS 入口網站或 SDS toolkit。一旦上傳新的 CSV 檔案,同步處理程序會在若不發生任何錯誤會自動開始。如果您是新的資料集包含錯誤,您可能需要先加以修復及 reupload 檔案,或瀏覽繼續次不論找到之錯誤的同步處理設定檔的 [繼續同步處理] 按鈕。Sync runs continuously after a sync profile is created, unless manually stopped. For PowerSchool API and OneRoster API, the connection to the SIS is continuous and always polling for changes in data to be synced. If you’re running a sync profile which uses one of the available CSV based sync methods, changes within your data can be synchronized by uploading new CSV files that contain the data changes. You can upload new files through the SDS portal or through the SDS toolkit. Once new CSV files are uploaded, the sync process will begin automatically if no errors are encountered. If you’re new data set contains errors, you may need to remediate them first and reupload the files, or hit the resume sync button on the sync profile to continue syncing regardless of the errors found.

存取及管理 School Data Sync 需要哪些權限?What are the permission requirements for accessing and managing School Data Sync?

存取和管理 SDS,您的帳戶必須是租用戶內的全域管理員。To access and manage SDS, your account must be a Global Administrator within the tenant.

我們要如何將 SIS 中的資料匯出成 Microsoft 要求的 CSV 格式?How can we export data from our SIS to Microsoft’s required CSV format?

由於每個 SIS 是不同,我們鼓勵學校資料同步處理 (SDS) 客戶其 SIS 廠商連絡支援與獲得協助從 SIS 建置適當匯出至 CSV 檔案中其中一種可接受的格式 (SDS 格式、 聰明格式或 OneRoster格式)。許多 SIS 的已具有 CSV 匯出功能,且不需要自訂工具或資料庫擷取器完成匯出程序。Microsoft 不不過提供支援的內建的 SIS 廠商 SIS 點選連結擷取程式工具。請連絡您的 SIS 廠商以獲得協助資料匯出。Since each SIS is different, we encourage School Data Sync (SDS) customers to contact their SIS vendor for support and assistance with building the appropriate export from the SIS to CSV files in one of the acceptable formats (SDS format, Clever format, or OneRoster format). Many SIS’s already have CSV export functionality, and do not require custom tools or database extractors to complete the export process. Microsoft does not provide support however for SIS extractor tools built by SIS vendors. Please contact your SIS vendor for assistance with data exports.

我可以透過 REST API 使用哪些 School Data Sync 結構描述 (物件和屬性)?What is the School Data Sync schema (object and attributes) available through REST API?

教育屬性參考資料含有潛在資料可用的完整清單。CSV 檔案參考 (英文) 說明可用於透過 SDS 匯入的必要的欄位。The Education Attributes Reference contains the full list of potential data available. The CSV files reference explains the required fields available for import via SDS.

我們要如何將 SIS 中的資料匯出成 Microsoft 要求的 CSV 格式?How can we export data from our SIS to Microsoft’s required CSV format?

由於每個 SIS 是不同,我們鼓勵學校資料同步處理 (SDS) 客戶其 SIS 廠商連絡支援與獲得協助從 SIS 建置適當匯出至 CSV 檔案中其中一種可接受的格式 (SDS 格式、 聰明格式或 OneRoster格式)。許多 SIS 的已具有 CSV 匯出功能,且不需要自訂工具或資料庫擷取器完成匯出程序。Microsoft 不不過提供支援的內建的 SIS 廠商 SIS 點選連結擷取程式工具。請連絡您的 SIS 廠商以獲得協助資料匯出。Since each SIS is different, we encourage School Data Sync (SDS) customers to contact their SIS vendor for support and assistance with building the appropriate export from the SIS to CSV files in one of the acceptable formats (SDS format, Clever format, or OneRoster format). Many SIS’s already have CSV export functionality, and do not require custom tools or database extractors to complete the export process. Microsoft does not provide support however for SIS extractor tools built by SIS vendors. Please contact your SIS vendor for assistance with data exports.

Term StartDate 和 Term EndDate 屬性的正確格式是什麼?What is the proper format for the Term StartDate and Term EndDate attributes?

學校資料同步處理不限制字詞 StartDate 和超過目前允許.NET 字詞 EndDate 屬性格式選項,但建議使用 mm/dd/yyyy (亦即 11/19/2016年或 6/12/2016年) 格式。此建議的功能與運用這些屬性的功能可能會對齊未來的開發工作。School Data Sync does not restrict the Term StartDate and Term EndDate attribute format beyond the currently allowed .NET options, however we recommend using a format of mm/dd/yyyy (i.e. 11/19/2016 or 6/12/2016). Future development efforts may align to this recommendation for features and functionality which leverage these attributes.

我可以匯出 SDS 產生的同步處理問題/錯誤嗎?Can I export the sync issues/errors generated by SDS?

是,您可能會匯出設定檔的設定檔為基礎在 SDS UI 產生錯誤的清單。若要匯出清單中的錯誤,登入 sds.microsoft.com > 選取您同步處理設定檔 > 按一下下載所有錯誤.csv 檔案] 按鈕。Yes, you may export the list of errors generated on a profile by profile basis within the SDS UI. To export the list of errors, log into sds.microsoft.com > select your sync profile > click on the Download all errors as .csv file button.

Microsoft 是否提供 SIS 資料的擷取器工具?Does Microsoft provide extractor tools for my SIS data?

Microsoft 不會建立或維護擷取器工具的任何 SIS 廠商。許多 SIS 必須已經內建 SIS 資料擷取工具。如果您 SIS 不包括擷取工具,而您需要從您 SIS 擷取資料到我們的結構描述 CSV 格式的協助,請連絡您 SIS 廠商支援。Microsoft does not build or maintain extractor tools for any SIS vendor. Many SIS’s have data extraction tools built into the SIS already. If your SIS does not include an extraction tool, and you need assistance extracting data from your SIS into our schema CSV format, please contact your SIS vendor for support.

為什麼 SDS 中的電子郵件地址有字元限制?Why is there a character limitation on email addresses in SDS?

針對網際網路電子郵件位址、 數個 RFC 標準必須遵守 O365 中的所有物件的電子郵件地址和 SDS 只是對齊每個核心 Office 365 服務,包括 SharePoint Online、 Exchange Online 和 Azure 中的字元限制Active Directory。Email addresses for all objects in O365 must adhere to several RFC standards for internet email addressing, and SDS is simply aligned to the character limitations within each of the core Office 365 services, including SharePoint Online, Exchange Online, and Azure Active Directory.

在設定 School Data Sync 時,我需要建立幾個同步處理設定檔?How many sync profiles do I need to create when setting up School Data Sync?

最常學校只須建立單一同步處理設定檔中學校資料同步處理 (SDS) 同步處理所有學校、 章節、 老師、 學生,以及名冊。有幾個原因會需要建立額外的同步處理設定檔:Most often, schools will only need to create a single sync profile in School Data Sync (SDS) to synchronize all Schools, Sections, Teachers, Students, and Rosters. There are a few reasons that would require you to create additional sync profiles:

Identity 比對多個網域– 設定 SDS 您必須從來源目錄符合使用者的使用者在 Azure Active Directory (AAD) 時。每個同步處理設定檔中您可以指定為單一網域老師與單一網域的學生。如果老師或學生來設定一個以上的單一網域的 identity 比對設定中所使用的屬性,您可能需要建立多個同步處理設定檔,以確保您的租用戶內的所有使用者的相符項目。建議您跨學生與老師的核心 identity 比對屬性如 UserPrincipalName 和 Mail 屬性設定的網域數目最小化。Multiple Domains for Identity Matching – When configuring SDS you must match users from your source directory to users in Azure Active Directory (AAD). Within each sync profile, you can specify a single domain for teachers and a single domain for students. If your teachers or students are configured with more than a single domain for the attribute being used in the identity matching configuration, you may need to create multiple sync profiles to ensure a match for all users within your tenant. We recommend minimizing the number of domains configured across student and teachers for core identity matching attributes such as the UserPrincipalName and Mail attributes.

多個同步處理方法或來源目錄– SDS 可讓您同步處理幾個不同的方式中的物件和屬性。我們目前接受三種不同 CSV 檔案格式 (SDS 格式、 聰明格式、 OneRoster 格式)。SDS 也可讓兩個不同的類型的 API 與連線同步處理物件和屬性 (PowerSchool API 和 OneRoster API)。如果您需要從一個以上的單一來源目錄匯入資料,您必須設定多個同步處理設定檔。例如,可能必須 1 同步處理設定檔同步處理物件 PowerSchool 及其他同步處理設定檔同步處理物件從 SDS 格式的 CSV 檔案。建議您同步處理設定檔盡可能數目最小化。Multiple Sync Methods or Source Directories – SDS allows you to synchronize objects and attributes in a few different ways. We currently accept three different types of CSV file formatting (SDS format, Clever format, OneRoster format). SDS also allows for two different types of API connections to sync objects and attributes (PowerSchool API and OneRoster API). If you need to import data from more than a single source directory, you will need to configure multiple sync profiles. For example, you may need 1 sync profile to sync objects from PowerSchool and another sync profile to sync objects from SDS format CSV files. We recommend minimizing the number of sync profiles whenever possible.

混合的建立新的使用者並同步處理現有使用者– SDS 可讓您為 AAD 中建立新的使用者帳戶從來源目錄資料,或與已存在的 Azure AD 的現有使用者進行同步處理。如果您需要建立新的使用者,並針對某些現有的使用者同步處理,會需要兩個或多個同步處理設定檔。您僅可選擇其中一個單一的同步處理設定檔中的兩個選項。Mix of Create New Users and Sync Existing Users – SDS allows you to either create new user accounts in AAD from your source directory data, or synchronize against existing users that are already present in Azure AD. If you need to create some new users, and synchronize against some existing users, two or more sync profiles will be required. You can only choose one of these two options within a single sync profile.

Csv 檔案中的多個 2 百萬個列– SDS 具有可以包含的一組內的單一同步處理設定檔上傳 CSV 檔案中的列數限制。目前的限制為每個 CSV 檔案的 2 百萬個列。如果您有包含超過 2 百萬個列的 CSV 檔案,您需要分割 CSV 檔案整組沿著學校行 (所有章節、 老師、 學生、 rostering 被分割 school(s) 相關聯)。一次分割、 建立額外的同步處理設定檔使用相同的設定和上傳分割檔案據此。More than 2 million rows in a csv file – SDS has a limit on the number of rows that can be contained within a set of CSV files uploaded within a single sync profile. The current limit is 2 million rows per CSV file. If you have CSV files that contain more than 2 million rows, you’ll need to split the entire set of CSV files up along school lines (all sections, teachers, students, rostering associated with the school(s) being split). Once split, create additional sync profiles with the same settings, and upload the split files accordingly.

CSV 檔案中,是否能包含我不想要同步處理的標頭和欄位?Can I have additional headers and columns in my CSV files beyond what I intend to sync?

是,您的 CSV 檔案可能包含額外的標頭和資料。僅限選取 [同步處理設定檔安裝精靈] 中的屬性將會嘗試進行同步處理。任何額外的標頭和資料行的資料都會被忽略。Yes, your CSV files may contain extra headers and data. Only the attributes selected within the sync profile setup wizard will attempt to synchronize. Any extra headers and columns of data will be ignored.

如果我們從教室將使用者或章節移除,當我們再次同步處理時,它們是否會重新出現?If we remove a user or section from Classroom will they reappear when we sync again?

手動更新透過教室類別名冊將不會覆寫下的同步處理執行時。 學校資料同步處理會根據上次同步處理,並不根據除了兩個動作的手動變更名冊進行變更: 重設同步處理及重新建立同步處理設定檔。除了這些例外狀況之外以下是如何 SDS 來說手動新增和刪除。Manually updating a class roster through Classroom will not be overwritten when the next sync runs. School Data Sync makes changes to the roster based on the last sync, and not based on manual changes, with the exception of two actions: Reset Sync and Recreating a Sync Profile. Aside from those exceptions, here is how SDS treats manual additions and deletions.

範例 1:Example 1:

  1. 類別與老師與學生同步處理A class is synced with a teacher and students
  2. 教師前往新增至類別的共同撰寫老師教室The teacher goes to Classroom to add a co-teacher to the class
  3. 類別的後續同步處理與老師註冊不變更The class is subsequently synced with no changes to teacher enrollment
  4. (正確行為)共同撰寫教師的成員資格是不會影響(Correct behavior) The co-teacher's membership is unaffected
  5. 類別的後續已新增共同老師與同步處理The class is subsequently synced with the co-teacher added
  6. (正確行為) 共同撰寫教師的成員資格是不會影響(Correct behavior) the co-teacher's membership is unaffected
  7. 類別的後續同步處理具有移除共同老師The class is subsequently synced w/ the co-teacher removed
  8. (更正行為) 共同老師移除類別(Correct behavior) the co-teacher is removed from the class

範例 2:Example 2:

  1. 類別與老師與學生同步處理A class is synced with a teacher and students
  2. 教師前往教室學生移除類別The teacher goes to Classroom to remove a student from the class
  3. 類別的後續同步處理與學生註冊不變更The class is subsequently synced with no change to the student enrollment
  4. (正確行為)Student's 非成員資格是不會影響(Correct behavior) The student's non-membership is unaffected
  5. 類別的後續已移除學生與同步處理The class is subsequently synced with the student removed
  6. (正確行為) student 氏非成員資格是不會影響(Correct behavior) the student's non-membership is unaffected
  7. 類別的後續已具有 student 重新新增同步處理The class is subsequently synced w/ the student re-added
  8. (正確行為) student 會重新新增至類別(Correct behavior) the student is re-added to the class

Azure AD Connect 和 SDS 的作用為何?它們如何共同運作?What do Azure AD Connect and SDS do and how can they work together?

Azure Active Directory 連線 (AAD 連線) 會同步內部部署 AD 使用者、 群組及 Office 365 中的 Azure AD (AAD) 的物件。Azure Active Directory Connect (AAD Connect) syncs on-premise AD Users, Groups, and Objects to Azure AD (AAD) in Office 365.

學校資料同步處理 (SDS) 會同步與現有的使用者已同步處理及由 AAD 連線建立額外的學生資訊系統 (SIS) 從學生與老師屬性。 新增學生與老師屬性發展身分識別與可讓應用程式,以提供更豐富的使用者體驗根據這些分辨屬性和教育人物代表。 SDS 可讓您自動建立小組內的類別小組教育、 學校的 Intune 型安全性群組的教育裝置原則、 OneNote 類別筆記本及類別 rostering 3rd 廠商應用程式整合。AAD 連線及 SDS 將永遠不衝突,SDS 不會同步處理或覆寫由 AAD 連線管理任何屬性。 SDS 也提供選項可建立新的使用者,因此如果您不想要同步處理並建立其與 AAD 從內部部署 AD 連線,您可以使用 SDS 同步處理並直接從您 SIS 加以建立。School Data Sync (SDS) syncs additional Student and Teacher attributes from the Student Information System (SIS) with existing users already synced and created by AAD Connect. Adding Student and Teacher attributes evolves the identity and enables apps to provide richer user experiences based on these distinguishable attributes and education personas. SDS allows you to automatically create Class Teams within Teams for Education, School based Security groups for Intune for Education Device policy, OneNote Class Notebooks, and class rostering for 3rd party application integration. AAD Connect and SDS will never conflict, as SDS will not sync or overwrite any attribute managed by AAD Connect. SDS also provide the option to create new users, so if you don’t want to sync and create them with AAD Connect from your on-premise AD, you can use SDS to sync and create them directly from your SIS.

AAD 連線和 SDS 也同步處理並建立其他物件類型,例如群組、 系統管理單位及連絡人但不同的使用者,這些物件類型未結合至 AAD 中的表單且唯一的個別物件。Both AAD Connect and SDS also sync and create other object types, like Groups, Administrative Units,and Contacts, but unlike Users, these object types are not combined to form individual and unique objects in AAD.

what-do-azure-ad-connect-and-sds-do-and-how-can-they-work-together-1。PNG

School Data Sync 不支援哪些特殊字元?What special characters are not supported by School Data Sync?

有數個不支援內學校資料同步處理的特殊字元。設定檔建立時,您必須具有 SDS 自動取代找到與""的特殊字元不受支援的選項。 下列連結說明不受支援的字元。There are several special characters that are not supported within School Data Sync. During profile creation, you will have an option to have SDS automatically replace unsupported special characters found with an “”. The following link explains unsupported characters.