Use the table below to format your classes.csv file. Each row in the classes.csv file represents a class, for example, “General Music, 5th period.” You can view an example of the classes.csv file in CSV form or the classes.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 class. Class sourcedIds will be used in the enrollments.csv file to enroll users in the classes listed here. This value must be unique for every row in this file.|
|status||no||string (0)||Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,|
|dateLastModified||no||date (0)||Leave this field blank. This should appear as two consecutive commas in the .csv file: ,,|
|title||yes||string (30)||Name of the class. This will be the name of the class that appears to teachers in Quaver’s GradeBook. It is important that this value alone is able to distinguish one class from another for a given teacher. For example, a teacher may have a hard time telling the difference between 5 classes when each one is titled “Music.” Class titles over 20 characters may not display correctly in all areas.|
|grade||no||string (2)||Grade level of the class (for example, 5).|
|courseSourcedId||no||string (75)||sourcedId of the course to which this class is an instance. This value must reference a sourcedId in the courses.csv file.|
|classCode||no||string (75)||Human readable code used to help identify this class.|
|classType||no||string (9)||Describes how the class meets. Each value MUST be one of either: homeroom | scheduled|
|location||no||string (75)||Human readable description of where the class is physically located.|
|schoolSourcedId||no||string (75)||sourcedId of the organization (school) which teaches this class. This value must reference a sourcedId in the orgs.csv file.|
|termSourcedId||yes||string (75)||sourcedId of the academicSession in which this class is taught. This value must reference a sourcedId in the academicSessions.csv file. The start and end dates of the referenced academicSessions row will determine the start and end dates of this class within Quaver.|
|subjects||no||string (100)||Subject name, relating to course content. If more than one subject is appropriate, you may list multiple values separated by commas and enclose the entire set with double quotes. For example: “choir, band”.|