Extracting data from tlog files for plotting in Excel

I wanted to analyze some data from a tlog file and figured that Excel would be the most flexible  way so I created a little utility to extract the data I was interested in and save it as a comma separated value (CSV) file. Each selected parameter is in a separate column, and Excel can open  the csv directly.

Note that it can't open the tlog file directly. You must use the Mission Planner to convert it to txt format. so:
1. From the APM Mission Planner Flight Data page select "Telemetry Logs", then "Tlog > Kml or Graph", then "Convert to Text". 

2. Select the tlog file you are interested in, and the Mission Planner will create a txt file in its log folder. 

3. Open the txt file in this program and it will parse the file and list the available parameters in the left tree control. Double click on the parameters you are interested in and they will be selected and displayed in the right tree control. If you want to remove a parameter from the selected list, double click it.

4."Save As" and provide an output file name. This will produce the csv file that you can open in Excel and plot as desired. The file will look like this, where each row was produced from one packet in the input file that contained at least one of the selected parameters.

If you want to re-use the list of parameters you can save and re-load them from the "configure" menu. These are simple text files you can edit directly if you like.

I am not familiar with the deloyment process for C# programs, so I have placed the entire project folder here

Views: 17973

Comment by Robert Sinclair on May 11, 2012 at 8:52pm

Looks good, nice and clean. If you're up for it you'd probably find a lot more people willing to use a web parser than running an exe.

Comment by Oliver Ensslin on May 12, 2012 at 12:35am

That's exactly what i needed. Lets hope they integrate that into the mission planner Thanks Andrew.

Comment by Rana on May 12, 2012 at 12:56am

Excellent, worth sharing !

Comment by Rigel on May 12, 2012 at 1:10am

Thanks, this will definitely come in handy!

Comment by Sam Kelly on May 12, 2012 at 12:32pm

I'm liking this new trend of modular tools for APM and its accessories (this one, the 3DR radio config, MinimOSD config).

Comment by John Moore on May 12, 2012 at 7:12pm

Nice, this is just what I needed.

Comment by Colin Bouriquet on May 13, 2012 at 3:10am

Very nice... i've been looking for this kind of tool... Thanks !

Comment by Daniel Portillo on May 13, 2012 at 10:38am

Seem nice, but I don't know execute the program. Thanks for this tool.

Comment by Jae Wook,Kim on May 14, 2012 at 10:36pm

I think this tool is vey useful. But i don't know execute the file. Thanks.

 

Comment by Andrew Fernie on May 15, 2012 at 3:17pm

You should be able to run TLogDataExtractor.exe located in the zip file at \TLogDataExtractor\TLogDataExtractor\bin\Release

Comment

You need to be a member of DIY Drones to add comments!

Join DIY Drones

Groups

Season Two of the Trust Time Trial (T3) Contest 
A list of all T3 contests is here. The current round, the Vertical Horizontal one, is here

© 2019   Created by Chris Anderson.   Powered by

Badges  |  Report an Issue  |  Terms of Service