[Koha-devel] Listing Zebra (and Elasticsearch) indexes for end-users' benefit

[dcook at prosentient.com.au]

Thanks for sharing that. I look forward to looking at it more if/when I make that plugin.

David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia

Office: 02 9212 0899
Online: 02 8005 0595

-----Original Message-----
From: Fridolin SOMERS <fridolin.somers at biblibre.com> 
Sent: Wednesday, 8 September 2021 6:50 PM
To: 'koha-devel' <koha-devel at lists.koha-community.org>
Cc: dcook at prosentient.com.au
Subject: Re: Listing Zebra (and Elasticsearch) indexes for end-users' benefit

Hi, sounds nice.

FIY I am actually using a transformation of Zebra config in order to present it in CSV:
https://git.biblibre.com/biblibre/tools/src/branch/master/zebra/list_indexes.xsl

We may use this to display in HTML.

Best regards,

Le 18/08/2021 à 17:12, dcook at prosentient.com.au a écrit :
> Hi all,
> 
> As always, a new day brings a new Zebra idea.
> 
> One of my librarians asked me if there was any way to get a list of 
> Zebra indexes (particularly for Record Matching Rules), and I was all 
> prepared to say no… when I remembered something I read the other day.
> 
> It turns out you can send the query "@attr exp1 1=1 attributedetails" 
> to the magical database “IR-explain-1”, and it will give you a list of 
> all the indexes in that database along with the type of index and how 
> many documents are indexed against that index in the database. I think 
> this is something that we should add to Koha!
> 
> I’m not familiar with Koha’s use of Elasticsearch, but I imagine there 
> is an easy way of getting a list of Elasticsearch indexes?
> 
> --
> 
> Of course, while having a list of indexes is good, it would be nice to 
> know what MARC data is in each of those indexes. I’m thinking about 
> creating a Koha Plugin that parses "biblio-koha-indexdefs.xml" and 
> shows a user-friendly view of what parts of the MARC record are put 
> into which indexes.
> 
> --
> 
> What do folk think about that? I think having a list of Zebra indexes 
> would be very useful for Record Matching Rules, but also for a “Search 
> tips” guide for the Staff Interface and OPAC.
> 
> While we could provide a static list of indexes, but I think that 
> would be too much of a maintenance burden. I think having a list from 
> Zebra (or Elasticsearch), which we could cache in Memcached, would be 
> the way to go.
> 
> Ideally, we could have an API route that surfaces this information, so 
> that we could just do an AJAX lookup from a web interface.
> 
> --
> 
> I’m hoping my librarian will sponsor development of a plugin, but I 
> think this would be useful in the core Koha code.
> 
> David Cook
> 
> Senior Software Engineer
> 
> Prosentient Systems
> 
> Suite 7.03
> 
> 6a Glen St
> 
> Milsons Point NSW 2061
> 
> Australia
> 
> Office: 02 9212 0899
> 
> Online: 02 8005 0595
> 

--
Fridolin SOMERS <fridolin.somers at biblibre.com> Software and system maintainer 🦄
BibLibre, France