[Koha] exporting/querying only records having at least one item

[Indranil Das Gupta]

Hi Giuseppe,

You have mentioned that you are in the process of setting up your library
and given that you are inheriting the bibliographic records from a
different catalogue, I would say a cleaner approach would be to setup a
parallel Koha instance, import this catalog into that and have this second
instance run as a z39.50 service. Your actual instance could import the bib
records from this second instance only of actual titles you have in your
collection.

That said, your question #1 can be addressed via some XSLT that looks if
any item is attached to the bib record, i.e.

 <xsl:when test="count(key('item-by-status', 'available'))=0 and
count(key('item-by-status', 'reference'))=0">

And then adding the modified XSLT stylesheet to your Koha
via OPACXSLTResultsDisplay system preference (by overriding the default).

With regard to your question #2 : At least on MARC21, when you export the
MARC records, only bibs with items get exported IIRC (I would assume that
the behavior should be similar for UNIMARC as well).

Hope this helps.


Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW  : http://www.l2c2.co.in
Blog    : http://blog.l2c2.co.in
IRC     : indradg on irc://irc.freenode.net
Twitter : indradg

On Sat, Jul 21, 2018 at 5:30 PM, giuseppe <giuseppe.ciaccio at unige.it> wrote:

> Hello all,
>
> sorry for bothering with a possibly silly question.  I'm a beginner with
> Koha.  We are setting up the archive of our library.  Our approach to
> populating the archive is perhaps peculiar: indeed we have been given a
> unimarc backup of bibliographic records from a larger library, and thus we
> are expecting to mostly (but now always) add items to existing records.
>
> So, since the beginning, our archive has a lot of bibliographic records
> associated with no items.  Querying such a set is somehow misleading for a
> end user: most of the answer, indeed, will not correspond to items actually
> found in the library.  Hence my two questions:
>
> 1) Is there a way to configure/tweak the user search interface so that only
> records with nonzero items will be searched?
> 2) Is there a way to export (for backup purposes) only records having
> nonzero items
>
> (BTW the latter would also provide an alternate solution to the former)
>
> Thanks a lot for any suggestions, and many thanks to the maintainers and
> contributors of this nice and useful software,
>
> Giuseppe Ciaccio
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>