MR60

Is there an easy way to retrieve the timestamp of each .bin log record in a csv or excel file ?

Posted by Hugues on September 1, 2015 at 12:37pm

Hi,

I posted this on drone-discuss but without any answer, so I try here again:


In an objective to georeference images, I'd like to export from a .bin log file the CAM & GPS messages with corresponding timestamps (the time that is displayed in the second column of the mission planner "review log" screen). I convert the .bin file to a .log file from the mission planner log utilities. However when importing the produced log file into excel, the timestamp column was removed in the .bin to .log conversion (as if the first two columns of the .bin are removed when creating the .log version of the flight log).

Questions that I have are :

-the timestamp that appears in the second column in mission planner review log corresponds to what time ? GPS time or internal Pixhawk time or else ?

-How can I easily (without programming a utility to decode the .bin log) export ALL columns of the .bin log to a csv type of file ?

-Where are specifications of the .bin data structure & content ?

-Is the disapperance of two columns from .bin to .log conversion a known bug or should a new issue ticket be created (if yes, where to create it, I am lost in all of these forums used for various categories of topics ?)?

Thx

Hugues
 

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

Join diydrones

Email me when people reply –
Follow

Replies

    • MR60
      Hugues > Martin September 4, 2015 at 9:31am

      Great tip thx ! that is indeed a possible solution to my problem of exporting the .bin to a text/csv file

    • Martin > Hugues September 4, 2015 at 10:46am

      I've also struggled with geotagging photos when the number of photos and the number of CAM messages don't match.

      If you don't need very high accuracy then you can use Picasa or some other program to shift the Modified timestamp of all the photos so that the first photo matches up with the first CAM message. That is the approach I have used.

  • Cala September 2, 2015 at 5:21pm

    Why don't you use MP georef images? http://copter.ardupilot.com/wiki/common-geotagging-images-with-miss...

    I don't try yet.

    • MR60
      Hugues > Cala September 2, 2015 at 9:58pm

      It only works in ideal cases where you have same number of pictures as number of CAM messages. And most of the time I find it crashing unexpectedly. 

    • Cala > Hugues September 3, 2015 at 5:02am

      Perhaps crash for a bug on the time stamp?

    • MR60
      Hugues > Cala September 3, 2015 at 5:13am

      I don't know. There must be someone out there who's able to say what is that second column shown by the yellow arrow on the picture above; and then how to export it ?

    • MR60
      Forrest Frantz > Hugues September 3, 2015 at 8:12am

      i get the time stamp in all log files imported into excel.  don't you?  it's in the file and tab name.

    • MR60
      Forrest Frantz > Forrest Frantz September 4, 2015 at 7:00am

      yes.  it is easy to access and manipulate in a VB macro. see code in previous answer. also the code in Hover Analysis shows how to bring in a log file and manipulate it.

    • MR60
      Hugues > Forrest Frantz September 3, 2015 at 11:26pm

      You probably mean the log file timestamp is the tab name. 

    • Krzysztof > Hugues September 4, 2015 at 3:00am

      The second column is UTC time, so there is ~17 seconds difference between GPS time (leap seconds).

This reply was deleted.