Person Classification Import Type

Overview

The Veracross Data Importer allows schools to add non-system person classifications — as well as their start/end times, grading periods, and notes — to existing person records in batch. This article covers the fields needed in the person classification CSV import. All data updated through this import type must already exist in Veracross — no new classifications, people, or grading periods can be created in this way.

Preparing the Data for Import

Prepare a comma-separated value (CSV) file containing the data for the fields listed below. This CSV file must contain a column for each field listed below and they must be in that same order. Even if no content is populated in the non-required columns, a column must nonetheless exist as a placeholder in order for the Data Importer to properly read the file. Upload the CSV using the Data Importer.

Fields on this Import Type

All required fields are highlighted in orange and have an asterisk(*) next to their name.

person_id*Numeric — This is the value in the Person ID field in a Find Person query.
 This is the Person ID of the record the classification is being applied to.
classification*Numeric — The is the value in the ID field in this Person Classification query.
This is the ID of the Person Classification that is being added to the person record.
This classification cannot be a system classification — it must be school-defined.
start_school_yearNumeric — This is the value in the Year column in the Years query. This is the school year that the person began having this classification.
end_school_yearNumeric — This is the value in the Year column in the Years query. This is the school year that the person finished having this classification.
start_dateDate in the YYYY-MM-DD format — This is the start date for when this classification should be applied to the person.
end_dateDate in the YYYY-MM-DD format — This is the end date for when this classification should be applied to the person.
grading_periodNumeric — This is the value in the ID column of the Grading Periods query. This is the valid grading period that this classification should be associated with.
Leaving this blank or populating it with a 0 automatically applies the ALL grading period.
notesText — Any notes that should be stored on the Person Classification record.
This field may contain a maximum of 1000 characters.

Considerations with this Import Type

There are two things to consider when using the person classification import type:

  • all person classifications are applied as Active person classifications
  • each combination of person_id and classification may only be present in each import once