Racechrono and Dashware

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

  • Sorry, musst be "at line #10".

    Is it possible to cut the .csv file? I only need 10% of the recorded data.
  • aolaol
    edited April 2015
    Sounds like there is something in the header Dashware doesn't like. Did you export the v1 or v2 .CSV from RaceChrono? I would ask you to contact Dashware support, but as the product is discontinued, there's no support either... Maybe copy paste the 20 first lines of the file here...
  • Thank you so much for your fast support. I tried to export all types racechrono offers - usually it worked fine with the v2.

    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,,,,,,,,
  • Just to jump in here, it looks like there is an unmatched quote character in the file header. I don't generally use CSV myself but just checked test files I had exported with v4.0.9 and 4.0.5 and they do not have this problem.

    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?
  • Try removing the line feed from the session title (after "nos"). I think that should do it. Obviously RC should filter these out, but try removing it manually. I'll fix for future versions.
  • Thank both of you so much.... Finally I didn't get it, so I just copied the header of the old file to the new one. Track positioning and speed works. I have to set up Racechrono again, most of the data I recorded I don't need.

    Keep up with the great work. Nice to know you are there for help (Thx to Karter88).
  • I used it just fine on the 6th....with no issues...



Sign In or Register to comment.