[latest new] Exporting flight log online to VA

[DanSteph]

Webmaster of VA see more info inside at bottom.


[edit] you can download the php/sql script, see the "tool section" of download.
http://www.fspassengers.com/?action=down...rchtype=Id

So if your VA admin give you a litle cfg file to put in a FsP folder
you have one more menu that appear "Virtual Airline"

Here I have two VA set, "VaFsPassengers" and "Virtual Pilot Group"




For test the first one attempt to connect to this site but there is nobody that
answer (the requested file is not found)



If the site reply Ok you can now export your flight log to your Virtual Airline:




Inside Code, More infos

For webmaster the file that you must provide to each members
is really simple: ("anyname.cfg" go into "config_va" folder)
------------------------------------------------------------------------------------
menu_name=Virtual Pilot Group;
base_url=http://www.fspassengers.com;
path_stats=pageofstats.php;
path_export=getflight.php;
username=visitor;
password=test;
------------------------------------------------------------------------------------


After that FsP use POST http request so you can do whatewer you want at the other side
PHP/ASP etc etc.... any script that can understand form POST (html, php, asp etc etc)

the format will be open and documented

[edit] [... sniped the outdated info]



Post Edited ( 08-06-05 02:06 )

[DanSteph]

Outdated info...

The idea remain the same but it's more complex now...
You can setup you units when FsP connect to your site
and FsP send you the correct unit....

something like that (it will change again)

Code:

[FsPAskToRegister] => yes
    [UserName] => visitor
    [Password] => test
    [CompanyName] => World Travel
    [PilotName] => John Doe
    [FlightId] => JA191
    [OnlineNetworkNbr] => 0
    [DateDay] => 21
    [DateMonth] => 5
    [DateYears] => 2005
    [AircraftName] => crj700frt45
    [AircraftType] => MEJ
    [NbrPassengers] => 35
    [CargoWeight] => 5444 kg
    [Mtow] => 34132 kg
    [StartAircraftWeight] => 32367 kg
    [EndAircraftWeight] => 31534 kg
    [StartFuelQuantity] => 4660 kg
    [EndFuelQuantity] => 3804 kg
    [DepartureIcaoName] => EDDF - Frankfurt Main - Germany
    [ArrivalIcaoName] => LSZH - Zurich - Switzerland
    [DepartureLocalHour] => 13h41
    [ArrivalLocalHour] => 14h12
    [DepartureGmtHour] => 11h41
    [ArrivalGmtHour] => 12h13
    [TotalBlockTime] => 00h30
    [TotalBlockTimeNight] => 00h00
    [TotalAirbornTime] => 00h28
    [TotalTimeOnGround] => 00h02
    [MaxAltitude] => 21092ft
    [CruiseSpeed] => 405 kt
    [CruiseMachSpeed] => 0.62
    [CruiseTimeStartSec] => 636
    [CruiseTimeStopSec] => 1237
    [CruiseFuelStart] => 4134 kg
    [CruiseFuelStop] => 3953 kg
    [LandingSpeedKts] => 113 kt
    [LandingPitch] => 4.94
    [TouchDownVertSpeedFt] => -172
    [CaptainSentMayday] => 0
    [IncidentText] => 0
    [CasualtiesText] => 0
    [PilotPointsText] => 0
    [PassengersOpinionText] => 0

[VOZ_JLC]

Awsome work guys im a manager of our Australian VA myself and this feature is nothing short op TOP CLASS!
I'll be sure to strongly recommend this add on to all my pilots and those i come across!!
BRILLIANT!!

Feel free to check us out @ http://www.angelfire.com/oz2/vozflight/
Thanks Josh C (VOZ_JLC Hub manager of Virual Oz Flight)

[DanSteph]

I see that you have somes financial income ?

What is nice with the FsP system is that you can mix the data in any way you want, ignore
those that you don't want and record in Db and present the one you need in any form...

Some may ignore the penality text, point or passengers advice (pure flight log)
while some might preffer to record all...

Second things that is nice everyone is able to deal with POST data...
the script that receive them make 10 lines... this make FsP compatible
with any code...

Dan

[Shandon]

We where just talking about this on our V.A. forum...If it (Fsp) would work with our airline...Simply wonderful

[StephanP]

Just wanted to be clear about the Host site, is this assuming that the VA runs MySql, or MS Access etc.,

Cheers

[JayKae]

Hey Shandon ;P

[DanSteph]

StephanP wrote:
Just wanted to be clear about the Host site, is this assuming that the VA runs MySql, or MS Access etc.,

In fact with this POST method you can even do a basic script that simply write the data in a file
that you can view with another page...

If you can do something with form data as below:

<form action="http://server.com/getflight.php" method="POST">
Enter cargo weight <INPUT type="text" name="CargoWeight"><BR>
Enter MTOW <INPUT type="text" name="Mtow"><BR>
Enter aircraft name <INPUT type="text" name="AircraftName"><BR>
Enter aircraft start weight <INPUT type="text" name="StartAircraftWeight"><BR>
Enter aircraft end weight <INPUT type="text" name="EndAircraftWeight"><BR>
Enter departure ICAO <INPUT type="text" name="DepartureIcaoName"><BR>
Enter arrival icao <INPUT type="text" name="ArrivalIcaoName"><BR>

..... etc. etc.

<INPUT type="submit" value="Send"> <INPUT type="reset">
</form>

FsP do exactly the same then this form: it send POST data to the script in "form action"
so the script can be cgi, java, asp, php or whatewer that is able to take post data and write them
at any place. My personnal preffered method is of course PHP and SQL base as you can do
something really nice.

At worse you can do a basic script that write the data in a text file, but this would be uggly of course...
FsP will be provided with basic chunk of PHP to record the data in a SQL table...
At worse the format of what send FsP will be fully documented and open...

Dan



Post Edited ( 05-23-05 15:29 )

[DanSteph]

Success !! First flight registred in a SQL database...


For those that know SQL here is how the flights table look... not a tiny one

Code:

CREATE TABLE flights (
  id int(16) unsigned NOT NULL auto_increment,
  datestamp datetime NOT NULL default '0000-00-00 00:00:00',
  UserName varchar(22) NOT NULL default '',
  CompanyName varchar(35) NOT NULL default '',
  PilotName varchar(35) NOT NULL default '',
  FlightId varchar(10) NOT NULL default '',
  OnlineNetworkNbr tinyint(4) NOT NULL default '0',
  FlightDate date NOT NULL default '0000-00-00',
  AircraftName varchar(50) NOT NULL default '',
  AircraftType varchar(5) NOT NULL default '',
  NbrPassengers smallint(2) NOT NULL default '0',
  CargoWeight varchar(15) NOT NULL default '',
  Mtow varchar(15) NOT NULL default '',
  StartAircraftWeight varchar(15) NOT NULL default '',
  EndAircraftWeight varchar(15) NOT NULL default '',
  StartFuelQuantity varchar(15) NOT NULL default '',
  EndFuelQuantity varchar(15) NOT NULL default '',
  DepartureIcaoName varchar(50) NOT NULL default '',
  ArrivalIcaoName varchar(50) NOT NULL default '',
  DepartureLocalHour time NOT NULL default '00:00:00',
  ArrivalLocalHour time NOT NULL default '00:00:00',
  DepartureGmtHour time NOT NULL default '00:00:00',
  ArrivalGmtHour time NOT NULL default '00:00:00',
  TotalBlockTime time NOT NULL default '00:00:00',
  TotalBlockTimeNight time NOT NULL default '00:00:00',
  TotalAirbornTime time NOT NULL default '00:00:00',
  TotalTimeOnGround time NOT NULL default '00:00:00',
  MaxAltitude varchar(15) NOT NULL default '',
  CruiseSpeed varchar(15) NOT NULL default '',
  CruiseMachSpeed varchar(15) NOT NULL default '',
  CruiseTimeStartSec time NOT NULL default '00:00:00',
  CruiseTimeStopSec time NOT NULL default '00:00:00',
  CruiseFuelStart varchar(15) NOT NULL default '',
  CruiseFuelStop varchar(15) NOT NULL default '',
  LandingSpeed varchar(15) NOT NULL default '',
  LandingPitch varchar(15) NOT NULL default '',
  TouchDownVertSpeedFt float NOT NULL default '0',
  CaptainSentMayday tinyint(3) NOT NULL default '0',
  CrashFlag tinyint(3) NOT NULL default '0',
  FlightResult varchar(15) NOT NULL default '',
  PassengersOpinion tinyint(4) NOT NULL default '0',
  PassengersOpinionText text NOT NULL,
  FailureText text NOT NULL,
  CasualtiesText text NOT NULL,
  PilotBonusText text NOT NULL,
  BonusPoints int(10) NOT NULL default '0',
  PilotPenalityText text NOT NULL,
  PenalityPoints int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY datestamp (datestamp),
  KEY UserName (UserName),
  KEY CompanyName (CompanyName),
  KEY PilotName (PilotName),
  KEY AircraftName (AircraftName)
) TYPE=MyISAM;

[DanSteph]

Basic PHP/SQL script done, you will be able to download it for your website,
it's very simple to use and very clear given that your site have PHP/SQL abilities
and that you are able to tune a bit PHP to make nice report...

The admin part can even create the SQL table for you so making your site
able to receive FsP flights log is a matter of minutes...

See : http://www.fspassengers.com/?action=va

Dan

[VOZ_JLC]

Woooooowwwww!!!!!!! guys this just seems to be getting better and better each day i read a "post" AWSOME work
I fyou guys are into making scenery, with your proven efforts shown here, You's should look in to
making a complete scenery package for Australia as the JUNK out now is not of any decent standard at
all...

Any ways thanks for your time
Josh C, VOZ_JLC Hub manager @ http://www.angelfire.com/oz2/vozflight/

[StephanP]

Hi All

I have tried and tested the Scripts for the receipt of Files from FSP into the SQL database, and it works like a dream, I have also tried this
same routine on my SQL Server (7/2000 etc.,) and the script just needed a little tweeking but worked fine.

For those that don't have SQL on there hosted servers I have started to write another routine to accept MDB's.

Dan, if you are reading this then perhaps you could reply to my recent email about Software.......

Cheers

BTW., the Section for adding Users is not working, manual input into the table works ok, so will be working on that, unless you have
some updated scripts that you can hand over.

Steph

[DanSteph]

StephanP wrote:
Dan, if you are reading this then perhaps you could reply to my recent email about Software.......

Hello Steph, sorry I've been busy like hell last hours, I'll reply soon to your mail...

Dan

[StephanP]

DanSteph wrote:

StephanP wrote:
Dan, if you are reading this then perhaps you could reply to my recent email about Software.......

Hello Steph, sorry I've been busy like hell last hours, I'll reply soon to your mail...

Dan

Thank you. Brillant work btw., (yeah I know I am sucking up a bit here, but it don't hurt)

[DanSteph]

no problem

Dan