New Navdata.db3 - 20120701

[AirNav Development]

An updated navdata.db3 file is now available for download from the link below:
http://www.airnavsystems.com/download/ANRB/DBUpdater/ANRBDBUpdater20120701.exe

Changes:
1) Updated aircraft table;

Again thanks for the volunteers team amazing work.

[CoastGuardJon]

"163320 rows loaded in 372ms"  many thanks to all concerned with these updates.

[pjotrtje]

Thanks!!

[EK01]

Looking for help here guys !

I downloaded the new Navdata file and on going into database explorer and checking the aircraft table, I do indeed have 163,320 aircraft. So far, so good.
However, on checking the routes table in database explorer, I only have 42 routes showing (shock, horror) and even those are not showing fully when I click on aircraft in 'My Flights'. For example, a route which should be Valencia to Palma shows up in the details section next to the photos as being from LEVC to LEPA exactly the same as shown in the 'My Flights' grid. In other words the section next to the photos is not showing the full airport name. On checking the airports table it would appear many of the airports are also now missing including LEMD for Madrid.
Can anyone help in layman's terms with instructions in how to get back to the DB before the latest download or how to retrieve all my routes information as the update has worked for aircraft but seems to have caused a major problem with routes.

Thanks,

Ian

[RodBearden]

Hi Ian

Similar problem with airports - it's not recognising airports like EGLL, KMIA, KLAX etc.

If you didn't do a backup before you did the update, then shame on you ;-)

But all is not lost - the installer program does a backup anyway - you should find in your AirNav RadarBox/Data folder a file called navdata-backup.db3

Just move your current Navdata.db3 file out of that folder and then rename navdata-backup.db3 to Navdata.db3 and all should be well.

If you're using the lovely Navdata Editing Tool, you can use that to play with the different tables and select the ones you want to use - for example keeping all the old tables execept the Aircraft one.

I've asked several times that the updater allows us to choose which tables to update, but so far it's fallen on deaf ears :-(

Rod

[Runway 31]

As far as I am aware Rod the current system cannot do anything apart from update one table update them all, its the way its been since the beginning.

[EK01]

Alan/Rod,

Thanks for that information. I will give all suggestions a go. I will say that according to AN Development message at the start of this topic it, quite clearly states that the update will only make changes to the AIRCRAFT table. Had I been informed that it would have caused all these problems to the routes and airports tables as well, I would not have bothered with the update.

Others, be warned !

Ian

[tommyg]

Think I will delay updating until Development respond to Ian's issues. Don't want to get into the same situation.

tommyg

[Runway 31]

No Ian,  what it states is that the aircraft table is updated.

Nothing has changed with this as since the very first update this has been the case.  If you dont want your routes deleted dont update your aircraft table. 

There is a utility available on the forum as mentioned by Rod which enable individual tables to be amended.

Found it, get it here but have read through the thread to find out how it works http://www.airnavsystems.com/forum/index.php?topic=6631.0

Alan

[knight01]

If I don't want the routes, airports etc. table being affected because I have entered additions or made changes, this is what I always do when a new Navdata file is released.

1. Backup the original Navdata.db3 file
2. Run the new Setup, but change installation path to a place like "C:\Users\Default\Desktop\radarbox" to save the new file.
3. Use SQLmaestro or other database editing tool to open the new Navdata.db3 file.
4. Export the changed Aircraft table from the new database file as Aircraft.CSV.
5. Open the original Navdata.db3 and empty the Aircraft table.
6. Export the Aircraft.csv file you created into the original Navdata.db3 Aircraft table.
7. The other tables will remain unaffected.
8. Close database editor program and copy the original Navdata.db3 back in your radarbox installation directory.

hope this helps

[EK01]

A big thankyou to Alan and Rod. Having carried out their instructions to the letter, I now have the following :

Number of routes in the table : 396,350 (was 217).
Number of airports in the table : 10,779 (was 8114).
Number of aircraft in the table : 109,152 (was 163,320).

The aircraft table has obviously reverted to pre latest download levels. Without encountering the same problems, what is the best way of carrying out the latest download and only having the aircraft table affected or do I just leave things as they are (being computer illiterate possibly the best idea).

Ian

[Runway 31]

If the routes are your main interest I would not update using the Navdata Updater.  You can always use populate to get new aircraft or use the utility details posted previously but not being too computer literate it may be best just to leave things as they are and use populate.

I prefer to have the aircraft and let the system tell me about the routes.

Alan

[EK01]

Cheers Alan.
Much appreciated. I'll just leave things as they are !

Ian

[Hawkeye]

I prefer a regular clear out of the old RB route data because with all the flight number changes the airlines make, especially in spring and autumn, a lot of it is out of date. It doesn’t seem logical to me to keep an outdated  database which could be providing a lot of incorrect information.
As Alan says, the autopopulate facility brings them up to date fairly quickly anyway.
I also run FlightDisplayLite when using RB which also finds quite a lot of current routes which haven’t autopopulated.

It’s obvious though that users should have the choice of updating route data separately, not least to make all the tremendous work people put in to update the aircraft database worthwhile.  Seems pointless them providing updates that people aren’t going to download just because they have to have irrelevant info they don’t want.  Shouldn’t be too difficult to split them surely?

As Ian and Rod point out there’s also a problem with the 20120701 update regarding airports and codes which in my opinion means it is of  little or no use to anybody. The ones that don’t want to update routes won’t be downloading  it anyway and the rest will surely have done as I have and reverted to the previous one, again making the updaters work seem a waste of time and effort. I haven’t downloaded it again to check but presumably as AirNav haven’t said otherwise this problem hasn’t yet been resolved. 

Regards

Syd

[Runway 31]

Syd,

I believe in the past that Airnav have said that the tables cannot be seperated and to have it any different than it is now requires a software re-write hence it will have to stay this way until the next version

The good thing is that there are way round it using the utility detailed above so no one needs to miss out.  I havent seen any mention of airports and codes on the thread.

Alan