1

Re: Report Wizard - Checklist selection

Hi,

Happy New Year to all!

Having just tried to run the Report Wizard, I'm unable to select the 'BRC record card RA8 - Lepidoptera (butterflies and moths)' checklist as it isn't listed, along with a number of other BRC check lists and possibly others.

Has anyone else got the same issue?

Best wishes,
Les.

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

2

Re: Report Wizard - Checklist selection

Do you mean a checklist as in the species dictionary or do you mean opening one of the system supplied record cards?

Lynn

3

Re: Report Wizard - Checklist selection

Hi Lynn,

I can select it as a species dictionary (Dictionaries, Taxon), what I can't do is select it from within the Report Wizard. Does that clarify?

Les.

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

4

Re: Report Wizard - Checklist selection

Hi Lynn,

Have you managed to have a look at this issue?

Best wishes,

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

5

Re: Report Wizard - Checklist selection

Hi Les and Lynn,
I've just had a good look at the code behind this. In Recorder 2000 there was a facility to only install the lists you wanted from the CD to save disk space. So, in the Taxon_List table, there is a flag called LOCAL_DISK. This facility is no longer relevant so the flag ought to be removed along with all references. Anyway, some of the lists including many of the BRC RA... lists have this flag set to 0, which makes the report wizard think they are not in the database and exclude them from selection.
A quick fix would be to run this query:

UPDATE Taxon_List SET Local_Disk=1

This should also fix a bug where you can't drag species from these lists into the single occurrence record card.
Lynn, will you pick up an action to clean out this attribute and all the related code please?

John van Breda
Biodiverse IT

6

Re: Report Wizard - Checklist selection

Les
Just taken a quick look at this - could be a a bug in the species dictionary. I will add it to the list to sort out for the next upgrade. If you need to alter it now try updating the value of local_disc in taxon_list to -1 for taxon_list_key = NBNSYS0000000072.
Steve

7

Re: Report Wizard - Checklist selection

I think I must have misunderstood the reasoning behind this. I had assumed that these lists had been deliberately hidden as they had been superceded by the more comprehensive preferred checklists (as many BRC lists include 'obsolete' in their title). This then effectively forces the use of the preferred lists, only keeping the old checklists in the background to allow the system to deal with legacy data entered against them.

Gordon

Gordon Barker
Biological Survey Data Manager
National Trust

8

Re: Report Wizard - Checklist selection

There is an allow_data_entry flag in taxonomy_list_type which prevents entry of new data against unsuitable lists. But I don't think having a restriction on lists you can report against is intentional. Maybe I am wrong?

John van Breda
Biodiverse IT

9

Re: Report Wizard - Checklist selection

John
That was my understanding too. The local_disc was a mistake in my opinion - not deliberate. But yes - we do use the allow_data_entry_flag to attempt to encourage the use of new lists for recording - but reporting shoudl not be restricted.
S

10

Re: Report Wizard - Checklist selection

That'll be what I got it confused with then.

G

Gordon Barker
Biological Survey Data Manager
National Trust

11

Re: Report Wizard - Checklist selection

Hi all,

Just managed to catch up with this. John/Steve, your suggestions did the trick, thank you.

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