Routes database .csv file

[knight01]

I've made a .txt and .csv file for some of the alphanumeric Heathrow flights.  I got the data from this thread: http://www.airnavsystems.com/forum/index.php?topic=5190.0

and ACARS log from here:
http://www.lhr-lgw.co.uk/heathrow%20main.html

Most of the alphanumeric callsign flights are included (BMA,BAW,VIR,SWR,DLH, etc).  If any are missing, please add them to the list and post the file.

Somebody mentioned in the above referenced thread, the .csv file can be imported into the NavData.db3 using SQLmaestro.  Backup your original file before modifying.

[tarbat]

Somebody mentioned in the above referenced thread, the .csv file can be imported into the NavData.db3 using SQLmaestro.

Note that you can also use the SQLite command line interface to import CSV files.

Create a file called routes.csv, containing data in this format:
AEE602,LGAV,EGLL,,20100708090000
AEE603,EGLL,LGAV,,20100708090000

Run the sqlite command line
P:\AirNav Systems\AirNav RadarBox>sqlite3 data/navdata.db3
SQLite version 3.6.23.1
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .separator ","
sqlite> .import routes.csv routes
sqlite> .exit

[BlinkNFG]

Hi,

I just tried to import the routes using both TkSQLite and sqLite 3 but I get a "FN is not unique" error each time.  Will it not work if I have some of the flights already?

Any help appreciated.

thanks

Jon

[tarbat]

Did you try the command line interface?

[BlinkNFG]

Hi,

Yeah I tried that - it came up with the same message.

In the end I imported airline by airline - deleting the current entries before importing the new.  I got the info from libhomeradar and it has made a big difference - I now have a LOT more route info (esp alpha-numeric callsigns)

Jon



It has made a big