1 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem reporting on a major taxon group

I've just been asked for all my mollusc records - I knew I had at least 8,000 records so was rather surprised when Recorder only offered me just over 7,900 - on further investigation I found the following:

1) Using the Non-marine Mollusca checklist and "include all species from list" gave me 7,935 records
2) Using the Recorder 3.3 checklist and filtering on "Mollusca" gave me a list of 7,930
3) If I combine these two lists and remove duplicates I get 8,240 records, i.e. both the obvious filters are each missing over 300 records ... and I don't know if any other lists might pick up additional records!

This is very worrying when I regularly report on a major taxon - I cannot rely on Recorder to give me the correct result.

Is there a way to ensure Recorder selects ALL taxon within a major taxon irrespective of the list they are on?

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by wilkin_s

  • wilkin_s
  • Administrator
  • Offline
  • Registered: 31-03-2006
  • Posts: 87

Re: Problem reporting on a major taxon group

Hi Craig
Thanks for this. Can I check:
- you are on the most recent dictioanry version
- most recent Recorder version
- you have rebuilt the taxon indexes since the last update.
Assuming all of this is true would you mind running the following query (just in the linked Access database - under database from Recorder root.

SELECT TAXON.ITEM_NAME, TAXON_VERSION.OUTPUT_GROUP_KEY, TAXON_LIST.ITEM_NAME, TAXON_VERSION.TAXON_VERSION_KEY, TAXON_1.ITEM_NAME, TAXON_VERSION_1.TAXON_VERSION_KEY, NAMESERVER.RECOMMENDED_TAXON_LIST_ITEM_KEY
FROM (((((((TAXON INNER JOIN TAXON_VERSION ON TAXON.TAXON_KEY = TAXON_VERSION.TAXON_KEY) INNER JOIN TAXON_GROUP ON TAXON_VERSION.OUTPUT_GROUP_KEY = TAXON_GROUP.TAXON_GROUP_KEY) INNER JOIN TAXON_LIST_ITEM ON TAXON_VERSION.TAXON_VERSION_KEY = TAXON_LIST_ITEM.TAXON_VERSION_KEY) INNER JOIN TAXON_LIST_VERSION ON TAXON_LIST_ITEM.TAXON_LIST_VERSION_KEY = TAXON_LIST_VERSION.TAXON_LIST_VERSION_KEY) INNER JOIN TAXON_LIST ON TAXON_LIST_VERSION.TAXON_LIST_KEY = TAXON_LIST.TAXON_LIST_KEY) INNER JOIN NAMESERVER ON TAXON_VERSION.TAXON_VERSION_KEY = NAMESERVER.INPUT_TAXON_VERSION_KEY) INNER JOIN TAXON_VERSION AS TAXON_VERSION_1 ON NAMESERVER.RECOMMENDED_TAXON_VERSION_KEY = TAXON_VERSION_1.TAXON_VERSION_KEY) INNER JOIN TAXON AS TAXON_1 ON TAXON_VERSION_1.TAXON_KEY = TAXON_1.TAXON_KEY
WHERE (((TAXON.ITEM_NAME)="Cepaea hortensis"));

Best wishes
Steve

3 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem reporting on a major taxon group

Steve,

Recorder Version 6.14.4.212
Dictionary Version 0000000J

I have rebuilt the indexes and I have sent the results of the query by direct e-mail

Craig Slawson
Staffordshire Ecological Record

ser's Website

4 Reply by wilkin_s

  • wilkin_s
  • Administrator
  • Offline
  • Registered: 31-03-2006
  • Posts: 87

Re: Problem reporting on a major taxon group

Hi Craig
OK - I have done a quick check here and it works fine. Ie. I added a record against Cepaea hortensis (R3) and another against the preferred list, ran a report through the wizard filtering on R3 list and listing the taxon group. Both records appeared and bothwere listed as molluscs. ARe you absolutely sure there is no other flag that is set (eg. record isnt checked or is flagged as confidential etc). If all that is fine - can you just step me though exactly what you are selecting on each wizard screen so I can try and replicate it here.
Steve

5 Reply by sallyrankin

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

Re: Problem reporting on a major taxon group

Is ‘Use Full Translation to Preferred Term’ ticked on Tools – Options? One customer was getting different numbers of observations from the same report on different workstations and it transpired that this was ticked on one but not on the other. With this unticked, depending on the taxon dictionary lists used for data entry, you may not get out as many observations.

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

6 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Problem reporting on a major taxon group

Firstly to answer Sally's comment, yes 'Use Full Translation' is ticked on

Secondly, Steve why did you choose Cepaea hortensis for the check - that was a species where I think the discrepancy is due to a corrupt record because 172 out of 173 were present in the report - the problem species are those where NO records appeared in the report - e.g. Arion (Carinarion) circumscriptus (entered from the Mollusca checklist) or Arion hortensis agg. (entered from the List of additional names) - I am going to rerun your query on one of these and send it through to you by e-mail

Craig Slawson
Staffordshire Ecological Record

ser's Website