SD Card Reading

StevenRougeou · Post by **StevenRougeou** » Fri Oct 02, 2015 9:17 pm

Alright:
I am about to use Racecapture Pro for the first time. Instead of using live telemetry I want to just use the SD card and upload the files onto excel. So, I have looked at the files on my SD card, I know the word file can be translated to the excel file but I do not know the exact process of what it wants to read. I just select the "commas" during set up but the numbers are still all over the place.
Are the numbers in a code I then need to translate?
What is the process to look at my data and see usable numbers? I'm unfamiliar with this specific program.
Thanks

gizmodo · Post by **gizmodo** » Mon Oct 05, 2015 12:52 pm

Is there a reason you want to look at the raw data instead of opening the file in the RaceCapture application? That application will allow you to view the data in a more analysis type view. You can also upload the file: http://www.autosportlabs.com/new-raceca ... e-uploads/

StevenRougeou · Post by **StevenRougeou** » Mon Oct 05, 2015 8:43 pm

well, I gave it a try. I uploaded the LOG file from the SD card onto the "Add Device to Event" and all my configurations show up, but there is no data.. not sure what missed in translation.
If I recorded the data with a different "Telemetry Device ID" will it not work?

StevenRougeou · Post by **StevenRougeou** » Mon Oct 12, 2015 5:50 pm

Does anyone else have any advice?

JMcDonough · Post by **JMcDonough** » Tue Oct 13, 2015 8:51 pm

I'm not sure what you mean by "numbers are all over the place"

The import into excel should be straightforward. Open .log file w/ Excel, (might have to select "All Files" from the file type filter drop down to get it to show .log files), Select "My data has hdeaders." in the first window, click "Next", select "Comma" (I usually leave "Tab" also selected), then "Finish".

Since different variables are logged at different rates, you'll see the data sorta scattered on the page. You can plot against "Interval" or "Utc" to see the data as a function of time (in ms).

Personally I use the perl script here:

http://www.autosportlabs.net/RaceCaptur ... a_Analysis

More info here:

http://www.autosportlabs.org/viewtopic.php?t=3731

I run the perl script, then save it as an .sft file w/ Dlog99, then open it with GEMS/AEMdata. That process is covered in the thread.

I haven't tried the upload to race capture live option yet.