1 Topic by nmrs

  • nmrs
  • Veteran
  • Offline
  • From: London
  • Registered: 22-11-2006
  • Posts: 387

Topic: Taxon List Item Keys

Hi all,

I've been doing some testing recently in a development environment. I created a brand new vanilla NBNData and applied all of the R6 and dictionary updates to-date. I then imported a zipped NBN Exchange dataset which was created using the previous preferred Lepidoptera dictionary (Bradley, 2000). The TAXON_LIST_ITEM_KEY for these records will refer to (Bradley, 2000) and not the new preferred Lepidoptera dictionary (Agassiz, 2013), proven by running JNCC_H7_TaxonUsed.

Is there a batch utility or similar to apply the new preferred dictionary (R)TLIK or should I have imported this NBN Exchange zip file then applied the dictionary update in order to change the TLIK or would this have made no difference?

Best wishes,

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

nmrs's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,650

Re: Taxon List Item Keys

The TLI keys on the actual records are not changed by a dictionary upgrade or by an import.  Recorder 6 relies on the NameServer table to point old taxon keys to the latest versions. The NameServer table isn't normally used directly, but from via Index_Taxon_Name which includes the same information. Using Recommended name in any reporting will pick up the name from the latest list. If you want to start off with the Recommended Taxon List item keys for ALL records then this could be done with a simple batch update. The SQL for which would be


Update Taxon_Determination SET Taxon_List_Item_Key = Recommended_Taxon_List_Item_Key   
FROM Taxon_Determination INNER JOIN Index_Taxon_Name ON
Index_Taxon_Name.Taxon_List_Item_Key = Taxon_Determination.Taxon_List_Item_Key

You could also run this in Management Studio.

Mike Weideli

MikeWeideli's Website

3 Reply by nmrs

  • nmrs
  • Veteran
  • Offline
  • From: London
  • Registered: 22-11-2006
  • Posts: 387

Re: Taxon List Item Keys

Hi Mike,

Many thanks for this, I'll investigate further before I start to update TLIKs.

Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

nmrs's Website