The Veracross Data Importer allows schools to import numeric grades for students. This import type is considered both an importer and an updater — it allows you to both import new numeric grade records or update existing grade records. This importer type does not import or update qualitative grade records or transcript items.
On import completion, this process creates:
- class enrollment records for students without them for this class
- numeric grade records for students without them for this class
Additionally, this process updates and replaces existing grades and comments that are not locked.
Uploading Numeric Grades involves the following two steps:
- Preparing the data for upload using the Numeric Grades import type template, which is provided before data import on the Importer site.
- Uploading the data using the Veracross Data Importer.
Preparing the Data for Upload
The user must prepare a comma separated value (CSV) file containing all data to import. This file must contain all columns in the order listed below, even if no content is populated in the columns. If there is no content in a column, that row must be left blank.
Fields in the Import Type Template
Rather than a number of required fields, this template has several combinations of "either this field or that field are required" scenarios. See the notes in the table below for more information.
person_reference_type and person_reference_value
Numeric. The person_id can be found in the Person ID field in a standard Find Person query.
Must be an already existing person reference type. This information can be found in a Person Reference Type query. Must be either of the following:
Text/numeric. This value is the reference value in a Find Person Reference Number query.
class_id and school_year
Numeric. The internal class ID for the class the grade record applies to. This number can be found as the Internal Class ID field in this Find Classes query.
Text/numeric. The Class ID for the class the grade record applies to. This number can be found as the Class ID field in this Find Classes query.
The school year in which the class takes place. May be in one of the following formats:
|grade_level||The grade level in which the student was enrolled when the grade was earned. May be in one of the following formats:|
The grading period that the grade record is set for. May be in one of the following formats:
This field is always required.
NOTE: The Numeric Grade Import Type does NOT create new grading periods; all referenced grading periods must be created prior to using them in this import type. If you'd like to set up new grading periods, please reach out to your Account Manager to begin this process.
|assignment_posted_grade||Numeric. The numeric assignment posted grade.|
|exam_grade||Numeric. The numeric grade for the exam.|
Numeric. The posted numeric grade.
This cannot be populated if the "status" column is populated for this row.
The grade status to be imported when there is no posted numeric grade. May be in one of the following formats:
This cannot be populated if the "posted_grade" column is populated for this row.
The first (or only) other grade type, if your school has this functionality configured. Has a Category of 1 in this query. May be in one of the following formats:
The second other grade type, if your school has this functionality configured. Has a category of 2 in this query. May be in one of the following formats:
|comments||Text. The comment field on the grade record.|
There are additional things to consider when using this import type:
- each combination of person_id/internal_class_id/grading_period can only have one row per import, or else the import will fail