Openflights vs MyFlightRadar24

Is there any detail given on why a flight might not import? (Such as an error log.)

Also, are there any tips on getting the flight times information imported into, maybe as notes.
 
Has anybody successfully overcome the issue of exporting from the AFF Flight Tracker and data missing when importing into MFR24?

My specifics examples are I have entries in my AFF Flight tracker under Qantas and when I import to MF24 no airline is shown for this?

This also occurs with Virgin Australia which is in my AFF Flight Tracker export as V Australia.
 
Has anybody successfully overcome the issue of exporting from the AFF Flight Tracker and data missing when importing into MFR24?

My specifics examples are I have entries in my AFF Flight tracker under Qantas and when I import to MF24 no airline is shown for this?

This also occurs with Virgin Australia which is in my AFF Flight Tracker export as V Australia.
Qantas needs to be rewritten as Qantas Airways in the CSV file. Thats what worked for me and it now shows up as QF in myFR
 
Is there any detail given on why a flight might not import? (Such as an error log.)

Also, are there any tips on getting the flight times information imported into, maybe as notes.
Gutted that we have to change things. Tried to do so today registered for MYF24, clicked on what I thought was the right thing, something happenned, can't find the "saved export" file to import so - Goodby Flight Tracker - too hard for an old fellow.
 
Gutted that we have to change things. Tried to do so today registered for MYF24, clicked on what I thought was the right thing, something happenned, can't find the "saved export" file to import so - Goodby Flight Tracker - too hard for an old fellow.
You can try again, the flight information on AFF flight tracker won't stop being available for a couple of weeks.
 
I imported my OpenFlights CSV file to MyFlightRadar24 with a few tweaks. you need to use Excel to fix some names:
1. convert date from DD-MM-YYYY format to YYYY-MM-DD.
2. Convert "Qantas" to "Qantas Airways"
3. Convert "V Australia Airlines" to "Virgin Australia"

after this, all my flights imported to MYFR24 without problems
 
Gutted that we have to change things. Tried to do so today registered for MYF24, clicked on what I thought was the right thing, something happenned, can't find the "saved export" file to import so - Goodby Flight Tracker - too hard for an old fellow.
Please see message I have just sent you
 
I imported my OpenFlights CSV file to MyFlightRadar24 with a few tweaks. you need to use Excel to fix some names:
1. convert date from DD-MM-YYYY format to YYYY-MM-DD.
2. Convert "Qantas" to "Qantas Airways"
3. Convert "V Australia Airlines" to "Virgin Australia"

after this, all my flights imported to MYFR24 without problems
Nice!

This works well.

Unfortunately i find it fails on aircraft type consistently. But can manually fix that.
 
I have worked out how to find what myFR24 should accept for various values.

Start the process of manually creating an entry and on the second screen - stop.

There you can enter a few characters of an airline or aircraft type, then wait a second or three and options (presumably valid) will pop up. Select the one you want and paste that into the spreadsheet. Rinse and repeat. (Or at least that's my theory - I have yet to actually try to load the data)
 
Last edited:
I've just discovered a new problem (or it may be an explanation). My dates are in the near universal dd/mm/yyyy format rather than the illogical US mm/dd/yyyy format and there are no flights in the imported list (of 198 flight out of 509 in AFF) with dates after the 12th of any month.
 
Moving the export to openflights was relatively painless however getting the same data into mf24 is proving to be somewhat difficult.
 
Turn business expenses into Business Class! Process $10,000 through pay.com.au to score 20,000 bonus PayRewards Points and join 30k+ savvy business owners enjoying these benefits:

- Pay suppliers who don’t take Amex
- Max out credit card rewards—even on government payments
- Earn & Transfer PayRewards Points to 8+ top airline & hotel partners

AFF Supporters can remove this and all advertisements

I've noticed that the AFF exported spreadsheet and the MFR24 exported spreadsheets have the data in different columns (I'm hoping my spacing survives posting):
DateFL#FromToDurLineCraftDistClReas
MFR24:ABCDGHI?MN
AFF:ADBCGELFJK

There's obviously some conversion going on as MFR24 gets some of the data correct but has anyone experimented with moving the AFF columns to match the MFR24 columns?
 
Last edited by a moderator:
Having deleted (one at a time) the 148 flights that had the wrong dates, thanks to MFR24 not interpreting normal dates, I experimented with moving the AFF columns to match the MFR24 columns myself but it didn't seem to make any difference - still no aircraft types.
 
After clearing the incorrect flights, the import of my flights was relatively straightforward apart from a 1967 flight shown as 2067 - I'll be 116 then! and three flights failing to load as the airport codes somehow had an extra X at the end. Now I just need to go through and add the aircraft types.
 

Become an AFF member!

Join Australian Frequent Flyer (AFF) for free and unlock insider tips, exclusive deals, and global meetups with 65,000+ frequent flyers.

AFF members can also access our Frequent Flyer Training courses, and upgrade to Fast-track your way to expert traveller status and unlock even more exclusive discounts!

AFF forum abbreviations

Wondering about Y, J or any of the other abbreviations used on our forum?

Check out our guide to common AFF acronyms & abbreviations.
Back
Top