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. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    he is updating the file in the original post
     
  2. AchillesPDX

    Joined:
    Mar 2, 2016
    Messages:
    45
    Likes Received:
    6
    He's been updating the file in the original post. Just download it again and run it - go to "about" to make sure you're running the one from today.
     
  3. Zzyzx

    Joined:
    Feb 18, 2016
    Messages:
    52
    Likes Received:
    15
    Location:
    Beaverton, OR, USA
    Doh! Thanks!
     
  4. AchillesPDX

    Joined:
    Mar 2, 2016
    Messages:
    45
    Likes Received:
    6
    @ferraript Any way to change OSD.yaw from -180>180 to 0>360? I can't find a way to get Dashware to show a compass properly with the negative coordinates and I can't think of a way to convert the numbers using the limited capabilities of Dashware's functions.

    EDIT: Nevermind! Discovered the "Loop Range" checkbox in the Needle Properties. Working splendid now.
     
  5. flyNfrank

    Joined:
    Feb 1, 2014
    Messages:
    4,301
    Likes Received:
    942
    Location:
    Indy, USA
    Sure is nice when things work the way you like for them to work, right?
     
  6. AchillesPDX

    Joined:
    Mar 2, 2016
    Messages:
    45
    Likes Received:
    6
    Yeah. I was banging my head against the desk for several hours today trying to figure out how to use Dashware to add 360 to only the negative numbers of those values and determined that it probably couldn't be done. It was only after all that that I discovered the "Loop Range" checkbox and proceeded to bang my head against the desk again. Oh well. I've only been playing with Dashware for a day or so, so I guess it's to be expected :)
     
  7. flyNfrank

    Joined:
    Feb 1, 2014
    Messages:
    4,301
    Likes Received:
    942
    Location:
    Indy, USA
    Btw, that reminds me, @ferraript thanks for the update on the displayed Speed. However, it appears that "CUSTOM.hSpeed" in Column "D" is corrupt. Some of the fields are showing the same pack of numbers repetitively. Such as, 0.141, 0.224, 0.316, 0.412, and many more.

    Also I have one more request if you don't mind. This would be....leaving the CUSTOM.hSpeed column to display in thousandths, but when a field is highlighted set it to show the full number in the upper description area. Example shown in image below. As a reminder, the long number display only appears when highlighted.


    1csvlog.png
     
  8. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    The numbers will show the same if your speed is kept the same for so many miliseconds
     
  9. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    Android or IOS users can obtain their TXT files from here, then use any converter you like.
    DJI Flight Record Converter

    Just log on with your dji credentials
     
  10. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    Currently the aileron, elevator, throttle, rudder all go from 10,000 to -10,000 . In dashware just do a math calculation dividing this field by 10 and your values will now be 100 to -100
     
  11. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    I rather see @ferraript work to get the field we all request, instead of doing the calculations for us. I would love an imperial file, but dashware will do all the calculations you need.
     
  12. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    Here are all the current fields alphabetically. I found some fields I was looking for by going thru the list this way.

    APP_TIP.tip
    APP_WARN.warn
    CENTER_BATTERY.connStatus
    CENTER_BATTERY.current
    CENTER_BATTERY.currentCapacity
    CENTER_BATTERY.currentPV
    CENTER_BATTERY.errorType
    CENTER_BATTERY.fullCapacity
    CENTER_BATTERY.life
    CENTER_BATTERY.loopNum
    CENTER_BATTERY.productDate
    CENTER_BATTERY.relativeCapacity
    CENTER_BATTERY.serialNo
    CENTER_BATTERY.temperature
    CENTER_BATTERY.voltageCell1
    CENTER_BATTERY.voltageCell2
    CENTER_BATTERY.voltageCell3
    CENTER_BATTERY.voltageCell4
    CUSTOM.distance
    CUSTOM.distance.running_max
    CUSTOM.hSpeed
    CUSTOM.hSpeed.running_max
    CUSTOM.isPhoto
    CUSTOM.isVideo
    CUSTOM.updateTime
    DEFORM.deformMode
    DEFORM.deformStatus
    DEFORM.isDeformProtected
    DETAILS.area
    DETAILS.city
    DETAILS.isFavorite
    DETAILS.isNew
    DETAILS.latitude
    DETAILS.longitude
    DETAILS.maxHeight
    DETAILS.maxHorizontalSpeed
    DETAILS.maxVerticalSpeed
    DETAILS.needUpload
    DETAILS.photoNum
    DETAILS.recordLineCount
    DETAILS.street
    DETAILS.substreet
    DETAILS.totalDistance
    DETAILS.totalTime
    DETAILS.updateTime
    DETAILS.videoTime
    GIMBAL.autoCalibrationResult
    GIMBAL.isAutoCalibration
    GIMBAL.mode
    GIMBAL.pitch
    GIMBAL.roll
    GIMBAL.rollAdjust
    GIMBAL.version
    GIMBAL.yaw
    GIMBAL.yawAngle
    HOME.aircraftHeadDirection
    HOME.compassCeleStatus
    HOME.dataRecorderCurrentIndex
    HOME.dataRecorderLeftTime
    HOME.dataRecorderPercent
    HOME.dataRecorderStatus
    HOME.goHomeHeight
    HOME.goHomeMode
    HOME.goHomeStatus
    HOME.hasGoHome
    HOME.height
    HOME.iocMode
    HOME.isBeginnerMode
    HOME.isCompassCeleing
    HOME.isDynamicHomePointEnabled
    HOME.isHomeRecord
    HOME.isIOCEnabled
    HOME.isMultipleModeOpen
    HOME.isReatchLimitDistance
    HOME.isReatchLimitHeight
    HOME.latitude
    HOME.longitude
    HOME.navigationOpen
    HOME.simulatorOpen
    OSD.battery
    OSD.batteryType
    OSD.canIOCWork
    OSD.compassError
    OSD.droneType
    OSD.flightAction
    OSD.flycCommand
    OSD.flycState
    OSD.flycVersion
    OSD.flyTime
    OSD.goHomeStatus
    OSD.gpsLevel
    OSD.gpsNum
    OSD.groundOrSky
    OSD.height
    OSD.imuInitFailReason
    OSD.isAcceletorOverRange
    OSD.isBarometerDeadInAir
    OSD.isImuPreheated
    OSD.isMotorUp
    OSD.isNotEnoughForce
    OSD.isSwaveWork
    OSD.isVibrating
    OSD.isVisionUsed
    OSD.latitude
    OSD.longitude
    OSD.modeChannel
    OSD.motorRevolution
    OSD.motorStartFailedCause
    OSD.nonGPSCause
    OSD.pitch
    OSD.roll
    OSD.sWaveHeight
    OSD.voltageWarning
    OSD.waveError
    OSD.xSpeed
    OSD.yaw
    OSD.ySpeed
    OSD.zSpeed
    RC.aileron
    RC.custom1
    RC.custom2
    RC.elevator
    RC.gimbal
    RC.goHome
    RC.mode
    RC.playback
    RC.record
    RC.rudder
    RC.shutter
    RC.throttle
    RC_GPS.gpsNum
    RC_GPS.gpsStatus
    RC_GPS.latitude
    RC_GPS.longitude
    RC_GPS.startupTime
    RC_GPS.xSpeed
    RC_GPS.ySpeed
    RECOVER.activeTimestamp
    RECOVER.aircraftName
    RECOVER.aircraftSnBytes
    RECOVER.appType
    RECOVER.appVersion
    RECOVER.batterySn
    RECOVER.cameraSn
    RECOVER.droneType
    RECOVER.rcSn
    SMART_BATTERY.battery
    SMART_BATTERY.goHomeBattery
    SMART_BATTERY.goHomeCountdown
    SMART_BATTERY.goHomeStatus
    SMART_BATTERY.goHomeTime
    SMART_BATTERY.landBattery
    SMART_BATTERY.landTime
    SMART_BATTERY.lowWarning
    SMART_BATTERY.lowWarningGoHome
    SMART_BATTERY.safeFlyRadius
    SMART_BATTERY.seriousLowWarning
    SMART_BATTERY.seriousLowWarningLanding
    SMART_BATTERY.status
    SMART_BATTERY.usefulTime
    SMART_BATTERY.voltage
    SMART_BATTERY.voltagePercent
    SMART_BATTERY.volumeConsume
     
  13. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    Rows E & G are the same values

    [​IMG]
     
    #53 Fdnyfish, Mar 13, 2016
    Last edited: Mar 13, 2016
  14. flyNfrank

    Joined:
    Feb 1, 2014
    Messages:
    4,301
    Likes Received:
    942
    Location:
    Indy, USA
    I have used this myself 3-4 times. But I have not cared so much for sharing my dji.com and skypixel.com login info. Especially with one having a credit card info attached to it. I also tried to contact him about his converter, but he never would respond. Plus he also began charging to use his converter that never did work properly. Nothing wrong with charging fee's, but there is much better ways to do it if you still want user's visiting your website. Even though I went 4-5 weeks with using a txt to csv converter due to paying fee's, it is what opened the door to this setup here as well as msinger's converter. This offline converter, @BudWalker offline DAT converter, and @msinger converter Plus Viewer with Report dominates the Dollar General store online setups bigtime!
     
  15. BudWalker

    Joined:
    Jun 24, 2015
    Messages:
    901
    Likes Received:
    270
    Location:
    Santa Margarita, Ca
    But, the result will have an error of +180. A value of 0 (north) will be translated to 180 (south). The correct formula is

    (X + 360) modulo 360 ; where X is in the [-180, 180] range.
     
    AchillesPDX likes this.
  16. flyNfrank

    Joined:
    Feb 1, 2014
    Messages:
    4,301
    Likes Received:
    942
    Location:
    Indy, USA
    You are missing 180 degree's with how you explained this.

    If the data shows -180 which is actually 180 (or South), and you add 180, you end up with 0 which is North.

    It needs to have 360 added to the displayed negative number, only. I suppose if it applied to the a positive number it would read correctly as well.
     
    #56 flyNfrank, Mar 13, 2016
    Last edited: Mar 13, 2016
  17. flyNfrank

    Joined:
    Feb 1, 2014
    Messages:
    4,301
    Likes Received:
    942
    Location:
    Indy, USA
    Hahahaa... Your post wasn't not on my screen when I went to post. My java must be slow updating today.
     
  18. AchillesPDX

    Joined:
    Mar 2, 2016
    Messages:
    45
    Likes Received:
    6
    Isn't OSD.zSPEED the same thing?

    That's what I'm using after multiplying it by -1 to get positive up and negative down.
     
  19. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    I never used his converter, but it is a great way to get your txt files online
     
  20. Fdnyfish

    Joined:
    Jun 6, 2013
    Messages:
    669
    Likes Received:
    37
    Location:
    Barnesville, PA
    I tried that, but it wasn't jiving with my altitude. what format is the osd.zspeed in? m/s?
     
Loading...
Similar Threads - [TOOL][WIN] Offline TXT Forum Date
Offline automated mapping - is there an option that actually works?! General Discussion May 6, 2017
on/offline venue to buy Phantom based in NJ? Phantom 4 Discussion Apr 17, 2017
offline 2d mapping question Phantom 4 Pro Discussion Apr 13, 2017
Offline 3D Mapping Surveying and Mapping Jan 30, 2017
Downloading maps offline Phantom 4 Pro Discussion Dec 3, 2016