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.
Comments
for the first two columns the program is only printing the time and date field text strings as they come from the input file, and they only have seconds.
I will have a look at the the other fields that you mention and see if there is any way to get more useful data out of them.
Andrew
Thanks for this program, as the txt and csv files from MisionPlanner are too complex.
Is there any way we could have the Time field with milliseconds? i.e. having
1:55:09.345 instead of just 1:55:09. Note that currently, with the time in seconds,
we have several different positions and angles for the same time.
If this is not possible, could anybody explain the differences between the
different time fields and how they relate to first Time field? For example, the difference between
mavlink_gps_raw_int_t.time_usec,
mavlink_global_position_int_t.time_boot_ms
I just understand that the first one is in microseconds and the second one in
milliseconds, but the values in the same row often are not coincident:
12/17/2012, 1:55:39 , 31006000, 31407
12/17/2012, 1:55:39 , 31407000, 31407
12/17/2012, 1:55:39 , 31407000, 31808
12/17/2012, 1:55:39 , 32007000, 31808
12/17/2012, 1:55:39 , 32007000, 32007
Also, as minor issues, the help menu does not work (even not the About tab) and the File/Exit tab
does not work either.
Agus
thank you very much!!!
Download the zip file from the link above - you want "TLogDataExtractor_V1.1.zip" - and extract everything from the zip file to any convenient folder.
The application is TLogDataExtractor.exe" in the folder TLogDataExtractor_V1.1.zip\TLogDataExtractor\TLogDataExtractor\bin\Release.
Andrew
i am using MissionPlanner 1.2.13 mav1.0!
please anyone comment is welcome!
thanks in advance!
No problem Michael. Didn't take long to adapt.
I noticed that you have a CSV output format that would be another way for me to split the fields. Do you expect to continue to support both txt and csv, or am I better to stick with one in particular?
Andrew
Sorry about that Andrew, that wasn't on Purpose
TLogDataExtractor_V1.1.zip has been uploaded to the same location. It works with V87 of the mission planner. If in doubt, check the txt file exported from the mission planner. If you see '=" between parameter names and values you have the old version, if there is just a space, you have the new file format.
One issue to watch is the statustext message that has a format like "mavlink_statustext_t severity 1 text GROUND START Len 59". "text" is the parameter name, and the value should be "GROUND START" but the program interprets "GROUND" as the value, and "START" as the next parameter. No guarantee that the value is one, two, or three words long so tough to decide on what to do.
Andrew
Looks like the data format of the txt file was changed in recent versions of the Mission Planner. I was keying on the "=" to pick up the parameters and it is gone. I will rework the code.
Andrew
Andrew (and Daniel)...I encountered the same problem. Packets were visible in the left hand box, but no option to expand them or add to the right hand box. I got the program to work by generating the text file in an older version of APM Planner (1.0.68 is the one I happened to have on my computer). The TLOG was from a recent flight (using 1.1.86)...the only action performed in the old version was generating the text.
The only problem now is that the CSV generated by the utility is slightly off. All of the requested column headers are present, but some of the columns have incorrect data types populated (most noticeably date and time).
Which version of APM Planner did you use while creating this program?
-
2
-
3
-
4
-
5
-
6
of 6 Next