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 41144 times)

0 Members and 1 Guest are viewing this topic.

freqhopping

  • Full Member
  • ***
  • Posts: 132
Re: NavData.db3 Editing Tool
« Reply #45 on: January 15, 2012, 06:46:40 PM »
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?
« Last Edit: January 15, 2012, 06:54:11 PM by freqhopping »

Runway 31

  • Moderator
  • Hero Member
  • *****
  • Posts: 33509
Re: NavData.db3 Editing Tool
« Reply #46 on: January 15, 2012, 06:53:05 PM »
CO is operator/Owner

Alan

freqhopping

  • Full Member
  • ***
  • Posts: 132
Re: NavData.db3 Editing Tool
« Reply #47 on: January 15, 2012, 08:37:57 PM »
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

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #48 on: January 16, 2012, 04:59:08 AM »
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

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #49 on: January 16, 2012, 05:03:41 AM »
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

  • Full Member
  • ***
  • Posts: 132
Re: NavData.db3 Editing Tool
« Reply #50 on: January 18, 2012, 01:25:04 AM »
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

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #51 on: January 18, 2012, 05:26:08 AM »
Glad to hear it came right for you.

csparksfly

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #52 on: January 18, 2012, 07:23:27 AM »
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

  • Hero Member
  • *****
  • Posts: 801
Re: NavData.db3 Editing Tool
« Reply #53 on: January 21, 2012, 12:03:05 PM »
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
Best Regards from the Netherlands, John Racars
13 NM East of EHAM
-
ANRB:
Version: 3D - 5.00.072
Antenna: outside WiMo GP-1090 (with ECOFLEX 10 cableconnection)
PC: Windows 7 SP 1 - 64 bit
-
RadarBox24 station: EHAM4

freqhopping

  • Full Member
  • ***
  • Posts: 132
Re: NavData.db3 Editing Tool
« Reply #54 on: January 21, 2012, 02:34:28 PM »
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

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #55 on: January 22, 2012, 05:01:58 AM »
Spot on freqhopping!

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: NavData.db3 Editing Tool
« Reply #56 on: January 22, 2012, 08:59:53 AM »
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.
Best Regards from the Netherlands, John Racars
13 NM East of EHAM
-
ANRB:
Version: 3D - 5.00.072
Antenna: outside WiMo GP-1090 (with ECOFLEX 10 cableconnection)
PC: Windows 7 SP 1 - 64 bit
-
RadarBox24 station: EHAM4

John Racars

  • Hero Member
  • *****
  • Posts: 801
Re: NavData.db3 Editing Tool
« Reply #57 on: January 22, 2012, 09:33:49 AM »
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.
Best Regards from the Netherlands, John Racars
13 NM East of EHAM
-
ANRB:
Version: 3D - 5.00.072
Antenna: outside WiMo GP-1090 (with ECOFLEX 10 cableconnection)
PC: Windows 7 SP 1 - 64 bit
-
RadarBox24 station: EHAM4

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #58 on: January 22, 2012, 03:17:01 PM »
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

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #59 on: January 23, 2012, 05:57:15 PM »
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