CSV File Import

Currently, the app fully supports CSV file import from MyFlightRadar24.

Go to Settings (upper tray) > Export (left column) > Download CSV (button) to gain your file.

Perhaps, it accepts any CSV with the same structure.

Data example:

Date,"Flight number",From,To,"Dep time","Arr time",Duration,Airline,Aircraft,Registration,"Seat number","Seat type","Flight class","Flight reason",Note,Dep_id,Arr_id,Airline_id,Aircraft_id
2016-08-26,QS1098,"Prague / Praha-Ruzyne (PRG/LKPR)","London / Gatwick (LGW/EGKK)",19:50:00,20:55:00,02:05:00,"Travel Service (QS/TVS)","Boeing 737-800 (B738)",,,3,1,1,,2398,1614,803,231

Data structure:

  • Comma as delimiter
  •  Headline in this format: Date,"Flight number",From,To,"Dep time","Arr time",Duration,Airline,Aircraft,Registration,"Seat number","Seat type","Flight class","Flight reason",Note,Dep_id,Arr_id,Airline_id,Aircraft_id
  • Column 1: Date in format YYYY-MM-DD
  • Column 2: Flight number without spaces
  • Column 3: origin airport with codes in brackets >> (IATA code/ICAO code)
  • Column 4: destination airport  with codes in brackets >> (IATA code/ICAO code)
  • Column 5: Departure time in format HH:mm:ss
  • Column 6: Arrival time in format HH:mm:ss
  • Column 7: flight duration in format HH:mm:ss
  • Column 8: Airline in the format name (IATA code/ICAO code) with the priority in the airlie name.
  • Column 9: Airline name in the format name (ICAO code)
  • Column 10: plane immatriculation 
  • Column 11: seat number
  • Column 12: seat type in number index >> 1 for windows, 2 for aisle, 3 for middle
  • Column 13: cabin class in number index >> 1 for  economy, 2 for business, 3 for first, 4 for premium economy, 5 for private
  • Column 14: flight reason in number index: 1 for leisure, 2 for business, 3 for crew, 4 for other
  • Column 15: note
  • Column 16+: not supported / not used

Up to the version 2.0.12 column position in CSV file is important for successful import perhaps you may leave the column(s) empty. It may change in the future versions. Mandatory columns for import to display your flight: date, origin airport & destination airport.

Popular posts from this blog

Version 2.0.14

Making of version 2.0.14 was very painful. First of all, I needed to manage with a new Google's rule introduced in the latest security update - forced removal of the permission READ_MEDIA_IMAGES which I used for profile photo selection and sharing map. Profile photo is selected by Photo Picker now. Perhaps, I spent a lot of time with finding a solution how to share map without that permission and I didn't crack it. So, the menu entry Save map is temporarily disabled. Let's hope that it is not temporary solution as Soviet army in Czechoslovakia in 1968... This version brings many improvements: new widget Top Aircrafts improves managing alliances - inactive alliances are now in gray color both in autocomplete and in the list. enhanced display of Visited Countries Stats Flight List: support for filtering by flight number and registration.
Read more

Version 2.0.12

Image
improved graphs enhanced airlines list added easteregg  added Telegram channel for modification requests modified welcome text Can you find easter egg? Hint: Go to About App screen
Read more