Subject Import Type

Overview

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.

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.

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) NameValue Considerations
school_levelText/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:
departmentRequired value. Text/numeric format. The department that this subject should be a part of. This field must be populated by one of two options:
  • a valid department id (numeric — found as the ID column value on a Departments query)
  • a valid department abbreviation (text — found as the Abbreviation column value on a Departments query)
descriptionRequired 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.
abbreviationRequired 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_requiredNumeric 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_styleHex 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_keyNumeric 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.

Additional Considerations

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.