Welcome to PhantomPilots.com

Sign up for a weekly email of the latest drone news & information

[TOOL][WIN] Offline TXT FlightRecord to CSV Converter

Discussion in 'Pro/Adv Discussion' started by ferraript, Mar 6, 2016.

  1. lazaruz

    Joined:
    Oct 7, 2016
    Messages:
    10
    Likes Received:
    0
    I've tried to read up in the post but i couldn't really find it, sorry if it's been asked before...

    I've just got the Mavic Pro and I did a test flight this morning with DJI GO 4 v4.0.5 on Android.
    When converting the txt file to csv, most of the battery data is missing, but when uploading the txt to Healthy Drones, the data is there.

    Is this a problem with TXT FlightRecord to CSV Converter together with DJI GO 4 or am I making something wrong?

    I've attached the original log file and the csv if you would like to take a look.

    Thanks!
     

    Attached Files:

  2. ferraript

    Joined:
    Feb 3, 2016
    Messages:
    322
    Likes Received:
    139
    Location:
    Slovakia/Kosice
    csv example or screenshot of those data could be fine
    otherwise I don't know what exactly are you talking about
     
  3. Digdat0

    Joined:
    Feb 20, 2016
    Messages:
    1,196
    Likes Received:
    573
    Location:
    Oregon, USA
    im bored at work :)

    The flight log from the txt2csv tool fails to show any data in the columns CENTER_BATTERY.voltageCell1 [V], CENTER_BATTERY.voltageCell2 [V], CENTER_BATTERY.voltageCell3 [V]. The CSV export from HD shows shows values for these in the columns voltageCell1, voltageCell2, voltageCell3 (I assume these columns map between the two data sets to show battery cell voltage).

    tool:
    upload_2017-3-16_15-43-11.png
    hd:
    upload_2017-3-16_15-43-31.png
     

    Attached Files:

  4. BudWalker

    Joined:
    Jun 24, 2015
    Messages:
    883
    Likes Received:
    261
    Location:
    Santa Margarita, Ca
    In the case of the Mavic the .txt does not include the individual cell voltages. It does, however, include the SMART_BATTERY.voltage [V] which is shown in the .csv generated by TXTlogToCSVtool (column DZ). HealthyDrones divides SMART_BATTERY.voltage [V] by 3 and presents that as each of the individual cell voltages. I.e., the cell voltages will be identical.

    @lazaruz
     
    Digdat0 likes this.
  5. msinger

    Approved Vendor

    Joined:
    Oct 30, 2014
    Messages:
    23,614
    Likes Received:
    7,114
    Location:
    Harrisburg, PA
    Right on. This is what I'm doing in my log viewer too.
     
  6. Digdat0

    Joined:
    Feb 20, 2016
    Messages:
    1,196
    Likes Received:
    573
    Location:
    Oregon, USA
    makes total sense.
     
  7. lazaruz

    Joined:
    Oct 7, 2016
    Messages:
    10
    Likes Received:
    0
    Ah ok, but does the .txt not include for example the serial number, product date, loop number and temperature? In my CSV all of these other fields are also empty...

    CENTER_BATTERY.relativeCapacity
    CENTER_BATTERY.currentPV [V]
    CENTER_BATTERY.currentCapacity [mAh]
    CENTER_BATTERY.fullCapacity [mAh]
    CENTER_BATTERY.life
    CENTER_BATTERY.loopNum
    CENTER_BATTERY.errorType
    CENTER_BATTERY.current [A]
    CENTER_BATTERY.serialNo
    CENTER_BATTERY.productDate
    CENTER_BATTERY.temperature [C]
    CENTER_BATTERY.connStatus
    CENTER_BATTERY.totalStudyCycle
    CENTER_BATTERY.lastStudyCycle
    CENTER_BATTERY.isNeedStudy
    CENTER_BATTERY.isBatteryOnCharge
    RECOVER.batterySn
     
  8. ferraript

    Joined:
    Feb 3, 2016
    Messages:
    322
    Likes Received:
    139
    Location:
    Slovakia/Kosice
    it was mentioned more than once
    it does not
     
  9. 120CCPM

    Joined:
    Nov 21, 2016
    Messages:
    200
    Likes Received:
    83
    Location:
    San Diego, CA
    Hi, quick question: are the control signal strength and WiFi signal strength for a Phantom 3 Standard recorded anywhere in the flight records? I can find GPS satellites (OSD.gpsNum) and GPS signal strength (OSD.gpsLevel), but nothing about the 5.8 and 2.4GHz signals...
     
    #429 120CCPM, Mar 17, 2017
    Last edited: Mar 17, 2017
  10. 120CCPM

    Joined:
    Nov 21, 2016
    Messages:
    200
    Likes Received:
    83
    Location:
    San Diego, CA
    Didn't realize they came out with a new version... thank you for pointing that out, that's great news. Here the release notes, in case others are interested to know what changed:

    • Fixed DashWare to work properly on Windows 10 with the Anniversary Update. We no longer support XP. Earliest supported OS is Win7.
    • Added GoPro HERO5 Black GPS support. Data is now automatically extracted from the .MP4 file and auto-synced with the video.
    • Updated to .NET 4.6.2, which seemed to fix a lot of Microsoft MediaElement bugs (the player we use in the UI).
    • We are using a new installer system, since our old one was deprecated by Microsoft.
    • If you Drag & Drop video/data into DashWare, without a project open, a new project is now automatically created using the default template.
    • If you merge chaptered GoPro HERO5 Black videos, we’ll also merge the data into one big CSV. If you do this with a project open, we’ll automatically add the resulting .MP4 and .CSV to the project.
    • Added the ability to export a .PNG image sequence of gauges with a transparent background. Handy if you wish to apply the overlays in software like Adobe Premiere.
    • Added the ability to rotate gauges.
    • Analog gauge faces (and the various other analog components) can now optionally set their value ranges automatically from your data (in a project). So, for example, a speedometer can now automatically scale based on your max speed.
    • Better sharing of value range / angle range settings between the various analog gauge components (parent component –> child).

    EDIT: I tested the new DashWare version on Windows 7 Professional 64bit, and when I went to create a video, the usual FFmpeg encoder option was missing. The only available option was Windows Media Foundation, which repeatedly crashed. Hence, I went back to the old DashWare 1.7.37.
     
    #430 120CCPM, Mar 17, 2017
    Last edited: Mar 18, 2017
  11. ferraript

    Joined:
    Feb 3, 2016
    Messages:
    322
    Likes Received:
    139
    Location:
    Slovakia/Kosice
    nope
     
  12. Thirk

    Joined:
    Mar 16, 2017
    Messages:
    2
    Likes Received:
    0
    Is the source code for this available? I'm looking to create a web app that leverages a DJI FlightRecord parser myself, but it seems everyone is hell-bent on keeping their parser a secret.
     
  13. msinger

    Approved Vendor

    Joined:
    Oct 30, 2014
    Messages:
    23,614
    Likes Received:
    7,114
    Location:
    Harrisburg, PA
    True. Nobody wins once everyone knows how to decrypt the flight logs. DJI will just re-encrypt them and we'll be back to square one.
     
    phlo, BudWalker and Digdat0 like this.
  14. isicom

    Joined:
    Feb 24, 2017
    Messages:
    6
    Likes Received:
    3
    Hey great Work.

    May I see the source code, please.

    Thanks a lot.

    isicom
     
  15. neven

    Joined:
    Jan 5, 2016
    Messages:
    510
    Likes Received:
    156
    Location:
    Zagreb, Croatia, Europe
    10 PRINT "This is the source code"
    20 GOTO 10
     
    isicom and Digdat0 like this.
  16. Digdat0

    Joined:
    Feb 20, 2016
    Messages:
    1,196
    Likes Received:
    573
    Location:
    Oregon, USA
    i dont see them sharing source code, and for good reason. dji will change their encryption scheme again and we won't be able to convert logs again. We don't want that. If you can figure it out using your knowledge, skills and resources, you deserved to know. If not, you need to use the tool like the rest of us :)
     
    isicom likes this.
  17. isicom

    Joined:
    Feb 24, 2017
    Messages:
    6
    Likes Received:
    3
    I undert
    :D : D :D
     
    Digdat0 likes this.
  18. isicom

    Joined:
    Feb 24, 2017
    Messages:
    6
    Likes Received:
    3
    You have right. I didn't see it in this view.
    Thanks for clearing :)
     
    Digdat0 likes this.
  19. manju91080

    Joined:
    Mar 12, 2017
    Messages:
    6
    Likes Received:
    3

    Thanks for the tool. Btw any intention of sharing the code ? or atleast can you please how are you decoding. I am planning to develop the tool in python. If you help me with this, then I will be happy to share the python code with you.
     
  20. alokbhargava

    Joined:
    Sep 28, 2015
    Messages:
    6,249
    Likes Received:
    2,072
    Location:
    San Francisco, CA
    Why does everyone want to develop the same tool again and again? Can't we collectively work and make one tool strong and meaningful for all?
     
    isicom likes this.
Loading...