1 Topic by Fletchere

  • Fletchere
  • Member
  • Offline
  • Registered: 29-10-2007
  • Posts: 11

Topic: Import Wizard template issue

Hello all, can I ask is there a way to view the species names that are matched using a saved template within the Rec6 import wizard?

Currently it matches the names automatically from previously created matches, but it doesn't display them and allow any amendment. My issue revolves around what I can only assume was a momentary lapse in concentration which now results in Cheshire water voles morphing into Minke whales! Hmmm...

Fortunately we have picked up the problem (it only affects a few records, thankfully), but this could quite easily go unnoticed for some time. What would have happened if this was a less obvious species; would we have picked it up so easily?

We are fortunate to have someone here who was able to rectify the problem in the matching table, but without that expertise would I have to recreate the template from scratch? I know the answer is not to get it wrong, but I am concerned that we can't even see the matched species; surely this is a data validation issue?

Has anyone else had this issue or is it just us? Is there a way to avoid this situation arising in the future as well as paying more attention to what we are doing?!

Is there an easy method of cross checking these matches to ensure we don't have any other erroneous links in the table?

Any assistance would be very gratefully received.

Eric

Eric Fletcher
RECORD Manager
http:/www.record-lrc.co.uk

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Import Wizard template issue

Remembered matches for data in the import file are stored in the IW_Matched_xxx tables in the database, not in the template although, if I remember correctly, they used to be prior to the introduction of the IW_Matched_xxx tables. When doing an import the remembered matches appear in the species matching page highlighted in pale green. Users should check them and amend any that are wrong before proceeding. Unfortunately the pale green isn’t easy to see on some screens and it isn’t always easy to distinguish from the pale blue shading on every 5th line. This works as it should when matching against individual taxon lists but not when matching against ‘All preferred lists’. In this case the manual matches aren’t remembered correctly which can lead to incorrect matches in subsequent imports. This problem is corrected in v6.19 which will be issued as a candidate release very soon.

The following query will list the stored species name matches:
SELECT IWMSp.Matched_Value, IWMSp.Matched_Key, IWMSp.Match_Checklist_Key, IWMSp.Temp_User_ID, ITN.ACTUAL_NAME
FROM IW_Matched_Species IWMSp
INNER JOIN INDEX_TAXON_NAME ITN ON IWMSp.Matched_Key = ITN.TAXON_LIST_ITEM_KEY
If this includes any matches that aren’t correct you could do another query to see whether their Matched_Keys are used in any taxon determinations.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687