Data Sync is capable of importing any OneRoster 1.1 compliant CSV files. This makes it quick and easy as many Student Information Systems are capable of exporting data in this widely-adopted format.

You may read more about OneRoster CSV file format here.

If your SIS or School Management System is not capable of exporting this format natively, below is a helpful guide on how to create the recommended files and fields specifically for the Google Classroom Integration:

NOTE:

While it is possible to only provide the required data and have a working Google Classroom integration, it is highly advised to try your best to produce all the recommended fields as this will enable you to take advantage of more features of the Data Sync Google Classroom Integration.

Download an Example File Set

Examples

academicSessions.csv (Recommended)

Headers

Necessity

sourcedId

Required

title

Recommended

type

Required (only “term” accepted)

startDate

Recommended

endDate

Recommended

schoolYear

Recommended

Example:

sourcedId,title,type,startDate,endDate,parentSourcedId,schoolYear

classes.csv (Required)

Headers

Necessity

sourcedId

Required

title

Required

grades

courseSourcedId

Recommended

classCode

Recommended

classType

location

Recommended

schoolSourcedId

Recommended

termSourcedIds

Recommended

subjects

subjectCodes

periods

Example:

sourcedId,title,grades,courseSourcedId,classCode,classType,location,schoolSourcedId,termSourcedIds,subjects,subjectCodes,periods

courses.csv (Recommended)

Headers

Necessity

sourcedId

Required

schoolYearSourcedId

title

Required

courseCode

Recommended

grades

orgSourcedId

Recommended

subjects

subjectCodes

Example:

sourcedId,schoolYearSourcedId,title,courseCode,grades,orgSourcedId,subjects,subjectCodes

demographics.csv (Recommended)

Headers

Necessity

sourcedId

Required

birthDate

Recommended

sex

Recommended

Example:

sourcedId,birthDate,sex

enrollments.csv (Required)

Headers

Necessity

sourcedId

Required

classSourcedId

Required

schoolSourcedId

userSourcedId

Required

role

Required “student” or “teacher” or else not used by Google

primary

Recommended

beginDate

Recommended

endDate

Recommended

Example:

sourcedId,classSourcedId,schoolSourcedId,userSourcedId,role,primary,beginDate,endDate


orgs.csv (Recommended)

Headers

Necessity

sourcedId

Required

name

Recommended

type

Required

identifier

Recommended

parentSourcedId

Recommended

Example:

sourcedId,name,type,identifier,parentSourcedId

users.csv (Required)

Headers

Data Sync Necessity (recommended)

sourcedId

Required

enabledUser

orgSourcedIds

Recommended

role

Recommended

username

Recommended

userIds

givenName

Recommended

familyName

Recommended

middleName

Recommended

identifier

email

Required - Must be Google Workspace email and domain

sms

phone

Recommended

agentSourcedIds

Recommended

grades

password

birthDate*

Recommended

sex*

Recommended

Example:

sourcedId,enabledUser,orgSourcedIds,role,username,userIds,givenName,familyName,middleName,identifier,email,sms,phone,agentSourcedIds,grades,password,birthDate,sex

NOTE: birthDate and sex may optionally be supplied in the users.csv or additionally in the demographics.csv

Did this answer your question?