1-800-401-2474 | support@airnavsystems.com
Forum| About| Support| Contact
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Searching a blank Navdata.db3 file  (Read 687 times)

0 Members and 1 Guest are viewing this topic.

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Searching a blank Navdata.db3 file
« on: January 01, 2019, 03:13:27 pm »
Hi,
   I kindly ask for help for getting the blank file for Navdata.db3.I want completly new data from start of this year.I am using AirNav radarbox 6.00.000 version of program.Very satisfied with it but as I said I would like to have an actual yearly record not an obsolete record of last 10 years.Thank you in advance for a help and best wishes in the New Year to all of you.Andrej

Runway 31

  • Database Updaters
  • Hero Member
  • *****
  • Posts: 26338
Re: Searching a blank Navdata.db3 file
« Reply #1 on: January 01, 2019, 04:17:21 pm »
Andrej

The information on what you have seen is stored in your MyLog file not the Navdata

Go to MyLog/Tools/Grids and set the From Date and the To date or use Quick Set and choose Last Year

Use Tools/Export to  CSV and save the resulting log

Happy New Year to you

Alan
« Last Edit: January 01, 2019, 04:36:58 pm by Runway 31 »

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Re: Searching a blank Navdata.db3 file
« Reply #2 on: January 01, 2019, 06:04:54 pm »
Hi,
   I see if I set the From date and To date I would have only "new" registrations-aircraft in that period but not "all" registrations-aircraft listed that would flew over my territory.I remember that few years ago it was a blank file on this forum but can,t find it anymore.The database would be absolutely empty at a start...I need a blank table following file-database explorer-select table-aircraft .That is to be able to see "all" registrations-aircraft to fly-by this year only.
« Last Edit: January 01, 2019, 06:26:21 pm by ANDREJ767 »

Runway 31

  • Database Updaters
  • Hero Member
  • *****
  • Posts: 26338
Re: Searching a blank Navdata.db3 file
« Reply #3 on: January 01, 2019, 06:38:38 pm »
Setting the From and To dates will give you all flights picked up by your receiver between these dates, not just new registrations.
 
The Navdata tables are encrypted and cannot be amended

Alan
« Last Edit: January 01, 2019, 07:41:40 pm by Runway 31 »

romdouk

  • Jr. Member
  • **
  • Posts: 51
Re: Searching a blank Navdata.db3 file
« Reply #4 on: January 01, 2019, 07:20:04 pm »
Hi Alan/Andrej
I think what Andrej wants is a blank NavData db3 file that will only populate with the aircraft actually picked up by his Radarbox.
It's the system I use, and when aircraft are picked up by me for the first time, I check the info and if any discrepancies are found, forward them to Alan for confirmation and to be amended.
I have a copy of the blank NavData.db3 file but it is too large to post on the forum. Andrej: if you want a copy then PM me & I'll send you a copy.
regards
« Last Edit: January 01, 2019, 07:31:52 pm by romdouk »
Terry.

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Re: Searching a blank Navdata.db3 file
« Reply #5 on: January 01, 2019, 07:29:59 pm »
@romdouk yes thats exactly what I am looking for.Thanks.
« Last Edit: January 01, 2019, 07:32:57 pm by ANDREJ767 »

Runway 31

  • Database Updaters
  • Hero Member
  • *****
  • Posts: 26338
Re: Searching a blank Navdata.db3 file
« Reply #6 on: January 01, 2019, 07:37:40 pm »
Thanks Terry, never knew that you could get a Navadata with no information on it whatsoever.  Do you add all the data into the other tables or are you not concerned about the routes, aircraft type codes etc

I would however have thought that a blank NavData.db3, not having any data in it would be quite small

Alan
« Last Edit: January 01, 2019, 08:07:44 pm by Runway 31 »

romdouk

  • Jr. Member
  • **
  • Posts: 51
Re: Searching a blank Navdata.db3 file
« Reply #7 on: January 01, 2019, 08:38:00 pm »
Evening Alan
I haven't found any need for the actype or airlines tables so left them blank. My airports table is around 670 entries relating to routes gathered from aircraft picked up on my RadarBox and entered manually (new ones added as and when). The aircraft and routes tables are populated automatically, also by aircraft picked up on my RadarBox.
For some reason every NavData File I've saved has 71,697KB whether empty or full. (can't understand why)
Happy New Year
Terry.

Runway 31

  • Database Updaters
  • Hero Member
  • *****
  • Posts: 26338
Re: Searching a blank Navdata.db3 file
« Reply #8 on: January 01, 2019, 08:43:10 pm »
Good to know Terry, each to their own I suppose

Happy New Year

Alan

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Re: Searching a blank Navdata.db3 file
« Reply #9 on: January 07, 2019, 10:37:40 pm »
Hi,
   I just did a clean installation of AirNav radarbox and then replace original navdata.db3 file with the one Terry kindly sent to me.There is not much difference when I did restarted the program - still the database is huge almost as original one (over 234000 aircraft).Mayba this file wasn,t OK - also it is strange to be 70MB big for an empty one.Have anyone some other idea or correct file?My installed version is now 6.02.003 on WinX.Thank you in advance.Andrej

romdouk

  • Jr. Member
  • **
  • Posts: 51
Re: Searching a blank Navdata.db3 file
« Reply #10 on: January 08, 2019, 07:54:22 am »
Hi Andrej
Can't understand why that happened  because when I replace the NavData with the blank file it works ok for me. Maybe it has something to do with the encryption Alan  mentioned. I know when I tried editing using SQLite it asks for the encryption key, which nobody is going to give you. The large file must mean the old records are still there somewhere, even if they don't appear in my case. Sorry I can't help you any further.
regards
Terry.

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Re: Searching a blank Navdata.db3 file
« Reply #11 on: January 08, 2019, 08:04:32 am »
One interested thing - when I did delete some ModeS records from the database the program remebers that when I run it again,but there was no time or date changed of the navdata.db3 . At least it should be changed because there was edited,right?Maybe it is version related file and I should try to install the right version (old) that you are using?

Runway 31

  • Database Updaters
  • Hero Member
  • *****
  • Posts: 26338
Re: Searching a blank Navdata.db3 file
« Reply #12 on: January 08, 2019, 09:13:52 am »
The change date/time is when the change is made on the server not on your file.  As you didn't and cant change the server data the date will not change.

234,000 aircraft in the aircraft table would suggest to me that it is the file that comes with the V6 software and not a blank file and it looks to me like you didn't replace the original file

Alan

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Re: Searching a blank Navdata.db3 file
« Reply #13 on: January 08, 2019, 09:18:47 am »
The both file were 70MB , then I replaced it even with my old navdata file which was smaller - but the rusult was that there were also over 234000 aircraft then on it although my database only have over 25000!Strange really.

ANDREJ767

  • Jr. Member
  • **
  • Posts: 52
Re: Searching a blank Navdata.db3 file
« Reply #14 on: January 08, 2019, 09:20:28 am »
Could it be to need empty mylog.db3 file ...