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 add immunization data to student health records.
Importing the data involves two steps:
- Preparing the data for upload.
- Uploading the data using the Veracross Data Importer.
Preparing the Data for Upload
Prepare a comma separated value (CSV) file containing contact data for any/all of the fields listed below. This CSV file must contain all of the required columns in the order listed below, even if no content is populated in the columns. If a cell, or even a whole column, is left blank in the import file for any of the fields, the import process will not affect whatever data already exist for that field. As such, this import type can be used to simply update the values that are provided in the file, and leave untouched any values currently in the database.
Note that the following data must already be present for the import to succeed:
- person_id (required) and medical_person_id (optional) must already exist.
- immunization_description must already exist.
Fields on the Import Type Template
Required fields are marked with an asterisk (*).
| person_id* | Numeric field. The person ID must already exist in the database. |
| immunization_description* | Text field. The immunization description must already exist in the database. |
| medical_person_id | Numeric field that identifies the medical personnel who administered the immunization. If provided, the person must already exist in the database. |
| actual_date | Several formats accepted: yyyy-MM-dd, mm/dd/yy, mm-dd-yy, mm-dd-yyyy, mm/dd/yyyy |
| vaccine_used | |
| dose_number | |
| dosage_amount | |
| exemption_code | |
| exemption_text | |
| verified_complete | A yes/no field. Values accepted are yes, true, 1; no, false, 0. |
| out_of_compliance | A yes/no field. Values accepted are yes, true, 1; no, false, 0. |