Species inventory updates

[davidnicholls125]

We've noticed a number of species names that have been updated on NBN and on iRecord but our inventory still has the old names. Should this have been updated? We haven't had the update file from BRC for a long time - can you remind me if this updates our taxonomy and species pages? Thanks.

[johnvanbreda]

The update file doesn't update names, it only fixes the NBN key in certain circumstances so your keys don't get out of step (as a preferred name change results in a preferred TVK key change). I can see there were 54 updates that don't look like they have been applied, so I may have forgotten to send the update file when the last update was done in June. I've just applied this file and fixed the keys in the warehouse list.

As a separate thing, I've written a query to compare the accepted names on UKSI and NatureSpot for matching TVKs and have downloaded all the differences. The attached file contains the output.
naturespot-name-differences.csv

[davidnicholls125]

Wow! Over 700 species.... Given that we are still hoping to switch to using the UKSI it probably isn't worth the mammoth effort that would be needed to manually amend the NS inventory at this point. However, even with the UKSI it still leaves us with the mismatches on our drupal species pages. Would is be possible to write a query to amend the drupal taxonomy and the title on the species pages?
I've looked through the list and realised that nearly 100 entries are duplicates - there doesn't appear to be any reason for this that I can find so could these be excluded? There are also 350+ which we don't need to change as the differences are just formats, but that still leaves over 300!

[davidnicholls125]

We've manually amended most of the name changes. For future reference, would it be possible to write a query that would update the names in drupal? It would need to change the entry in the drupal taxonomy and also any references to it on the species page.

[davidnicholls125]

We've manually amended most of the name changes. For future reference, would it be possible to write a query that would update the names in drupal? It would need to change the entry in the drupal taxonomy and also any references to it on the species page.

[johnvanbreda]

I'd have to write a custom module which accepts a CSV file of the changes, loops through them and applies them to the species accounts. Probably 3-4 hours work.

[davidnicholls125]

I think this will be worth it in the long-term. Would you be able to write something to all of the following?

1. Amend the name entry in the drupal species taxonomy
2. On the species page, amend the title entry (where needed)
3. Enter the old name in the 'Alternative names' field
4. Amend the URL alias keeping the format: /species/genus-species
5. Scan the other species page fields and update any reference to the old name (this could be just a reference to second part of the name (the species name element or could be abbreviated as G. species)

[davidnicholls125]

I think this will be worth it in the long-term. Would you be able to write something to all of the following?

1. Amend the name entry in the drupal species taxonomy
2. On the species page, amend the title entry (where needed)
3. Enter the old name in the 'Alternative names' field
4. Amend the URL alias keeping the format: /species/genus-species
5. Scan the other species page fields and update any reference to the old name (this could be just a reference to second part of the name (the species name element or could be abbreviated as G. species)