[Koha] How to clean transaction table?

e-Libris Helpdesk elibris.helpdesk at gmail.com
Wed Aug 14 14:10:22 NZST 2013

You should have delete privileges on your MySQL database.  I'm guessing you
can truncate the circ and other transaction table by delete existing

Just a thought.

Jerry Brock
e-Libris Technologies, LLC

On Tue, Aug 13, 2013 at 4:32 AM, Vimal Kumar V. <vimal0212 at gmail.com> wrote:

> Dear Friends,
> Today our Koha officially started in production mode.
> Trial transaction (checkout, checkin, fines etc) details are still in Koha.
> We wish to clean all transaction details from Koha and start the
> transactions fresh from today.
> If old transactions persist in Koha, auditors create problems at the year
> end.
> How can we clean the transaction table and get ready for a fresh startup?
> Regards,
> --
> Vimal Kumar V.
> Technical Assistant
> Mahatma Gandhi University Library
> Kottayam, Kerala- 686 560
> Web: http://www.vimalkumar.info
> Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> ---------------------------------------------------------------------------
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

Jerry Brock
e-Libris Technologies, LLC
email: elibris.helpdesk at gmail.com <elibrishelpdesk at gmail.com>
phone: 1-877-723-9447 ext. 2

More information about the Koha mailing list