how's this csv look?

[sickmint79]

just got in from driving around my community college after buying a phone to pretend it's a pda, an obd2 bluetooth reader and obd2 external gps antenna. i'm using racechrono on the pda to record data. is this looking dashware compatible? i didn't expect there to (apparently) be multiple row types. also not sure what of these is like a time dimension (or if there isn't one?)

my file is named 20090418-1523-nmea and looks like this (no headings):

$GPGGA,192134.800,4221.6652,N,08800.3386,W,2,10,0. 81,234.9,M,-34.1,M,0000,0000*5A
$GPGSA,A,3,14,09,21,19,11,30,31,12,22,18,,,1.30,0. 81,1.02*06
$GPGSV,3,1,11,22,82,073,48,14,66,288,44,18,50,112, 48,51,37,207,45*78
$GPGSV,3,2,11,09,30,047,48,31,19,201,45,12,17,096, 42,30,13,131,38*70
$GPGSV,3,3,11,21,07,168,35,19,07,276,25,11,06,322, 36*4F
$GPRMC,192134.800,A,4221.6652,N,08800.3386,W,0.01, 194.20,180409,,,D*7A
$GPGGA,192135.000,4221.6652,N,08800.3386,W,2,9,0.8 8,234.9,M,-34.1,M,0000,0000*62
$GPGSA,A,3,14,09,21,11,30,31,12,22,18,,,,1.39,0.88 ,1.07*0B
$GPGSV,3,1,11,22,82,073,48,14,66,288,44,18,50,112, 48,51,37,207,45*78
$GPGSV,3,2,11,09,30,047,48,31,19,201,45,12,17,096, 42,30,13,131,38*70
$GPGSV,3,3,11,21,07,168,35,19,07,276,25,11,06,322, 36*4F
$GPRMC,192135.000,A,4221.6652,N,08800.3386,W,0.00, 194.20,180409,,,D*72
$GPGGA,192135.400,4221.6652,N,08800.3386,W,2,9,0.8 8,234.9,M,-34.1,M,0000,0000*66
$GPGSA,A,3,14,09,21,11,30,31,12,22,18,,,,1.39,0.88 ,1.07*0B
$GPGSV,3,1,11,22,82,073,48,14,66,288,44,18,50,112, 48,51,37,207,45*78
$GPGSV,3,2,11,09,30,047,48,31,19,201,45,12,17,096, 42,30,13,131,37*7F
$GPGSV,3,3,11,21,07,168,35,19,07,276,25,11,06,322, 36*4F
$GPRMC,192135.400,A,4221.6652,N,08800.3386,W,0.01, 194.20,180409,,,D*77
$GPGGA,192135.600,4221.6652,N,08800.3386,W,2,10,0. 81,234.9,M,-34.1,M,0000,0000*55
$GPGSA,A,3,14,09,21,19,11,30,31,12,22,18,,,1.30,0. 81,1.02*06
$GPGSV,3,1,11,22,82,073,48,14,66,288,44,18,50,112, 48,51,37,207,45*78
$GPGSV,3,2,11,09,30,047,48,31,19,201,45,12,17,096, 42,30,13,131,37*7F
$GPGSV,3,3,11,21,07,168,35,19,07,276,26,11,06,322, 36*4C
$GPRMC,192135.600,A,4221.6652,N,08800.3386,W,0.01, 194.20,180409,,,D*75
$GPGGA,192136.400,4221.6652,N,08800.3386,W,2,10,0. 81,234.9,M,-34.1,M,0000,0000*54
$GPGSA,A,3,14,09,21,19,11,30,31,12,22,18,,,1.30,0. 81,1.02*06
$GPGSV,3,1,11,22,82,073,48,14,66,288,44,18,50,112, 48,51,37,207,45*78
$GPGSV,3,2,11,09,30,047,48,31,19,201,45,12,17,096, 42,30,13,131,37*7F
$GPGSV,3,3,11,21,07,168,35,19,07,276,26,11,06,322, 36*4C
$GPRMC,192136.400,A,4221.6652,N,08800.3386,W,0.00, 194.20,180409,,,D*75
$GPGGA,192136.600,4221.6652,N,08800.3386,W,2,10,0. 81,234.9,M,-34.1,M,0000,0000*56
$GPGSA,A,3,14,09,21,19,11,30,31,12,22,18,,,1.30,0. 81,1.02*06
$GPGSV,3,1,11,22,82,073,48,14,66,288,44,18,50,112, 48,51,37,207,45*78
$GPGSV,3,2,11,09,30,047,48,31,19,201,45,12,17,096, 42,30,13,131,37*7F
$GPGSV,3,3,11,21,07,168,35,19,07,276,26,11,06,322, 36*4C
$GPRMC,192136.600,A,4221.6652,N,08800.3386,W,0.01, 194.20,180409,,,D*76

for the obd2 reader there were 2 sets of data i could tell it to write. one had rpm, obd2 speed, throttle and relative throttle and the other i forgot. no way to record which gear i'm in? how does this file look to you guys?

[sickmint79]

this one looks much better...
http://mike.developer10.com/test.csv

[Dmitriy]

I think that they are working on making that data file native. The racechrono guy is really chill so I am sure something can be worked out.

[sickmint79]

yes he's quite helpful and responsive.

[Rolf]

We'll have a look today and we'll get back to you. We'll make it work one way or another.

[Dmitriy]

I have lap timing and video for Laguna Seca if you want a sample files to work with. Timing from Race Chrono.

[Rolf]

I have lap timing and video for Laguna Seca if you want a sample files to work with. Timing from Race Chrono.

That would be really helpful. PM coming...

[Rolf]

OK, so that first data format with the varying row types would be pretty hard to get working right in DashWare. The 2nd one is pretty easy though. I just cut out the "junk" that appears before the header line (see http://www.hyperattack.com/tmp/Copy%20of%20test.csv). I then got DashWare to read it in fine.

I manually set a start/finish in the area you looped around, so I am getting lap times etc now.

By the way, once you set a start/finish we then associate the calculated, lap-related inputs with your data file. To hook them up to your gauge(s) you have to open up the Gauge Input Mapper for each applicable gauge. It should auto-assign them for you when the dialog pops up, but double check the list to make sure.

(Double click on a gauge name in the Project Gauges list to bring up the Gauge Input Mapper, or click on the "Edit Gauge Input Assignments..." toolbar button).

Does that work for you?

FYI, we are in the middle of trying to streamline this process for you guys.

[sickmint79]

yeah the first set was like the nmea gps sentences or something like that.

i have this software now (can't take a look at it at the moment) - i didn't notice i could set the start/finish on it. will have to look when back home. can i set other traps too, like turn 3 start and end? have dash display a turn # when i'm going through it?

[Rolf]

Yeah, you can set split points to segment the track however you want.

You can have a dash/gauge display the current split number, current split time, previous split time, ...

[sickmint79]

any tricks to synching it? my first vid: http://www.youtube.com/watch?v=tvhRs_2cwCI&fmt=35

[Rolf]

I find the engine RPM to be the most useful for syncing. A good trick is once you know the data logger is logging, blip the throttle a couple of times. High enough that you will hear the engine in your video. Then when you bring the video and data into DashWare you can stare at your tach needle and listen to the engine sound. If your needle spikes too early or too late it is pretty darn noticeable, even if you're only off by a quarter of a second. Just like when you are watching a movie that is out of sync, you notice when the lip movement is off.

By the way, it's easier to use an analog gauge for this vs. a digital one. Easier to watch a needle spike vs. watching some numbers.

[sickmint79]

thanks for the tip!