As Robin stated to me yesterday regarding my other query, checked out status comes from two locations (issues table and items.onloan field). So if I understand what you're asking, in order to remove all availability status I think you'd need to run the following two statements in MySQL: update items set onloan=NULL; delete from issues;
Of course, make a backup first :-) Hope this helps! Steve -----Original Message----- From: Vimal Kumar V. [mailto:vimal0...@gmail.com] Sent: Thursday, April 03, 2014 9:36 AM To: koha@lists.katipo.co.nz Subject: [Koha] Remove checked out status from marc records Dear Friends, I exported marc from one Koha 3.10 system and imported in a newly installed Koha 3.12 machine. Some books status says that its still on loan. No transactions made in new Koha. I think checked out status in old Koha available with marc record. How can I remove that status in bulk mode? Please see the screenshot from the below link, https://drive.google.com/file/d/0B6E3iEzJp74uSUhnSVZ6WXJGbUE/edit?usp=sharing 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 http://moovandan.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