As of July 12, 2021, this "Learn Veracross" site has been deprecated. It will remain live through December 2022, but will no longer be updated. All knowledge content has moved to the new Veracross Community. Please update your bookmarks.
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:
- Preparing the data for upload using the "Race" import type template found at import.veracross.com/your_school.
- 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) Name | Notes |
|---|---|
| person_fk | Required 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). |
| race | Required 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
| Question | Answer |
|---|---|
| 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. |