1 Topic by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Topic: Bulk Update Determination Type

Hi All,
We have a large number of quite old records in R6 with weird and wonderful 'determination types'.

We would like to update all these records to have one of our standard set of determination types and then delete the dodgy types.

Is there a way of doing this either within R6 or in the SQL?

Many thanks,
Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Bulk Update Determination Type

You should be able to use "merge data items" with Determination Types

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Re: Bulk Update Determination Type

Thanks Charlie - that worked a treat!

However, on a couple like 'original' and 'observation' we get a warning: 'the data is system supplied and cannot be reassigned'.

Is there any way of doing a find and replace on these (even if we dont actually delete them)?

Thanks,
Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website

4 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Bulk Update Determination Type

You'd have to use SQL for those - as the warning implies, you can only 'assign to' system supplied data.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

5 Reply by SteveGoddard

  • SteveGoddard
  • SteveGoddard
  • Member
  • Offline
  • From: Brecon
  • Registered: 31-01-2012
  • Posts: 39

Re: Bulk Update Determination Type

Thanks Charlie - I think we might leave those - I'm reluctant to start fiddling with the raw data in the tables.

Steve

=====================================================
Steve Goddard - IT Officer
Biodiversity Information Service for Powys & Brecon Beacons National Park
T: 01874 610881 - E: steve[at]b-i-s.org - W: www.b-i-s.org

SteveGoddard's Website