AirNav Systems Forum
AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: Bell 407 on November 29, 2011, 11:45:15 AM
-
Greetings All,
I have found that the in-programme database editor of RadarBox proves to be extremely tedious and time consuming having to work cell by cell with only copy and paste functions to assist. Furthermore, I have never been able to successfully develop the skills and knowledge to edit in SQL.
A colleague and I have therefore developed a programme for users of RadarBox to edit their NavData.db3 file in the user-friendly environment of MS Excel.
So, what has been developed is called the NavaData.db3 Editing Tool and it does three things:
(1) Extract the six SQL database tables from the NavData.db3 file into individual MS Excel files.
(2) Edit any of the files extracted in (1) above through the MS Excel 2007 or later environment.
(3) Compile the six files edited in (2) above into a new NavData.db3 file.
As an avid user of RadarBox since 2009, I have always wanted to perform some sort of database management on my key NavData.db3 file and now this tool allows me to do that. I have been running a newly compiled NavData.db3 file since the beginning of November 2011 with no problems and have edited all 6 tables without any issues over 10 times.
So what does this mean going forward for other users of RadarBox?
It is hoped that with this programme users will develop the confidence to easily and quickly edit their NavData.db3 file should they feel the need to. For me it was enjoyable to freely explore each table as extracted from the NavData.db3 file in MS Excel and to develop a better understanding of the contents therein.
A further benefit that can be foreseen is that now users can email copies of their tables to other users for them to view, edit or use information in their own tables. It is also believed that this programme will make it easier for the Database Update Team to release updates in individual MS Excel format instead of via the complex installation and overwrite process that is available at present.
The NavData.db3 Editing Tool can be run using the Java Runtime Environment (JRE). The JRE exists for most operating systems, including Windows, Mac and Linux. The JRE can be downloaded from the Java website (www.java.com).
The NavData.db3 Editing Tool is provided free for private, non-commercial use.
For information about downloading the programme, please visit the website www.earthimage.co.za/NavDataDB3. A detailed User's Manual is also available for your reference.
Your comments about this programme would be much appreciated so please post them here for the programme developers to take note of.
Regards,
-
Hi Bell 407
Works a treat. One problem to be aware of is that in excel you can have duplicate data in the same columns
ie hexcodes or flight codes etc
Bryan
-
Hi Bryan,
Would the duplicates also not show up in SQL as well?
-
Thank you for investing a lot of time and effort into this project. It looks very much as if it will prove a more straightforward file editing tool than delving into SQL. :-)
-
Thank you for investing a lot of time and effort into this project. It looks very much as if it will prove a more straightforward file editing tool than delving into SQL. :-)
You are most welcome and look forward to any input, problems or improvements that we can make.
-
Great program!
Excel filters are a great way of finding the stuff that has been being discussed about data consistency in the Update thread - like Avia Nova or Avianova etc.
I agree that the possibility of duplicate entries is a problem - I don't know of a quick way in Excel of finding duplicate Mode-S codes, for example. There is a duplicate remover available here http://www.ablebits.com/excel-remove-duplicates/index.php (http://www.ablebits.com/excel-remove-duplicates/index.php) (found through the Excel help system) - has anybody experienced it?
Rod
-
Thanks Rod, appreciate the postive response.
Will have a look at the link you posted about filters. Personally I don't have a lot of experience with filters so maybe other more advanced Excel users can post some suggestions.
-
Hi Bell 407
In SQL in field MS (Aircraft) & FN (Routes) it is not possable to insert the same code more than once.
To overcome this problem in excel the follow is available.
Click on a cell A9 in the MS column then find the data validation tool, click on data validation, settings (allow) custom, formula =ISNA(VLOOKUP(A134398,$A$2:A134397,1,FALSE))
Click on error alert, ser style, insert title and error message click OK.
Highlight cell A9, Copy, then highlight column A, Paste Special, Validation & OK.
If you then type in any data that is already in that column you are warned.
That should then copy the validation into every cell in column A.
The same process can be used in the other tables routes etc.
Bryan
-
Hi Bell 407
In the last item the formula should read =ISNA(VLOOKUP(A9,$A$2:A8,1,FALSE))
Sorry for the mistake
Bryan
-
Thanks Bryan, will give it a try out.
-
Hi Bryan
Many thanks for that - works nicely. I think it's worth pointing out (if I'm right) that it works when you add a new record at the bottom of the list, not if you insert a row inside the list and the existing duplicate is below you.
Rod.
-
Very useful program, many thanks!
But I have problem with compilation of а new database file from excel files (without making any changes in the files).
Process stops on very last phase – compilation of Routes table with following error message:
null
java.util.Arrays$ArrayList.<init>(Unknown Source)
java.util.Arrays.asList(Unknown Source)
com.csparksfly.anrbdb3tool.DBTable.ensureRequiredHeadersExist(DBTable.java:99)
com.csparksfly.anrbdb3tool.ANRBdb3Tool.importDB(ANRBdb3Tool.java:339)
com.csparksfly.anrbdb3tool.gui.CreateDBFromDirectoryAction.doThisTask(CreateDBFromDirectoryAction.java:39)
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)
New database file contains empty Routes table.
-
Hi Rod
Your point is correct
Bryan
-
Hi Rod
Try altering the formula to =ISNA(VLOOKUP(A9,$A$2:$A$200000,1,FALSE)) where 200000 (line number) is whatever you want.
Bryan
-
Hi Netcop,
Your error is noted and I will get the programmer to address it for you.
-
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.
-
Hi Bryan
That tweak works fine, no matter where the duplicate is. Thanks.
Rod
-
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
-
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.
-
many thanks for this program ; no real techno wonder myself, so any help to make life easier on that DB is more than welcome ;-)
-
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.
-
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?
-
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
-
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.
-
Works like a dream - thanks
-
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,
-
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,
-
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.
-
I must be doing summat wrong, I just keep getting the error message "unable to launch the application"
cheers
Bob
-
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.
-
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 )
-
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) .....
-
... ( 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...
-
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.
-
Many thanks for your help & advice Marc, all up & running now..
cheers
Bob
-
Many thanks for your help & advice Marc, all up & running now..
cheers
Bob
Pleasure Bob. Let us know how it goes.
-
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,
-
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,
-
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,
-
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.
-
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 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.
-
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,
-
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.
-
The NavData.db3 Editing Tool was designed to work with RadarBox V4.03.
-
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?
-
CO is operator/Owner
Alan
-
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
-
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,
-
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...
-
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.
-
Glad to hear it came right for you.
-
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.
-
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
-
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.
-
Spot on freqhopping!
-
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.
-
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.
-
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
-
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
-
As has been mentioned by Freqhopping, the SQLite Database Browser is a very useful tool to check before and after you use the NavData.db3 Editing Tool and might calm the nerves of some users who may feel a bit trepidatious when using the NavData.db3 Editing Tool for the first time.
-
hy, still trying to make the program work without errors
had to do a complete reinstal of my PC, this time i installed the program with the installer, i have Java installed, checked if the extra lines are there with the Sqlightbrowser and Excel was in no way running.
attached is the error log i get
-
Hi,
thanks for taking time to post the error. Could you please attach a screenshot of the top of your ACTYPE xlsx file. The program is trying to import your exported data, and I suspect the ACTYPE(which is the first one to be imported) file is corrupt.
The header should preferably not be tampered with, and should start in the A1 cell.
C.
-
this is how it looks like
-
Thanks it seems fine. I'll send you a PM, and once resolved post the resolve here.
-
Can't get the software to properly read my navdata.db3 file. It is possible I didn't install the JAVA part properly....the instructions are a bit confusing, or it isn't doing what it is suppose to do. I used to be good at messing around DOS and Windows...but I'm not sure what to do and what to look for when installing this software. Why doesn't the installer take care of the WHOLE installation? Please help.
-
Hi,
"Can't get the software to properly read my navdata.db3 file. It is possible I didn't install the JAVA part properly....the instructions are a bit confusing, or it isn't doing what it is suppose to do. "
I used to be good at messing around DOS and Windows...but I'm not sure what to do and what to look for when installing this software. Why doesn't the installer take care of the WHOLE installation? Please help."
Java is a separate program, and we are not affiliated with Oracle, which does not allow us to distribute Java :->
I suspect you hava a different version that what we cater for...what do you have?
Could you share your db3 file with using perhaps dropbox ? and send me a PM with the link to it?
Craig.
-
Thanks Graig, it was indeed a problem with the anlv_photo_asdi.xlsx file
it was empty ( go figure why ) and after typhing these into the file and save it, where A1,B1,C1 is the cell number :
A1: CO
B1: AT
C1: AR
compiling a new DB and BINGO !!! no more error message
-
Glad you came right with Craig's help. Seems that the older DB versions of RadarBox have this common problem.
-
Hi,
"Can't get the software to properly read my navdata.db3 file. It is possible I didn't install the JAVA part properly....the instructions are a bit confusing, or it isn't doing what it is suppose to do. "
I used to be good at messing around DOS and Windows...but I'm not sure what to do and what to look for when installing this software. Why doesn't the installer take care of the WHOLE installation? Please help."
Java is a separate program, and we are not affiliated with Oracle, which does not allow us to distribute Java :->
I suspect you hava a different version that what we cater for...what do you have?
Could you share your db3 file with using perhaps dropbox ? and send me a PM with the link to it?
Craig.
Sent you the link to my db3 file...any luck with it?
-
it seems you also have the older version as discussed earlier:
I have updated your db for you and sent you the new link to download - enjoy.
Craig.
-
Since no news is good news, it's been a while since anyone referded to this topic so thought I would post the question just to check if there are any issues users are having with the NavData.db3 Editing Tool?
I just did a bulk update of local airline 1Time to my Routes table yesterday. Sourced the information from the interweb, edited it quite quickly then cut and pasted into the Route table and voila, update done :-).
-
Hi
I know what you mean regarding updating routes tables.
I have been doing a similar exercise with various European Airports.
Only problem is that the sources just show the flight numbers whilst sometimes the actual flight uses an alpha-numeric code.
However a editing tool.
Bryan
-
I'm having problems running this program. Extract works okay, but when compiling, it gets to about the 4th or 5th table and throws up some errors:
null
java.util.Arrays$ArrayList.<init>(Unknown Source)
java.util.Arrays.asList(Unknown Source)
com.csparksfly.anrbdb3tool.DBTable.ensureRequiredHeadersExist(DBTable.java:99)
com.csparksfly.anrbdb3tool.ANRBdb3Tool.importDB(ANRBdb3Tool.java:339)
com.csparksfly.anrbdb3tool.gui.CreateDBFromDirectoryAction.doThisTask(CreateDBFromDirectoryAction.java:39)
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)
I'm using all tables from my existing database except the aircraft table which is taken from Airnav's latest database release.
Any ideas what I'm doing wrong?
-
Hi Tarbat, have sent your request to the IT Guru. Hopefully he will have an answer for you soonest.
-
Hi Tarbat, have sent your request to the IT Guru. Hopefully he will have an answer for you soonest.
Thanks, but I've just fixed it. See post #67, which fixed it for me. Maybe you need to do something in the export routine to handle older databases.
-
Great tarbat, glad you managed to fix it.
I agree, perhaps we should look into making the app more compatible with other versions.
C.