[Koha] How to clean transaction table?

[e-Libris Helpdesk]

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

Just a thought.

Regards,
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