Profile for Harry's GPS LapTimer iPhone app

[964RSA]

Link to the app:
http://web.me.com/hschlangmann/LapTimer_Homepage/Home.html

Had a friend use it at the track this past weekend and get me his exported csv file so I could see if it was compatible with Dashware but there is no "profile" in Dashware for it. I'd like to get this app for DE's to run in my street car with a POV1.5 so I can make some Dashware projects but need to know if I can make it work.

Any help or direction would be greatly appreciated!


Thanks so much!

Cheers,
Dell

[RandallNoll]

DashWare has a very extensive help section. If you go into File / Edit Data Profiles and hit F1 you should be able to navigate through the help and be shown how to make a new profile from scratch.

If you'd like to attach the csv we can have a look at it.

[964RSA]

Thanks Randall. Attached is the file. I'm not very proficient at this type of stuff but I learn pretty quickly so I have no problem trying it on my own. If you could take a look at the file and let me know if this is something I can use to create a profile then I'd be grateful. Thanks so much for all your help!

[nickpoore]

Hey Randall.

I took a look at this data file, and could not create a custom data profile.

I opend up the Data Profile Editor.
I created a new Data Profile "HarrysGPS".
I opened the CSV data file - and can see it in the preview pane.

However, the next step is to "Mark the Header Line" - and that option is grayed out.

Am I doing something wrong, or is this a bug?

[RandallNoll]

Hey guys,

There is no way to directly import the file without modifying it first because it uses a 00:00.00 time format. First you need to convert it to seconds. To do this:

-Open the csv file in Excel
-Type a new column header at the end (column T, cell T1) named "RunTime" (must be exact).
-Enter this formula in cell T2 to convert to seconds: =N2*86400
-Note: you can't do the conversion in DashWare because it doesn't recognize the time format 00:00.00.
-Copy this formula down the column so it exists for every row of data
-Save the file as a .csv

You also need to add the attached data profile to DashWare. To do this, copy the attached file to C:\ProgramData\ChaseCam\DashWare\DataProfiles (Vista) or something similar in XP.

Then open DashWare, add the data file and select the new data profile and you should be good.

I've also attached the modified data file here.

Thanks.

[RandallNoll]

Hey Randall.

I took a look at this data file, and could not create a custom data profile.

I opend up the Data Profile Editor.
I created a new Data Profile "HarrysGPS".
I opened the CSV data file - and can see it in the preview pane.

However, the next step is to "Mark the Header Line" - and that option is grayed out.

Am I doing something wrong, or is this a bug?

Nick,

Click on the header line to select it first, then the option should light up. Let me know if that doesn't work.

Thanks.

[964RSA]

Thanks for the help! I'll work on it this weekend when I come up for air :)

[nickpoore]

Nick,

Click on the header line to select it first, then the option should light up. Let me know if that doesn't work.

Thanks.

That's exactly what I was doing.
v1.1.2 (clean install on Windows 7 x64).

I clicked the header row (and others for that matter), but the buttons remained greyed out.

[RandallNoll]

Nick,

I just released 1.1.3 on our website. See if updating will solve your issue.

Thanks.

[Rolf]

If you click below your Data Start line it won't let you mark a Header line. Move your Data Start line down first, then make sure to remove any old header lines and add the one you want.

[Dwayne Dibbley]

I have contacted harry regarding the export format and he has replied:

is there a format description for chasecam's available? I'm currently planning a specific export to TrackVision. However, I have no idea about the market share this solutions have. I can support if it is widely spread.

Is there a better format that would make importing into dashware easier, or would just updating the seconds to a recognised format be all the would be required?

Thanks

[Rolf]

Cool, it would be great if he wanted to add an Export to Dashware option.

I don't have a sample file from his app, but here are some general guidelines for making DashWare-friendly CSV files:

-All value entries need to be numerical e.g. "3.1", not formatted strings like timestamps etc
-There will need to be a running time (in seconds) column. It does not necessarily have to start at 0.
-If a given line is going to be missing 1 or more fields, leave those blank i.e. ",," instead of using an old value or putting in a 0. This way DashWare can linearly interpolate these values to fill in the blanks.
-It is good to have a line of text at the top of the file that says the logger name. This way DashWare can automatically choose the correct data profile for this logger by matching against the text.
-Have a consistent # of lines before the header line.
-Every row of data should have the same # of fields as the header line, in the correct order. Again, use blanks as placeholders if values are not present.

Example:

Harry's CSV File
Time,Latitude,Longitude,Elevation,LatG,AccelG
0.0,123.45,123.78,78.9,,
0.45,,,,0.7,0.23
1.1,122.3,123.89,80.1,,

If Harry could email me a sample file, that would be great. I can set up a data profile and test it out. Also, he can email me directly with any questions.

Thanks,
rolf@chasecam.com