Transportation Import Type

Overview

The Veracross Data Importer allows schools to import transportation schedules. This article covers the fields needed in the CSV import. This import type is connected with the Transportation Module, which is an add-on module. If your school does not use the Transportation module and would like to, speak with your account manager for pricing. If your school does use the Transportation module and does not currently see this importer type available, please speak with your account manager to request that it be installed.

Preparing the Data for Import

Prepare a comma-separated value (CSV) file containing the data for the fields listed below. This CSV file must contain a column for each field listed below and they must be in that same order. Even if no content is populated in the non-required columns, a column must nonetheless exist as a placeholder in order for the Data Importer to properly read the file. Upload the CSV using the Data Importer.

Fields on the Import Type Template

An asterisk (*) indicates that data is required in the field.

FieldTypeNotes
person_id *integerRun a Find Person query to determine.
school_year *integerYYYY format (e.g., 2018).
grading_period *integerRun a Grading Periods query to find the grading period ID.
class_fkintegerInclude the internal class ID if associating the schedule with an extended care or other program class.
day *integerUse the following query to locate the rotation day ID:


https://axiom.veracross.com/shortname/#/results/323080

Replace the word “shortname” with your school’s short name found in Axiom and Portals URLs.

am_pm *textUse “am” or “pm”.
transportation_method *textThis must match an existing transportation method exactly. View a transportation schedule for examples, e.g., “bus” and “car”.
bus_routeintegerRun a Bus Routes query and add the ID field to find the bus route ID.
bus_stopintegerThe bus stop must belong to the indicated bus route.
bus_zoneintegerSome schools may use this field to aid in billing calculations
pu_drop_off_timetimeAny standard time input is accepted (e.g., 2:30 pm or 14:30).
notestextAdd any optional notes.