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

[Coehoorn, Joel]

I haven't seen the SQL, but you might be able to change an INNER JOIN
somewhere into a LEFT JOIN and get the results you need.


Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoehoorn at york.edu <jcoehoorn at york.edu>*

*Please contact helpdesk at york.edu <helpdesk at york.edu> for technical
assistance.*


The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society


On Fri, Aug 30, 2019 at 12:20 PM King, Fred <Fred.King at medstar.net> 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
>