Topic: Transfer confidential location details to 'Private Location' field
I’ve identified a subset of records within our database where the location name contains confidential information (i.e. a house number).
I wanted to find a way of transferring these to the ‘Private Location’ field and updating the ‘Sample Location Name’ with an amended entry with the house number removed. I’ve already created a spreadsheet containing the following columns:
Taxon Occurrence Key | (new) Sample Location Name | (new) Private Location
What I wanted to know is: Is it possible to run a batch update(s) to make these bulk changes rather than me going through each individual sample and editing it?
Has anyone tried this?