What did you have in your Scripts folder when you ran the dictionary upgrade? You should have had 0000000H.zip plus any other scripts you were running but no Rec6Dict files. If you downloaded a Rec6Dict file you must unzip it just once. Check Dict Seq in the SETTING table before rerunning anything. In v6.14, Help – About Recorder 6 will tell you the version of your copy of the system and the dictionary. In earlier versions, you will find the dictionary version in Dict Seq. A dictionary upgrade will only run if the previous one has been run and the upgrade kit uses Dict Seq to find out if the previous one has been run. The following notes may also help.
When doing dictionary upgrades please follow the instructions at http://www.jncc.gov.uk/page-4615 but note the following points. When preparing to run a dictionary upgrade please ensure that you download the required files to somewhere other than \Dictionary Upgrade Kit\Scripts, then unzip them to the Scripts folder prior to running the DictionaryUpgrade.exe file. When running the K, L, and M upgrades, for example, the Scripts folder should contain 0000000K.sql, 0000000L.ini, 0000000L.zip, 0000000M.ini, 0000000M.zip and, ReadMe.txt. It shouldn’t contain the files you download, i.e. Rec6Dict_0000000K_UnzipMe.zip, Rec6Dict_0000000L_UnzipMe.zip and Rec6Dict_0000000M_UnzipMe.zip. If it contains these Rec6Dict files the upgrade won’t run correctly. Note that the help on upgrading the dictionaries in Recorder 6 says not to unzip the download files but the procedure has changed since that was written because when the new Recorder web-site became available in October JNCC wouldn’t allow files like 0000000K.sql to be available for download unless they were zipped. Previously they had been available exactly as required in the Scripts folder.
Please note that if you run the K, L and M dictionary upgrades together the changes in M don’t get done, e.g. the addition of the Integrated Habitat System to the biotope dictionary. JNCC rectified this by issuing M again as N. If you run K and L on their own and then run M on its own it works but if you have already run the 3 together it would be best to just run N to correct the problem. Either way you will still need to run N so that you won’t be told you have missed an upgrade when O comes out and you try to run it.
Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687