[Koha] Remove checked out status from marc records

[Steven Nickerson]

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:vimal0212 at gmail.com] 
Sent: Thursday, April 03, 2014 9:36 AM
To: koha at 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