Board index FlightGear Development AI Traffic

Simple XLS Traffic File Generator  Topic is solved

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

Simple XLS Traffic File Generator  

Postby BecOzIcan » Tue May 07, 2013 12:55 pm

G'day

I have put together a traffic file generator running on Excel for those of us Non Developers who still want to populate airports with a bit of activity.

EDIT: By default, the sheet allows you to handle 200 Aircraft and 300 Flights, per Airline. This can be extended, based on your machine capabilities (potentially slower response times).
EDIT: The Workbook handles only WEEK Repeats

The file includes 3 sheets to be filled in order
1/ Airline Details (Cover)
2/ Fleet (AirlineFleet)
3/ Flights (AirlineSchedule)


and one sheet (XML) to collect your traffic file.

Other Tabs are filled with reference IATA/ICAO tables allowing control of your entries and the creation of sane Traffic files. This worksheet does not allow you to ingest existing traffic files but I will soon start work on this functionality

Use should be self explanatory if you follow the instructions included. In case of trouble and depending of your understanding of Excel functions, you can unhide columns/rows and try to fix it or post a message here

Download is available HERE

Feedback welcome

Ian
Last edited by BecOzIcan on Sun Apr 24, 2016 3:02 am, edited 5 times in total.
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 Hooray » Tue May 07, 2013 2:12 pm

Hi, please feel free to add your project to the upcoming newsletter (see my signature).
Please don't send support requests by PM, instead post your questions on the forum so that all users can contribute and benefit
Thanks & all the best,
Hooray
Help write next month's newsletter !
pui2canvas | MapStructure | Canvas Development | Programming resources
Hooray
 
Posts: 12707
Joined: Tue Mar 25, 2008 9:40 am
Pronouns: THOU

Re: Simple XLS Traffic File Generator

Postby gooneybird » Thu May 09, 2013 9:36 am

This is well timed we are currently updating the traffic files to include the newer AI models/liveries and converting the aircraft radii to the latest figures on the wiki.

http://wiki.flightgear.org/Aircraft_radii
http://www.flightgear.org/forums/viewtopic.php?f=23&t=19421
http://www.flightgear.org/forums/viewtopic.php?f=23&t=14232

I have not tried it yet but it does load into Libre Office with no problems.
A nice tool and will be even better when it's able to open existing traffic files. :D

Are you doing doing any traffic files yourself, If so can let us know what ones and whether you need any new liveries for them as we are also updating many models and liveries.
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 qf707 » Fri May 10, 2013 5:54 am

Unfortunately on my Libre calc on Ubuntu 12.04LTS it locks up Libre office and I can not shut my computer down short of a hard reboot.
It gets about one third the way through loading and locks up.

Cheers
qf707
qf707
 
Posts: 135
Joined: Sun Feb 21, 2010 4:28 am

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Fri May 10, 2013 3:13 pm

Thanks for the messages. Will try to start work on Existing files ingestion next week. Fleets should be easy enough, have to put a bot more thinking into flights

@gooneybird, I am in the process of creating traffic files required for handling current movements at LFPG. Already started ALK but realized I need to update/add aircrafts & liveries as I go so it's a pretty slow process.

I couldn't find a repository for updated AI Aircrafts/Liveries and rely only on the ones available as part of FGFS' main program download, Is there a plan to set up a download page/site specifically for AI ? (Aircrafts, Liveries and Traffic)

Cheers
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 gooneybird » Fri May 10, 2013 8:48 pm

BecOzIcan wrote in Fri May 10, 2013 3:13 pm:
@gooneybird, I am in the process of creating traffic files required for handling current movements at LFPG. Already started ALK but realized I need to update/add aircrafts & liveries as I go so it's a pretty slow process.


Please keep us updated on what models/liveries you are adding as we are replacing some of the models with newer versions, at the moment we have a new A320 and working on A330 and A340 so It may be best to avoid them until we can release them, paint kits will also be available for them.

New A330-200
Image

I couldn't find a repository for updated AI Aircrafts/Liveries and rely only on the ones available as part of FGFS' main program download, Is there a plan to set up a download page/site specifically for AI ? (Aircrafts, Liveries and Traffic)


The only other place they are available from is GIT but there is not much more there than what is available in 2.10. If you have AI stuff that you want included in the program you can send them to Durk he handles the AI side of things.

As It seems several people are now creating new traffic files It may be worth starting another topic listing who is doing what so you don't duplicate your efforts.
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 » Sat May 11, 2013 3:39 am

Good call here Gooneybird. Too bad my A332 ALK was almost complete :-)

I ll start work on the Traffic File Ingestor now. Will also try to optimize the XLS Worksheet as I understand its current size would be a problem for some users> Will keep you posted here
Last edited by BecOzIcan on Sun Jul 07, 2013 3:39 am, edited 1 time in total.
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 May 11, 2013 12:21 pm

Work Started on Ingesting Existing Traffic Files, Fleet Ingestion [Beta] Completed
Last edited by BecOzIcan on Sun Jul 07, 2013 3:39 am, edited 1 time in total.
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 Gijs » Sat May 11, 2013 12:28 pm

Just to be sure, you are aware of the scripts in https://gitorious.org/fg-ai-flightplan and https://gitorious.org/trafficgear/trafficgear ? I think it would be good to concentrate the efforts on a single system. You should definitely talk to Adrian and/or Durk.
Airports: EHAM, EHLE, KSFO
Aircraft: 747-400
User avatar
Gijs
Moderator
 
Posts: 9544
Joined: Tue Jul 03, 2007 3:55 pm
Location: Delft, the Netherlands
Callsign: PH-GYS
Version: Git
OS: Windows 10

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Sat May 11, 2013 12:48 pm

Hey Gijs. No experience with GIT. Is there already a program in place to ingest/generate traffic files? how do I retrieve it from GIT? (Win7 machine)

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 qf707 » Sun May 12, 2013 1:01 pm

BecOzican are you working on Srilankan traffic.I have the start of a file for traffic into Singapore but if you have a more advanced file then I will go no further.

Cheers
qf707
qf707
 
Posts: 135
Joined: Sun Feb 21, 2010 4:28 am

Re: Simple XLS Traffic File Generator

Postby BecOzIcan » Sun May 12, 2013 3:39 pm

Hey Qf707,

Yep completed fully owned fleet and 19 destinations out of VCBI today. Another 13 to finish outbound. Once inbound done as well I will post a topic. More or less another week to go.

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 gooneybird » Tue May 14, 2013 11:14 am

Here's a collection of the new A330-200 plus a paint kit, If you are doing any liveries for it can you please let us know what ones you going to do.
http://www.mediafire.com/download.php?e7n47q8s2ns7vzs

These have been created already:
Code: Select all
Aer Lingus   
Air France
Air Mauritius
Alitalia
China Eastern Airlines
Emirates Airline
Etihad Airways
Garuda Indonesia
Jet Airways
KLM
Korean Air
Qantas
Qatar Airways
South African Airways
SriLankan Airlines
Virgin Australia


These are on my todo list:
Code: Select all
Air Berlin
Air China
Air India
Air Transat
bmi - British Midland
Brussels Airlines
China Southern Airlines
Delta Air Lines
Malaysia
TAM
TAP
Vietnam Airlines


Image
Ignore the cartoon trees that was a moment of madness :shock:
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 » Tue May 14, 2013 12:08 pm

Thanks a lot for the files, much appreciated

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?)

Looking at delivering Mid June as I really want to complete my Existing Traffic File Ingestor before that ;-)

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 » Tue May 14, 2013 2:42 pm

Advice Welcome...

I just realized the file I am generating to be saved as Traffic XML in Notepad++ does not include TAB indent.
Not being a Dev, I looked up on the web and understand the only purpose of indenting is to make the code readable.

If needed/requested I will include the feature in my next release but advice on the need to do that is welcome

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

Next

Return to AI Traffic

Who is online

Users browsing this forum: No registered users and 5 guests