NavData.db3 Editing Tool

[vonsmalhausen]

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]

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) .....

[neroon79]

... ( 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...

[Bell 407]

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]

Many thanks for your help & advice Marc, all up & running now..

cheers

Bob

[Bell 407]

Many thanks for your help & advice Marc, all up & running now..

cheers

Bob

Pleasure Bob. Let us know how it goes.

[airfire]

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]

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]

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]

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.

[freqhopping]

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]

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]

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]

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]

The NavData.db3 Editing Tool was designed to work with RadarBox V4.03.