Board index FlightGear Development AI Traffic

Simple XLS Traffic File Generator  Topic is solved

Intelligent, computer controlled vehicles that drive/fly over the planet!

Re: Simple XLS Traffic File Generator

Postby gooneybird » Tue May 14, 2013 3:16 pm

You can get a plugin for notepad++ that will do the job for you.
https://code.google.com/p/xpatherizernpp/
My Github repository (mostly AI stuff) https://github.com/gooneybird47
User avatar
gooneybird
 
Posts: 3046
Joined: Sat May 31, 2008 2:57 pm

Re: Simple XLS Traffic File Generator

Postby gooneybird » Tue May 14, 2013 3:26 pm

BecOzIcan wrote in Tue May 14, 2013 12:08 pm:
Transat, China Southern and TAM are valid candidates for me as they use A330s to LFPG.

I Will put this on my Backlog (any preference for the first to deliver?)


Oops I missed this post. I can let you have them in a couple of days.
My Github repository (mostly AI stuff) https://github.com/gooneybird47
User avatar
gooneybird
 
Posts: 3046
Joined: Sat May 31, 2008 2:57 pm

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Wed May 15, 2013 12:58 pm

No worries, awaiting your go ahead
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Sat Jun 08, 2013 4:29 pm

Hi

Existing Traffic Files XLS Ingestor now available for download at http://www.mediafire.com/view/sk69koptd4b4qob/120511_AI_Traffic_File_Ingestor_v0.1.xlsx

Cheers
Ian
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Sun Jul 01, 2018 3:55 am

Latest version ie v0.9 of XLS converter (traffic file generator) available from http://www.mediafire.com/file/w3w82fa6s ... x.zip/file

Cheers
Ian
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby wkitty42 » Sun Jul 01, 2018 8:56 pm

10Q, sir :)
"You get more air close to the ground," said Angalo. "I read that in a book. You get lots of air low down, and not much when you go up."
"Why not?" said Gurder.
"Dunno. It's frightened of heights, I guess."
User avatar
wkitty42
 
Posts: 9148
Joined: Fri Feb 20, 2015 4:46 pm
Location: central NC, USA
Callsign: wk42
Version: git next
OS: Kubuntu 20.04

Re: Simple XLS Traffic File Generator

Postby wkitty42 » Wed Jul 18, 2018 10:22 am

Ian, i broke the sheet again :(

on the AirlineFleet sheet in the workbook, i tried to add in the rest of the performance types so the drop down list on the ICAO sheet would show them for the new craft i was adding but something went wrong and the drop list now only shows "#NAME?"... the range was $V$19..$V$21... i simply extended it to $V$26 but i must have done something wrong... i don't know what...

Code: Select all
turboprop_transport
jet_transport
heavy_jet
light
jet_fighter
ww2_fighter
tanker
ufo
"You get more air close to the ground," said Angalo. "I read that in a book. You get lots of air low down, and not much when you go up."
"Why not?" said Gurder.
"Dunno. It's frightened of heights, I guess."
User avatar
wkitty42
 
Posts: 9148
Joined: Fri Feb 20, 2015 4:46 pm
Location: central NC, USA
Callsign: wk42
Version: git next
OS: Kubuntu 20.04

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Thu Jul 19, 2018 11:00 am

wkitty42 wrote in Wed Jul 18, 2018 10:22 am:Ian, i broke the sheet again :(

on the AirlineFleet sheet in the workbook, i tried to add in the rest of the performance types so the drop down list on the ICAO sheet would show them for the new craft i was adding but something went wrong


Missing Performance Classes added.
V0.91 download link : http://www.mediafire.com/file/ao6ej9mio ... x.zip/file

Cheers
Ian

Image
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby wkitty42 » Fri Jul 20, 2018 8:28 pm

thanks!

now if i can just figure out why the daily xml missed the last 9 flights of 16 flights per day for the last of the 10 craft i have, things may be easier to work out... the last page with all the xml on it only reported #REF! for some 40 lines or so... in any case, i am happy with the workbook... it definitely made it easier for me to work on my fictitious ga airline at KRDU... it also helped me figure a few other things related to AI traffic... i did have to massage a few things in the xml once i wrote it to disk... mainly to add in missing cruise-alt tags (listed as "#N/A" because it couldn't find them in the list i guess) and fix the empty required-aircraft tags when i couldn't select them from the dropdown list... most all of this is likely due to these all being ga craft and i because added them to the end of the list of existing craft...

[EDIT] i forgot that i also had to switch IFR to VFR for these ga guys... at least, that's what i did so anyway :lol: [/EDIT]

all in all, excellent work! i'm really really glad it works in LibreOffice :mrgreen:
"You get more air close to the ground," said Angalo. "I read that in a book. You get lots of air low down, and not much when you go up."
"Why not?" said Gurder.
"Dunno. It's frightened of heights, I guess."
User avatar
wkitty42
 
Posts: 9148
Joined: Fri Feb 20, 2015 4:46 pm
Location: central NC, USA
Callsign: wk42
Version: git next
OS: Kubuntu 20.04

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Sat Jul 21, 2018 1:51 am

wkitty42 wrote in Fri Jul 20, 2018 8:28 pm:if i can just figure out why the daily xml missed the last 9 flights of 16 flights per day for the last of the 10 craft i have, things may be easier to work out... the last page with all the xml on it only reported #REF! for some 40 lines or so...


Best troubleshooting approach :

1. In XML FILE Tab : Unlikely to be the source of error given a single formula applies everywhere from Cell A3 down but just to be on the safe side, Grab cell A3 and copy down all the way to the end of your data.
2. If issues remain (#REF reappears on recalculation : Grab the problematic Flight Number then
3 in AirlineSchedule, locate the row where the flight is listed, look at the flight counter in columns AH-AO; this one counts incrementally, line after line the number of flights per day type. (See attached image, last line of the counter indicates total number of flights per day and you can see how the counter increments with each line)
4. If broken (shows #REF inside), same approach, copy down formulas from AH4-AO4, per column
5. Look at columns AS-AZ where each flights's xml is formed. you flight should be in there (one column per day type)
6. Same Same, if broken, copy down formulas from AS4-AZ4
7. Always ensure you have no empty rows in your flight data (Columns B to X) which would break the counter). You can sort flights within the Columns A to X area but do NOT grab any data right of column X in any sorting or you will break the formulas)

Cheers
Ian

Image
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby wkitty42 » Sat Jul 21, 2018 2:51 am

thanks for this! i'll get back... i definitely do have empty lines between my flights so i could easier see them when i was copying them and adjusting them for the schedule for the new craft... there's a 6 minute difference between each craft's departure time... i'm going to add two more craft which will drop that to 5 minutes between each one... i put the blank line so i could easily see when i was in one craft's schedule and another's...

as i recall, the count was correct... 160 flights for the airline per day... 10 craft with 16 flights per day comes out right...

the main thing is i didn't find those sections of code waaaaay over there... i thought i had but apparently i missed something... anyway, i'll play with this and see if i can figure it out more :)
"You get more air close to the ground," said Angalo. "I read that in a book. You get lots of air low down, and not much when you go up."
"Why not?" said Gurder.
"Dunno. It's frightened of heights, I guess."
User avatar
wkitty42
 
Posts: 9148
Joined: Fri Feb 20, 2015 4:46 pm
Location: central NC, USA
Callsign: wk42
Version: git next
OS: Kubuntu 20.04

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Mon Jul 23, 2018 1:50 am

Fixed the issue with HEAVY Aircraft Tag taking Yes/No. now forced to true/false) values

Updated Download Link http://www.mediafire.com/file/dptv98qr7 ... x.zip/file

Cheers
Ian
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby SP-KOK » Mon Jul 23, 2018 8:00 am

Shit
that's how many xml files look like. has the same Yes or NO error
Examples:
ACA.xml
ABW.xml
AAR.xml
ACI.xml
AFL.xml

And many more from the entire list.
these are examples from item A
SP-KOK
 
Posts: 679
Joined: Tue Feb 02, 2016 6:04 pm

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Mon Jul 23, 2018 8:58 am

SP-KOK wrote in Mon Jul 23, 2018 8:00 am:Shit
that's how many xml files look like. has the same Yes or NO error
And many more from the entire list.
these are examples from item A


Don't worry, from the AI documentation : "<heavy> Can be true or false. Reserved for future use by ATC, to determine whether the postfix "Heavy" should be appended to the aircraft's callsign"

So no urgency in fixing as it does not look like it would likely impact performance/functionality. We just need to keep an eye on it for our next traffic updates. I only did the two changes mentioned in the forum because I was still testing the files.

Sorry I guess introduced the issue with the us of my xls sheet .... but no one noticed either :-)

Cheers
Ian
Current Projects: AI Traffic, Models & Liveries
User avatar
BecOzIcan
 
Posts: 1302
Joined: Tue Oct 04, 2011 11:43 pm
Location: Sydney, NSW, Australia
Version: 2020.4.0
OS: Win10

Re: Simple XLS Traffic File Generator

Postby wkitty42 » Mon Jul 23, 2018 7:21 pm

SP-KOK wrote in Mon Jul 23, 2018 8:00 am:that's how many xml files look like. has the same Yes or NO error

that's easy to fix by massaging the xml file... a manual search and replace is the easiest... a scripted method using sed is the next easiest...

FWIW: here's a list of the 62 traffic files that are currently affected...

Code: Select all
cd ~/flightgear-dev/fgdata-ng/AI/Traffic
$ find . -type f -name *.xml -exec egrep -Hin -e "<heavy>(no|yes)</heavy>" {} \; | cut -d "/" -f 3 | cut -d ":" -f 1 | sort | uniq

AAR.xml
ABW.xml
ACA.xml
ACI.xml
AFL.xml
AHY.xml
AIC.xml
AJA.xml
ALK.xml
AMC.xml
AMX.xml
ANG.xml
ANT.xml
ANZ.xml
ASL.xml
AUL.xml
AVJ.xml
AVN.xml
CAL.xml
CLU.xml
DAH.xml
EIN.xml
ELY.xml
FIN.xml
FJI.xml
GFA.xml
HAL.xml
HVN.xml
IBE.xml
IBS.xml
JAL.xml
KAC.xml
KAL.xml
KLM.xml
MAU.xml
MDG.xml
MEA.xml
OMA.xml
PAL.xml
QFA.xml
RAM.xml
RBA.xml
RLU.xml
RON.xml
RXA.xml
RXP.xml
SAA.xml
SBI.xml
SVA.xml
TAM.xml
TAR.xml
TGW.xml
THA.xml
THT.xml
THY.xml
TPC.xml
TUX.xml
TVS.xml
TYA.xml
UAE.xml
VTA.xml
WRC.xml
Last edited by wkitty42 on Mon Jul 23, 2018 7:26 pm, edited 3 times in total.
"You get more air close to the ground," said Angalo. "I read that in a book. You get lots of air low down, and not much when you go up."
"Why not?" said Gurder.
"Dunno. It's frightened of heights, I guess."
User avatar
wkitty42
 
Posts: 9148
Joined: Fri Feb 20, 2015 4:46 pm
Location: central NC, USA
Callsign: wk42
Version: git next
OS: Kubuntu 20.04

PreviousNext

Return to AI Traffic

Who is online

Users browsing this forum: No registered users and 2 guests