XML Data I'd like to see

[RayShaffer]

I've been looking through the XML data and trying to figure out some recognition tables I could create.  I'd like to see some a list of flights made per pilot/Gross income/aircraft flown/flight time.  This data would help out considerably for determining Gross Income generated per pilot, who flew the most time in which aircraft and who made the longest flight in the month.

Unless there is another way to pull it.

[VAFS001]

You can pull the callsign out of the the flights XML. If you can put all the callsigns in an array and then parse the flights like that it should work.

Mike

[RayShaffer]

Is this applicable to just the active flights or does it apply to all flights.  In the PDF there is no reference to flights xml, only routes and active flights.  I'm looking for a list of all flights ever taken.

Ray

[VAFS001]

Hmmm, thought I put the flights out too. If not I will create that one.

Mike

[RayShaffer]

Will this include flight details as in this file:

http://www.vafinancials.com/vadata/flight_details.php?id=XXXX

If so, that'd be awesome.  I know that would be lot of fields and a lot of data to pull, but definitely worth it.  If not, that's cool too.

Thanks!

[VAFS001]

I am actually thinking there will be two ways of doing it.

Yes there are believe it or not about 51 fields for each flight. (I track a lot of information including all the financial data for the flight) and those do take a while to load. BUT I am now using something simular for the client that loads limited information, about a quarter of that.

What I could do and what I am planning on doing is having the option to have each flight uploaded in some type of format to the VA's own server via FTP. (The VA would have to setup a FTP account for their pilots to enter that information into the new VAFS client.) Then have an XML with limited data and a link to that filename in that data. So if the VA wanted to display flight data for each flight, the link to the file would be available to show the whole pilot log and flight information that is right on their server.

Mike

[RayShaffer]

How often would the data be updated to the VA's ftp?  The thing I love about XML is its dynamic and probably is pulled straight from the database (I'm assuming), whereas with a text file, or whatever you decide, would be static and the data would not be refreshed until the push from your server.   

Just a thought...

Ray

[VAFS001]

The flights XML would be dynamic. In the XML would be a tag to the filename that was uploaded to the VA's ftp. All you would have to do is take that filename and grab the file from your own web server host whereever it was uploaded to display all the data from that flight.


That way instead of 51+ fields for each flight there would only be about 18 and then you grab the rest of the information from that file. I will have an example when I get to that point to see what I mean.

Mike

[RayShaffer]

That would be awesome.  What your eta for completing the XML?

[VAFS001]

No ETA but it will be part of this new client. The flight upload would be the last item to code.

[RayShaffer]

Great!  The new client looks so sweet.  Thanks for all the hard work.  It looks beautiful and I can't wait to use it.

[tomarild]

I would love to see XML data for:


Pilots salary
Pilots HUB
Pilot since (date)
Promotion dates for pilot
Status (Active, vacation etc)
Age

[VAFS001]

Pilots salary: Will be in the rank XML.
Pilots HUB: Is in the roster xml as "hubid", just have to link it to the hub xml.
Pilot since (date): That is in the new pilot table and roster and should be in the new pilot xml.
Promotion dates for pilot: Not anywhere at this time.
Status (Active, vacation etc): In the pilot xml
Age: I did not take information for age at this time but it will be in the pilot profile section of the pilot center.

Mike

[tomarild]

Pilots salary: Will be in the rank XML.

In the upcoming verison? I cannot find any rank xml.

Pilots HUB: Is in the roster xml as "hubid", just have to link it to the hub xml.

Hm. How can I combine a pilots name and the HUB he is connected to?

Pilot since (date): That is in the new pilot table and roster and should be in the new pilot xml.

In my  new pilot xml I can only find Pilot callsign, name and flag (?)

Pilot since (date): That is in the new pilot table and roster and should be in the new pilot xml.

In the pdf-file I have, I cant find any pilot.xml. Have you released a new one? In that case... where can I find it?


Thanks for helping Mike. I am spending a lot of time setting up my VA these days, and I love that you respond so fast. I cant wait to invite my first new pilot. Im planning on starting with just two planes and a handful of routes, and build the VA in the most realistic way.

[VAFS001]

I will release the link to the xml files in each section of VCAS. When you go to hubs for example, there will be a link in the setup add on section that will point to your hub xml file.

I have not set that up yet but it is not hard to do.

The new xml files will be different than the old xml files.

Mike