home

contact: Recorder@JNCC.gov.uk 

Recorder

Dictionary Upgrades

You are strongly advised to keep the dictionaries in Recorder 6 updated to the most recent version.

The updates provided need to be run in sequence, working from the bottom to the top of this page. The Dictionary Upgrade Kit will not allow you to run them out of sequence and an appropriate error message will be displayed if the 'next' upgrade file is missing.

To run the upgrades:

• Download the dictionary upgrade kit - Note that the Dictionary Upgrade Kit has been updated in line with the internationalisation of version 6.10. Users at version 6.10 onwards need to use 'Dictionary Upgrade Kit V2' to update their dictionaries. This file replaces the previous Dictionary Upgrade kit supplied and should be downloaded to your hard disk and unzipped. The new Upgrade Kit does not include any updates to the dictionary itself. Click here to download Dictionary Upgrade Kit V2
• Download each upgrade file - download each file by right clicking on the filename below and selecting 'Save Target As...'. Save each file to the Dictionary Upgrade Kit/Scripts folder. Note: Please do not unzip any of these files or rename them. Once you have downloaded the outstanding files needed you are ready to run the upgrade. Due to the time taken to run the upgrade if you need all or most of the files provided here we advise you to run the following in separate 'batches': 00000000.sql - 00000003.sql; 00000004.sql - 0000000A.sql; 0000000B.zip - 0000000C.sql.
• Run the upgrade - double click on the DictionaryUpgrade.exe file and use either trusted connection or an appropriate SQL Server login to proceed. With a default instance of MSDE installed by Recorder 6 you can use the 'sa' login with the password left blank. Note: if you are using SQL Server 2005 or SQL Express with Recorder 6, you need to use the trusted connection option to update your database.
• Rebuild indexes - Once the upgrade has completed go to Tools - Database Tools in Recorder 6 and rebuild the taxon group, name and synonym indexes.

We plan to revise the Dictionary Upgrade Kit in future so that a SQL Server account and password can also be used to run the upgrade with SQL Server 2005 and SQL Express.

Upgrades since V6.10

Upgrade file	Size	Date	Description
0000000B.zip	10M	05/12/2007	Updates taxon dictionary in line with the NHM's copy dated 19/11/07. This includes: Additional list - 'ACARI Fauna Europaea checklist of Prostigmata (Acari) of Britain and Northern Ireland' Additional list - 'ISOPODA Checklist of woodlice (Isopoda: Oniscidea) and water-slaters (Isopoda: Asellidae) occurring in the British Isles' Additional list - 'THYSANOPTERA Fauna Europaea checklist of Thysanoptera (thrips) of Britain' Additional list - 'HETEROPTERA Checklist of Heteroptera of the British Isles (with Channel Isles)' Additional list - 'PLECOPTERA Fauna Europaea checklist of Plecoptera (stoneflies) of Britain' Additional list - 'Priority Species List (2007)' Other minor changes to a range of lists
0000000C.sql	7K	05/12/2007	Updates Nameserver table and removes the preferred list flag for the 'British Ornithologists'' Union categories D and E' checklist to resolve problems with recommended taxonomic sort order
0000000D.zip	1.4M	09/05/2008	Series of minor updates to Nameserver. Also adds the "JNCC collation of taxon designations" - a list summarising the current status of species in the UK.
0000000E.sql	2K	25/06/2008	Series of minor updates to taxon designation information to avoid duplicate reporting in the report wizard.

Upgrades since V6.9.3

Upgrade file	Size	Date	Description
0000000A.sql	1K	04/07/2007	Provides further minor updates to the taxon dictionary
00000009.sql	193K	10/07/2007	Removes entries from taxon dictionary in line with NHM's copy dated 04/06/07
00000008.sql	729K	10/07/2007	As above, removes entries from taxon dictionary in line with NHM's copy dated 04/06/07
00000007.zip	8.4M	06/08/2007	Updates taxon dictionary in line with the NHM's copy dated 04/06/07. This includes: Additional 'Protection of Badgers Act 1992' checklist Large updates to the following checklists; 'British Isles List of Lichens and Lichenicolous fungi', 'VASCULAR PLANTS AND STONEWORTS', 'CHILOPODA - Checklist of British Chilopoda (centipedes)', 'A review of the scarce and threatened Coleoptera of Great Britain' and 'DIPLOPODA – Checklist of British and Irish Diplopoda (millipedes)' Changes to Nameserver - All taxon version keys incorporated except for 3-4,000 flowering plants and a similar number of fungi. This equates to >28,000 new Nameserver entries and >4,000 changes to existing records Other minor changes to a range of lists
00000006.zip	30K	14/12/2006	Fixes problems with description fields in Taxon_list and Taxon_list_version tables
00000005.zip	812K	18/07/2007	Re-synchronises Admin Areas dictionary with copy provided in Recorder 2002
00000004.sql	3K	01/12/2006	Script provides some minor updates to the Admin Areas dictionary namely to the Scottish National Parks

Upgrades pre V6.9.3

Upgrade file	Size	Date	Description
00000003.sql	633K	5/12/2006	Script to delete items from the dictionary which are no longer valid or used to complete synchronisation with V13-09-2006 of the NBN species dictionary.
00000002.zip	7.7M	5/12/2006	Full dictionary update to synchronise with V13-09-2006 of the NBN species dictionary managed by the NHM.
00000001.sql	4K	4/12/2006	Creates an additional category in taxon list type for defunct lists. This is really to allow lists to be tagged to this and not used for data entry. The script also updates a set of lists to exclude them from data entry (namely Freshwater checklist (obsolete - source unknown), Guidelines for selection of SSSI's, JNCC interpretation of Higher Level Designations, Long list of Globally Threatened/Declined Species (1995), NBN Gateway Vascular Plant Dataset, Passmore-Edwards Museum number, Pink list of British Plants, Species of Conservation Concern list.)
00000000.sql	1K	29/11/2006	Downgrades the two NHM mollusc lists as these are no longer preferred lists (and updates their title). Updates the title of the BOU list (other updates are part of the mdb file). Downgrades the preliminary collembola checklist. Upgrades the trichoptera list.