Jump to content

jantorre

Members
 View Profile  See their activity

  • Posts

    66

  • Joined

  • Last visited

 Content Type 

Posts posted by jantorre

  1. Need help scripting from excel to working schedule table

    in Paid Services

    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

  2. AIRAC updates

    in Support Forum

    Posted

    Hi

    Wondering if AIRAC updates are progressing any further (Ref. Hosting and Navdata Updates )

    Around our neighbourhood the airways and fixes has changed a lot since the first version and we hope to se an update able airac soon so we can easily keep it updated. Uptil now we have been updating some fixes ourself but its not the best solution.

    Thank you

    Jan Tore

  4. Timetable 1.0

    in Simpilot Group Addons

    Posted

    You should be able to add

    if($schedule->enabled <> '1'){continue;}

    on line 45 of the original timetable_index.tpl file and it should skip any schedule that is not enabled.

    Sweet, worked out great! Added to our site. Thank you for making so many great things for VMS

  6. Set departure time to Pushback time

    in kACARS

    Posted

    I would also like to have the parking brake release to trigger the timer. I want block to block. I got some notes from some of the pilots about this to.

    And also, the way it now, we have to closely look at the time used in each pirep, because some forgets that the timer starts right away or they sometimes have to delay the flight. So a 1 hour trip becomes 1:20 and so on. On a pirep from one of our pilot sent a pirep on 2 hours on a 1 hour flight(Dinner time :lol:)

    2 cents

    I'll send you a mail regarding this an another request I sent earlier this summer.

  10. New pilots can´t register

    in Support Forum

    Posted

    I rather keep recaptha off course, but I think it is kinnda unfair to say it like you do regarding unpro host etc.

    They have solved all my problems so far in a very positive and effective way.

    In this case I just don't know what has happen and neither does my host.

    They also have other customers on the servers who don't have the problem.(not that they are using similar scripts etc)

    It was working excellent until recently, and neither I or host changed anything.

    Only thing we did was to add vacentral to our settings, I tried remove it, but that wasn't the problem.

    I tried getting a new api code from google, but I don't know where to insert the recaptha api code into vms...

    As allways it must be one server that the system needs external connection to witch we don't have set up yet or the ip adress of an existing one has changed.

  12. New pilots can´t register

    in Support Forum

    Posted

    Did you get it fixed?

    We currently have the same prrblem. I think it is related to the reCaptcha. I have talked to the host, but they have no idea what is causing it.

    Is there a way to bypass the reCaptcha and make our own entry question? We tried removing recaptha from the register page, but then nothing will happen when we push register...

  18. Unable to upload all pireps

    in General & Support

    Posted

    We just recently activated vacentral part of this magnificent community.

    At first we had problems exporting to vacentral because our web host have to make an exception to external connections.

    Now that this has been done, sending our schedule did result in success, but trying to send all pireps I get a:

    Sending all PIREPS

    There was an error, server said ""

    And if I try again it will tell me to wait for 8 hours...

    If a pilot logs a flight it will export just fine to vacentral also the live map includes our pilots.

    Our airline is Vacentral Virtual Norwegian

    If anyone have any pointers give me a shout :rolleyes:

    We are currently on build 934, could this be a problem? We have done so many custom stuff to the pages so updating is a pain in the... :D

    Regards,

    Jan Tore

  19. Airport Tables

    in Releases

    Posted

    Yup I would also like to learn about that.

    I guess if I had used similiar php as in the pilot lists for country image it would work, except for that in $pilot->location it is in NO for Norway , SE for Sweden etc, but in $airport->location its in full country name Norway, Sweden.

    Using the ICAO minus the 2 last identifers will not work either because ES in icao dosent meet SE (iso?) like the images are called... :P I guess making all that refers to location country in the same format would have helped?

    Hoping Im just missing a simple solution

  20. [New] vACARS V1.0 Released for Beta Testing

    in Development Help

    Posted

    Just installed / registred to the test site:

    First thoughts:

    Simple layout (simple is often the best)

    I like the different pages, good with timetable search and web browser.

    Chart viewer will be kinda pointless to our airline as long as it is only us airports. We fly only in europe, only flight we have in the US is the delivery flight from Boeing Field :P Maybe a version where we can specify a server for map source? Like if we have maps available from va site or something(yea I know, lots of manual work there...)

    Feature request for down the line:

    To lock fuel/aircraft once the logging has started

    To have a "folder" to point to the schedule briefing for the current flight.(for us that would solve chart issue, give weather info etc as we have some extras to the standard briefing.)

    On admin point of view be able to select either lbs or kg for pireps.

    My impression is that this is a great base to work further on, looking forward to see how it progresses, good luck:)

    Cheers, JT

  23. External connections used by phpVMS

    in Support Forum

    Posted

    Hi folks,

    my web host doesn't allow external databases. But if I knew what connections I need I could maybe get some exceptions(ip addresses or similar)

    Reason for asking:

    some features like Live fuel, doesn't work with our server, and also if we are going to use VAcentral we need a external access.

    Pulling airport data when adding new airports actually works.

    Sorry for my messy post, looking forward for an answer B)

×
×
  • Create New...