Blogs

Extracting data from tlog files for plotting in Excel

Posted by Andrew Fernie on May 11, 2012 at 6:00pm

3689456308?profile=original

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.

3689456415?profile=original

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. 

E-mail me when people leave their comments –
Follow

You need to be a member of diydrones to add comments!

Join diydrones

Comments

  • Andrew Fernie May 16, 2012 at 4:05pm

    So you see a bunch of packets (e.g. mavlink_heartbeat_t, mavlink_attitude_t...) in the left hand tree control box, but can't expand them to see the fields? Could you please send me the file and I will have a look -  andrewfernie_at_hotmail_dot_com

    Has anyone else managed to have it work, or had problems?


    Andrew

  • Daniel Portillo May 16, 2012 at 9:25am
    I can see the tree in the left column but I can't display the fields or add them to the left column
  • Andrew Fernie May 16, 2012 at 9:09am

    Do you see the tree structure in the left box when you open the text file?

  • Daniel Portillo May 16, 2012 at 1:07am

    I can execute the exe file but the program didn't work fine on my pc, I can't do nothing when I open the txt file, when I double click in the left column  don't happen nothing. My OS is W7 64bit.

    Thanks

  • Andrew Fernie May 15, 2012 at 3:17pm

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

  • Jae Wook,Kim May 14, 2012 at 10:36pm

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

     

  • Daniel Portillo May 13, 2012 at 10:38am

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

  • Colin Bouriquet May 13, 2012 at 3:10am

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

  • John Moore May 12, 2012 at 7:12pm

    Nice, this is just what I needed.

  • Sam Kelly 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).

This reply was deleted.