The airline we model, releases the complete seasonal program in excel spreadsheet.
These are for the hole seasons, and we want to try make a script to extract flights for a given week/period within the season, for example, 1 week in May, 1 week in July, 1 week in September.
This would save us a great deal of manual labour, and would free up time to do other stuff with our airline.
For the season we are in now, I manualy removed duplicates, adjusted for active/inactive within the season etc. I want to make this more effective.
Anyway, the format for the spreadsheet is like this:
FltNo From To Freq STC ACT DEP STD ARR STA Config
DY118 30MAR12 30MAR12 5 J 73H BGO 1810 AES 1855 Y186
DY118 13APR12 27APR12 5 J 73H BGO 1810 AES 1855 Y186
DY118 29APR12 22JUN12 5 7 J 73H BGO 1810 AES 1855 Y186
DY118 19AUG12 19AUG12 7 J 733 BGO 1810 AES 1855 Y148
DY118 24AUG12 26OCT12 5 7 J 73H BGO 1810 AES 1855 Y186
DY119 30MAR12 30MAR12 5 J 73H AES 1915 BGO 2000 Y186
DY119 13APR12 22JUN12 5 J 73H AES 1915 BGO 2000 Y186
DY119 24AUG12 26OCT12 5 J 73H AES 1915 BGO 2000 Y186
(Day 7 is Sunday , 0 in VMS)
So what we want to do is that, if we select a week in May, the script would extract every flight in that period and compile it in a csv format for import to our system.
Probably a massive task, but if somebody is capable and interested in giving us a hand, send me a pm or mail me @ jantore(youknowwhattoputhere)virtualnorwegian.net / skype jan.tore.elvheim
Cheers
PS. If somebody knows any other way to get up to date schedule data ready for VMS in an easy "effortless" way, please give me a shout.
I know somebody gets data from forexample Innovata, how does this work?
A tool to extract the timetable from amadeus would be very cool