Hi Fred, did you set the item type EBOOK in 942$c by chance? If yes, then the itemtype search will find them even if they are no items and we can also craft a SQL query to find them.
isbn.biblioitems shoudl be set from the data in your bibliographic record independent of existing items. Can you tell us what you tried? The 'Query MARC' section of the reports library might give you some pointers: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC Hope this helps, katrin On 30.08.19 19:19, King, Fred wrote:
Thanks to Chris and a script from George Williams, it worked like a charm. Almost. With a few of them. After a lot of trial and error, I think I might have found the problem: my SQL queries can’t find the item type EBOOK, or any data associated with bib records of that type. Since there aren’t any items associated with these records, that makes sense, but… Is there any way to run an SQL report looking for something in the biblioitems.isbn field when there aren’t any items attached? The 020 field has them, and I can put the ISBN in the search box, so the system knows they’re there. Thanks! And if I’m totally confused, could someone point me in the right direction? I’m about to leave for the day, and Monday is a holiday here in the States, so I might not be checking e-mail for a while. Have a great weekend everybody. Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center [email protected]<mailto:[email protected]> 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) From: Chris Cormack <[email protected]> Sent: Thursday, August 29, 2019 5:23 PM To: [email protected]; King, Fred <[email protected]> Subject: [EXTERNAL] Re: [Koha] Bulk search/delete by ISBNs? ** ATTENTION: This email originated from outside the MedStar network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. 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" <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]%3E<mailto:[email protected]%3cmailto:[email protected]%3E> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__medstarauthors.org&d=DwMFaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=E4eNiVIJtiO21Ua5DyrKj9CVOqS-pVLhHLXrzdtSCxA&s=nxjZBoMiTfLJ423yCYGyfFHjNanefLzmsCqbKH1soE0&e=> 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<https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DwMFaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=E4eNiVIJtiO21Ua5DyrKj9CVOqS-pVLhHLXrzdtSCxA&s=6sMFUxsF0xaQemqufEI6aYJ45LI1E5iAfi3JhLkRFC8&e=> [email protected]<mailto:[email protected]> https://lists.katipo.co.nz/mailman/listinfo/koha<https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DwMFaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=E4eNiVIJtiO21Ua5DyrKj9CVOqS-pVLhHLXrzdtSCxA&s=16UQvxVDiNyisn80ywDdWsKJ0Skgz1BnItHUhoVZrxU&e=> -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
