1

Topic: Transfer confidential location details to 'Private Location' field

Hi,

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?

Thanks!

Andy

Biodiversity Information Officer
EcoRecord

2

Re: Transfer confidential location details to 'Private Location' field

I'm watching for replies on this one. We have the same issue and often manually remove this information time and time again.