1 Topic by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Topic: Batch delete

In in my records I have some duplicated data which needs to be deleted, which represents circa 350 separate events. Identifying the records is straight forward, as it is all events between 2002 and 2008 for two Locations.

I had a look at the JNCCDel5Records Batch Update to see whether that could be easily modified to delete the events. Obviously it can be used to delete everything below for a single event, but given the size of the file, a non-trivial exercise to modify to delete all events in one or a few goes.

Any suggestions?

Harry Clarke
Surrey County Butterfly Recorder

2 Reply by MikeWeideli

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

Re: Batch delete

The default section of the Batch Update can be easily be altered to so this. It means changing the Where clause in the SQL statement to populate  the temporary tabel with the records you want to delete. I will do it for you, but I will need the specific keys for the Locations (you can get them using the meta data button). Also can you be very specific about the dates (ie do you mean start dates 1/1/2002 to 31/12/2008).

Mike Weideli

MikeWeideli's Website

3 Reply by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Re: Batch delete

Many thanks Mike for your offer, the two locations are:
DSS007180000007W
DSS007180000007I

Yes the dates are from 1 Jan 2002 to 31 Dec 2008

Harry Clarke
Surrey County Butterfly Recorder

4 Reply by MikeWeideli

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

Re: Batch delete

The batch update which should do this is attached.  It is down to you to make sure that you have security before you run it and that it has done the right thing. Check the results carefully and  restore from backup if you have any doubts. It runs from Run Batch Update in the tools menu and is in the Delete menu under Special Delete.

It is a 'one off' just designed to do this specific task.

Post's attachments

LCSpecialDelete.xml 7.79 kb, 3 downloads since 2013-09-27 

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

MikeWeideli's Website

5 Reply by HarryClarke

  • HarryClarke
  • Veteran
  • Offline
  • From: Surrey
  • Registered: 11-10-2011
  • Posts: 99

Re: Batch delete

Many thanks, the batch delete seems to have worked correctly

Harry Clarke
Surrey County Butterfly Recorder