Data Importer: Immunizations

Overview

The Veracross Data Importer allows schools to add immunization data to student health records.

Importing the data involves two steps:

  1. Preparing the data for upload.
  2. 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 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.
print

Related Articles