jantorre Posted August 31, 2012 Report Posted August 31, 2012 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 Quote
MBrown Posted August 31, 2012 Report Posted August 31, 2012 Simpilot offers a service I believe and you get a ready built csv with all the routes of your airline ready to import! You'd have to ask him Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.