anything
AirNav Radar
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 47779 times)

0 Members and 1 Guest are viewing this topic.

csparksfly

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #15 on: November 30, 2011, 03:34:48 PM »
Hi Netcop,

It seems the program is expecting headers in your file. It is crucial that the headers are not moved to other cells, i.e. The first column must be in cell A1, second column in B1 etc...
I see you state that you did not edit anything, so I am just poking around a bit to understand you scenario...
Did you use Excel top open the routes xlsx file?
Does it display correctly?
Perhaps the program did not finish extracting first?

If it is possible, perhaps you can send me your routes xlsx file, or at least a portion of it, say the first 100 lines. Perhaps I can try and see whats happening.

Craig.

RodBearden

  • Hero Member
  • *****
  • Posts: 9193
    • Rod's RadarBox Downloads
Re: NavData.db3 Editing Tool
« Reply #16 on: November 30, 2011, 04:21:18 PM »
Hi Bryan
 
That tweak works fine, no matter where the duplicate is. Thanks.
 
Rod
Rod

Netcop

  • Full Member
  • ***
  • Posts: 107
Re: NavData.db3 Editing Tool
« Reply #17 on: November 30, 2011, 04:52:46 PM »
Hi Graig,

Yes, I may open routes.xlsx file in Excel.

I have tried to compile new database file both on my W7 and XP PC's with the same results.

Please find attached my routes.xlsx file.

Nick
Greetings from Russia, Moscow
20.54 nm NWN of UUDD

SW: ANRB v 3.13/ANRB v 4.03 3D, XP SP3
HW: SkyCentre Quad Core PC for 24/7 operation
Antenna: outside SSE 1090SJ mk2
Amp: Wimo AS-1090
Cable: Draka NK Cables RFF 1/2'-50
RadarBox24 station: Netcop

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #18 on: November 30, 2011, 06:02:13 PM »
If I may make a suggestion Nick. Once you have extracted the tables and you open up any of them to edit or explore in Excel, you must remember to use "Save" and not "Save as..." to write any changes to the file and not to change the file type ie it must remain in exactly the same format when it was extracted.

And whilst Craig is the Java guru, my only other suggestion is to make sure you have the latest verson of Java installed on your PC.
« Last Edit: November 30, 2011, 06:05:04 PM by Bell 407 »

vonsmalhausen

  • Hero Member
  • *****
  • Posts: 733
Re: NavData.db3 Editing Tool
« Reply #19 on: November 30, 2011, 06:46:17 PM »
many thanks for this program ; no real techno wonder myself, so any help to make life easier on that DB is more than welcome ;-)

csparksfly

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #20 on: November 30, 2011, 06:59:59 PM »
Nick, I am going to have to say something you might not like to hear...It works for me, using the routes file you supplied - it looks fine.

Wonder if you had Excel open while trying to import the data/recreate the db3? I know Excel likes to be be greedy and tends to lock files for itself...
Can you try the extract again, make sure about the paths, and recompile? (Remember not to have Excel open at any stage)

Craig.

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #21 on: December 01, 2011, 07:16:40 AM »
Craig, thanks for your assistance. My feeling is that it Nick's problem is that MS Excel was open.

I have uploaded a revised User's Manual on the website to include a note in Section 4.3 that MS Excel must be closed before the compilation process is started (www.earthimage.co.za/NavDataDB3).

Nick, did this work for you?

Netcop

  • Full Member
  • ***
  • Posts: 107
Re: NavData.db3 Editing Tool
« Reply #22 on: December 01, 2011, 09:32:37 AM »
Negative, it doesn’t work. I had MS Excel close on all stages.

Moreover I have tried to compile database file with all Excels files opens and have the same result. Process stops with the same error and final database doesn’t contain Route table.

I’ll continue my efforts to understand nature of this error on my PC’s.  No ideas at time.
Some regional or language settings probably?

By the way the name of database backup file which programm creates before start of compilation process in backup ditectory doesn't contain full date/time stamp.

In my case this name is New_NavData_20111201_1.db3. This is normal?

Thanks for your assistance

Nick
« Last Edit: December 01, 2011, 11:27:07 AM by Netcop »
Greetings from Russia, Moscow
20.54 nm NWN of UUDD

SW: ANRB v 3.13/ANRB v 4.03 3D, XP SP3
HW: SkyCentre Quad Core PC for 24/7 operation
Antenna: outside SSE 1090SJ mk2
Amp: Wimo AS-1090
Cable: Draka NK Cables RFF 1/2'-50
RadarBox24 station: Netcop

csparksfly

  • New Member
  • *
  • Posts: 18
Re: NavData.db3 Editing Tool
« Reply #23 on: December 01, 2011, 11:30:09 AM »
Nic,

Perhaps we should take this offline? Once we get it resolved we can post the resolve here.
Send me a message with your email address.

C.

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: NavData.db3 Editing Tool
« Reply #24 on: December 01, 2011, 04:06:56 PM »
Works like a dream - thanks

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #25 on: December 06, 2011, 04:18:55 PM »
Evening All,

We have updated the programme font-end as well as revised the User's Manual. So if you would like to download the newest version of the programme, please visit the link below:

www.earthimage.co.za/NavDataDB3/download.htm.

Please ensure you download and read section 3.1 of the new User's Manual to be clear as to how to install the programme update.

Best wishes,

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: NavData.db3 Editing Tool
« Reply #26 on: December 12, 2011, 09:11:43 AM »
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,

neroon79

  • Hero Member
  • *****
  • Posts: 4657
Re: NavData.db3 Editing Tool
« Reply #27 on: December 12, 2011, 04:45:20 PM »
Downloaded: Yes, "Installed": Yes, A short use (open .db file etc. pp.): yes, Real testing and use: No (I haven't found the time jet. But will -hopefully- have intense testing / use time in my Christmas-Break.
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

Bob SEN

  • Sr. Member
  • ****
  • Posts: 301
Re: NavData.db3 Editing Tool
« Reply #28 on: December 12, 2011, 04:48:45 PM »
I must be doing summat wrong, I just keep getting the error message "unable to launch the application"

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 #29 on: December 12, 2011, 07:05:25 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.