Racechrono and Dashware

Comments

• timjen

  April 2015

  Sorry, musst be "at line #10".
  
  Is it possible to cut the .csv file? I only need 10% of the recorded data.
• aol_of_RaceChrono

  April 2015 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...
• timjen

  April 2015

  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,,,,,,,,
  
• Karter88

  April 2015

  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?
  
• aol_of_RaceChrono

  April 2015

  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.
• timjen

  April 2015

  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).
• TAD158

  April 2015

  I used it just fine on the 6th....with no issues...