[Koha] Can't include itype in report (was Bulk search/delete by ISBNs?)

[Katrin Fischer]

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
> fred.king at medstar.net<mailto:fred.king at 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)
>
> From: Chris Cormack <chrisc at catalyst.net.nz>
> Sent: Thursday, August 29, 2019 5:23 PM
> To: koha at lists.katipo.co.nz; King, Fred <Fred.King at Medstar.net>
> 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" <Fred.King at Medstar.net<mailto:Fred.King at 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 at medstar.net<mailto:fred.king at medstar.net%3E<mailto:fred.king at medstar.net%3cmailto:fred.king at medstar.net%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=>
> Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
> 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
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha