Welcome Inspire Pilots!
Join our free DJI Inspire community today!
Sign up

Online Flight-Record Converter Tool (CSV/KML/Images)

Joined
Jun 14, 2015
Messages
28
Reaction score
10
Age
34
Hello Inspire users,

in my freetime I created a small online tool to convert the DJI Inspire Flight Records written by the Pilot App to detailed CSV-Files, extract the 4 moments that were captured during the flight and to create a KML-File for import into Google Earth to show the flight route of your aircraft and the RC position on the ground.

To use it, you need either need to sync your Flight Records with the DJI cloud and login into the website http://thecutter.net/djiconverter/ with your DJI/SkyPixel account that is used in your DJI Pilot App. No Login information is saved!

Or you can upload single Flight Records and convert them without logging in to skypixel.

Sample KML-File loaded into Google Earth:


List of Flight Records:


And a sample ZIP-Package created by the tool can be found here:
http://thecutter.net/djiconverter/downloads/sample.zip

If you find any bugs or have problems using the tool, feel free to contact me!

The project is not related to DJI!
If you like it you are free to donate for my work on this project.
 
Joined
Mar 29, 2015
Messages
1,262
Reaction score
594
Location
Buckie, Scotland, UK
Website
www.moraysky.co.uk
Excellent utility. Unfortunately, the use of commas (,) for decimal points (.) and semi-colons ( ; ) as column separators instead of <tab> or comms makes it impossible to import the CSV files into Apple's spreadsheet app Numbers. CSV does stand for COMMA separated variables.
 
Joined
Jun 9, 2015
Messages
42
Reaction score
10
Age
49
Very useful - thanks very much! One thing I noticed (which of course is understandable) is that the elevation / ground level is shifted, but relatively it looks cool.
 
Joined
Jun 14, 2015
Messages
28
Reaction score
10
Age
34
Excellent utility. Unfortunately, the use of commas (,) for decimal points (.) and semi-colons ( ; ) as column separators instead of <tab> or comms makes it impossible to import the CSV files into Apple's spreadsheet app Numbers. CSV does stand for COMMA separated variables.
Too bad for Apple users ;)
In Microsoft Excel you can define the separator character.
 
Joined
Jun 9, 2015
Messages
42
Reaction score
10
Age
49
Unfortunately, the use of commas (,) for decimal points (.) and semi-colons ( ; ) as column separators instead of <tab> or comms makes it impossible to import the CSV files into Apple's spreadsheet app Numbers.
You could open the csv in a text editor and search & replace those characters with tabs.
 
Joined
Mar 29, 2015
Messages
1,262
Reaction score
594
Location
Buckie, Scotland, UK
Website
www.moraysky.co.uk
For Apple Mac users with Numbers the following simple edit in TextEdit will make the CSV readable:
  • Open downloaded .csv file in TextEdit.
  • Type Cmd+F
  • Type , (comma) in find
  • Tick Replace
  • Type . (decimal point/period) in replace
  • Click on All
  • Type ; (semi-colon) in find
  • Type , (comma) in replace
  • Click on All
  • Save file
  • Open .csv file in Numbers
There are lots of parameters recorded and plenty of information to see but it is worth it if you are examining, for example, battery status during flight.

I will be donating.
 
Joined
Jun 14, 2015
Messages
28
Reaction score
10
Age
34
Ok, I changed the decimal point character to "." instead of ",".
But the CSV separator still is ";".
 
Joined
Mar 29, 2015
Messages
1,262
Reaction score
594
Location
Buckie, Scotland, UK
Website
www.moraysky.co.uk
Ok, I changed the decimal point character to "." instead of ",".
But the CSV separator still is ";".
You need to do 2 swaps to make the CSV file compatible with Numbers as set out above. You need to replace the European decimal point (the comma) with the UK/USA one (fullstop/period) as you have done. Then you need to change the ';' 'separator' (semi-solon) with commas (',') or Tabs (#A).
 
Joined
Apr 11, 2015
Messages
37
Reaction score
12
Age
64
Thanks for the suggested Apple workaround.

Those who are PC-centric always have seem to have such interesting attitudes. It certainly cannot be because they prefer virus-ridden OSes and inferior computers. It seems odd? I found it humorous that for years (not sure about this since 2012) the Evil Empire (MS) used an entire floor of Macs to do their PC software development in WA, because PCs were not as stable, fast or easy to use.

From what I've seen the Mac : PC user ratio of Inspire 1 pilots is at least 2 : 1 at this point in time. Anyone have actual stats?
 
  • Like
Reactions: Scotflieger
Joined
Jun 14, 2015
Messages
28
Reaction score
10
Age
34
You need to do 2 swaps to make the CSV file compatible with Numbers as set out above. You need to replace the European decimal point (the comma) with the UK/USA one (fullstop/period) as you have done. Then you need to change the ';' 'separator' (semi-solon) with commas (',') or Tabs (#A).
I know what I need to do, but I will not change it because you are the only one having problems with it and I already invested so much hours into the project.

If you want to import it to Apple Numbers just change the characters for yourself or you can make a donation and I will add something that allows easy import of the CSV file on Windows and OSX.
 
Joined
Mar 29, 2015
Messages
1,262
Reaction score
594
Location
Buckie, Scotland, UK
Website
www.moraysky.co.uk
I know what I need to do, but I will not change it because you are the only one having problems with it and I already invested so much hours into the project.

If you want to import it to Apple Numbers just change the characters for yourself or you can make a donation and I will add something that allows easy import of the CSV file on Windows and OSX.
As a software engineer in my former life, I greatly appreciate the efforts and time you have put into decoding the data hidden in the DJI Inspire 1 DAT files. I made a donation this morning. The work around I posted above at #7 will allow Apple Numbers users to benefit from your excellent work.
 
Joined
Oct 5, 2014
Messages
171
Reaction score
55
Location
Connecticut, USA
Cutter: Sorry but I don't get it. How is this different fro the Flight Record display from the Pilot App? Am I missing something?
 
Joined
Mar 29, 2015
Messages
1,262
Reaction score
594
Location
Buckie, Scotland, UK
Website
www.moraysky.co.uk
Cutter: Sorry but I don't get it. How is this different fro the Flight Record display from the Pilot App? Am I missing something?
The data is identical to that you can replay on the Pilot App. What Cutter has done is decoded the DAT file format to enable a 3D representation of your flight to be viewed in Goggle Earth and for the raw data to be analysed and processed in Excel (PC) or Numbers (Mac) (once edited).
 
Joined
Jun 14, 2015
Messages
28
Reaction score
10
Age
34
Cutter: Sorry but I don't get it. How is this different fro the Flight Record display from the Pilot App? Am I missing something?
It gives you access to the raw data thats hidden in the Flight Records stored on your mobile device.
 
Joined
Jun 14, 2015
Messages
28
Reaction score
10
Age
34
The data is identical to that you can replay on the Pilot App. What Cutter has done is decoded the DAT file format to enable a 3D representation of your flight to be viewed in Goggle Earth and for the raw data to be analysed and processed in Excel (PC) or Numbers (Mac) (once edited).
I don't use the DAT files which came from the aircraft, would I use are the Flight Records (txt-files) stored on the mobile device.
 

New Threads

Members online

Forum statistics

Threads
19,808
Messages
193,381
Members
29,181
Latest member
Dialogue Creative