anything
AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: NavData.db3 Editing Tool  (Read 41143 times)

0 Members and 1 Guest are viewing this topic.

vonsmalhausen

  • Hero Member
  • *****
  • Posts: 733
Re: NavData.db3 Editing Tool
« Reply #30 on: December 12, 2011, 07:20:05 PM »
same here as Neroon79 ; downloaded, installed and ( after some trials ) up and running.
just did not had some time lately to make updates on my db3 file ( and to be honnest, unless it is really nessesary because of a BIG fault in the DB, i'm not all that eager to start messing with it )

Bob SEN

  • Sr. Member
  • ****
  • Posts: 299
Re: NavData.db3 Editing Tool
« Reply #31 on: December 12, 2011, 10:01:52 PM »
Hi Bob, have you got the latest version of Java installed on your computer? Check at www.java.com and do an online confirmation of what's installed.

Hi Bell407, yep its the latest version...... & running on Win 7 (64 bit) .....
1/2 a mile South of EGMC/SEN

MY PHOTO'S http://www.flickr.com/photos/96219572@N07/

.

neroon79

  • Hero Member
  • *****
  • Posts: 4657
Re: NavData.db3 Editing Tool
« Reply #32 on: December 13, 2011, 03:58:35 AM »
... ( and to be honnest, unless it is really nessesary because of a BIG fault in the DB, i'm not all that eager to start messing with it )
Well, for the first "real" testing I will use a copy of the copy of a back-up...
Greetings from northern Germany, Ingo
11.75nm ESE of EDDV

SW: ANRB v5.00.072/6.01.001 on WIN10 64Bit Pro&Home
HW:
Ant.: DPD Productions ADS-B Vertical Outdoor Base Antenna
AMP: Kuhne electr. KU LNA 1090 A TM
Cable: 25m of ECOFLEX 15+
NB: Asus P53E 24/7 op.
PC: 28"4K + 24" Monitor
AirSpy mini @RPi3

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #33 on: December 13, 2011, 05:26:08 AM »
Hi Neroon,

Yip, best bet is to work with copies :-).

However, there is quite a bit of "maintenance" that one can do on the various tables which you will get to see when you start browsing through the tables in Excel.

Bob SEN

  • Sr. Member
  • ****
  • Posts: 299
Re: NavData.db3 Editing Tool
« Reply #34 on: December 14, 2011, 12:18:21 PM »
Many thanks for your help & advice Marc, all up & running now..

cheers

Bob
1/2 a mile South of EGMC/SEN

MY PHOTO'S http://www.flickr.com/photos/96219572@N07/

.

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #35 on: December 14, 2011, 05:07:48 PM »
Many thanks for your help & advice Marc, all up & running now..

cheers

Bob
Pleasure Bob. Let us know how it goes.

airfire

  • New Member
  • *
  • Posts: 11
Re: NavData.db3 Editing Tool
« Reply #36 on: December 14, 2011, 09:52:11 PM »
I have downloaded the latest update. All I can say is thank you, thank you, thank you.

Your program has made the daunting task of updating the database and made it simple.

This program is exactly what has been missing for those of us that found other update processes over our head.

Jim

Morning All,

Was just wondering if any users, other than those who have posted comments already, who have downloaded the NavData.db3 Editing Tool if they have any comments on its usefulness and how it may have helped in sorting out their NavData file?

Thanks,

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #37 on: December 15, 2011, 08:27:52 AM »
Morning Jim,

Thank you for the postive response and glad it has made a difference for you.

For everyone else, keep a lookout in the next week or so as we will be releasing a Windows Installer package which should make life a lot easier and sort out a few problems some users had.

Cheers,

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #38 on: December 22, 2011, 03:27:27 PM »
Greetings All,

As promised, a Windows Installer option is now available for the NavData.db3 Editing Tool allowing custom directory installation of the programme.

Go to http://www.earthimage.co.za/NavDataDB3/ and click on the Download page for the Windows Installer option.

The User's Manual has also been updated.

Cheers,

neroon79

  • Hero Member
  • *****
  • Posts: 4657
Re: NavData.db3 Editing Tool
« Reply #39 on: December 22, 2011, 05:09:33 PM »
Thanks for the installer. For all those that using norton: You have to confirm "trusting this file", if you don't do so, norton will block the installation. After "confirmation of trusting" installation took 1 minute on a WIN7 Netbook. So far no problem.
Greetings from northern Germany, Ingo
11.75nm ESE of EDDV

SW: ANRB v5.00.072/6.01.001 on WIN10 64Bit Pro&Home
HW:
Ant.: DPD Productions ADS-B Vertical Outdoor Base Antenna
AMP: Kuhne electr. KU LNA 1090 A TM
Cable: 25m of ECOFLEX 15+
NB: Asus P53E 24/7 op.
PC: 28"4K + 24" Monitor
AirSpy mini @RPi3

freqhopping

  • Full Member
  • ***
  • Posts: 132
Re: NavData.db3 Editing Tool
« Reply #40 on: January 14, 2012, 10:15:33 PM »
I just attempted to run this for the first time and got this message.

no such column: CO
org.sqlite.DB.throwex(DB.java:288)
org.sqlite.NativeDB.prepare(Native Method)
org.sqlite.DB.prepare(DB.java:114)
org.sqlite.Stmt.executeQuery(Stmt.java:89)
com.csparksfly.anrbdb3tool.ANRBdb3Tool.exportDB(ANRBdb3Tool.java:257)
com.csparksfly.anrbdb3tool.gui.ExportToDirectoryAction.doThisTask(ExportToDirectoryAction.java:29)
com.csparksfly.anrbdb3tool.gui.ANRBdb3ToolAbstractAction$2.doInBackground(ANRBdb3ToolAbstractAction.java:122)
com.csparksfly.anrbdb3tool.gui.ANRBdb3ToolAbstractAction$2.doInBackground(ANRBdb3ToolAbstractAction.java:118)
javax.swing.SwingWorker$1.call(Unknown Source)
java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
javax.swing.SwingWorker.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)


It created a good actype.xlsx file and an aircraft.xlsx file with no data.  Could having nearly 470,000 aircraft records be a problem?

RNAGG

  • Full Member
  • ***
  • Posts: 119
    • Aerococus
Re: NavData.db3 Editing Tool
« Reply #41 on: January 15, 2012, 02:18:01 AM »
I just attempted to run this for the first time and got this message.

no such column: CO
org.sqlite.DB.throwex(DB.java:288)
org.sqlite.NativeDB.prepare(Native Method)
org.sqlite.DB.prepare(DB.java:114)
org.sqlite.Stmt.executeQuery(Stmt.java:89)
com.csparksfly.anrbdb3tool.ANRBdb3Tool.exportDB(ANRBdb3Tool.java:257)
com.csparksfly.anrbdb3tool.gui.ExportToDirectoryAction.doThisTask(ExportToDirectoryAction.java:29)
com.csparksfly.anrbdb3tool.gui.ANRBdb3ToolAbstractAction$2.doInBackground(ANRBdb3ToolAbstractAction.java:122)
com.csparksfly.anrbdb3tool.gui.ANRBdb3ToolAbstractAction$2.doInBackground(ANRBdb3ToolAbstractAction.java:118)
javax.swing.SwingWorker$1.call(Unknown Source)
java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
java.util.concurrent.FutureTask.run(Unknown Source)
javax.swing.SwingWorker.run(Unknown Source)
java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)


It created a good actype.xlsx file and an aircraft.xlsx file with no data.  Could having nearly 470,000 aircraft records be a problem?

I´m too problem.

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #42 on: January 15, 2012, 10:29:37 AM »
Hi Freqhopping and RNAGG,

Thanks for the post. As a first start to identify your problem, have you tried using the Installer Version of the software?

If still the same problem, I will get the Java Guru to have a look at the error messages you are getting and get back to you soonest.

Thanks,

csparksfly

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #43 on: January 15, 2012, 11:36:15 AM »
Hi Freqhopping and RNAGG,

I suspect that your AIRCRAFT table is a bit different than the one the program expects (its quite strict as far as I know).
It needs these columns for the AIRCRAFT table(perhaps it has to do with the version of Radarbox you are using):
MS,AR,AT,AN,AC,CN,PT,LK,PT2,LK2,CO

Can you confirm whether I am right?
I can think of two ways to sort it out:
1. Perhaps you need to upgrade to a different version of RadarBox?
or
2. The program needs to be relaxed and not be pedantic about the columns.(Cater for more versions of RadarBox)

Appreciate your feedback.

C.

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #44 on: January 15, 2012, 11:54:08 AM »
The NavData.db3 Editing Tool was designed to work with RadarBox V4.03.