AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: AirNav Development on April 26, 2012, 12:26:31 AM

Title: New Navdata.db3 - 20120424
Post by: AirNav Development on April 26, 2012, 12:26:31 AM
An updated navdata.db3 file is now available for download from the link below:
http://www.airnavsystems.com/download/ANRB/DBUpdater/ANRBDBUpdater20120424.exe

Changes:
1) Updated aircraft table;

Again tks for the volunteers team amazing work.
Title: Re: New Navdata.db3 - 20120424
Post by: neroon79 on April 26, 2012, 02:00:38 AM
And here is the long awaited Database Update file!

Thank you AirNav!

Number of airframes in list is: 257283 (correct?)
Title: Re: New Navdata.db3 - 20120424
Post by: X on April 26, 2012, 05:39:52 AM
Alan

That's some jump to 157,000 since end Jan. Well done

X
Title: Re: New Navdata.db3 - 20120424
Post by: nortonbeak on April 26, 2012, 09:54:17 AM
Superb work by the update team.

I doff my hat to you all :-)
Title: Re: New Navdata.db3 - 20120424
Post by: pjotrtje on April 27, 2012, 08:28:23 PM
I would like to give a  B I G   T H A N K   Y O U  to the entire team! Here's to afternoons filled with watching more identified tracks on the screen!
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on April 29, 2012, 07:07:41 PM
Hi
I have ran the update and it is showing in my data file but when  I look in my database explorer I still have the same number as before  136228.
any idea where I am going wrong
I am installing it into
C:\Program Files (x86)\AirNav Systems\AirNav RadarBox\Data
any  help please
Thanks
Nick
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on April 29, 2012, 08:56:37 PM
AV61, Only go as far as Airnav Systems\AirnNav\Radarbox, leave out the data bit, it will do that itself

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on April 30, 2012, 05:55:11 AM
Hi Alan
I will try that this evening and let you know how I get on.

Cheers
Nick
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on April 30, 2012, 02:27:09 PM
Alan
I have done as you asked but it is still the same
in my data file I have the new one showing modified 24/4/2012
yet my database explorer still only shows 136228
any ideas
Nick
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on April 30, 2012, 02:59:40 PM
Alan
Just to let you know I have tried deleting the navdata.db3 file and redownladed the file and it still comes p with the same number of aircraft as before.
Nick
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on April 30, 2012, 05:31:34 PM
Al
out of interest I have downloaded it again to a location on my pc and the file is 28249kb which is the same size as the one Ive downloaded to my AIRNAV.
nick 
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on April 30, 2012, 05:50:46 PM
Nick,

Did you Run the file or Save it when you downloaded.  If you saved it, RUN it

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on April 30, 2012, 06:14:27 PM
Alan
have tried both have saved it and run it and have just run it
in both cases the number of kb are the same  which are the same as the january update
nicki
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on April 30, 2012, 06:50:19 PM
You must have more than one instance of Airnav on your computer.  Use windows search and look for Navdata db.3 24/4/2012 and see where they are.  Replace the old one in the correct place with the new one in the wrong place.  Remember where that correct place is

If you installed from the disc which came with your box and then upgraded to 3.13 or 4.03 you will have at least two instances of Radarbox on your computer and have installed the update to the wrong one.

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on May 01, 2012, 06:41:23 AM
Al

I am running a 4.3  3d version
Maybe I need to delete all and reload but if I go down this route
how do I keep all my data in  mylog as I dont want to lose what I have

currently at work so cant try anything til this afternoon
Nick
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 01, 2012, 06:54:17 AM
Hi Nick,

Just save your My log file from the data folder and replace if the existing if you re-install.  You shouldnt have to delete but if you do, remember and delete all instances of Radarbox.

Alan

Title: Re: New Navdata.db3 - 20120424
Post by: orkney on May 01, 2012, 08:48:33 AM
Hello Nick

Also you might want to check your virtual store as the correct navdata and mylog will be here since you installed into the default program files location.

Andrew
Title: Re: New Navdata.db3 - 20120424
Post by: AV61 on May 01, 2012, 02:16:56 PM
hi Alan & Andrew
Many thanks for all your help
I searched for all files Navdata.db3 and it came up with a few
as you said Andrew something about virtual files I found a couple that were showing located
in a virtual file (Idont know why)  but I deleted all of those and when I reran the program
I now have  157283 aircraft is this correct only I noticed in one of the comments on here someone mentioned 257283 I am guessing the 2 at the beginning is wrong or I am still missing loads
Any way many thanks to you both for all your assistance
Nick
Title: Re: New Navdata.db3 - 20120424
Post by: neroon79 on May 01, 2012, 05:06:09 PM
the 2 is false. My brain wasn't 100% "online" at 3AM.
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 01, 2012, 06:20:44 PM
Glad we got you there in the end.

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: Brisbane on May 05, 2012, 10:54:20 PM
Hi all, thought I'd share my experience with you. Back in March I posted saying I had troubles with installation, and after much debate resigned myself to not being able to update.
I reinstalled ANRB into it's own file, not in Program Files.
Seeing the latest database, I tried installing it in C:\AirNavSystems\Radarbox and left off the Data at the end. It has now, miracle of miracles, updated my database.
For those experiencing problems with updating, try these tips, you never know it might work. 
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 06, 2012, 10:49:08 AM
Glad you got there in the end Brisbane.  Its really hard trying to help from a distance but its good when something eventually clicks.

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: jaskel on May 06, 2012, 01:18:28 PM
thanks to all for your hard work!
Title: Re: New Navdata.db3 - 20120424
Post by: FACTflights on May 07, 2012, 10:43:05 AM
Alan,

Got one here that I can't Find in the DB, actually there are many, but this one stands out, again with USA flag:

A07070  decodes in two lines as:

N12728  Cessna 206H C206  Weaver Aero Int. Mountridge KS

ZS-SED Cessna 206H C206  (wrong ICA024)

What does that mean?

John
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 07, 2012, 11:26:43 AM
John,

A07070 is an American hex which decodes to N12726 which was its previous identity.  This aircraft is now ZS-SED and is Cessna T206H Turbo Stationair c/n 20608303.

It is an unfortunate fact of life that in your part of the world, miscodes like this are prevelant and as they are using the American hex code, this will give an American flag.

I have added it to the database under the miscoded hex.

Please forward any other unidentified hex codes and I will try and add them as well.

Alan

Title: Re: New Navdata.db3 - 20120424
Post by: Lionel on May 15, 2012, 08:21:49 PM
A quick question - does this update incorporate all the previous updates?

I am still having trouble getting the number of aircraft to go above 80166 - have followed all the tips given in the thread and still no joy - any suggestions much appreciated.

This installation was a new one (from an original 2007 cd) on a windows 7 laptop - so managed to do a system upgrade from version 2 to 3.13 with no problem. Everything else is working correctly - it is only the latest database update that is proving a problem.

Is the 157000 for the total aircraft number confirmation that the update has worked ok?
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 15, 2012, 08:53:39 PM
Lionel,

Having done an upgrade from the original CD, to 3.13 you will have more than one instance of Radarbox on your computer.

First of all I presume you ran the Navdata and didnt just save it from the website. Use Windows search to look for the NavData.db3 from April.  Copy this to the data folder of the 3.13 installation, replacing the one that is there.  It will probably be in the original installation data folder and will be around 27Mb and dated whenever you installed it.  Be aware there is more than one file with Navdaat.db3 as part of the name.

It replaces trhe original and will have over 157,000 codes

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: CoastGuardJon on May 15, 2012, 09:24:27 PM
Hi Alan, this may appear to be a stupidly basic question, but just how do you find out how may codes are in the file?
Title: Re: New Navdata.db3 - 20120424
Post by: andrewarles on May 15, 2012, 09:43:29 PM
Choose the menu item "File" then "Database Explorer"

On the Database Explorer window select the "aircraft" table from the drop down list.

At the bottom of the Database Explorer window is the number of rows (MS codes).
Title: Re: New Navdata.db3 - 20120424
Post by: Paulc on May 16, 2012, 11:07:51 AM
Alan,

I was with Lionel whilst the reinstall was being done and we did find and delete any previous versions of the Navdata3 file. Airnav had not been installed on that laptop before so there was only the original CD installation to remove. The file is in the correct place as far as I can tell so am at a loss as to why it is not showing the correct total. The system does work ok and if there is a planned upgrade that does away with the Navdata file then that cannot come soon enough
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 16, 2012, 11:23:18 AM
Paul,

If there was only the updated Navdata on the computer it would be being read correctly, there must be another on there if only 80,000 codes are being read.  If all the original files had been deleted there would only be the updated on there, hence my suggestion to carry out a windows search for Navdata.db3 files.

Carrying out a de-installation using the Windows control panel does not remove all files and normally leaves the original Navdata.Db3 file among others.

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: Paulc on May 16, 2012, 02:02:08 PM
Alan

as per my previous post we did a search for the Navdata file - it came up with 4. 2 of these were the downloaded update and the other 2 were from the cd installation and were removed. I have seen mention of the 'virtual store' - could something be in there that the search is not finding? As I only use XP the inner workings of windows 7 are all new to me.
Title: Re: New Navdata.db3 - 20120424
Post by: CoastGuardJon on May 16, 2012, 03:14:41 PM
Choose the menu item "File" then "Database Explorer"

On the Database Explorer window select the "aircraft" table from the drop down list.

At the bottom of the Database Explorer window is the number of rows (MS codes).

Hi Andrew, many thanks for that, mine is showing "80891 rows loaded in 170ms", so I assume my DB isn't updated, despite me downloading .db3 - 21120424 and then going through the Install process.
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 17, 2012, 03:25:34 PM
Paul,

A windows search will pick up any in the store. so no worries

What is the path of the Airnav you are using.  I presume you have it installed to the default location in program files, this will give problems with the virtual store. Wherever you have installed radarbox to you should install the update to.  As you look as if you have installed to the defaul location I presume it will be c:programfiles\Airnav Systems\Radarbox.  You should therefore install the update to there as well, do not go any further and put it in Data as the installer does that, only go as far as Airnav Systems\Radarbox.

To avoid the virtual store problems my preferred option would be to de-install what you already have using Control Panel then do a munaul search and delete all the remaining Airnav folders you would find.

I would the re-install to somewhere like C:\Airnav Systems and once installed use the Navdata update installer to install to that location.

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 17, 2012, 03:28:21 PM
John,

That will be the case your system is still using the old Navdata as the one you installed has not went into the Data folder.

Use the info provided previously to search for it and move it to the correct data folder replacing the one already there.

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: CoastGuardJon on May 17, 2012, 06:10:44 PM
Hi Alan, thanks for that - I've been trying to download and install to C:\AirNav Systems\AirNav RadarBox\Data, but have just tried C:\AirNav Systems\AirNav RadarBox without the \Data, lo and behold, I now have "157283 rows downloaded in 398 ms" so seem to now have the updated DB file installed.   It would appear that directing the download to the \Data file is what was causing my problem.   Hope this helps anyone else having a similar problem.
Title: Re: New Navdata.db3 - 20120424
Post by: Lionel on May 18, 2012, 06:22:29 PM
Managed to delete the vitual store ones and run in the update. However the total I get is still only 136K - any ideas as to why when others report that 157K is the expected total after this update?  Is it possible that an earlier update needed to be loaded before or is this one a total replacement of the navdata file?
Title: Re: New Navdata.db3 - 20120424
Post by: Runway 31 on May 19, 2012, 08:33:10 AM
Lionel,


Each Navdata update replaces all before.

136K was an earlier update, did you run the one at the start of this thread?

Alan

Alan
Title: Re: New Navdata.db3 - 20120424
Post by: Lionel on May 20, 2012, 05:57:13 PM
Many thanks to those that responded, problem resolved and database now with the correct number.

Thanks especially to Paul C for his patience !!

Lionel
Title: Re: New Navdata.db3 - 20120424
Post by: dantheman on May 21, 2012, 07:29:34 AM
AV61,
To be safe goto MyLog and export to CSV. Not sure how you can import it again though as the import option is from SQB. You could also make a copy the mylog.db files to make a backup. These are located in the Data folder eg: C:\AirNav RadarBox\Data for me.