FlyerTalk Forums

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   oneworld (https://www.flyertalk.com/forum/oneworld-411/)
-   -   New Version of Oneworld Electronic Timetable (https://www.flyertalk.com/forum/oneworld/445648-new-version-oneworld-electronic-timetable.html)

phillipas Oct 9, 2005 7:33 pm


Originally Posted by hauteboy
I'll admit I like the old format better too; I haven't figured out how to decode the new file format yet. :)

My efforts on the timetable front are to download to OW pdf, copy it to an Excel spreadsheet where I've got all the filters and sitances set up and hey presto, I can tell you the longest NA non Transcon (for xONEx purposes)... but it's only valid for one month.

What I realy need, and would be most appreciative of any help on, I some indication as to how I can get hold of the AA schedules for, ideally, the next 6 months. The key thing is they MUST be in a format that I can decode to Excel.

Cheers.

hauteboy Oct 10, 2005 8:45 pm


Originally Posted by phillipas
My efforts on the timetable front are to download to OW pdf, copy it to an Excel spreadsheet where I've got all the filters and sitances set up and hey presto, I can tell you the longest NA non Transcon (for xONEx purposes)... but it's only valid for one month.

What I realy need, and would be most appreciative of any help on, I some indication as to how I can get hold of the AA schedules for, ideally, the next 6 months. The key thing is they MUST be in a format that I can decode to Excel.

Cheers.

I have a utility that does the same, and lots more. Shows all flights from a city, all flights to a city, all flights less than X miles, all flights greater than X miles, all flights from a country, all flights from a country, all flights on a certain aircraft, etc. You can combine the queries.

eg.
dumpow.exe -from lhr -gte 5000 -airline ba

phillipas Oct 10, 2005 9:00 pm


Originally Posted by hauteboy
I have a utility that does the same, and lots more. Shows all flights from a city, all flights to a city, all flights less than X miles, all flights greater than X miles, all flights from a country, all flights from a country, all flights on a certain aircraft, etc. You can combine the queries.

eg.
dumpow.exe -from lhr -gte 5000 -airline ba

Yep, my spreadsheet does all those things. :p The great thing about Excel is that it's so easy to manipulate the data.

The 'but' though is that it's only valid for the current month - and is thus something of a pain when it comes to planning an xONEx a few months in advance. The non-NA parts are all very schedule, but the long NA non-transcons seem to change every month. Hence my plea for help.

PS - Kiwiflyer, e-mail on it's way later today.

LRD Aug 5, 2006 1:40 pm


Originally Posted by Mateo4321
still hoping for that all cities option to come back... :rolleyes:

Sorry for digging up an old thread, but I also am looking for a timetable or tool that shows all departures from a given airport - listed by departure time.

(OAG comes close... it will show all destinations alphabetically or by flight duration. A few airports also publish their departure info, but not the airports I'm interested in.)

Thanks.

Kiwi Flyer Aug 6, 2006 3:48 pm

Which airports are you interested in?

LRD Aug 6, 2006 4:09 pm


Originally Posted by Kiwi Flyer
Which airports are you interested in?

Schiphol. I couldn't see departing flights yesterday - but I do now - so I'm good.

However, it still would be helpful to have a single source (like the old OW timetable) that could list all departing flights from any airport (or just the OW airports) by departure time.

Viajero Aug 6, 2006 4:39 pm


Originally Posted by LRD
...However, it still would be helpful to have a single source (like the old OW timetable)...

Actually we do have one (sort of): flt_dat1.ftd

All we need is some clever FTer to decode it. @:-)

mhaines94108 Jul 17, 2016 2:24 am


Originally Posted by phillipas (Post 4703158)
My efforts on the timetable front are to download to OW pdf, copy it to an Excel spreadsheet
Cheers.

I realize this post is pretty old. Are you still able to copy it to an Excel spreadsheet? How do you do this? The PDF is almost 7500 pages long, so that's a lot of work if any significant manual cleanup or reformatting is required.


All times are GMT -6. The time now is 12:14 pm.


This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.