students.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 events such as getting on or off a bus) back to the school system. Also used to deduplicate and make updates to previously imported records.

name

The full name of the student, which is displayed in the mobile app along with general status information.

school 

Name of the specific school this student attends (e.g. “Stoney Brook Elementary”)

grade 

Grade should be a number, or be listed in ['K', 'KF', 'KP', 'KA', 'KG', 'KINDERGARTEN', 'PK', 'PRE K', 'PA', 'PP', 'EC', 'P', 'PS', 'PE']

emails

A comma separated list of all e-mails associated with this student (e.g. “robert@gmail.com, robert@yahoo.com”) . Notice the quotations around both email addresses with a comma separating.

primary_phone_number

The primary phone number for this student. 


secondary_phone_number

 The secondary phone number for this student.

fob_number

The number of the RFID FOB (or barcode) associated with this student. This will be used by the ridership reader when students swipe in and out of the bus.


Student addresses fields are available for routing purposes. Additionally, address latitude and longitude values can be provided for extra accuracy. All these fields are optional.

address

The main address for the student, that is the main location at/near which the student will be picked up / dropped off from the bus

address_latitude

The latitude coordinate for the main address

address_longitude

The longitude coordinate for the main address


secondary_address

The secondary address for the student, that is the alternative location at/near which the student will be picked up / dropped off from the bus on some occasions.


secondary_address_latitude

 The latitude coordinate for the secondary address


secondary_address_longitude

 The longitude coordinate for the secondary address

Example CSV

  1. id,name,school,grade,emails,primary_phone_number,secondary_phone_number,fob_number
  2. 309123,"Watson, Abby Grace",Hill Valley EL,2,abby.watson@hillvalley.com,18165550110,19185551212,3213195671
  3. 309124,"Watson, Jennifer Louise",Hill Valley EL,2,jennifer.watson@hillvalley.com,18165550202,17635558723,7329101589
  4. 309125,"Keaton, James Oliver",Hill Valley EL,-1,james.keaton@hillvalley.com,18165556677,18165558777,1212301846
  5. 309126,"Davis, Lauren Charlotte",Hill Valley HS,10,lauren.davis@hillvalley.com,18165559210,18165558245,3943201931

Example CSV viewed as spreadsheet

id
name
school
grade
emails
primary_phone_number
secondary_phone_number
fob_number
309123
Watson, Abby Grace
Hill Valley EL
2
18165550110
19185551212
3213195671
309124
Watson, Jennifer Louise
Hill Valley EL
2
18165550202
17635558723
7329101589
309125
Keaton, James Oliver
Hill Valley EL
-1
18165556677
18165558777
1212301846
309126
Davis, Lauren
Charlotte Hill Valley HS
10
18165559210
18165558245
3943201931

    • Related Articles

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

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

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

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

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