Find attached Flybe summer callsigns with route tie ups
Thanks for posting that spanman. Just spent the afternoon creating a spreadsheet to convert 3-letter IATA code to 4-letter ICAO code and full airport description for all FlyBe's destinations.
Intention was to enter all decoded routes into my database - far too ambitious!
Wow - until this little exercise, I had no idea how many detinations FlyBe served - just shy of 70 in my little spreadsheet - unless I've missed any!
May just enter the BHX flights into my database - don't want to enter anymore if next upgrade is going to over-write them!
For other flights, I will just have your PDF file running in the background and use the search facility of Adobe Reader.
Attach PDF of FlyBe destinations - sorted by IATA code - can't get Exeter into correct order for some reason!
Pinza - tarbat developed a simple little SQL routine that allowed the import of the routes into the database.
You just need to save your spreadsheet in a specific text format and then import it
Thanks for the post spanman. The attached CSV contains the same data in a format that can be imported into the routes table using a SQLite database utility such as SQLiteMaestro.
Perhaps someone can check that I've done the conversions correctly. For me it added 563 new routes, and updated 137.
Perhaps Tarbat could spell it out for us numpties, slowly and in small words please,so we can input it to the right place.
:-)
Dave.
Quote from: anorak on April 21, 2011, 05:08:25 PMPerhaps Tarbat could spell it out for us numpties, slowly and in small words please,so we can input it to the right place.
If you're not familiar with an SQLite database utility, then I wouldn't recommend trying it. Maybe Airnav can import these routes into their central routes database?
I`ll go with your recommendation, how about it Airnav, if we ask nicely?
Its on the list of things to do.