Microsoft School Data Sync Export
Creates a set of CSV files for the Microsoft School Data Sync.
The files can be saved locally, sent via (S)FTP, or sent to an email address.
V1:
School File | ||
Lists the selected schools. | ||
Column | Notes | |
SIS ID | School Code | |
School Name | ||
License File | ||
Includes a row for every student present in the student file. Optionally included in SFTP transfer. | ||
Column | Notes | |
Display Name | first name + last name | |
User Principal Name | student email address | |
Account Sku Id | Contains the value entered in the 'Account SKU ID:' option. | |
Section File | |
Lists all course sections in selected schools. | |
Column | Notes |
SIS ID | School Code - Course Code - Course Section |
School SIS ID | |
Section Name | Course Description |
Student File | |
Lists active students in selected schools. | |
Column | Notes |
SIS ID | Student ID |
School SIS ID | |
First Name | |
Last Name | |
Username | Optionally blank, email address, or email address before the '@'. |
Password | |
Teacher File | |
Lists teachers with active enrollment that are assigned to selected schools. Teachers teaching in more than one school can appear multiple times in this file. | |
Column | Notes |
SIS ID | Teacher ID |
School SIS ID | |
First Name | |
Last Name | |
Username | Optionally blank, email address, or email address before the '@'. |
Password | |
Student Enrollment | |
Lists section enrollments for students in selected schools. | |
Column | Notes |
Section SIS ID | |
SIS ID | |
Teacher Roster | |
Lists section enrollments for teachers in selected schools. | |
Column | Notes |
Section SIS ID | |
SIS ID | |
V2/2.1:
Classes | ||
Lists all course sections in selected schools. | ||
Column | Notes | |
sourcedId | ||
orgSourcedId | ||
title | ||
Enrollments | ||
Lists section enrollments for students and teachers in selected schools. | ||
Column | Notes | |
classSourcedId | ||
userSourcedId | ||
role | ||
Orgs | ||
Lists selected schools. | ||
Column | Notes | |
sourcedId | ||
name | ||
type | ||
Users | ||
Lists students and teachers in selected schools. | ||
Column | Notes | |
sourcedId | ||
orgSourcedIds | Not in V2.1 | |
username | ||
role | Not in V2.1 | |
familyName | ||
givenName | ||
password | ||
grade | Not in V2.1 | |
Roles (V2.1 Only) | |
Lists selected schools. | |
Column | Notes |
userSourcedId | |
orgSourcedId | |
role | |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article