[Koha] [Koha-devel] How to clean transaction table?

Michael Hafen michael.hafen at washk12.org
Wed Aug 14 05:38:35 NZST 2013


There are several database tables involved in the transactions.  And
cleaning them will probably be easiest from inside the database.

Please be advised that running commands like the one I'm going to add below
is very dangerous.  I advise leaving it to someone who knows databases.  At
the least you should backup the database first.

with that said, the sequence database queries would be something like:

Truncate Table branchtransfers;
Truncate Table issues;
Truncate Table old_issues;
Truncate Table reserves;
Truncate Table old_reserves;
Truncate Table tmp_holdsqueue;
Truncate Table accountoffsets;
Truncate Table accountlines;
Truncate Table statistics;
Truncate Table action_logs;

Those queries will clear all the checkins/checkouts, items being transfered
to other branches, reserves, and fines.



On Tue, Aug 13, 2013 at 3: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-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>


More information about the Koha mailing list