Data Import
How to Send Data to Transportant
You can send the files mentioned in this section to Transportant in one of three ways: By uploading them manually using the dashboard By connecting to our SFTP server and sending the files By uploading the files through the HTTP endpoint Manual Data ...
pictures.zip
This is a compressed archive containing student pictures. Each file in the archive must be named with the student's ID as given in students.csv, followed by the picture's extension (either jpg or png). For example, if student Jane Doe has ID number ...
tags.csv
This file associates tags to students, guardians, routes, stops, buses, or schools. Tags can be any sequence of characters, including emojis. Fields category The name of the category this tag will apply to. Has to be one of student, guardian, route, ...
ridership.csv
This file associates students defined in students.csv to the stops defined in stops.csv, and to the routes defined in routes.csv. Fields student_id Student id as per students.csv. stop_id Stop id as per stops.csv. route_id Route id as per routes.csv. ...
route_stops.csv
This file associates stops to routes and where a stop is positioned in the route. Stops will be ordered by their travel time. Fields stop_id The unique id for a stop. route_id The unique id for the route where the stop above belongs. travel_time The ...
stops.csv
This file contains all stops for all routes in the system. Each row is a stop. Stops can be used on multiple routes, so each stop should only have one row in this file. If no latitude or longitude are provided, the system will attempt to resolve the ...
routes.csv
This file contains all the bus routes. Each row is a route (or run, depending on your system). Fields id Unique id for the route. Can be either text or a number. description Human friendly description of the route. start_time Time of day when the ...
busses.csv
This file contains information about all the buses in the fleet. Because we recognize that many school systems do not have this information digitized and easily available, this file is optional and will not affect others if not uploaded. ...
guardians.csv
This file contains guardians for the students. Each row is a guardian. Required fields are id, name, and at least one form of contact information. "Children" is not a required field -- this is to accommodate special situations -- but normally each ...
fobs.csv
This file associates each student defined in students.csv with the number of his or her fob or other bus pass. Fields student_id student id as per students.csv. fob_number The number associated with the fob or other bus pass. Example CSV ...
students.csv
This file contains student demographic data, such as name, address, and phone number. Bus pass (RFID tag, fob, etc.) numbers will also be contained in this file. Fields id Unique ID for the student. Used to provide associated events (e.g. ridership ...
Getting Started With Data Import
What data needs to be imported for Transportant to provide services Transportant needs to know information about the school bus fleet, the routes and stops it operates on. Additionally, parents and students may use Transportant’s Bus Compass mobile ...