Requesting Script to pull airline timetables
-
Sunday, January 06, 2013 8:15 AMHello 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
All Replies
-
Sunday, January 06, 2013 8:23 AM
I am requesting a script that can pull airline information from this program
Sorry, this is not a free code delivery service. Instead of "requesting" a script, you need to write it yourself. Respondents will then be pleased to assist with the finer points.
- Marked As Answer by Bill_StewartMicrosoft Community Contributor, Moderator Sunday, January 06, 2013 2:35 PM
-
Sunday, January 06, 2013 8:32 AM
That is not a script request it is spam. It's an advertisement for a program for windows. It has nothing to do with Flight Simulator.
Happy New Year ¯\_(ツ)_/¯
-
Sunday, January 06, 2013 8:11 PM
That is not a script request it is spam. It's an advertisement for a program for windows. It has nothing to do with Flight Simulator.
Happy New Year ¯\_(ツ)_/¯
It actually does have to do with Flight Simulator. You know the saying about assuming, (ass out of u and me). Using the data in a particular format in excel I can put it into a program called MRAI Compiler (Google it if you still think i'm an advertisement spammer) and it puts it into a format that can be used in FSX as a flightplan that can be assigned to AI traffic. If you'd like a better understanding of what I am talking about look up payware programs such as MyTraffic 2013, Ultimate Traffic 2.
-
Sunday, January 06, 2013 8:26 PM
That is not a script request it is spam. It's an advertisement for a program for windows. It has nothing to do with Flight Simulator.
Happy New Year ¯\_(ツ)_/¯
It actually does have to do with Flight Simulator. You know the saying about assuming, (ass out of u and me). Using the data in a particular format in excel I can put it into a program called MRAI Compiler (Google it if you still think i'm an advertisement spammer) and it puts it into a format that can be used in FSX as a flightplan that can be assigned to AI traffic. If you'd like a better understanding of what I am talking about look up payware programs such as MyTraffic 2013, Ultimate Traffic 2.
Ok - maybe it is not spam but how do you expect anyone to pull data from a website that is an advertisement fro an airline schedule package,?
Perhaps you posted the wrong link. Airline schedules are al available via SOAP as a web service and can be loaded directly into Excel. There are numerous Excel add-ins that can do this.
As posted above, this is not a free scripting site. If you are writing a script then we can be of assistance. If you have an issue with a third aprty program then you will need to contact the vendor for assistance.
The idea that this was spam is because many post in forums to advertise their products. Tis is what it looked like you were doing. I apologize if I was mistaken.
In any case I don't see how scripting can be of any help.
Happy New Year ¯\_(ツ)_/¯
-
Sunday, January 06, 2013 9:26 PM
Here's the link to a script that was made for me to download the timetables.
https://www.dropbox.com/s/d1w34gk0npuciwq/AirlineTables.zip
The scipt is in the Airports.kix file. The url was tied to another script on a separate computer that was accessing the program I mentioned before to scrape the data. The only thing I need is to have the URL reconfigured so that it can access and pull from that desktop utility to scrape the airline timetables. I don't have the experience.
How would one use SOAP to load timetables into Excel?
-
Sunday, January 06, 2013 9:41 PM
It is a KIX script which is not supported here. The script will only work if you are running the vendors program to authenticate to the site first.
The script makes specific reference to a custom page that only exixts in your logged in session.
Note the bit davidDownloadFlights.php that is only available when logged in.
You cannot get suypport fort this here. You need to use the forum on teh virtual airline site to get user support. They will help you understand how to hook up FS to SVA,
Happy New Year ¯\_(ツ)_/¯
-
Sunday, January 06, 2013 10:38 PMModerator
Hi,
As Oberwald already said, this is not a free code writing service. In addition, we don't support the KiXtart language in this forum but rather focus on native/standard Windows scripting technologies (WSH with VBScript, WSH with JScript, and PowerShell).
Bill
.png)
