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 language proficiencies for multiple individuals all at once. This import type is considered an importer but not an updater — this import type can add new languages to a person, but cannot modify or delete existing languages that the person has. If you import a language that the person already has, the new imported value is completely ignored.
Uploading Person Language records involves the following two steps:
- Preparing the data for upload using the Person Language import type template, which is provided before data import on the Importer site.
- Uploading the data using the Veracross Data Importer.
Preparing the Data for Upload
The user must prepare a comma separated value (CSV) file containing all data to import. This file must contain all columns in the order listed below, even if no content is populated in the columns. If there is no content in a column, that row must be left blank.
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
This template has an instance of a "either this field or that field are required" scenario. See the notes in the table below for more information.
| Column (field) Name | Notes |
|---|---|
| Required fields: person_id or person_reference_type and person_reference_value | |
| person_id | Numeric format. The person_id can be found in the Person ID field in a standard Find Person query. |
| person_reference_type | Text/numeric format. Must be an already existing person reference type. This information can be found in a Person Reference Type query. Must be either of the following:
|
| person_reference_value | Text/numeric format. This value is the reference value in a Find Person Reference Number query. |
| language | Required field. Text/numeric format. Either the language ID or the language description. This information can be found on a Languages query as the ID or Description field, respectively. |
| primary_code | Text/numeric field. Whether or not this language is the person's primary language. Options are:
Note: individuals may only have one primary language. |
| spoken_at_home | Text/numeric field. Whether or not this language is spoken at home. Options are:
|
| reading_proficiency | Text field. The proficiency level of the individual relating to reading. Available options may vary from school-to-school, but can be found using this query. Click on the "Reading Proficiency" field and your available options will display in the right column under "Properties". While this field is not case sensitive, besides this, the value must match exactly. |
| writing_proficiency | Text field. The proficiency level of the individual relating to writing. Available options may vary from school-to-school, but can be found using this query. Click on the "Writing Proficiency" field and your available options will display in the right column under "Properties". While this field is not case sensitive, besides this, the value must match exactly. |
| speaking_proficiency | Text field. The proficiency level of the individual relating to speech. Available options may vary from school-to-school, but can be found using this query. Click on the "Speaking Proficiency" field and your available options will display in the right column under "Properties". While this field is not case sensitive, besides this, the value must match exactly. |
| listening_proficiency | Text field. The proficiency level of the individual relating to listening. Available options may vary from school-to-school, but can be found using this query. Click on the "Listening Proficiency" field and your available options will display in the right column under "Properties". While this field is not case sensitive, besides this, the value must match exactly. |
| years_studying | Integer value. How many years this person has been studying the language. Note that this value must be a whole number or the import will fail. |
| notes | Text field. Any additional notes about this person language record. This field has a character limit of 255 characters. |
Q&A
In addition to the criteria set in the table above, this import type has a number of additional considerations that should be taken into account.
| Question | Answer |
|---|---|
| Can I remove or adjust languages on a person using this import? | Sorry, but no. This import type acts as an importer and not an updater — it can insert (add) new records, but cannot modify (remove) existing ones. |
| Can I create new languages through this import type? | No — new languages must be created in Axiom. |