Bulk search/delete by ISBNs?
Esteemed Colleagues, My library has a collection of about 5000 online books that are in Koha with bib records and no items. The publisher periodically archives titles so they're no longer available, and I have a list of them that I'd like to remove from Koha. The problem is that my list consists of ISBNs and that there are over 450 of them. I could search and delete one-by-one, but that's an awful lot of searching and deleting. Is there an easier way? We're on Koha 17.05* and Ubuntu 16.04. *I know, I know, but I'm hoping to get a new server before I upgrade. Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org Rest is not idleness, and to lie sometimes on the grass under trees on a summer's day, listening to the murmur of the water, or watching the clouds float across the sky, is by no means a waste of time. --Sir John Lubbock, The Use of Life (1894) ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.
Hi Fred You might be able to write a report to get all biblio with no items attached, of a certain type and then use that list of biblionumbers in the bulk biblio delete. Hope this helps Chris On 30 August 2019 1:51:31 AM NZST, "King, Fred" <Fred.King@Medstar.net> wrote:
Esteemed Colleagues,
My library has a collection of about 5000 online books that are in Koha with bib records and no items. The publisher periodically archives titles so they're no longer available, and I have a list of them that I'd like to remove from Koha. The problem is that my list consists of ISBNs and that there are over 450 of them. I could search and delete one-by-one, but that's an awful lot of searching and deleting. Is there an easier way?
We're on Koha 17.05* and Ubuntu 16.04.
*I know, I know, but I'm hoping to get a new server before I upgrade.
Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org
Rest is not idleness, and to lie sometimes on the grass under trees on a summer's day, listening to the murmur of the water, or watching the clouds float across the sky, is by no means a waste of time. --Sir John Lubbock, The Use of Life (1894)
---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI.
IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you.
Help conserve valuable resources - only print this email if necessary.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
participants (2)
-
Chris Cormack -
King, Fred