1 Topic by atheta01

  • atheta01
  • Veteran
  • Offline
  • From: YNU Coleoptera recorder
  • Registered: 30-10-2009
  • Posts: 318

Topic: Document references - links to events etc - batch update required

Is a batch update to delete document references which do NOT have surveys/events/samples/occurrences/persons linked to them a possible thing to put together? I have a large number of these in my dataset, resulting from data imports that were performed rather sloppily while running Recorder 3 before I moved to Recorder 2000 quite a few years ago. Does anyone have a batch update that will do this or a similar one which can be modified to suit?

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

atheta01's Website

2 Reply by MikeWeideli

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

Re: Document references - links to events etc - batch update required

I have had a go at this and the result is attached. Please make sure you take a backup before giving it a try and restore if there are any problems. Also check the results carefully. Let me know if there are any problems.

Post's attachments

LCDelUnattachedReferences.xml 3.73 kb, 4 downloads since 2013-06-07 

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

MikeWeideli's Website

3 Reply by atheta01

  • atheta01
  • Veteran
  • Offline
  • From: YNU Coleoptera recorder
  • Registered: 30-10-2009
  • Posts: 318

Re: Document references - links to events etc - batch update required

Thanks for this Mike - I will have a go at this tomorrow and get back to you which ever way it goes.

Bob.

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

atheta01's Website

4 Reply by atheta01

  • atheta01
  • Veteran
  • Offline
  • From: YNU Coleoptera recorder
  • Registered: 30-10-2009
  • Posts: 318

Re: Document references - links to events etc - batch update required

Many thanks Mike - batch update run and reduced number of document refs from 4100-ish down to about 1500

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

atheta01's Website