1

Topic: Report for listing any missing Organisms

Hi Mike,

Any updates with respect to this report?

Many thanks.

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

2

Re: Report for listing any missing Organisms

Sorry. I missed the post about the missing upload.

Attached is a report which will list any missing Organisms. Once it has run we need to check to see if the Taxon_version_Key it returns are present in the full Organism table. If you send me the results I can check this or you can check it against the Organism table you have at home. If the entries are in the full table then the problem is in the population of the table in the Dictionary upgrade. It would then be worth you running the upgrade again, by changing the Dict Seq in the setting table to 00000015 (not 14), so that the upgrade is run again without deleting what is already there.  If they are not in the full Organism table then this means the Dictionary has some missing or incorrect data. I may be able to work out why this is has happended from the list.

Post's attachments

LCCheckOrganism.xml 495 b, 5 downloads since 2013-02-05 

You don't have the permssions to download the attachments of this post.
Mike Weideli

3

Re: Report for listing any missing Organisms

Many thanks Mike, I'll get back to you as soon as I can.

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

4

Re: Report for listing any missing Organisms

Hi Mike,

Here's the output...

Post's attachments

Organism Report Output (NMRS 20130205).xlsx 14.12 kb, 10 downloads since 2013-02-05 

You don't have the permssions to download the attachments of this post.
Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

5

Re: Report for listing any missing Organisms

Thanks. A worrying result from my point of view as it looks like some of the entries just haven't gone in.  We will need to hold back 6.18 from general release until we can find out why this has happend. If you could set back the Dict Seq indicator in the Setting table to 00000015 and run the Dictionary Upgrade again I am hoping this will fix it. .

Mike Weideli

6

Re: Report for listing any missing Organisms

Ok, I'll crack on with that now.

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

7

Re: Report for listing any missing Organisms

Mik, I've reset the SETTINGS Deq Seq indicator to 00000015 and am running dictionary upgrades 00000016 onwards. This may not finish by the time I go home so I'll report back with a new output from the ORGANISM report ran earlier.

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

8

Re: Report for listing any missing Organisms

Hi Mike,

Updated report output having re-run dictionary upgrades 00000016 onwards.

Post's attachments

Organism Report Output (NMRS 20130205-2).xlsx 12.35 kb, 4 downloads since 2013-02-05 

You don't have the permssions to download the attachments of this post.
Les Evans-Hill
Senior Data Officer
Butterfly Conservation, Butterflies for the New Millennium and National Moth Recording Scheme

9

Re: Report for listing any missing Organisms

I believe this is something to do with the order in which the Organism table is processed. Although the order is correct in the table (ie the parents come before their children) it looks like this order is not always adhered to when the dictionary upgrade runs, which means that some records don't go in because their parents are not yet there. Running a second time finds the parent, so a few more go in.  To eliminate this possibility, I have split the table into the 10 levels so that the children can't go in first. There is a new dictionary upgrade at www.Recorder6.info/0000001Bto1N.zip  which implements this. It is designed to run on a Dictionary already upgraded to 0000001A.  I would be most grateful if you would try this for me. You should end up with 108,222 entries in the Organism table.  Don't worry about the report I sent you. It has done its job and can be deleted.

Mike Weideli

10

Re: Report for listing any missing Organisms

Hi Mike, you're a star! Doing a 500,000 record import (split into 75,000 chunks) at present, I'll give it a go when this is done and backed up.

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

11

Re: Report for listing any missing Organisms

Hi Mike, I've just ran the new set of dictionary upgrades and I now have 108,222 entries in the Organism table. Many thanks for your help!

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