Skip to content

Importing

Jump to bottom
Pietro Bonaldo Gregori edited this page Sep 6, 2024 · 3 revisions

The API has a dedicated /importing endpoint, which supports the formats described below

MyFlightRadar24

  1. Go to MyFlightRadar24 > Settings > Export and download the CSV
  2. Go to Jetlog > Settings > Import
  3. Upload your CSV in the MyFlightRadar24 section and press Import
  4. Check your logs for progress

Custom CSV

  1. Go to Jetlog > Settings > Import
  2. Upload your CSV in the Custom CSV section and press Import
  3. Check your logs for progress

Formatting

The CSV should have some of the following columns (order doesn't matter)

Column name Required Format
date ✅ YYYY-MM-DD
origin ✅ ICAO code of origin airport (4 letters)
destination ✅ ICAO code of destination airport (4 letters)
departure_time HH:MM
arrival_time HH:MM
arrival_date YYYY-MM-DD
seat One of window,middle,aisle
ticket_class One of private, first, business, economy+, economy
duration Number of minutes (integer)
distance Kilometers (!)
airplane String
flight_number String
notes String

The importing logs should give you information about any errors. If any columns are invalid, the importing will fail to avoid importing a lot of flights with incomplete data.

Here's an example custom CSV:

date,distance,origin,destination,arrival_time,departure_time
2024-03-14,800,lime,eheh,11:20,10:00
2024-03-19,800,eheh,lime,18:40,16:30
Clone this wiki locally