NavData.db3 Editing Tool

[freqhopping]

I'm using 3.13.  What is the CO column for?  I could try adding a CO column to my file with SQLite Database browser and see if that works.   


Update:  Well this worked.  But the next error was no such table: anlv_photo_asdi
So I imagine I would have to create a new table for that too in order for the process to complete. 

What other differences are there in the db3 file between  v3.xx and v4.03?

[Runway 31]

CO is operator/Owner

Alan

[freqhopping]

With some modifications I was able to extract the data.  But it won't compile it.
There is an immediate error of table actype already exists

[Bell 407]

With some modifications I was able to extract the data.  But it won't compile it.
There is an immediate error of table actype already exists

Hi Freqhopping,

Please could you send me a PM with your NavData.db3 file attached for us to have a look at.

Thanks,

[csparksfly]

With some modifications I was able to extract the data.  But it won't compile it.
There is an immediate error of table actype already exists

Perhaps make sure that the file you have chosen to compile to does not exist already...

[freqhopping]

For whatever when the reason the anlv_photo_asdi.xlsx was created there was no information in it.  After fixing that it worked.  I've also found that the 'new' .db3 with the additional aircraft table column and other table works just fine with  v3.13.

[Bell 407]

Glad to hear it came right for you.

[csparksfly]

For whatever when the reason the anlv_photo_asdi.xlsx was created there was no information in it.  After fixing that it worked.  I've also found that the 'new' .db3 with the additional aircraft table column and other table works just fine with  v3.13.

Great news! I think you will find that the anlv_photo_asdi table now exists in your database, and subsequent extracts should work fine. Perhaps just keep it in mind if you should upgrade from v3.13 - the upgrade might complain that the anlv_photo_asdi table exists...

c.

[John Racars]

Hi All,

unfortunately the programm is not working with me. After pressing "go" in the extractbox following errormessagage appear:

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$Worker.runTask(Unknown Source)
java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
java.lang.Thread.run(Unknown Source)

Any help will be welcome.

Kind regards, Hans

[freqhopping]

Hans,

It looks like you're in the same situation that I was with using the original database configuration. If you want to use your existing database rather than the newest one from Airnav (like if you've made a lot of manual updates) you will need to add a CO column to your aircraft table.  You will also need to create an additional table named anlv_photo_asdi with tables named CO, AT and AR with the field types set to TEXT.

To do this it's as simple as downloading and using this application.  http://sourceforge.net/projects/sqlitebrowser/

Using the application is really straightforward.  The attached image shows what it should look like once modified if your database isn't already configured this way.

[csparksfly]

Spot on freqhopping!

[John Racars]

It looks like you're in the same situation that I was with using the original database configuration.

Oké csparksfly. Thank you for your help. I will work this out and let you know  a.s.p.

[John Racars]

Hi All,

thank you csparksfly for your help. The programm is running fine.

To the authors of this I would say: thank you verry much for developing a verry usefull tool like this! I am verry happy with it.

[Bell 407]

Hi Hans and others,

You are most welcome and we are glad that the programme is being used by numerous other users with success. Any other problems users may have just let us know and we will be happy to try and solve the problems you may be experiencing.

Cheers from a rainy but warm Johannesburg, South Africa

[csparksfly]

Thanks John, but I cannot take the credit here. It is rather freqhopping that helped you out :->

Glad you found use for the tool.

C