Hi,
I recently used Racechrono (with a Samsung Galaxy 3 Tab) in combination with a GoPro and Dashware and it worked quite perfect. Yesterday I recorded about 2 hours of material, after converting the files to the .csv (as usual) I tried to get the data work for Dashware. Unfortunally the programm said
Error parsing header line(s):
Failed to parse header #1 at line #0.
Check your separator settings
In my opinion I didn't change anything in Racechrono (older files I try are working fine).
Do you have a clue or hint that I can do?
Cheers, Tim
Comments
Is it possible to cut the .csv file? I only need 10% of the recorded data.
Here are the first lines of the "problem"-file:
This file is created using RaceChrono v4.0.9 ( http://www.racechrono.com/ ).
Format,2,"Format 1 = static columns","Format 2 = new format with dynamic columns only channel header string is fixed, number of columns and channels' column numbers are variable."
Session title,"nos
"
Session type,Lap timing
Track name,Nordschleife Full Lap"""
Driver name,
Export scope,Fragment 0
Created,07/04/2015,11:05
Note,
Time (s),Session fragment #,Lap #,Trap name,X-position (m),Y-position (m),Speed (m/s),Altitude (m),Bearing (deg),Lateral acceleration (m/s2),Longitudinal acceleration (m/s2),Device update rate (Hz),Satellites (sats),Fix type,Accuracy (m),Distance (m),Latitude (deg),Longitude (deg),X acceleration (m/s2) *Accelerometer,Y acceleration (m/s2) *Accelerometer,Z acceleration (m/s2) *Accelerometer,Device update rate (Hz) *Accelerometer,Speed (m/s) *OBD,RPM (rpm) *OBD,Throttle position (%) *OBD,Coolant temperature (.C) *OBD,Intake temperature (.C) *OBD,Calculated engine load (%) *OBD,Diesel rail pressure (kPa) *OBD,Accelerator pedal position D (%) *OBD,Device update rate (Hz) *Magnetometer,X magnetic field (uT) *Magnetometer,Y magnetic field (uT) *Magnetometer,Z magnetic field (uT) *Magnetometer
1428405481.448,0,,,0.000,0.000,10.067,648.207,256.320,-0.720,-2.895,1.0,10,1,10.000,1585.728,50.3377128,6.9507595,3.617,3.124,9.852,49.9,20.125,3359,83.9,89.1,26.8,99.6,160683.647,74.5,10.0,-20.120,-25.890,-5.750
1428405481.451,0,,,-0.035,0.000,10.065,648.204,256.320,-0.723,-2.883,1.0,10,1,10.000,1585.759,50.3377128,6.9507590,3.620,3.112,9.816,49.9,20.133,3361,83.9,89.1,26.8,99.6,160746.118,74.5,10.0,-20.127,-25.867,-5.750
1428405481.470,0,,,-0.213,0.074,10.052,648.183,256.320,-0.739,-2.807,1.0,10,1,10.000,1585.953,50.3377135,6.9507565,3.428,2.931,9.845,50.0,20.181,3368,83.9,89.1,26.9,99.6,161141.765,74.5,10.0,-20.175,-25.725,-5.750
1428405481.491,0,,,-0.426,0.130,10.038,648.160,256.320,-0.756,-2.723,1.0,10,1,10.000,1586.168,50.3377140,6.9507535,3.630,3.036,10.381,49.9,20.234,3377,83.9,89.1,26.9,99.6,161579.059,74.5,10.0,-20.227,-25.567,-5.750
1428405481.500,0,,,-0.509,0.167,10.032,648.150,256.320,-0.763,-2.686,1.0,10,1,10.000,1586.261,50.3377143,6.9507523,3.530,3.069,10.507,49.6,20.257,3380,83.9,89.1,26.9,99.6,161766.471,74.5,10.0,-20.250,-25.500,-5.750
1428405481.510,0,,,-0.603,0.204,10.025,648.139,256.320,-0.772,-2.646,1.0,10,1,10.000,1586.363,50.3377147,6.9507510,3.420,3.106,10.647,49.3,20.282,3384,83.9,89.1,26.9,99.6,161974.706,74.5,10.0,-20.300,-25.450,-5.775
1428405481.517,0,,,-0.674,0.222,10.020,648.131,256.320,-0.778,-2.618,1.0,10,1,10.000,1586.434,50.3377148,6.9507500,3.342,3.132,10.745,49.1,20.300,3387,83.9,89.1,26.9,99.6,162120.471,74.5,10.0,-20.335,-25.415,-5.792
1428405481.530,0,,,-0.804,0.259,10.011,648.117,256.320,-0.788,-2.566,1.0,10,1,10.000,1586.568,50.3377152,6.9507482,3.534,3.045,10.630,50.0,20.333,3392,83.9,89.1,26.9,99.6,162391.176,74.5,10.0,-20.400,-25.350,-5.825
1428405481.550,0,,,-0.994,0.334,9.997,648.095,256.320,-0.805,-2.486,1.0,10,1,10.000,1586.772,50.3377158,6.9507455,3.649,2.959,10.994,50.3,20.384,3400,83.9,89.1,26.9,99.6,162807.647,74.5,10.0,-20.500,-25.250,-5.875
1428405481.565,0,,,-1.136,0.389,9.987,648.079,256.320,-0.818,-2.426,1.0,10,1,10.000,1586.926,50.3377163,6.9507435,3.224,2.884,10.513,49.8,20.422,3406,83.9,89.1,26.9,99.6,163120.000,74.5,10.0,-20.575,-25.175,-5.912
and here the same one of the last one that worked:
This file is created using RaceChrono v3.20 ( http://www.racechrono.com/ ).
Format,2,"Format 1 = static columns","Format 2 = new format with dynamic columns only channel header string is fixed, number of columns and channels' column numbers are variable."
Session title,"Nordschleife Full Lap"
Session type,Lap timing
Track name,"Nordschleife Full Lap"
Driver name,
Export scope,Whole session
Created,31/07/2014,16:33
Note,
Time (s),Session fragment #,Lap #,Trap name,X-position (m),Y-position (m),Speed (m/s),Altitude (m),Bearing (deg),Lateral acceleration (m/s2),Longitudinal acceleration (m/s2),Device update rate (Hz),Satellites (sats),Fix type,Accuracy (m),Distance (m),Latitude (deg),Longitude (deg),X acceleration (m/s2) *Accelerometer,Y acceleration (m/s2) *Accelerometer,Z acceleration (m/s2) *Accelerometer,Device update rate (Hz) *Accelerometer,Speed (m/s) *OBD,RPM (rpm) *OBD,Throttle position (%) *OBD,Coolant temperature (.C) *OBD,Intake temperature (.C) *OBD,Calculated engine load (%) *OBD,Diesel rail pressure (kPa) *OBD,Accelerator pedal position D (%) *OBD
1406824572.131,0,,,0.000,0.000,0.176,626.400,0.000,,,,1,1,19.018,0.000,50.3466863,6.9668758,-0.115,7.527,6.388,,,,,,,,,
1406824572.330,0,,,0.000,0.000,0.157,626.400,0.000,,,,3,1,17.525,0.000,50.3466863,6.9668758,-0.460,7.661,6.254,5.0,,,,,,,,
1406824572.531,0,,,0.000,0.000,0.138,626.400,0.000,,,,5,1,16.018,0.000,50.3466863,6.9668758,-1.063,7.824,6.072,5.0,,,,,,,,
1406824572.742,0,,,0.000,0.000,0.118,626.400,0.000,,,,7,1,14.435,0.000,50.3466863,6.9668758,-1.034,7.815,6.072,4.9,,,,,,,,
1406824572.945,0,,,0.000,0.000,0.099,626.400,0.000,,,,9,1,12.913,0.000,50.3466863,6.9668758,-1.188,7.748,6.177,4.9,,,,,,,,
1406824573.146,0,,,0.000,0.000,0.080,626.400,0.000,,,,10,1,11.405,0.000,50.3466863,6.9668758,-1.216,7.681,6.235,4.9,,,,,,,,
1406824573.348,0,,,0.000,0.000,0.061,626.400,0.000,,,,12,1,9.890,0.000,50.3466863,6.9668758,-1.197,7.719,5.947,4.9,,,,,,,,
1406824573.550,0,,,0.000,0.000,0.042,626.400,0.000,,,,14,1,8.375,0.000,50.3466863,6.9668758,-1.130,7.920,6.464,4.9,,,,,,,,
1406824573.929,0,,,0.000,0.000,0.007,626.400,0.000,,,,17,1,5.533,0.000,50.3466863,6.9668758,-1.599,7.920,6.292,4.4,,,,,,,,
The closing quote mark for the Session title is strangely on its own line and the value for Track name has three quotes at the end. So the confusion in title caused multiple lines to be enclosed as one value and bad parsing follows. If you use a text editor to fix all the quotes to resemble the working example, I believe it should import to Dashware successfully.
I wonder whether the root cause is some special character in the session title. How does the "nos" session read in the RaceChrono UI?
Keep up with the great work. Nice to know you are there for help (Thx to Karter88).