1 Topic by andy_f

  • andy_f
  • andy_f
  • Member
  • Offline
  • From: BBOWT, Oxford
  • Registered: 06-12-2012
  • Posts: 42

Topic: Roll back from imported data

Hello

This seems like it should be a stupid question, but I haven't been able to figure out a suitable solution by my own experimentation or by searching the forum (apologies if this has been discussed before).

I would like to delete a large set of imported data from a single survey. However the survey already contained data with overlapping dates and locations as the imported data. Currently I can only separate the imported and previous data by running an external filter using the .ref file created during the import. However, I haven't managed to find a way to delete only those survey events as a group (too many to do manually) without deleting the whole survey. Can anyone let me know a way I can do this without also deleting the previously entered data, or to move the .ref filtered survey events as a group into a temporary survey which I can then delete in one go? Otherwise I'll have to go to a backed up version of the database, but it feels like there should be an easy way to do this.

Thanks,
Andy.

2 Reply by MikeWeideli

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

Re: Roll back from imported data

A batch update will do it. It can access the filter file.   If the records can be identified by survey event  you can use the filter file in a batch update to move all the events to a dummy survey and delete this. You can do this just by changing the Survey key in the events.  I will help further with examples if you need them.

Mike Weideli

MikeWeideli's Website

3 Reply by andy_f

  • andy_f
  • andy_f
  • Member
  • Offline
  • From: BBOWT, Oxford
  • Registered: 06-12-2012
  • Posts: 42

Re: Roll back from imported data

Hi thanks for the response Mike. I used the .ref file to extract a list of the unwanted survey event keys, and then looped through that to generate a series of update queries to change their survey keys to a dummy survey. I'm not sure that I understand how to make custom batch updates within the Recorder front end (if that is possible) so just queried the database directly, I think to the same end as what you suggested.

Best wishes,

Andy.

4 Reply by MikeWeideli

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

Re: Roll back from imported data

Same effect. Batch updates are just SQL in a XML wrapper which recorder can run, through the Batch Update menu. Same as XML reports. The help file which explains this is attached in case you find it useful in the future.

Post's attachments

R6XMlHelp.chm 685.41 kb, 2 downloads since 2013-11-12 

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

MikeWeideli's Website

5 Reply by andy_f

  • andy_f
  • andy_f
  • Member
  • Offline
  • From: BBOWT, Oxford
  • Registered: 06-12-2012
  • Posts: 42

Re: Roll back from imported data

Thanks again for your help Mike. I've never been able to open help .chm's successfully within or without of Recorder, through various versions of the help and on various computers with various flavours of Windows.  The same applies to your attached file. The best I get is the Contents in the left frame, but I can never see any actual content.  Presumably I'm missing something...

Any chance of the help pages making onto a website for easy access at any point?

Cheers,
Andy.

6 Reply by andy_f

  • andy_f
  • andy_f
  • Member
  • Offline
  • From: BBOWT, Oxford
  • Registered: 06-12-2012
  • Posts: 42

Re: Roll back from imported data

Ok, managed to get into the help file by decompressing/decompling to HTML using 7zip. Thanks again.

Andy.