AirNav Systems Forum

AirNav Radar => AirNav Radar Discussion => Topic started by: Rockeyes on May 06, 2008, 07:13:01 AM

Title: Missing flight information?
Post by: Rockeyes on May 06, 2008, 07:13:01 AM
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?
(http://i74.photobucket.com/albums/i264/gransden/Fltinfo.jpg)
Title: Re: Missing flight information?
Post by: AirNav Support on May 06, 2008, 07:52:12 AM
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.
Title: Re: Missing flight information?
Post by: jgrloit on June 16, 2008, 02:45:20 PM
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?
Title: Re: Missing flight information?
Post by: Allocator on June 16, 2008, 03:10:28 PM
Quote from: jgrloit on June 16, 2008, 02:45:20 PM
Which table contains this information?

It is the routes table of the NavData.db3 database

QuoteIs 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.

QuoteIf 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

QuoteHow 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.
Title: Re: Missing flight information?
Post by: malcdee2001 on June 16, 2008, 09:02:33 PM
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