1 Topic by FNRCinfoassist (edited by FNRCinfoassist 11-12-2019 12:30:00)

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 67

Topic: Batch update to change subspecies to species?

I have several hundred records for Pied Wagtail which recorder matched with the sub species Motacilla alba yerrellii. I have now located the original data and would like to update the sub species to the species. Is there a batch update that could do this?. Many thanks for any help. Mhairi

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,623

Re: Batch update to change subspecies to species?

Hi

This should do the job.  Please make sure you take a backup of the database and check the results before adding more data.

Post's attachments

LCSpecial201ChangeTLIKey.xml 454 b, 5 downloads since 2019-12-14 

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

MikeWeideli's Website

3 Reply by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 67

Re: Batch update to change subspecies to species?

thank you Mike, much appreciated. There are some other species with trinomials that I would like to change using the TOK key and the appropriate TVK. Is there anything more general available? Sorry to be a pest.
Mhairi