Importing past flights with Airportcode TXL doesn't work

[Maxklos]

The bug

When I import past flight from Flightradar24 it works without error. But flights from and to the (now closed) Airport Berlin-Tegel TXL are "forgotten" and not displayed. Flight to the (also now closed) Airport Berlin Schönefeld SXF are converted to BER. I can't manually add flight to/from TXL&SXF either, just BER. That's ok, but old data get lost this way.

Both versions could work:

• convert TXL flights to BER as well
• Allow import for TXL flights

Export file for testing (both TXL & SXF flights) flightdiary_2024_09_12_08_59.csv

Operating System that is running AirTrail

Ubuntu WSL

AirTrail Version

latest

Your docker-compose.yml content

No response

Your .env content

No response

Reproduction steps

1.import file with airport code TXL 2.flights won't appear

Relevant log output

No response

Additional information

No response

[johanohly]

Good find, I'll add a list of closed airports. I am not sure how SXF is converted to BER though. Is SXF mentioned in the CSV and does AirTrail show it as BER in the end?

[Maxklos]

Yes, in the CSV this flight is SXF -> ARN but in Airtrail it's BER -> ARN.

All my SXF flights got converted to BER

[johanohly]

The airports are matched by their ICAO code, rather than their IATA code, to support airports without a IATA code. In AirTrails' database, Berlin Brandenburg Airports ICAO code is EDDB which, in your CSV, matches Berlin Schoenefeld. I think the ICAO code got transferred when Schoenefeld shut down.

[johanohly]

Handled in v0.1.0, you would have to re-import the flights though

[Maxklos]

reimported my flight, everything works as expected. Thank you very much!