AirNav Systems Forum
AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: AirNav Development on July 02, 2012, 08:45:04 PM
-
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.
-
"163320 rows loaded in 372ms" many thanks to all concerned with these updates.
-
Thanks!!
-
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
-
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
-
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.
-
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
-
Think I will delay updating until Development respond to Ian's issues. Don't want to get into the same situation.
tommyg
-
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
-
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
-
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
-
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
-
Cheers Alan.
Much appreciated. I'll just leave things as they are !
Ian
-
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
-
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
-
Hi Alan, thanks for your reply.
Ian raised the airports and codes matter in reply #3, and in #4 Rod confirmed he had the same problem.
I assume you installed the update and if so, it seems odd you didn't get the same result.
If you didn't, just to clarify, - In the From and To lines in the bottom panel, some flights were showing both airport name and ICAO code, but the majority, no airport, just the code.
I'm sure the editing tool Rod mentions is great, but, like Ian, I think I'll leave it alone, when I mess with such things something generally goes wrong :-)
Pity I won't be able to take advantage of you and the team's Aircraft updates though if the prob isn't put right, which I consider whoever produced the update should do.
Syd
-
Thanks Syd, I missed those replies and therefore had missed the nature of the problem being experienced. I will ask Airnav what they have been up to as something appears to have gone ammis in the creation of the Navdata. As you can see from the opening of the thread the only change was to the aircraft table but evidently not
Alan
-
Syd,
I got into one heck of a mess downloading the latest 'aircraft' update and it was only through the help of Alan and Rod that I managed to get back to pre download status. I agree that it is a shame that the immense work being down by the updaters team is not being fully appreciated due to the problems that the downloads are causing to the airports and routes tables. I also do not consider myself to be computer savvy enough to be able to handle additional utilities, SQlite, etc in order to work around the problem. No more update downloads for me until this is sorted !
Ian
-
Ian,
My apologies as I somehow missed from your initial reply that airports were missing from the Navdata and didnt also appreciate that the routes were missing as well. Airnav have been advised and we await their response. Hopefully we shall here from them soon.
Alan
-
Cheers Alan.
Ian
-
Hi Ian,
I see from one of your previous posts that you are a bit apprehensive about using 3rd party utilities to edit your NavData.db3 file. It is for this exact reason that the NavData.db3 Editing Tool was created by my colleague and I specifically for people like you (and me). I am also not IT savvy and so when we produced the Tool that allows you to edit in the comfortable environment of MS Excel, I immediately found myself becoming more adept at making regular updates to my NavData.db3 file.
All I can therefore say is give it a try. Make a copy of your current NavData.db3 file and use that copy in the Tool. If you follow the steps as outlined in the users manual you really can't go wrong. There is much apprehension when you do the recompile for the first time as you believe that somehow the programme will not work. But I have been using it regularly to edit my routes table to do bulk updates etc and it works perfectly every time. Just working in the familiar environment of MS Excel is what gives most users the confidence to edit all tables that make up the NavData.db3 Editing Tool (www.earthimage.co.za/NavDataDB3).
Just shout if you need any help.
Cheers,
-
Afternoon Alan,
Just wondering what the latest position is re your chasing up the database prob.
Syd
-
Hi Syd,
Chased them up, had an updated Navdata sent to me for testing, still the same problem, awaiting a further response
Alan
-
Thanks Alan, much appreciated.
Syd
-
just uploaded the new navdata file,all ok except now have nil routes!any idea how i get them back in computer for dummies language,simon.
-
Yes replace with your back up Navdata
Alan
-
sorry still confused.i have 3 files as follows;
navdata db3file 28,440kb
navdata.db3.bak bak file 28,440 kb
navdata-backup db3file 1 kb
have deleted first one,renamed second as navdata.result nothing in any file when checking database when using radarbox and only approx 50% of my flights now only a code and a flag on the side box.why do these updates always seem to cause more problems than they solve?simon.
-
Moral - stop doing the updates. I had the exact same problem regarding routes with the last update. I now just don't bother doing the updates. Pity, because the updaters team do a huge amount of hard work but AN just don't seem to bother.
-
There is a delay in the production of the next Navdata at this time so wont be out by the weekend as hoped. All the defects from the last one being ironed out.
Something wrong somewhere Simon as navdata-backup db3file should be around 28,000kB. As the routes are more important to you than the aircraft it may be better for you to go back to the previous Navdata which as far as I am aware was OK http://www.airnavsystems.com/download/ANRB/DBUpdater/ANRBDBUpdater20120525.exe and await the next corrected update.
Alan
-
may have given the wrong message above,aircraft are first priority,routes are very useful.just uploaded the link as suggested by runway31 but still no routes in database and aircraft are approx 3,000 less than new navdata,regards,simon.
-
Simon,
There were no reports of problems with the d/b routes until the July update thats why I suggested the May one would have been correct. Using the db.3 back up would have given you the same result.
The July one does contain additional aircraft so its up to you whether you use the July or May one.
As I stated previously Airnav are working on the new Navdata which will hopefully include the correct d/b routes and airport tables and should now be out sometime next week, all going well. As we only update the aircraft table that is what we check is OK but we will check all tables are OK from now on before giving Airnav the go ahead to release.
Alan
Alan
-
thanks alan,think i will stick with what i have and check for updates next week,regards,simon.