Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Looking for script to pull airline timetables

Jan 5, 2013 4:20PM PST

Hello there,
I am requesting a script that can pull airline information from this program:
http://www.eskyguide.com/mobile/windows

I would like to be able to pull data from a specific date between multiple airport pairs. I would like to be able to put a txt file together with airport codes and have the program download all flights for the day between all airport codes.

Example is as follow:
Depart=LAS Arrival=SMF Date=Jan 6

It would look like this:
Flight From Depart To Arrive Via Aircraft Duration Itinerary
WN752 LAS 10:40am SMF 12:20pm 73W 1h40m
WN387 LAS 1:50pm SMF 3:20pm 733 1h30m
WN749 LAS 4:10pm SMF 5:40pm 73W 1h30m
WN3879 LAS 6:45pm SMF 8:15pm 733 1h30m
WN154 LAS 7:55pm SMF 9:25pm 73W 1h30m
WN1874 LAS 9:00pm SMF 10:30pm 73W 1h30m
WN1409/WN1409 LAS 8:35am SMF 11:50am SAN 733 3h15m
DL1820/DL4702~ LAS 11:19am SMF 2:40pm LAX 319/CR7 3h21m
AA1308/AA2628~ LAS 1:35pm SMF 5:20pm LAX 738/CRJ 3h45m
BA4839*/BA4721* LAS 1:35pm SMF 5:20pm LAX 738/CRJ 3h45m
UA233/UA6510~ LAS 2:27pm SMF 6:10pm LAX 752/CR7 3h43m
US6478*/US7013* LAS 2:27pm SMF 6:10pm LAX 752/CR7 3h43m
UA5523~/UA5402~ LAS 4:56pm SMF 8:30pm SFO CR7/EM2 3h34m
AA776/AA2623~ LAS 7:00pm SMF 10:05pm LAX 738/CRJ 3h05m

If I could have this data put into a excel format I can then change it and put it in a format I can make a Flightsim Flightplan with.

This is for Flightsimming purposes.

Thanks

Discussion is locked

- Collapse -
Answer
First you need to find
Jan 6, 2013 10:24AM PST

out whether they offer an API that provides you with access to that data.

~Sovereign

- Collapse -
No API key from listed software
Jan 6, 2013 2:44PM PST

No they don't. The program I listed doesn't offer an API. I can however get an API key from FlightAware.com, would that help you?

- Collapse -
If you've found a company
Jan 7, 2013 10:34PM PST

that has the data you're looking for and they offer an API to interface with that data, then you'd be able to build a spreadsheet from it.

You're best bet is to get in touch with a local development company or freelance developer, and see how much they quote you on this project.

~Sovereign