ClassTag Connect offers Single Sign-On (SSO) rostering integration with ClassLink or Clever. Alternatively, set up data with SFTP or use our manual process in the product.

The manual process of uploading District and School rosters requires OneRoster compatible users, classes, and enrollments CSV files. This article will provide you with information about these files.


USERS.CSV

You can download the sample file here.

This is to upload all students, parents/guardians, School Leaders, teachers, and other School Staff.

You can leave out the parents if you prefer uploading them separately. The process of uploading parents/guardians separately can be found here.

Below is the definition of each column of the users.csv file.

sourceId

  • Student, parent, teacher, staff ID or any unique identifier for your students, parents, and staff. There must only be one sourceId per person.

orgSourcedIds

  • The School's unique identifier. This will have to be set manually to all Schools before you upload your users.csv file. If you haven't done so, please follow the instructions from this article.

  • You can use multiple IDs for users that exist in multiple schools. Separate the ordSourced IDs by a comma.

  • You can remove this column if you are uploading the file from the School Level.

role

  • The user's role; student, parent or guardian, teacher, or administrator.

givenName

  • The user's first name.

familyName

  • The user's last name.

email

  • The user's email address.

sms

  • The user's mobile number.

phone

  • The user's home phone number if there is any. It will be kept in the account confidential but will not be used for notifications.

agentSourcedIds

  • Parent/guardian IDs from the first column to be connected to the student in each row.

  • Each student can have up to 6 parents/guardians so the file can have 6 unique IDs separated by commas.

grades

  • The student's grade level.

  • The acceptable codes are listed here.

language

  • The parent/guardian's preferred language for communication.

  • Leaving it blank will default to English

  • This will be used for all future communications to the parents.

  • If the Language selected is different than the teacher or other school members that write an Announcement or a private message, the Announcement or message will be automatically translated.

  • The acceptable Language codes are listed here.


CLASSES.CSV

You can download the sample file here.

This file is used to upload classrooms across all Schools if you are uploading at the District level. Schools uploading files independently can remove the schoolSourcedID column.

Below is the definition of each column of the classes.csv file.

sourcedId

  • The classroom's unique identifier.

title

  • Classroom name.

grades

  • Class level. You can find the list of complete codes here.

location

  • Classroom's location at school. It is not required so if you do not have identified location for the class, you can leave this blank.

schoolSourcedID

  • The School's unique identifier.

  • Must be the same as what you used for the users.csv file.


ENROLLMENTS.CSV

You can download the sample file here.

This process connects the users you uploaded using the users.csv file to the classrooms created by uploading the classes.csv file. You MUST successfully upload the first two files before attempting to upload the enrollments.csv file.

Below is the definition of each column of the enrollments.csv file.

classSourcedId

  • The classroom unique identifier you uploaded via classes.csv.

  • This is where the students and teachers in the third column will be enrolled.

schoolSourcedID

  • The School's unique identifier set before you started uploading these files.

userSourcedId

  • The students and teachers' unique identifiers used in the users.csv file.

role

  • The users' roles set in the users.csv file.

EXPLORE MORE:

Did this answer your question?