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=sharin... 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
Dear Vimal, I think it is picking from koha 952 field so pls remove that sub-field with the help of marc edit which is responsible for that. It may be from other field also pls check and confirm me. On Thu, 03 Apr 2014 19:06:30 +0530 wrote
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=sharin... 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 With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian@rediffmail.com : mishravk79@gmail.com
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@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=sharin... 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
participants (3)
-
Steven Nickerson -
Vimal Kumar V. -
Vinod Kumar Mishra