Jump to content

Need help scripting from excel to working schedule table


Recommended Posts

Posted

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 :D

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...