Could be that R6 is now ahead of the Record Cleaner and the Gateway. R6 is reflecting what is in the NHM dictionary as far as  the Greenfinch is concerned.   I  don't know enough about the taxonomy to know what is correct, but Chloris chloris and Carduelis chloris are considered as two separate species, with Chloris chloris not having any link to the common name 'Greenfinch'. 

I need to investigate the lizards a bit further.

Thanks for the responses. Yes, as far as I can tell they are the same, with Chloris newer - can see from the metadata this has been edited recently on the Brit Orn Cat A,B,C list. Presumably similar issues with name changes for the other birds mentioned, though the Redpolls might be a special case as a spilt with respect to the RSPB checklist.

Is the behaviour of the filtering I mentioned unexpected? Just curious as to whether I should stop using this feature as I have done heretofore.

Best,
Andy

Just had a look at our data and I get 38 records looking at greenfinch in BIRDS and 143 with R3.3. It looks to me as if there is no synonymy between the two lists, although some other lists do synonomise to R3.3 where appropriate, e.g. VASCULAR PLANTS. Some might link through an intermediary table (Common lizard?) . This does assumes that my view of the taxon tables is close to reality.

Investigation shows a problem where some taxa will not be picked up if they were entered from a Designation List. Entering or matching agaisnt these lists  isn't possible now, unless matching is done outside Recorder,  but it was for a while. As far as I can see there shouldn't be any issue with the common lizard unless the Taxon_List_Item_Key came from one of these designation lists.  Apart from taxa on the designation lists there are 45 other taxa affected.  Nine  taxa ( 4 species) on the Diptera check list and the rest on the Environment Agency Check List. Changing R6 to deal with this problem is going to take some detailed investigation, because making what seems the obvious change may have a knock on effect elsewhere. As an interim measure it might be possible to make some adjustments via the dictionary which will get around the problem and I will look into this.

Apart from these exceptions I  think that if the links in the dictionary are correct, then R6 will find all related taxa. 

Andy - it may be worth running some further tests on your system to see if the problem with the lizard is down to entries coming from designation lists and also to make sure that your dictionary hasn't got out of step at some point.

The problem with the record cleaner is probably down to the fact that R6 is in line with the latest NHM dictionary and ahead of the gateway. This has proved the case with some other recent queries.

P.S. as regards the unrecognized TVK errors with the bird data mentioned in my original post - I was about to send an export including these to our LRC. Can I take it that these are fine and will be sorted in time, and that it's OK to go ahead and pass on the export?

Many thanks,
Andy.

Hi Mike

Yes, the Use Translation... box is ticked.

Thanks for confirmation about the bird TVK issues.

I was getting the crashes from the report wizard if I selected "Taxon Checklist" under Taxon on the Select Attributes screen of the wizard - all fine until the report actually tries to run, then crashes out with the above error. If I continued the program and went backwards through the wizard and unticked Taxon Checklist then the report completed without error.  However, further investigation has shown that I only get this crash if I'm trying to report on all taxa (for a polygon or Recorder location) - if I specify a Checklist or species on the Taxa Selection form of the wizard I don't get the crash.

The crash seems to occur on most specified polygons/locations, however I tried using a location with only two plant records as the location criterion, and that report didn't crash. So, I'm guessing it is something to do with our data, possibly taxa matched against checklists no longer in use? 

So, using a report for all species on the prefered Reptilia checklist, all the common lizard records have been matched against either REPTILIA Nat Hist Mus or Recorder 3.3 (1998) checklists. However, this wouldn't tell me if there are other common lizard records matched against other checklist if the report isn't actually picking them up... (hence desire to do all taxa reports with "Taxon Checklist" field).

Cheers,
Andy.

Sure, thanks Mike.

Best,
Andy.

Hi Mike - the report returns 19 rows. Just out of interest, is the Recommended Taxon List Item Key the unifying reference for the various names of a species in the dictionary? Was wondering why none of the keys I've previously seen were common to the various names, but assumed there must be a common key somewhere.

Thanks,
Andy.

Thanks. This shows your dictionary is fine, but fails to explain why you are not getting the correct results when you report on these names.  If you start with any of the Taxon_List_Item_Keys you should get everything related to them.  I have run some more test, but can't at the moment detect any issues, so will need to investigate further. The Recommended_Taxon_List_Item key is unifying reference.

Interesting, I had never even noticed that you could filter like that. Learn something new every day. Thanks (even if it is inconsistent.)

I've been doing a bit more testing to clarify what is going on with the crash I'm getting when I running a report as described above. From what I can tell by applying various filters to my data, when using the Reporting Wizard, if I select 'Taxon Checklist' as an Attribute for my report the report crashes if it comes across any taxon occurrences matched to a dictionary with a title more than 100 characters long. For me these are:

NEUROPTERA, MEGALOPTERA RAPHIDIOPTERA & MECOPTERA Checklist of British lacewings and their allies (Neuroptera, Megaloptera, Raphidioptera and Mecoptera)
FEP Guidance 007: Plant & Animal Species in the Farm Environment Plan (FEP). Table 2: Species to be recorded in Part 2 of the FEP
ISOPODA Checklist of woodlice (Isopoda: Oniscidea) and water-slaters (Isopoda: Asellidae) occurring in the British Isles
DIPTERA Checklist of Insects of the British Isles (New Series) Part 1: Diptera (Chandler, 1998 and updates)
CRUSTACEA Fauna Europaea checklist of freshwater and terrestrial Crustacea of Britain and Northern Ireland
FUNGI British Mycological Society Preferred List of Fungal Names - Includes Lichen Names (non preferred)
LEPIDOPTERA Checklist of Lepidoptera Recorded from the British Isles (Second Edition; Bradley, 2000)
THYSANURA Checklist of British Thysanura (silverfish and firebrats) and Archaeognatha (bristletails)

(error: EOleException, String or a binary data would be truncated)

Apologies if I should have started a new thread for this, thought I'd post here as I'd mentioned it previously in this thread.

Cheers,
Andy.

Do you know which version of the addin you are using ?  Don't think it is dictionary problem, but more likely  one of the other fields.