NavData.db3 Editing Tool

[csparksfly]

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]

Hi Bryan
 
That tweak works fine, no matter where the duplicate is. Thanks.
 
Rod

[Netcop]

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

[Bell 407]

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.

[vonsmalhausen]

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]

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]

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]

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

[csparksfly]

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]

Works like a dream - thanks

[Bell 407]

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]

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]

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.

[Bob SEN]

I must be doing summat wrong, I just keep getting the error message "unable to launch the application"

cheers

Bob

[Bell 407]

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.