Introducing MyFlightPath.club - flights tracker and shared calendar for BA flyers
May 27, 2021, 2:49 pm
#76
Original Poster
Join Date: Jul 2014
Location: WAW ✈ LHR ✈ GLA
Programs: BA GfL/GGL/CCR, HH Diamond, IHG Diamond Ambassador
Posts: 2,498
May 28, 2021, 1:58 am
#77
Join Date: Aug 2007
Location: Cheshire / Wherever they send me
Programs: BA Blue, Marriott Plat Life, UA Silver (thx Marriott), IHG Gold, Accor Plat, Hilton Diamond
Posts: 943
May 28, 2021, 2:25 am
#78
Original Poster
Join Date: Jul 2014
Location: WAW ✈ LHR ✈ GLA
Programs: BA GfL/GGL/CCR, HH Diamond, IHG Diamond Ambassador
Posts: 2,498
can you share the relevant csv rows where it doesn't like to import SFX? you can check source data by clicking the first icon in the row on the review page.
May 28, 2021, 3:26 am
#79
FlyerTalk Evangelist
Join Date: Nov 2018
Location: Istanbul, Turkey
Programs: TK Elite Plus,BAEC GGL,ITA Executive, AFKL Gold,QR Gold,HH Diamond,Bonvoy Gold,ALL Gold
Posts: 14,185
My.FR24 had an issue regarding DOH; they didn't add Hamad Airport until it was already 2-3 years after it's reopening and then they changed old DOH to Hamad and added a new airport named Doha International Airport with the code DIA.
They were doing the same thing with new IST but I sent them an e-mail in May/June 2019, first, the agent responded to me claimed that the codes were correct but 2-3 days later, it was fixed, probably after somebody more knowledgable were checking e-mails and responses for customer service purposes.
They were doing the same thing with new IST but I sent them an e-mail in May/June 2019, first, the agent responded to me claimed that the codes were correct but 2-3 days later, it was fixed, probably after somebody more knowledgable were checking e-mails and responses for customer service purposes.
May 28, 2021, 3:40 am
#80
Original Poster
Join Date: Jul 2014
Location: WAW ✈ LHR ✈ GLA
Programs: BA GfL/GGL/CCR, HH Diamond, IHG Diamond Ambassador
Posts: 2,498
My.FR24 had an issue regarding DOH; they didn't add Hamad Airport until it was already 2-3 years after it's reopening and then they changed old DOH to Hamad and added a new airport named Doha International Airport with the code DIA.
They were doing the same thing with new IST but I sent them an e-mail in May/June 2019, first, the agent responded to me claimed that the codes were correct but 2-3 days later, it was fixed, probably after somebody more knowledgable were checking e-mails and responses for customer service purposes.
They were doing the same thing with new IST but I sent them an e-mail in May/June 2019, first, the agent responded to me claimed that the codes were correct but 2-3 days later, it was fixed, probably after somebody more knowledgable were checking e-mails and responses for customer service purposes.
May 28, 2021, 3:43 am
#81
FlyerTalk Evangelist
Join Date: Nov 2018
Location: Istanbul, Turkey
Programs: TK Elite Plus,BAEC GGL,ITA Executive, AFKL Gold,QR Gold,HH Diamond,Bonvoy Gold,ALL Gold
Posts: 14,185
I actually manually updated the flights that were incorrectly posted on MFPC so I personally don't have an issue.
May 28, 2021, 4:20 am
#82
Join Date: Aug 2007
Location: Cheshire / Wherever they send me
Programs: BA Blue, Marriott Plat Life, UA Silver (thx Marriott), IHG Gold, Accor Plat, Hilton Diamond
Posts: 943
CSV:
Flight,Date,From,To,Distance,Airline,Cabin,U/G,Seat,Aircraft,Notes
EZY5416,15/11/2014 19:25,SXF,LGW,593,Easyjet,Economy,,,,
T
May 28, 2021, 4:54 am
#83
Original Poster
Join Date: Jul 2014
Location: WAW ✈ LHR ✈ GLA
Programs: BA GfL/GGL/CCR, HH Diamond, IHG Diamond Ambassador
Posts: 2,498
Either way, SXF should import now
May 28, 2021, 6:18 am
#84
Join Date: Aug 2007
Location: Cheshire / Wherever they send me
Programs: BA Blue, Marriott Plat Life, UA Silver (thx Marriott), IHG Gold, Accor Plat, Hilton Diamond
Posts: 943
Note your date is not formatted correctly - ba97's export saves dates in 'YYYY-MM-DD hh:mm` format, and that's what's expected. Your date is saved as `DD/MM/YYYY hh:mm` which suggest you've opened the file in Excel and saved it from Excel
Either way, SXF should import now
Either way, SXF should import now
I've switched it around now and it works.
Thanks for your help.
T
May 28, 2021, 9:24 am
#85
Original Poster
Join Date: Jul 2014
Location: WAW ✈ LHR ✈ GLA
Programs: BA GfL/GGL/CCR, HH Diamond, IHG Diamond Ambassador
Posts: 2,498
Glad it worked for you!
The `d/m/Y` format is tricky as it's difficult for the import process to distinguish it form `m/d/Y` used by US based folks... so in IT it's very common that dates are saved behind the scenes in ISO format as `Y-m-d` - this way we're 100% sure format is correct and dates are easily sortable. Users prefer to see dates in the format they're comfortable with, so Excel (and other tools) will convert ISO format into a user-friendly display format of whatever their locale dictates. Problem starts when some tools (mainly Excel) will stupidly save dates as user sees them, not is ISO fromat. This bug has been hunting Excel for years and Microsoft does not seem to be interested in fixing it.
May 28, 2021, 10:35 am
#87
Original Poster
Join Date: Jul 2014
Location: WAW ✈ LHR ✈ GLA
Programs: BA GfL/GGL/CCR, HH Diamond, IHG Diamond Ambassador
Posts: 2,498
May 28, 2021, 2:16 pm
#89
FlyerTalk Evangelist
Join Date: Nov 2018
Location: Istanbul, Turkey
Programs: TK Elite Plus,BAEC GGL,ITA Executive, AFKL Gold,QR Gold,HH Diamond,Bonvoy Gold,ALL Gold
Posts: 14,185
As another suggestion, even though the website is smartphone friendly, how about an app?
May 28, 2021, 3:01 pm
#90
Join Date: Oct 2018
Location: London, UK
Programs: BAEC
Posts: 3,439