About Farebox CSV Format

The farebox csv file is in the following format: (The first value represents the column followed by the delimiter (,) and then the description.)

01,route# (line abbreviation*
02,start time (seconds from midnight)*
03,date (yyyy/mm/dd)
04,segmentID (pattern abbr)*
05,operator ID (only for login events)
06,full fare count
07,key1 (fields 7-15 are inserted into supplementary data fields - userlong1-9)
08,key2
09,key3
10,key4
11,key5
12,key6
13,key7
14,key8
15,key9
16,asterisk
17,ttp1
18,ttp2
19,ttp3
20,ttp4
21,ttp5
22,ttp6
23,ttp7
24,ttp8
.
.
.
64,ttp48