guardians.csv

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 guardian should of course be associated with at least one child.
If your guardian information is tied to your student information, let Transportant staff know and we will discuss custom imports tying guardians to students through the student IDs.

Fields

id

Unique ID of the guardian. This is a required field.

name

Full guardian name. This is a required field.

children

Comma separated list of all the guardian’s children as student IDs. These are the IDs in students.csv (e.g. “12331, 41231”). If there is more than one student ID, note the quotation marks surrounding the student IDs, and a comma separating each ID. 

email

The e-mail associated with this guardian, if any.

primary_phone_number

Primary phone number for this guardian, if any.

secondary_phone_number

Secondary phone number for this guardian, if any.

Example CSV

  1. id,name,children,email,primary_phone_number,secondary_phone_number
  2. 301923,"Watson, David","309123,309124",dwatson@gmail.com,18165552390,18165559823
  3. 301924,"Keaton, Jeannete",309125,jeank@gmail.com,18165556834,18165557822

Example Spreadsheet

id
name
children
email
primary_phone_number
secondary_phone_number
301923
Watson, David
“309123,309124”
18165552390
18165559823
301924
Keaton, Jeannete
309125
18165556834
18165557822


    • Related Articles

    • 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. ...

    • 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 ...

    • 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 ...