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. This is a required field.

name

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

school

Name of the specific school this student attends (e.g. “Stoney Brook Elementary”). This is a required field.

grade

Grade should be a number, or one of the following: 'K', 'KF', 'KP', 'KA', 'KG', 'KINDERGARTEN', 'PK', 'PRE K', 'PA', 'PP', 'EC', 'P', 'PS', 'PE'. This is a required field.

emails

A comma separated list of all e-mails associated with this student, e.g. “robert@gmail.com, robert@yahoo.com”. Notice the quotation marks surrounding both email addresses, and that addresses are separated with a comma. This is an optional field.

primary_phone_number

The primary phone number for this student. This is an optional field.

secondary_phone_number

The secondary phone number for this student. This is an optional field.

fob_number

The number of the bus pass (RFID fob, barcode, etc.) associated with this student. This will be used by the ridership reader when students swipe in and out of the bus. This is an optional field.

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