CiviCRM Community Forums (archive)

Hey there,

How can i delete the batch so that we can run the batch again?

I think you will have to do that at the database layer.  i.e. look at your civicrm_batch table and remove the entries for the batch ID in question.

'How come there is no batch delete workflow?', I hear you ask.  IMO there are a couple of reasons:

1) because these are being used for submission to HMRC, we were keen to make batches as read only as possible so we have an 'audit trail' etc.
2) the Batch entity is relatively new to CiviCRM and we didn't write a delete batch workflow.

HTH.  Let me know if you need more info.

Disclaimer: It might be that Batch has been improved upon since I last looked at it, but I am reasonably sure that it hasn't

Oops - forgot to mention that you will also need to delete the corresponding civicrm_entity_batch entries.

dependencies have got me one too many times!

I know what you are saying!

Unfortunately I seem to have an issue.

The system seems to be doing some strange things,

None of the donors who have donated twice within the period set have the 2nd donation in the batch.

The numbers are coming out very strange and considerably lower than before when i ran this and then deleted it, is there any other field that would stop the batch picking up anything as non eligible?

Thanks

Chelcone

Hey Chelcone,

First thing I would do (if you haven't already) is update your giftaid to the latest version, as recommended by Deepak in IRC just now (see below)

FROM IRC

[14:13] michaelmcandrew: deepaks: have u seen this forum post about giftaid?: http://forum.civicrm.org/index.php/topic,20605.0/topicseen.html
[14:20] deepaks: michaelmcandrew: just read
[14:22] deepaks: michaelmcandrew: you r right, batch & entity_batch are two tables that needs to be dealt with
[14:22] michaelmcandrew: thanks deepaks - there is another question afterwards from chelcone
[14:22] michaelmcandrew: any ideas about that?
[14:25] deepaks: michaelmcandrew: can't think of the reason, i would suggest to use the latest code as there been lot of fixes recently and give the steps to reproduce
[14:27] deepaks: michaelmcandrew: http://issues.civicrm.org/jira/browse/CRM-8250 was the issue when some major changes happened.
[14:28] michaelmcandrew: thanks deepaks
[14:28] deepaks: Also remember fixing some bugs
[14:28] michaelmcandrew: deepaks: have there been any db structure changes? or is it just code level?
[14:28] deepaks: just code level
[14:28] michaelmcandrew: just trying to work out whether chelcone can upgrade
[14:29] michaelmcandrew: his giftaid module
[14:29] michaelmcandrew: without worrying about the other stuff
[14:29] michaelmcandrew: ok - will tell him - thanks

Ok i didnt realise that the SVN was updated haha.

Downloaded it, but your documentation doesnt say if you need to run the import script again when you upgrade. Do i need to do that?

Thanks

Chelcone

Still having problems with this however i have done some digging and narrowed the issue.

Running the batch month by month brings up donations that are dated after the 1st donation, however any donations that are made after the 1st donation of the month still wont show in the report. its like the batch only check for A donation thats yes to gift aid instead of all donations that are yes.

I have done the update as recommended and really need help on this as we are going to miss our claim date if this doesn't work soon and if the claim is wrong then we can get fined.