1 Topic by FNRCinfoassist

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

Topic: Changing sub species to species using tok keys

Hello, a few years ago Mike made me an xml batch update that would change a sub species of bird to a species (Motacilla alba yarrellii to Motacilla alba). Is there anyway I can get that xml (LCSpecial201) edited to only change the records listed by TOK in a csv rather than every record of sub sp yarrellii? Some of the yarrelliis need to stay as yarrelliis. There are many hundreds that need to change in our database and it would be a pain to have to do them one by one. Any help appreciated.
Mhairi

Post's attachments

LCSpecial201ChangeTLIKey.xml 454 b, 5 downloads since 2023-10-31 

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

2 Reply by MikeWeideli

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

Re: Changing sub species to species using tok keys

Generate an excel file using the report Wizard. Make sure you include the  Taxon_Occurrence_key. Remove any records which are Ok and all columns except the Taxon_Occurrence_Key. Save as a csv file which can be used in an dapted version of the batch update.

I attach an xml file designed to do this, but can't test it here at the momen. take a backup before trying and if it works check the resukts with a new  Report before continuing to use Recorder.  Let me know if it fails and I will take a look.

Post's attachments

LCSpecial202ChangeTLIKey.xml 817 b, 2 downloads since 2023-11-01 

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: 69

Re: Changing sub species to species using tok keys

Hi Mike, I tried this yesterday and again today but it didnt work. I got a message saying it had been applied but nothing has changed on the records themselves. I shall have another look at these next week. Thank you
Mhairi