search

iRail / gtfs-tdt

Loads GTFS into MySQL and serves next departures and arrivals at a certain stop from The DataTank
BSD 3-Clause "New" or "Revised" License
4 stars 1 forks source link

csv parse error #32

Closed brechtvdv closed 9 years ago

brechtvdv commented 9 years ago

Error for columns that are enclosed in "..." and contain a comma

TEC:LPLc65-2,,"PLAINEVAUX route du Condroz, 65",50.549121,5.504338,0,stoparea:TEC:LPLc65-,,1,,

pietercolpaert commented 9 years ago

https://github.com/iRail/gtfs-tdt/blob/master/datasources/tec/importTec.sql#L177 → make sure it has enclosed by instead: https://dev.mysql.com/doc/refman/5.1/en/load-data.html