Is there a way to import FlightAware track logs to ForeFlight ?

Discussion in 'Flight Following' started by XSi, Jun 20, 2020.

  1. XSi

    XSi Filing Flight Plan

    Joined:
    May 29, 2020
    Messages:
    13

    Display name:
    XSi
    I am starting to use ForeFlight's Logbook and one of the options is to attach a track log in the Logbook entry. This is great going forward but how can I bring in old track logs in. FlightAware has the track log of my flight. It can also export this to KML file. Is there a way to import to ForeFlight?
     
  2. AggieMike88

    AggieMike88 Touchdown! Greaser!

    Joined:
    Jan 13, 2010
    Messages:
    20,808
    Location:
    Denton, TX

    Display name:
    The original "I don't know it all" of aviation.
  3. PaulS

    PaulS Touchdown! Greaser!

    Joined:
    May 29, 2007
    Messages:
    13,566
    Location:
    New England

    Display name:
    PaulS
    Won't help you with this, but if you have FF on an ipad that you bring on the flight with you, you can set FF to automatically record flights. It will save then under track logs and you can make log book entries from them. You can also manually record flights with FF, but I like the auto feature better. One less thing to remember.
     
    MBDiagMan likes this.
  4. XSi

    XSi Filing Flight Plan

    Joined:
    May 29, 2020
    Messages:
    13

    Display name:
    XSi
    This, unfortunatelly, will only import shapes etc to show as a map layer. It will not import track log data. Looking at it a little bit more, it looks like ForeFlight can only import track logs from a G1000 exported csv files. So I guess the next step is the searching of a tool that can convert .kml files to G1000 csv files. (or figure out the G1000 csv file format and build a tool on my own :D )
     
  5. MPearon

    MPearon Filing Flight Plan

    Joined:
    Apr 10, 2021
    Messages:
    3

    Display name:
    MPearon
    Did you have any luck with this? I am in a very similar boat.
    FlightAware has a perfect record of my flight, but I can't find a great way to get it into ForeFlight.
    I tried running it through GPSBabel, but didn't have any luck.
    The forum won't let me upload, so I'll drop a sample of the CSV ForeFlight is rejecting here:

    Code:
    #airframe_info, log_version="1.00", airframe_name="Cessna 182T", unit_software_part_number="", unit_software_version="12.03", system_software_part_number="", system_id="", mode=NORMAL,
    #yyyy-mm-dd," hh:mm:ss"," hh:mm"," ident"," degrees"," degrees"," ft Baro"," inch"," ft msl"," deg C"," kt"," kt"," fpm"," deg"," deg"," G"," G"," deg"," deg"," volts"," volts"," amps"," amps"," gals"," gals"," gph"," deg F"," psi"," Hg"," rpm"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," deg F"," ft wgs"," kt"," enum"," deg"," MHz"," MHz"," MHz"," MHz"," fsd"," fsd"," kt"," deg"," nm"," deg"," deg"," bool"," enum"," enum"," deg"," deg"," fpm"," enum"," mt"," mt"," mt"," mt"," mt"
    Lcl Date," Lcl Time"," UTCOfst"," AtvWpt"," Latitude"," Longitude"," AltB"," BaroA"," AltMSL"," OAT"," IAS"," GndSpd"," VSpd"," Pitch"," Roll"," LatAc"," NormAc"," HDG"," TRK"," volt1"," volt2"," amp1"," amp2"," FQtyL"," FQtyR"," E1 FFlow"," E1 OilT"," E1 OilP"," E1 MAP"," E1 RPM"," E1 CHT1"," E1 CHT2"," E1 CHT3"," E1 CHT4"," E1 CHT5"," E1 CHT6"," E1 EGT1"," E1 EGT2"," E1 EGT3"," E1 EGT4"," E1 EGT5"," E1 EGT6"," AltGPS"," TAS"," HSIS"," CRS"," NAV1"," NAV2"," COM1"," COM2"," HCDI"," VCDI"," WndSpd"," WndDr"," WptDst"," WptBrg"," MagVar"," AfcsOn"," RollM"," PitchM"," RollC"," PichC"," VSpdG"," GPSfix"," HAL"," VAL"," HPLwas"," HPLfd"," VPLwas"
    2021-04-09,"13:37:42","-06:00",,"38.584850","-92.143350","932","29.68",,,"79",,"0",,,,,"123",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    2021-04-09,"13:38:17","-06:00",,"38.576070","-92.131960","1207","29.68",,,"76",,"787",,,,,"173",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    
     
  6. Nub_Pilot

    Nub_Pilot Pre-Flight

    Joined:
    Jan 21, 2019
    Messages:
    89

    Display name:
    Jeremy's new interest
    will ForeFlight accept a .kml file? if so you can export that from FlightAware.

    In flightAware, click on "View Track Log" center near the top
    - click on the "Google Earth" image at the top.
    - it will give you the option to save as a .kml file
     
    spdracer888 likes this.
  7. PeterNSteinmetz

    PeterNSteinmetz En-Route

    Joined:
    Sep 9, 2015
    Messages:
    2,654
    Location:
    Tempe, AZ

    Display name:
    PeterNSteinmetz
    In general FF can import .kml files. It is somewhat limited in the elements it understands. That is how my layer for AM radio stations works.

    It is not hard to read, parse, and modify .kml files. They are just a particular xml based format.
     
  8. MBDiagMan

    MBDiagMan En-Route

    Joined:
    May 8, 2011
    Messages:
    4,966
    Location:
    NorthEast Texas

    Display name:
    Doc
    As long as my iPad is in the plane and Foreflight is on, it will record a track log of every flight. It begins when the plane begins to move and ends when the plane comes to a full stop.
     
    PaulS likes this.
  9. Lindberg

    Lindberg Final Approach

    Joined:
    Sep 25, 2013
    Messages:
    6,051
    Location:
    North Texas

    Display name:
    Lindberg
    I know MyFlightbook will import KML flight logs. I don't know all the other ways it's superior to Forelight, but I'm sure they are legion.
     
    Last edited: Apr 12, 2021
  10. MBDiagMan

    MBDiagMan En-Route

    Joined:
    May 8, 2011
    Messages:
    4,966
    Location:
    NorthEast Texas

    Display name:
    Doc
    MyFlightbook is superior to FF in what way.
     
  11. Salty

    Salty Touchdown! Greaser!

    Joined:
    Dec 21, 2016
    Messages:
    12,332
    Location:
    FL

    Display name:
    Salty
    I can’t think of anything FF does better in terms of logging.
     
  12. MBDiagMan

    MBDiagMan En-Route

    Joined:
    May 8, 2011
    Messages:
    4,966
    Location:
    NorthEast Texas

    Display name:
    Doc
    FF is not designed for logging. It is designed to be an electronic flight book.
     
    Tantalum likes this.
  13. MPearon

    MPearon Filing Flight Plan

    Joined:
    Apr 10, 2021
    Messages:
    3

    Display name:
    MPearon
    While ForeFlight will accept KMLs, it will only import shapes, not paths - and only as custom map layers, not track logs.
    What I’m after is to create a track log from the FlightAware data. I was hoping to recreate a G1000 log (which ForeFlight will accept as track logs)…but I haven’t had any luck.
     
  14. Cap'n Jack

    Cap'n Jack Final Approach

    Joined:
    Jun 25, 2006
    Messages:
    8,693
    Location:
    Nebraska

    Display name:
    Cap'n Jack
    If you've an original G1000 log I can use for an example, I can write some code to convert to it. Looking at the foreflight site, it is only a CSV file, like the example you posted earlier in the thread. Your example is likely missing something in the header or something simple, but difficult to find, that prevents FF from reading the file. I used to write excel VBA code to bring data in/out of Garmin units.
     
  15. MPearon

    MPearon Filing Flight Plan

    Joined:
    Apr 10, 2021
    Messages:
    3

    Display name:
    MPearon
    That's exactly what I'm lacking, unfortunately. I don't have access to a G1000, so I'm relying on random stuff I find in forums here and there - so who knows how dated it is.
    From what I gather, it is CSV, but the fields are fixed-width. I don't know that for sure (no original file), but one of the samples kind of supported the theory.
    If anyone has a G1000 that could provide an unadulterated file, it would be much appreciated. I've reached out to a Reddit community (r/flying) as well, but no sample files from there yet either. :(
     
  16. Cap'n Jack

    Cap'n Jack Final Approach

    Joined:
    Jun 25, 2006
    Messages:
    8,693
    Location:
    Nebraska

    Display name:
    Cap'n Jack
    I'll look as well for the file format. I've traces I'd like to save as well. If I get something working, I'll send it to you and otherwise make it available to all.
     
    MPearon likes this.
  17. Lindberg

    Lindberg Final Approach

    Joined:
    Sep 25, 2013
    Messages:
    6,051
    Location:
    North Texas

    Display name:
    Lindberg
    It has the feature the OP is asking for, to begin with.
     
  18. MBDiagMan

    MBDiagMan En-Route

    Joined:
    May 8, 2011
    Messages:
    4,966
    Location:
    NorthEast Texas

    Display name:
    Doc
    And one feature out of hundreds makes it superior?
     
  19. Lindberg

    Lindberg Final Approach

    Joined:
    Sep 25, 2013
    Messages:
    6,051
    Location:
    North Texas

    Display name:
    Lindberg
    I did say I don't know all the ways it's superior, right? And I'll never know because Foreflight only runs on iOS..... I guess that's another one.
     
  20. MBDiagMan

    MBDiagMan En-Route

    Joined:
    May 8, 2011
    Messages:
    4,966
    Location:
    NorthEast Texas

    Display name:
    Doc
    Yes it’s running on iOS is indeed one of the things that makes it superior.
     
  21. Lindberg

    Lindberg Final Approach

    Joined:
    Sep 25, 2013
    Messages:
    6,051
    Location:
    North Texas

    Display name:
    Lindberg
    Running only on iOS certainly isn't. Myflightbook has iOS and Android apps and will run anywhere you have a web browser. It's also open source and free, with fantastic support. But if you love Foreflight, use it.
     
  22. Tantalum

    Tantalum Final Approach

    Joined:
    Feb 22, 2017
    Messages:
    9,070

    Display name:
    San_Diego_Pilot
    Foreflight's logging is trash. This might be overkill but I export everything and have my own Tableau dashboard.. you can do great circle routing, actual routes flown, all sorts of cool stuff. If you really want to geek out you can do some really stuff with Python
     
  23. NightMute

    NightMute Filing Flight Plan

    Joined:
    May 2, 2021
    Messages:
    1

    Display name:
    NightMute
     
  24. Aaron Leiby

    Aaron Leiby Filing Flight Plan

    Joined:
    Feb 9, 2022
    Messages:
    10

    Display name:
    Aaron Leiby
    I didn't see any newer discussion on this topic, and it didn't seem like there was any definite conclusion for how to import FlightAware tracklogs into ForeFlight.

    I was interested in doing this myself, so I whipped up a quick python script that converts from FlightAware's KLM files to a minimal G1000 CSV file that ForeFlight will import.

    I haven't posted enough to include links yet, so you'll have to do some googling to find the script (maybe someone else can follow up with a direct link). It's on my github page, user name aleiby, project name klm2g1000.

    One thing I noticed was that ForeFlight appears to cut off data at the end - or maybe FlightAware isn't exporting the entire track, unclear. FlightAware clearly has more data than they export to the KLM, which is unfortunate. We could probably pull data directly from flightaware.com itself instead of importing KMLs, but that's more effort than I wanted to spend on this right now.

    I welcome any improvements folks want to submit. I only got things far enough along for my own personal needs, but figured I'd share in case it would be useful to anyone else.
     
    Last edited: Jun 11, 2022
    masloki likes this.
  25. TommyG

    TommyG Pattern Altitude

    Joined:
    Oct 24, 2011
    Messages:
    2,053

    Display name:
    Tom
    From what I have seen, it looks as foreflight borrowed a lot of feature from MyFlightbook. Just my opinion.
     
    EricBe likes this.
  26. EricBe

    EricBe Pre-takeoff checklist

    Joined:
    Jul 29, 2013
    Messages:
    356

    Display name:
    Eric Berman
    Can't help with ForeFlight, but here's what you can do with MyFlightbook: get the KML or GPX file off of FlightAware (or whatever other source you have). If you're using the website, you can attach it to a flight and optionally press "AutoFill" to detect things like landings, airports, night flight, and so forth. If you're using the iOS or Android app, you can "send" the file to MyFlightbook and it will prompt you to create a new flight based on that data (effectively pressing "autofill" for you). As long as the data has timestamped coordinates (ideally, but not necessarily, including speed), it should be able to do a good job of filling in the details of the flight.
     
  27. flyingpreacher

    flyingpreacher Pre-takeoff checklist PoA Supporter

    Joined:
    Sep 20, 2021
    Messages:
    281
    Location:
    Williamsport, PA

    Display name:
    flyingpreacher
    https://github.com/aleiby/kml2g1000
     
    masloki likes this.
  28. Dan Robinson

    Dan Robinson Filing Flight Plan

    Joined:
    Apr 21, 2023
    Messages:
    1

    Display name:
    HardRoc
    Sorry to revive an older thread but I feel like I’m hitting my head against a brick wall trying to run this Python script. I changed the directory in the .py file but when I try to run it I get a syntax error at the srcDIR line. Anyone get this to work on Windows?