Missing flight information?

[Rockeyes]

Most flights seem to have the departure and arrival information missing. Is it a problem with my settings or is anyone else seeing the same thing?

[AirNav Support]

Its not a problem :)

The aircraft do not send there route information. RadarBox trys to derive this from its Flight Number via a Flight Database.

However the Flight Database has 100,000 entries it does not cover all of the routes in the world (which is impossible as they change so much)

We are looking into alternatives for future versions.

[jgrloit]

Which table contains this information?

Is it possible to sort the table?

If I update the data for EGNT flights how can I propogate this to other users?

How can I copy data from the database tables to the Windows scratch pad for onward copy to other files, programs or messages?

[Allocator]

Which table contains this information?

It is the routes table of the NavData.db3 database

Is it possible to sort the table?

Yes, just click on the column title bar in the Database Explorer - the actual sort can take some time due to the number of records.  It will look like it has frozen, but just give it time.

If I update the data for EGNT flights how can I propagate this to other users?

Just give them a list of the routes as a txt file

How can I copy data from the database tables to the Windows scratch pad for onward copy to other files, programs or messages?

You can't do this with the Database Explorer.  You will have to use an external SQL program and produce an SQL query then export the results.  There is no easy way to get these records back into another version of NavData.db3 without using such a program to import the records.

You could send the other users your whole NavData.db3 file, but then they would loose whatever aircraft details they had autopopulated.

If you do decide to play around with your database files, do make a backup first as it is very easy to corrupt SQL files.

[malcdee2001]

I have had this problem before as mentioned in previous posts. Even when the information is in the database, it does not always show up on the list. I have spent hours of listing flight numbers and converting them to origination and destination airports and entering them into the data base, some show up some don't. Some show next time you use the RB, others go missing. I have found that if the information is in the data base, you cannot re-enter that information. Again having listed the flight number and found out the relevent information only to find it is already entered but not showing can be annoying at times.

Malc