Race Import Type

Overview

The Veracross Data Importer allows you to import people's races into Axiom for reporting use to aid in meeting NAIS DASL requirements. The import only adds new races to person records; it does not update existing races. Races need to exist in Veracross prior to the upload. If you have a new race to add, add it before beginning the import. 

Importing races involves:

  1. Preparing the data for upload using the "Race" import type template found at import.veracross.com/your_school.
  2. Uploading the data using the Veracross Data Importer.

Preparing the Data for Upload

Prepare a comma-separated-value (CSV) file containing all data to import. This file must contain all columns in the order listed below.

Recommendation: Use the import template provided at import.veracross.com/your_school, rather than creating your own CSV file. This can eliminate many unintentional errors.

Fields in the Import Type Template

Column (Field) NameNotes
person_fkRequired value. Numeric format. Supply the internal person ID from Veracross. Find it in the Person ID column of a standard Find People query on the Main homepage (and many other places).
raceRequired value. Numeric format. Supply ID of the race in Axiom. Find it in the ID column of the Find Person Race query on the System homepage.

Q&A

QuestionAnswer
Can I update people's races using this import type?No, this import type can only add races to people. It cannot remove or editing people's existing races
Can I add more than one race to someone in a single import?Yes! Each row of the CSV needs to associate one person with one race. To add more than one race to a person, simply add another line that repeats the person's Veracross ID in the "person_fk" column and indicates a different race in the "race" column, like this:
Can I use this import to create a new race that doesn't yet exist in Veracross?No, since you need to supply the internal Veracross ID of the race, that race must already exist in Veracross. If you need to add a race that doesn't yet exist in Veracross, create it in the system (click "Add Race" on the System homepage), grab the ID value, and plug it into the CSV file.