Login Now to remove this and all advertisements (GOLD and SILVER members)
Not a member? Register Now for free

Openflights vs MyFlightRadar24

RAM

Established Member
Joined
Jan 30, 2011
Messages
2,637
Points
690
Copy and Paste? !

I'm cleaning the data in my .csv and will attempt importing when I have time. 1975 is a few though - I hope I don't need to do 50 at a time.
Instead of copy & paste I suggest trying find & 'repace all' if your editor allows it (Excel does).
 

serfty

Veteran Member
Moderator
Joined
Nov 16, 2004
Messages
43,339
Solutions
10
Points
3,285
Qantas
Platinum
Virgin
Platinum
Instead of copy & paste I suggest trying find & 'repace all' if your editor allows it (Excel does).
Thanks, I'm sorting by columns as well as whatever works most efficiently.

I considered a vbscript but decided against it. (have worked in IT since 1980 ... ;)
 

Bundy Bear

Established Member
Joined
Jul 17, 2004
Messages
3,658
Points
845
After thinking about this a few weeks ago; saved the data from AFF I am now going through my 700 flights, lucky its not 1970 that would be time consuming. :eek:

Now deciding what do you call an aircraft.

Is it a Boeing 737 or a B737 or a Boeing 737-800(BSI) or is it a Fokker 50 or a Fokker F50, you get the idea.

Does any one remember the Impulse Airlines 2 digit code and was it 2011 or earlier when Virgin switched from DJ to VA.

AFF kept using the V Australia bit.
 

AIRwin

Established Member
Joined
Apr 13, 2013
Messages
4,011
Solutions
6
Points
700
Qantas
Gold
Virgin
Gold
Does any one remember the Impulse Airlines 2 digit code and was it 2011 or earlier when Virgin switched from DJ to VA.
From Wikipedia:
Impulse Airlines = VQ
V Australia = VA
Virgin Blue (until May 2011) = DJ
Virgin Australia = DJ (from May 2011 to January 2013)
Virgin Australia = VA (from January 2013)
 
Last edited:

Mattg

Senior Member
Joined
Aug 21, 2011
Messages
9,923
Solutions
9
Points
1,125
I just tried adding the myFlightradar24 banner to my AFF signature to see what it would look like. It seems to work well.

You can find the banner code to copy & paste into your signature under Settings > Banner on the myFlightradar24 website.
 

Flashback

Enthusiast
Joined
Oct 29, 2006
Messages
10,886
Points
1,530
I just tried adding the myFlightradar24 banner to my AFF signature to see what it would look like. It seems to work well.

You can find the banner code to copy & paste into your signature under Settings > Banner on the myFlightradar24 website.

km, what are they?! :p
 

Bundy Bear

Established Member
Joined
Jul 17, 2004
Messages
3,658
Points
845
Myflightradar seems to be better, so I uploaded 700 flights and only got 240 something, I think I have an error in the date.

Lucky I can delete all the data and start again.

The subscription of $9.99 for a year for silver seems like a cheap price, maybe not worthwhile.
 

Bundy Bear

Established Member
Joined
Jul 17, 2004
Messages
3,658
Points
845
Would anyone have access to any old Ansett flight timetables.

Looking for the flight numbers

April 1996 BNE-TSV 9:00am departure
April 1996 TSV-BNE 4:30pm departure (727?

april 1997 BNE-PER A320 7:30pm departure Friday evening,
April 1997 PER-BNE 11:30pm departure Friday evening; (a week later)

My first 20 flights or so I can picture the time of day and the aircraft but no idea on the flight numbers.
 

flychrisfly

Active Member
Joined
Mar 28, 2010
Messages
706
Points
305
Qantas
Platinum
I just tried adding the myFlightradar24 banner to my AFF signature to see what it would look like. It seems to work well.

You can find the banner code to copy & paste into your signature under Settings > Banner on the myFlightradar24 website.
Great! Now if I could just remember where in AFF the option to update your signature is...!
 

flychrisfly

Active Member
Joined
Mar 28, 2010
Messages
706
Points
305
Qantas
Platinum
I found it useful to load a few records/data points at a time to work out what is right and wrong. Then after the majority is correct, delete what you loaded, fix up the csv and bulk load it correctly leaving just a few tweaks at the end.
 
Credit cards which earn frequent flyer points is a popular way to earn frequent flyer points. You can receive thousands of points on everyday spend. And, many of these cards offer generous signup bonuses! Compare to find the credit card that best suits your needs.

Recommended by the Australian Frequent Flyer

samh004

Enthusiast
Joined
Apr 1, 2009
Messages
19,241
Solutions
13
Points
1,570
Qantas
Platinum
Virgin
Red
The subscription of $9.99 for a year for silver seems like a cheap price, maybe not worthwhile.
ISTR that if you have a Flightradar24 subscription (Silver or Gold) for tracking flights, this is included for removing ads and the like, it's more than just the log of flights that you get for the price.
Great! Now if I could just remember where in AFF the option to update your signature is...!
Only available to paid up members, possibly even just Gold rather than Silver?
Correct, it is a benefit of a Gold subscription.
 

snabbu

Established Member
Joined
Sep 1, 2014
Messages
1,313
Points
470
Qantas
Platinum
I've finally been able to successfully import my 1400 odd flights into MF24 in one hit.
The two problems I encountered were the airline names and the aircraft types.
My solution was to work out the numeric values for the aircraft types and airline names that MF24 used, then convert my export from OF to the new numeric values and rename the column names to Airline_id and Aircraft_id.

Additionally, the MF24 team are on the ball with requests - the heliport on Heron Island was not in their database so I sent a request to be added and bam three hours later an email confirming it was added.
 

Community Statistics

Threads
86,882
Messages
2,115,512
Members
54,134
Latest member
Goodo
Top