home

contact: Recorder@JNCC.gov.uk 

Recorder

Dictionary Upgrades

THIS WEBPAGE IS NO LONGER BEING UPDATED PLEASE USE THE NEW RECORDER WEBSITE

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 various 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 V3' 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 but includes a permissions fix for use with Vista. Click here to download Dictionary Upgrade Kit V3
• 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 the trusted connection (Windows authentication) 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.

PLEASE NOTE that to install dictionary upgrades 0000000J.sql and above you must have upgraded to version 6.14.4.

Upgrades since V6.14

Upgrade file	Size	Date	Description
0000000J.sql	60k	14/10/2008	This upgrade creates a list of designation sets and assigns a list of designation items to them. NOTE that you need to be running Recorder version 6.14.4 to upgrade the dictionary to version 0000000J.

Upgrades since V6.13

Upgrade file	Size	Date	Description
0000000F.sql	1k	14/10/2008	Hot fix to avoid using Recorder 3 list where it is not required and is resulting in duplicate entries being returned by some of the search functionality.
0000000G.sql	21k	13/08/2009	Tidies up the Nameserver table and removes entries from INDEX_TAXON_GROUP where they are not system supplied and are no longer required.
0000000H.zip	2.5MB	13/08/2009	Updates taxon dictionary in line with the NHM's copy dated 24/07/2009. This includes: Additional 'BPGS' checklist Additional 'SYMPHYTA Checklist of British and Irish Hymenoptera Symphyta' Additional 'LEPIDOPTERA (MICRO) Porter Micro-Lepidoptera' checklist Additional 'NERC Act 2006. Section 41: Species of Principal Importance in England' checklist Additional 'NERC Act 2006. Section 42: Species of Principal Importance in Wales' checklist Major update to the 'JNCC Collation of taxon designations' checklist (Now includes: Amber/Red Bird Lists 2009, Vascular plant amendments, W&CA Sch 5:9.4A* and 9.4c, NERC S41, NERC S42, IUCN Global RedList, Conservation Regs 2,3 and 4).
0000000I.sql	0.5k	13/08/2009	Further tidies the Nameserver table where the INPUT_TAXON_VERSION no longer exists and removes related fields in the Taxon_Version and Taxon tables.

Upgrades since V6.10

Upgrade file	Size	Date	Description
0000000B.zip	10MB	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.4MB	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.4MB	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.