The Veracross Data Importer allows schools to import subjects into Axiom for academic use. This import type should be considered an importer only — it allows you to import new subjects into Axiom but will not allow you to update existing subjects.
On import completion, this process creates new subjects within departments in Axiom for use with academic modules.
Uploading subjects involves the following two steps:
- Preparing the data for upload using the Subject import type template, which is provided before data import on the Importer site.
- Uploading the data using the Veracross Data Importer.
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.
Fields in the Import Type Template
The Subject import type has a number of required fields, each of which is designated in the corresponding row in the Value Considerations column below.
|Column (Field) Name||Value Considerations|
|school_level||Text/numeric format. The school level that this subject is associated with, if any. If used, this field can be populated by one of two options:|
|department||Required value. Text/numeric format. The department that this subject should be a part of. This field must be populated by one of two options:|
|description||Required value. Text format. This value is the name of the subject being imported. This value can be found in the Description column in a Subject List query. This field has a character limit of 50 characters.|
|abbreviation||Required value. Text format. This value is the abbreviation of the subject being imported. This value can be found in the Abbreviation column of a Subject List query. This field has a character limit of five (5) characters.|
|credits_required||Numeric format. This value typically designates how many credits are required from this subject for a student to graduate. It is worth noting that this value doesn't have any functionality tied to it and is for reporting purposes only. This value can be found in the Credits Required column of a Subject List query.|
|link_style||Hex code format. This value designates the color in which this subject appears in schedule documents. This value may be found as the Link Style column in a Subject List query.|
A hex code is a string of six alpha-numeric characters following a # that denotes a specific color. Each of these characters can be a number between 0-9 or a letter between A-F. Learn more about hex codes here.
|sort_key||Numeric value. This value determines the sort key for the subject. This value can be found in the Sort Key column in a Subject List query.|
In addition to the criteria set in the table above, the Subject import type has a number of additional considerations that should be taken into account:
- this import type is an importer only — it will insert new subjects but not update existing subjects
- to check for duplicates, the subject import type will look through the system to find if any subjects already exist that have all the following fields as identical: school_level, department, and description. If any subjects exist that exactly match all three of these fields, that new subject is not created and is, instead, skipped over.