Hello, Does anyone have a script to bulk remove items and then bibs with no items attached? I can't seem to find anything anywhere that can do this. -Sorry if this is a double post, I am having trouble posting to the list at the moment - Thanks Barry
There is a bulk item delete tool (http://koha-community.org/documentation/3-2-manual/?ch=x5580) in Koha 3.2, but not a bulk bib delete tool ... yet :) Nicole 2010/11/16 bar <bar@oslo.ie>:
Hello,
Does anyone have a script to bulk remove items and then bibs with no items attached? I can't seem to find anything anywhere that can do this.
-Sorry if this is a double post, I am having trouble posting to the list at the moment -
Thanks Barry
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
This script will delete bibs with no items: http://koha-plus.git.sourceforge.net/git/gitweb.cgi?p=koha-plus/koha-plus;a=... Kyle http://www.kylehall.info Mill Run Technology Solutions ( http://millruntech.com ) Crawford County Federated Library System ( http://www.ccfls.org ) Meadville Public Library ( http://www.meadvillelibrary.org ) On Tue, Nov 16, 2010 at 7:58 AM, Nicole Engard <nengard@gmail.com> wrote:
There is a bulk item delete tool (http://koha-community.org/documentation/3-2-manual/?ch=x5580) in Koha 3.2, but not a bulk bib delete tool ... yet :)
Nicole
2010/11/16 bar <bar@oslo.ie>:
Hello,
Does anyone have a script to bulk remove items and then bibs with no items attached? I can't seem to find anything anywhere that can do this.
-Sorry if this is a double post, I am having trouble posting to the list at the moment -
Thanks Barry
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi All While that script does do exactly what it says, delete biblio with no items attached. If you are using acquisitions, and have it set to create items on receipt, it will delete biblios that you may have on order. The same goes with serials. DelBiblio will delete the subscription information. This may be exactly what you want, but I just wanted to point it out in case it wasnt. Chris 2010/11/17 Kyle Hall <kyle.m.hall@gmail.com>:
This script will delete bibs with no items: http://koha-plus.git.sourceforge.net/git/gitweb.cgi?p=koha-plus/koha-plus;a=...
Kyle
http://www.kylehall.info Mill Run Technology Solutions ( http://millruntech.com ) Crawford County Federated Library System ( http://www.ccfls.org ) Meadville Public Library ( http://www.meadvillelibrary.org )
On Tue, Nov 16, 2010 at 7:58 AM, Nicole Engard <nengard@gmail.com> wrote:
There is a bulk item delete tool (http://koha-community.org/documentation/3-2-manual/?ch=x5580) in Koha 3.2, but not a bulk bib delete tool ... yet :)
Nicole
2010/11/16 bar <bar@oslo.ie>:
Hello,
Does anyone have a script to bulk remove items and then bibs with no items attached? I can't seem to find anything anywhere that can do this.
-Sorry if this is a double post, I am having trouble posting to the list at the moment -
Thanks Barry
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Another thing to be wary of is that a lot of sites will create title records with no items for electronic resources -- things that are only available online. Those titles need to be protected from a global delete as well. Jane Wagner Senior Project Manager LibLime, a division of PTFS Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner@liblime.com -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Chris Cormack Sent: Tuesday, November 16, 2010 12:13 PM To: Kyle Hall Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Fwd: Removing items and Bibs Hi All While that script does do exactly what it says, delete biblio with no items attached. If you are using acquisitions, and have it set to create items on receipt, it will delete biblios that you may have on order. The same goes with serials. DelBiblio will delete the subscription information. This may be exactly what you want, but I just wanted to point it out in case it wasnt. Chris 2010/11/17 Kyle Hall <kyle.m.hall@gmail.com>:
This script will delete bibs with no items:
http://koha-plus.git.sourceforge.net/git/gitweb.cgi?p=koha-plus/koha-plus; a=blob_plain;f=misc/scrub_orphaned_biblios.pl;hb=master
Kyle
http://www.kylehall.info Mill Run Technology Solutions ( http://millruntech.com ) Crawford County Federated Library System ( http://www.ccfls.org ) Meadville Public Library ( http://www.meadvillelibrary.org )
On Tue, Nov 16, 2010 at 7:58 AM, Nicole Engard <nengard@gmail.com>
There is a bulk item delete tool (http://koha-community.org/documentation/3-2-manual/?ch=x5580) in Koha 3.2, but not a bulk bib delete tool ... yet :)
Nicole
2010/11/16 bar <bar@oslo.ie>:
Hello,
Does anyone have a script to bulk remove items and then bibs with no items attached? I can't seem to find anything anywhere that can do this.
-Sorry if this is a double post, I am having trouble posting to the
wrote: list
at the moment -
Thanks Barry
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Another thing to be wary of is that a lot of sites will create title records with no items for electronic resources -- things that are only available online. Those titles need to be protected from a global delete as well.
This script seems to allow to exclude items by items type (biblio level item type). That would solve your concern. But you need to have biblio level item type which isn't always the case. An improvement of this script could also be done in the way 'protected' biblio records are protected from being delete. It could be done directly in the SQL query. For example, this query find all biblionumber of biblio records without items and which are not of item type AGH or PER : SELECT biblio.biblionumber FROM biblio RIGHT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE items.biblionumber IS NULL AND itemtype NOT IN ('AGH', 'PER');
participants (6)
-
bar -
Chris Cormack -
Frédéric Demians -
Kyle Hall -
Nicole Engard -
Wagner, Jane