1

Topic: Magpie Duck

Oh dear - why has the magpie moth (Abraxas grossulariata) suddenly changed to the magpie duck?  That'll confuse people!

Ellie

Devon Biodiversity Records Centre

Eleanor Knott
Devon Biodiversity Records Centre

2

Re: Magpie Duck

The preferred Lepidoptera list has Magpie Duck as the common name for  Abraxas grossulariata, which is obviously wrong. R6 is using the common name from the preferred list which is correct, but I can't explain why this has only just shown up as a problem as I suspect the list has been wrong for a long time.  Hopefully it can be put right for the next update which is not far away.

Mike Weideli

3

Re: Magpie Duck

This is also affecting Pica pica

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

4

Re: Magpie Duck

Please could you explain the problem with Pica pica.  The common name Magpie Duck is coming from the the preferred bird list.

Mike Weideli

5 (edited by charliebarnes 25-09-2014 11:22:32)

Re: Magpie Duck

Pica pica on the BIRDS list also has the common name of Magpie Duck

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

6

Re: Magpie Duck

Sorry down to my ignorance of birds. Now I have looked it up can see that it is obviously the wrong common name.

Mike Weideli

7

Re: Magpie Duck

OK folks - I have tracked this one down - humble apologies!! I swear, I think Magpies have it in for me recently, for all the hassle this name string has caused ;)  The error crept in after a simple edit to the Farmed animals list. I have given Mike details on how it can be fixed and the fix is fairly straightforward.

The effect is entirely reversible and there will be no lasting effect to existing data ... the TVKs are all fine but the name string attached to the TVK in TAXON was modified incorrectly. My fix creates a new name string for Magpie Duck and reverts the original string to Magpie.

The only problem is with entering new data for "Magpie" which will look a bit crazy until the patch has been applied. To help:

"Magpie Duck" (insect - moth) is the Magpie moth
"Magpie Duck" (bird, Species) is the Magpie bird
"Magpie Duck" (bird, Breed) is the real Magpie Duck

Best wishes, and sorry again for the foul-up :)
Chris R.

Chris Raper, Manager of the UK Species Inventory, Angela Marmont Centre for UK Biodiversity,
Natural History Museum, Cromwell Road, London, SW7 5BD.  (tel: 020 7942 5894)
also Tachinid Recording Scheme (http://tachinidae.org.uk/)

8

Re: Magpie Duck

I attach Dictionary Upgrade  0000002J which implements the changes made by Chris to correct this problem. Note that if you haven't yet   run 0000002I   then this needs to be run as well. It attach it  here for convenience.

Both these files need to be copied (as they are) into the Dictionary upgrades scripts folder and the dictionary upgrade run as normal. Index tables will need to be rebuilt.

If the problem with Magpie Moth is not of particular concern to you then these changes will be incorporated into the next Dictionary upgrade which should be ready in a a few weeks.

Post's attachments

0000002I.sql 1.28 kb, 5 downloads since 2014-09-26 

0000002J.sql 534 b, 7 downloads since 2014-09-26 

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

9

Re: Magpie Duck

Thanks Mike, Chris - looks good here.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership