Use the table below to format your enrollments.csv file. Each row in the enrollment.csv file designates one user as being in one class. You can view an example of the enrollments.csv file in CSV form or the enrollments.csv file in spreadsheet form.
Blue rows denote required fields.
|Field Header||Quaver Requires?||Format (max chars)||Description/Guidance|
|sourcedId||yes||string (75)||This value should assign a unique ID to each enrollment. An enrollment consists of the pairing of a user (student or teacher) and a class. A unique enrollment sourcedId can often be achieved by combining the user sourcedId and the class sourcedId. This value must be unique for every row in this file.|
|classSourcedId||yes||string (75)||sourcedId of the class in which the user is enrolled. This value must reference a sourcedId in the classes.csv file. This value indicates in which class the user should be enrolled.|
|schoolSourcedId||no||string (75)||sourcedId of the school in which the enrollment exists. This value must reference a sourcedId in the orgs.csv file. Quaver organizes classes by teacher, and this value is not utilized in our system.|
|userSourcedId||yes||string (75)||sourcedId of the user who is enrolled in the class. This value must reference a sourcedId in the users.csv file. This value indicates which user should be enrolled in the class.|
|role||yes||string (13)||Describes the role of the user within the class. For example, the user may be enrolled in the class as a teacher, or as a student. Each value MUST be one of the following: teacher | student | parent | guardian | relative | aide | administrator
Quaver uses only the “teacher” and “student” roles to define user:class relationships. Users with any other role will not be enrolled in the Quaver class.
|status||no||string (0)||Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,|
|dateLastModified||no||string (0)||Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,|
|primary||no*||Boolean (5)||If more than one teacher is enrolled in a class, one and only one of the teachers must be specified as the primary teacher. The value should be “true” for the one primary teacher and “false” for any other. *If more than one teacher is enrolled in a class, this value is required to be "true" for exactly one teacher.|