Re: Dictionary Upgrade Kit Version 4
Version 4 of the Dictionary upgrade kit is available at http://jncc.defra.gov.uk/page-4615 This is an updated version of the upgrade software only and the latest Dictionary upgrade remains at ‘Y’.
If you are already up to Dictionary upgrade ‘Y’ then you do not need to download the new upgrade kit until the next Dictionary upgrade. A reminder to do so will be included when the next update becomes available.
If you have not updated to ‘Y’ then this new kit can be used to update the Dictionary without having to run the upgrades in specific batches. All available upgrades can now be put in the scripts folder and run as one update. Those for updates ‘Q ‘ to ‘ Y’ are already in the scripts folder in the Upgrade kit , so there is no need to download these again. Remember that to run upgrades 0000000J.sql and above you must have upgraded Recorder to version 6.14.4 or above.
It is possible that some Dictionaries will not have updated fully using the previous version of the software. If the upgrades were not run in the batches specified or if an upgrade was run out of sequence then the Dictionary will not have been properly updated. We suggest that users run XML report JNCC_sy07Y which is available at http://forums.nbn.org.uk/uploads.php?file=JNCC_sy07Y_DictionaryCheck.zip
This report checks the number of records in each Dictionary table against the number in a Dictionary fully updated to ‘Y’, therefore, to produce useable results the system being checked must have been updated to ‘Y’ . The report will give an indication if there are any problems by reporting where there are differences. The fewer tables reported on and the lower the number of records the better. The file needs to be unzipped into the User File/Reports folder of Recorder 6. The report can then be run from System Reports/Information . The results may vary slightly depending on the version of Recorder used for the initial installation. If it shows problems with just a few tables(eg. Taxon_Version) then there is probably no reason for concern. If in doubt please post the results on the forum so that we can advise if action is required.
If the report indicates that there are problems please request a copy of the latest beta test version of the Dictionary Synchroniser.