The Veracross Data Importer allows you to both import (create) new transfer grade transcript items and update existing transcript items for use in generating and updating transfer grade student transcript items with grades from outside your school. It also allows you to create new transfer transcript courses through the import itself. This import type is considered both an importer and an updater — it allows you to import and create new transfer grade transcript items and also update transfer grade transcript items that that already exist in the database. A transcript item record is uniquely determined by the combination of the following fields:
To update an existing transfer grade transcript item, the above values on the relevant line in your CSV file must match the above values of the existing transcript item within Veracross. Otherwise, a new transcript item is created (or worse, the wrong transcript item is edited!).
Uploading transfer grade transcript items involves the following two steps:
- Preparing the data for upload using the Transfer Grade Transcript Item 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
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
There are a mix of columns in this import type where columns are required to be populated by a value and where the column being populated is optional. These are detailed in the Value Considerations column below.
|Column (Field) Name||Value Considerations|
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.|
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.|
|school_vc_organization_id||Required field. Numeric format. The ID of the organization this student's grades are coming from. This value can be found in the Organization ID column in this Organization query.|
|school_year||Required field. Text field. The year in which the course for this traqnscript item was taken. Populate this with the value in either the Year or School Year columns in the Years query.|
|grade_level||Required field. Text field. The grade level in which this course was originally taken by the student. Populate this with either the ID or Grade level columns in a Grade Levels query.|
|vc_grading_period_id||Required field. Numeric format. The grading period that this transcript item should be created for. Populate this with the ID field in a standard Grading Periods query.|
NOTE: The Transfer Grade Transcript Item Import Type does NOT create new grading periods; all referenced grading periods must be created prior to using them in this import type. If you'd like to set up new grading periods, please reach out to your Account Manager to begin this process.
vc_transcript_course_id (which is preferred for attaching existing transfer transcript courses) or
course_id and course_name and include_in_gpa (which is used in the creation of new transfer transcript courses).
If associating a transfer transcript item with an existing transcript course, this transcript course must be designated as a transfer transcript course (designated by the Transfer column in this query being checked).
|vc_transcript_course_id||Numeric format. The transcript course ID for the existing course in Veracross that this transcript item should be associated with. Populate this with the Transcript Course ID column in a Transcript Course query.|
|course_id||Text format. An often used abbreviation for a transcript course. Populate this with the Course ID column in a Transcript Course query. This field allows for a maximum of 15 characters.|
|course_name||Text format. The actual name of the transcript course. Populate this with the Course Name field in a Transcript Course query. This field allows for a maximum of 100 characters.|
|include_in_gpa||Boolean format. Whether or not transcript items for this course are calculated in the students' GPA. Find this value in the Include in GPA column in a Transcript Course query (Checked = Yes and Unchecked = No). Viable options are:|
|enrollment_level||Text format. The enrollment level that this transcript item should be assigned to. Populate this with either the ID or Description fields in the Enrollment Levels query.|
|status||Text format. The "status" for this transcript item if numeric grades don't apply (e.g., pass/fail or incomplete). Populate this with either the ID, Description, or Abbreviation columns in a Grade Statuses query.|
|numeric_grade||Required value. Numeric format. The numeric grade earned for the course the transcript item is pulling from.|
If the status column is populated, the numeric_grade column must be populated with a "0".
|credits_attempted||Required value. Numeric format. The number of credits attempted for the course the transcript item is pulling from.|
|credits_earned||Required value. Numeric format. The number of credits earned for the course the transcript item is pulling from.|
|vc_grade_conversion_scale_id||Required value. Text format. The ID of the grade convesrion scale this transcript item should correspond to. Populate this with the ID field in the Grade Conversion query.|
I know there are a couple "either this value or that value must be included" scenarios with this import type. What were they again?
There are two different scenarios that you're describing in your question. They are:
- Either person_id or person_reference_type & person_reference_value are required
- Either vc_transcript_course_id or course_id, course_name, and include_in_gpa are required
What do I have to make sure match if I want to update an existing transfer course transcript item through this import type?
To update an existing transfer grade transcript item, the following values on the relevent line in your csv file must match the following values of the existing transcript item within Veracross:
Can I add new transfer transcript courses through this import?
Yes! For the instance where you choose between either vc_transcript_course_id or course_id, course_name, and include_in_gpa, you can create a new transfer transcript course through the course_id, course_name, and include_in_gpa option by specifying the values you like upon import.
Please note that all transcript courses designated here (even existing ones) are marked as transfer transcript courses (designated by the Transfer column in this query) upon import.