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

Joined
Feb 3, 2016
Messages
384
Likes
184
Location
Slovakia/Kosice
#1
Hi folks, I'm glad to present you the result of my work.
A lot of us have been unhappy, because until now, there was no offline TXT FlightRecord to CSV Converter.
And after websites such as HealthyDrones and djilogs.com started to charge for their services, I decided I really need some offline converter. So I created it by myself.

It's quite simple, all you need to do is select input TXT file and output CSV file and press the GO button. There is also option to export JPG images, if they are present in the log.

I don't plan to add graphs, statistics or something like that.
My thanks goes to (for me) unknown person, who published some sources at this site, so I was able to put missing pieces together.

If you find any error, let me know.
Enjoy ;)

Notice 1: It is confirmed that the TXT logs of Inspire, and also TXT logs from iOS app, have a little bit different structure (not known to me), so, please, don't be surprised when you see some strange values

Notice 2: Some of you requested the structure of the TXT log, so, here you have it too
- edit: since DJI GO 2.8.4, TXT logs are encrypted, so the structure file is useless

Notice 3: Tool can be also run from command line like this, example:
TXTlogToCSVtool "C:\temp\inputFile.txt" "C:\temp\outputFile.csv" J I G
It will try to read inputFile.txt and write the output into outputFile.csv.
Optional parameters:
J ... it will also export JPGs, if they are present in the log
I ... imperial units will be used
G ... it will also export GPX file

Notice 4: The tool is freeware and it is intended for your own personal use only.

Notice 5: Please, don't ask for decrypting algorithm. It's not shareable. Explanation here.

actual version is from 2018/06/11
 

Attachments

Last edited:
Joined
Nov 25, 2015
Messages
294
Likes
85
Location
Grimsby, Ontario, Canada
#2
Thanks for doing this, was hoping I didn't have to do it myself.
However I'm getting errors each time I use it on different files and not getting any usable data.
Error in 0f/firmware at byte 12
Error in 01/OSD at byte 123
 
Joined
Feb 3, 2016
Messages
384
Likes
184
Location
Slovakia/Kosice
#3
hm, maybe logs from another types of Phantoms have another structure
I have P3 Advanced
What type do you have?
Could you upload at least one of those TXT logs somewhere? (if they are private for you, send me PM)
 
Joined
Feb 3, 2016
Messages
384
Likes
184
Location
Slovakia/Kosice
#7
@Luap provided me with some logs, so hopefully this new version will work fine

changes:
added possibility to choose CSV delimiter
variable RC-record size enabled
qtintf.dll no longer needed
 
Joined
Feb 1, 2014
Messages
4,305
Likes
935
Location
Indy, USA
Website
multicopterpilots.com
#9
There is some differences between android and ios OS's. But I don't think they matter in this case due to the limited amount of fields.

What you've put together here is very nice. I appreciate your efforts big time! This allows the txt file to be converted anywhere anytime even when there's no Wifi connection.

Currently there is a few minor issues but more importantly, nothing major. Do you have any plans to add any more fields? What are the chances of doing a setup similar to the "comprehensive.csv" on dji.com that has roughly 150 fields?
 
Last edited:
Joined
Feb 3, 2016
Messages
384
Likes
184
Location
Slovakia/Kosice
#11
Do you have any plans to add any more fields? What are the chances of doing a setup similar to the "comprehensive.csv" on dji.com that has roughly 150 fields?
last time I used their converter, I got 170 columns
my tool gives 174 columns
I think that's more than enough :)

at the moment I am looking into decompiled sources of DJI GO, but it's all mixed up
I don't know if I can get more data
 
Joined
Feb 1, 2014
Messages
4,305
Likes
935
Location
Indy, USA
Website
multicopterpilots.com
#12
last time I used their converter, I got 170 columns
my tool gives 174 columns
I think that's more than enough :)

at the moment I am looking into decompiled sources of DJI GO, but it's all mixed up
I don't know if I can get more data
I Happily stand corrected! I must have converted the file and then opened the wrong one to reference. I just quickly and notice there was much more columns then I saw yesterday. I will look them over and see what we have to work with. Will you need a dashware profile created? If so I can send you a convo.
 
Joined
Feb 1, 2014
Messages
4,305
Likes
935
Location
Indy, USA
Website
multicopterpilots.com
#14
@ferraript
I get more data than I can handle.
Busy hiding fields I'm not interested in or that have no data.
Surely you're not complaining about something that is free.

I know for a fact this @ferraript put in some serious hours and effort to put this together. I know I sure as heck appreciate what has been put together.
 
Likes: W2JFI
Joined
Jun 24, 2015
Messages
1,294
Likes
471
Age
70
Location
Santa Margarita, Ca
#18
these values should be fine
I just changed the scale, so it is the same like @BudWalker is using in his DAT converter, from -10000 to 10000
The .txt file produced by the Go App uses a [0, 2048] range. I suspect this is the output of the control stick digitizer. Somewhere between that output and the .DAT field that range gets changed to [-10000, 10000]. I.e. DatCon doesn't change the scale, it just reports what it sees in that field.
@msinger
 

New Threads

Forum statistics

Threads
129,628
Messages
1,346,422
Members
94,452
Latest member
ptay63