Welcome to InspirePilots.com

Join the leading DJI Inspire community for free!

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

Discussion in 'Inspire 1 Discussion' started by TheCutter, Jun 14, 2015.

  1. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    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:
    [​IMG]

    List of Flight Records:
    [​IMG]

    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.
     
  2. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, 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.
     
  3. nickruss_wales

    Joined:
    Jun 9, 2015
    Messages:
    41
    Likes Received:
    10
    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.
     
  4. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    Too bad for Apple users ;)
    In Microsoft Excel you can define the separator character.
     
  5. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, UK
    A fix please. Mac users are very prominent in the Inspire community.
     
  6. nickruss_wales

    Joined:
    Jun 9, 2015
    Messages:
    41
    Likes Received:
    10
    You could open the csv in a text editor and search & replace those characters with tabs.
     
  7. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, 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.
     
  8. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    I will have a look into this today.
     
    Scotflieger likes this.
  9. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    Ok, I changed the decimal point character to "." instead of ",".
    But the CSV separator still is ";".
     
  10. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, UK
    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).
     
  11. Dorian

    Joined:
    Apr 11, 2015
    Messages:
    34
    Likes Received:
    12
    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?
     
    Scotflieger likes this.
  12. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    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.
     
  13. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, UK
    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.
     
  14. Mopar Bob

    Joined:
    Oct 5, 2014
    Messages:
    161
    Likes Received:
    52
    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?
     
  15. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, UK
    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).
     
  16. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    It gives you access to the raw data thats hidden in the Flight Records stored on your mobile device.
     
  17. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    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.
     
  18. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, UK
    I stand corrected. Great job anyway.
     
  19. TheCutter

    Joined:
    Jun 14, 2015
    Messages:
    28
    Likes Received:
    10
    Just changed the CSV format to use "," as separator.
     
  20. Scotflieger

    Joined:
    Mar 29, 2015
    Messages:
    1,244
    Likes Received:
    577
    Location:
    Buckie, Scotland, UK
    Brilliant thank you. Tested on Mac and works out-of-the-box. Veilen dank.
     
    #20 Scotflieger, Jun 15, 2015
    Last edited: Jun 15, 2015