How to clean transaction table?
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
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@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@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/
Hi, On Tue, Aug 13, 2013 at 10:38 AM, Michael Hafen <michael.hafen@washk12.org>wrote:
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;
To add on one more command: UPDATE items SET onloan = NULL; This avoids a problem where an item would appear in certain places to still be on loan. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
Dear Hafen, I found that Truncate command is so danagerous. I used delete command to clean data in tables. Using delete command I cleared data in tables "statistics" and "accountlines". e.g. use koha_library; DELETE FROM statistics; I could erase fine amount in all transactions using following commands, use koha_library; *UPDATE `accountlines` SET `amount` = '';* Thank you again, On Tue, Aug 13, 2013 at 11:08 PM, Michael Hafen <michael.hafen@washk12.org>wrote:
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@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@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/
-- 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
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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jerry Brock e-Libris Technologies, LLC email: elibris.helpdesk@gmail.com <elibrishelpdesk@gmail.com> phone: 1-877-723-9447 ext. 2
Dear All, Koha (3.16) has been installed from packages method on ubuntu 12.4 LTS. Since, it is testing machine, and I would like to clean up all the transactions made under "PATRONS" ( for all patrons) 1. Circulation history 2. E-mail Notiecs 3. Modification Log and I am not sure how to go about this, Kindly share the mysql commands for the same. With Thanks Satish Librarian Govt. Engineering College, Hassan. Karnataka. INDIA. On Wed, Aug 14, 2013 at 7:40 AM, e-Libris Helpdesk < elibris.helpdesk@gmail.com> wrote:
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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jerry Brock e-Libris Technologies, LLC email: elibris.helpdesk@gmail.com <elibrishelpdesk@gmail.com> phone: 1-877-723-9447 ext. 2 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--
participants (5)
-
e-Libris Helpdesk -
Galen Charlton -
Michael Hafen -
SATISH -
Vimal Kumar V.