Hi there,
We are importing the GTFS bundle for Sydney Trains daily, and today’s has failed due to some invalid arrival/departure_time fields in the stop_times.txt file:
In the sample below, some of the arrival and departure times are invalid, i.e.: "::"
"trip_id","arrival_time","departure_time","stop_id","stop_sequence","stop_headsign","pickup_type","drop_off_type","shape_dist_traveled"
"1--A.1139.102.130.A.8.43239542","05:59:00","05:59:00","2144243","8","Empty Train","1","1",""
"1--A.1139.102.130.A.8.43239542","06:02:00","06:10:00","2141311","14","","0","0",""
"1--A.1139.102.130.A.8.43239542","06:15:30","06:18:00","2127102","25","","1","0",""
"1--A.1307.121.132.A.8.43269993","::","::","2144243","8","Empty Train","1","1",""
"1--A.1307.121.132.A.8.43269993","::","::","2141311","14","","0","0",""
"1--A.1307.121.132.A.8.43269993","::","::","2127102","25","","1","0",""
"1--A.1307.121.2.A.8.43269993","::","::","2144243","8","Empty Train","1","1",""
"1--A.1307.121.2.A.8.43269993","::","::","2141311","14","","0","0",""
"1--A.1307.121.2.A.8.43269993","::","::","2127102","25","","1","0",""
"1--A.1317.114.128.A.8.43322564","05:59:30","05:59:30","2144243","8","Empty Train","1","1",""
"1--A.1317.114.128.A.8.43322564","06:02:30","06:10:30","2141311","14","","0","0",""
"1--A.1317.114.128.A.8.43322564","06:16:00","06:18:00","2127102","25","","1","0",""
"1--A.1317.114.2.A.8.43840368","05:59:00","05:59:00","2144243","8","Empty Train","1","1",""
"1--A.1317.114.2.A.8.43840368","06:02:00","06:10:00","2141311","14","","0","0",""
"1--A.1317.114.2.A.8.43840368","06:15:30","06:18:00","2127102","25","","1","0",""
"1--A.1414.107.128.A.8.43131213","05:59:00","05:59:00","2144243","8","Empty Train","1","1",""
"1--A.1414.107.128.A.8.43131213","06:02:00","06:10:00","2141311","14","","0","0",""
"1--A.1414.107.128.A.8.43131213","06:15:30","06:18:00","2127102","25","","1","0",""
Could someone please take a look at this urgently, as without this working correctly, we will lose realtime information for trains in Sydney?
Many thanks,
David