IndianGuy
Topic Author
Posts: 3126
Joined: Fri Jul 07, 2000 3:14 pm

Reqd: Airline Info

Sat Aug 05, 2000 9:51 pm


I am working on a web-project, which will enable users to check airline schedules and plan their airline trips on the web. I am developing this project as a 'Technology-Demonstrator' for a new concept that my company has patented.

For this project, i require the detailed schedules of the following airlines, along with info. like acft used on the route etc.

British Airways (UK)
Virgin Atlantic (UK)
United Airlines (US)
Continental (US)
Southwest (US)
Singapore Airlines
Malaysian
JAL (Japan)
ANA (Japan)
Air France
Lufthansa
Biman (Bangladesh)
Thai
QANTAS
Air New Zealand
Air Canada
Canadian
IBERIA
Alitalia
Aeroflot
South African Airways
Air Kenya
Egypt Air
Gulf Air
Emirates

I require the schedules in a flat file, with ; delimited fields. The details are given b'low. My email id:
royskaria@lycos.com

Thanx.


1. Aircraft.txt
Format:
-------------------------

Carrier;AircraftCode;AircraftDisplayCode;AircraftName;FSeats;JSeats;YSeats
AI;742;747;Boeing 747-200B;16;40;336
AI;310;310;Airbus A310-300;0;22;181
AI;AB4;AB4;Airbus A300-B4;0;22;216
IC;3B4;300;Airbus A300-B4;0;28;232
IC;3B4;300;Airbus A300-B2;0;28;240
-------------------------
/*

The first-line must be kept as it is. All records must appear one to a line. Fields within a record should be separated by the 'semi-colon' character ( .

The values given above are for understanding purpose only, and may not be correct

The Field Keys are as follows:
Carrier : Two-char code of carrier (AI, IC, BA, SQ, 9W)
AircraftCode : 3 digit representation of Aircraft model (747-200:742) For system purpose only.

AircraftDisplayCode : The code of the aircraft as it should appear on schedule. for eg. All sub models of the 737 can be individually named (eg. 732, 733 etc), or given a common code like 737, when it appears on the schedule

Aircraft Name : Full Name of Aircraft. (eg. Boeing 737-2A8 or Boeing 747-300 Combi)

Fseats : Number of First Class Seats. Can be 0

Jseats : Number of Business Class Seats. Can be 0

Yseats : Number of Economy Class Seats. Can be 0
*/
-----------------------------------

2. Flights.txt
Format:
Carrier;FlightCode;From;To;Dep;Arr;AircraftCode;Stops;FFareL;JFareL;YFareL;FFareD;JFareD;YFareD;OpDays
IC;109;BOM;BLR;1000;1130;3B4;0;0;6645;4045;0;xxxx;xxxx;1111111
IC;917;BLR;GOA;1130;1210;320;0;0;6645;4045;0;xxxx;xxxx;1111110
IC;917;GOA;PNQ;1245;1335;320;0;0;6645;4045;0;xxxx;xxxx;1111110
IC;917;BLR;PNQ;1130;1335;320;0;0;6645;4045;0;xxxx;xxxx;1111110

/*
For Hopping flights like BOM-LHR-JFK, specify 3 entries eg:
AI;111;BOM;LHR;
AI;111;LHR;JFK;
AI;111;BOM;JFK;

The first-line must be kept as it is. All records must appear one to a line. Fields within a record should be separated by the 'semi-colon' character ( .

The values given above are for understanding purpose only, and may not be correct

The Field Keys are as follows:
Carrier : Two-char code of carrier (AI, IC, BA, SQ, 9W)

FlightCode : Flight Number without any prefix. Code-share flights must begin begin with 'CS' foll. by number

From : Station in IATA-std 3 letter format (BOM/LHR/JFK etc)

To : Station in IATA-std 3 letter format (BOM/LHR/JFK etc)

AircraftCode : 3 digit representation of Aircraft model (747-200:742)

FFareL : First Class Fare in Local Currency (Indian Rupees). Can be 0

JFareL : Business Class Fare in Local Currency (Indian Rupees). Can be 0

YFareL : Economy Class Fare in Local Currency (Indian Rupees). Can be 0

FFareD : First Class Fare in Dollars. Can be 0

JFareD : Business Class Fare in Dollars. Can be 0

YFareD : Economy Class Fare in Dollars. Can be 0

OpDays : Days on which Flight operates."0 0 0 0 0 0 0"
M T W T F S S

If flight operates on diff. time on diff. days, specify these flights as a separate record
*/

Who is online

Users browsing this forum: Areopagus, Baidu [Spider], BDABOY, cat3appr50, Dalmd88, GloomyDe, JetBuddy, Mikey711MN, mjoelnir, narisroj, neromancer, poolkeeper, smeagol, timberwolf24, Zaf, Zwi and 343 guests