Openflights vs MyFlightRadar24

[serfty]

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.

 

[motef]

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.

 

[AisleSeat]

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

 

[Millie]

Even I managed that without too much difficulty - I used Flight Tracker 24 - looks okay for my 168 flights!

 

[Henchy]

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.

 

[serfty]

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.

 

[bigchin]

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

 

[AIRwin]

I imported my OpenFlights CSV file to MyFlightRadar24 with a few tweaks.

Departure and arrival times?

 

[admin]

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

 

[motef]

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.

 

[serfty]

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)

 

[Kiwi_Flyer]

Thanks for the tips to get info loaded. Looks like I will need to set aside time to go through my 3100+ entries.

 

[amp-qld]

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.

 

[amp-qld]

Just seen bigchin's post and that helps. Still no import of aircraft types.

 

[motef]

Just seen bigchin's post and that helps. Still no import of aircraft types.

Yeah the aircraft types is really annoying

 

[snabbu]

Moving the export to openflights was relatively painless however getting the same data into mf24 is proving to be somewhat difficult.

 

[amp-qld]

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):

	Date	FL#	From	To	Dur	Line	Craft	Dist	Cl	Reas
MFR24:	A	B	C	D	G	H	I	?	M	N
AFF:	A	D	B	C	G	E	L	F	J	K

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?

 

[serfty]

Date Fl# From To Dur Line Craft Dist Cl Reas
A B C D G H I ? M N
A D B C G E L F J K

Thanks for the analysis. I have edited your content into a table for better clarity.

 

[amp-qld]

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.

 

[amp-qld]

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.