<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 15789 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 190, Issue 9<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Listing Zebra (and Elasticsearch) indexes for end-users'<br> benefit (Andrew Fuerste-Henry)<br> 2. Re: Listing Zebra (and Elasticsearch) indexes for end-users'<br> benefit (dcook@prosentient.com.au)<br> 3. Re: Listing Zebra (and Elasticsearch) indexes for end-users'<br> benefit (dcook@prosentient.com.au)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 8 Sep 2021 08:13:33 -0500<br>From: Andrew Fuerste-Henry <andrew@bywatersolutions.com><br>To: Fridolin SOMERS <fridolin.somers@biblibre.com><br>Cc: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Listing Zebra (and Elasticsearch) indexes<br> for end-users' benefit<br>Message-ID:<br> <CANGX5DxF3q27xK1GqtuGS7DJdBZ43coe3q7uAx23Kyo=D=mfvQ@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>Hi all!<br><br>For what it's worth, there is a list of Zebra indexes in the manual:<br>https://koha-community.org/manual/latest/en/html/searching.html#koha-search-indexes.<br>I'm all for a fun tool that shows them within Koha, but it'd also be great<br>if the manual were up to date.<br><br>Speaking of showing search indexes right in the Koha staff client, Elastic<br>already does that. The Search Engine Config page in administration shows<br>you exactly how all of your MARC data is indexed for Elastic. It would<br>totally make sense to rework this to also be able to show Zebra values.<br><br>Andrew<br><br>On Wed, Sep 8, 2021 at 3:49 AM Fridolin SOMERS <fridolin.somers@biblibre.com><br>wrote:<br><br>> Hi, sounds nice.<br>><br>> FIY I am actually using a transformation of Zebra config in order to<br>> present it in CSV:<br>><br>> https://git.biblibre.com/biblibre/tools/src/branch/master/zebra/list_indexes.xsl<br>><br>> We may use this to display in HTML.<br>><br>> Best regards,<br>><br>> Le 18/08/2021 à 17:12, dcook@prosentient.com.au a écrit :<br>> > Hi all,<br>> ><br>> > As always, a new day brings a new Zebra idea.<br>> ><br>> > One of my librarians asked me if there was any way to get a list of<br>> > Zebra indexes (particularly for Record Matching Rules), and I was all<br>> > prepared to say no… when I remembered something I read the other day.<br>> ><br>> > It turns out you can send the query "@attr exp1 1=1 attributedetails" to<br>> > the magical database “IR-explain-1”, and it will give you a list of all<br>> > the indexes in that database along with the type of index and how many<br>> > documents are indexed against that index in the database. I think this<br>> > is something that we should add to Koha!<br>> ><br>> > I’m not familiar with Koha’s use of Elasticsearch, but I imagine there<br>> > is an easy way of getting a list of Elasticsearch indexes?<br>> ><br>> > --<br>> ><br>> > Of course, while having a list of indexes is good, it would be nice to<br>> > know what MARC data is in each of those indexes. I’m thinking about<br>> > creating a Koha Plugin that parses "biblio-koha-indexdefs.xml" and shows<br>> > a user-friendly view of what parts of the MARC record are put into which<br>> > indexes.<br>> ><br>> > --<br>> ><br>> > What do folk think about that? I think having a list of Zebra indexes<br>> > would be very useful for Record Matching Rules, but also for a “Search<br>> > tips” guide for the Staff Interface and OPAC.<br>> ><br>> > While we could provide a static list of indexes, but I think that would<br>> > be too much of a maintenance burden. I think having a list from Zebra<br>> > (or Elasticsearch), which we could cache in Memcached, would be the way<br>> > to go.<br>> ><br>> > Ideally, we could have an API route that surfaces this information, so<br>> > that we could just do an AJAX lookup from a web interface.<br>> ><br>> > --<br>> ><br>> > I’m hoping my librarian will sponsor development of a plugin, but I<br>> > think this would be useful in the core Koha code.<br>> ><br>> > David Cook<br>> ><br>> > Senior Software Engineer<br>> ><br>> > Prosentient Systems<br>> ><br>> > Suite 7.03<br>> ><br>> > 6a Glen St<br>> ><br>> > Milsons Point NSW 2061<br>> ><br>> > Australia<br>> ><br>> > Office: 02 9212 0899<br>> ><br>> > Online: 02 8005 0595<br>> ><br>><br>> --<br>> Fridolin SOMERS <fridolin.somers@biblibre.com><br>> Software and system maintainer 🦄<br>> BibLibre, France<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>><br><br><br>-- <br>Andrew Fuerste-Henry<br>Educator<br>(he/they)<br>ByWater Solutions<br>bywatersolutions.com<br>Phone:(888)900-8944 <(888)%20900-8944><br><br>What is Koha?<br><http://bywatersolutions.com/what-is-koha/><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210908/65f6abf7/attachment-0001.htm><br><br>------------------------------<br><br>Message: 2<br>Date: Thu, 9 Sep 2021 09:26:29 +1000<br>From: <dcook@prosentient.com.au><br>To: "'Fridolin SOMERS'" <fridolin.somers@biblibre.com>, "'koha-devel'"<br> <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Listing Zebra (and Elasticsearch) indexes<br> for end-users' benefit<br>Message-ID: <120801d7a508$f3654260$da2fc720$@prosentient.com.au><br>Content-Type: text/plain; charset="utf-8"<br><br>Thanks for sharing that. I look forward to looking at it more if/when I make that plugin.<br><br>David Cook<br>Senior Software Engineer<br>Prosentient Systems<br>Suite 7.03<br>6a Glen St<br>Milsons Point NSW 2061<br>Australia<br><br>Office: 02 9212 0899<br>Online: 02 8005 0595<br><br>-----Original Message-----<br>From: Fridolin SOMERS <fridolin.somers@biblibre.com> <br>Sent: Wednesday, 8 September 2021 6:50 PM<br>To: 'koha-devel' <koha-devel@lists.koha-community.org><br>Cc: dcook@prosentient.com.au<br>Subject: Re: Listing Zebra (and Elasticsearch) indexes for end-users' benefit<br><br>Hi, sounds nice.<br><br>FIY I am actually using a transformation of Zebra config in order to present it in CSV:<br>https://git.biblibre.com/biblibre/tools/src/branch/master/zebra/list_indexes.xsl<br><br>We may use this to display in HTML.<br><br>Best regards,<br><br>Le 18/08/2021 à 17:12, dcook@prosentient.com.au a écrit :<br>> Hi all,<br>> <br>> As always, a new day brings a new Zebra idea.<br>> <br>> One of my librarians asked me if there was any way to get a list of <br>> Zebra indexes (particularly for Record Matching Rules), and I was all <br>> prepared to say no… when I remembered something I read the other day.<br>> <br>> It turns out you can send the query "@attr exp1 1=1 attributedetails" <br>> to the magical database “IR-explain-1”, and it will give you a list of <br>> all the indexes in that database along with the type of index and how <br>> many documents are indexed against that index in the database. I think <br>> this is something that we should add to Koha!<br>> <br>> I’m not familiar with Koha’s use of Elasticsearch, but I imagine there <br>> is an easy way of getting a list of Elasticsearch indexes?<br>> <br>> --<br>> <br>> Of course, while having a list of indexes is good, it would be nice to <br>> know what MARC data is in each of those indexes. I’m thinking about <br>> creating a Koha Plugin that parses "biblio-koha-indexdefs.xml" and <br>> shows a user-friendly view of what parts of the MARC record are put <br>> into which indexes.<br>> <br>> --<br>> <br>> What do folk think about that? I think having a list of Zebra indexes <br>> would be very useful for Record Matching Rules, but also for a “Search <br>> tips” guide for the Staff Interface and OPAC.<br>> <br>> While we could provide a static list of indexes, but I think that <br>> would be too much of a maintenance burden. I think having a list from <br>> Zebra (or Elasticsearch), which we could cache in Memcached, would be <br>> the way to go.<br>> <br>> Ideally, we could have an API route that surfaces this information, so <br>> that we could just do an AJAX lookup from a web interface.<br>> <br>> --<br>> <br>> I’m hoping my librarian will sponsor development of a plugin, but I <br>> think this would be useful in the core Koha code.<br>> <br>> David Cook<br>> <br>> Senior Software Engineer<br>> <br>> Prosentient Systems<br>> <br>> Suite 7.03<br>> <br>> 6a Glen St<br>> <br>> Milsons Point NSW 2061<br>> <br>> Australia<br>> <br>> Office: 02 9212 0899<br>> <br>> Online: 02 8005 0595<br>> <br><br>--<br>Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄<br>BibLibre, France<br><br><br><br><br>------------------------------<br><br>Message: 3<br>Date: Thu, 9 Sep 2021 09:56:39 +1000<br>From: <dcook@prosentient.com.au><br>To: "'Andrew Fuerste-Henry'" <andrew@bywatersolutions.com>, "'Fridolin<br> SOMERS'" <fridolin.somers@biblibre.com><br>Cc: "'koha-devel'" <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Listing Zebra (and Elasticsearch) indexes<br> for end-users' benefit<br>Message-ID: <121001d7a50d$2a7d94b0$7f78be10$@prosentient.com.au><br>Content-Type: text/plain; charset="utf-8"<br><br>Hi Andrew,<br><br> <br><br>Thanks for sharing that manual page. It actually reminds me that there’s a difference too between Zebra indexes and CCL qualifiers. For instance 030 is indexed into CODEN, but CODEN isn’t a CCL qualifier, so you can’t use it for searching. That certainly adds an extra wrinkle…<br><br> <br><br>Yeah, Zebra and Elastic are very different though. I don’t know that Search Engine Config would be the right place to show Zebra content which is not dynamically configurable. <br><br> <br><br>After having another think about it, listing Zebra indexes isn’t accurate enough, because what we really need are Zebra CCL qualifiers mapped to MARC fields. <br><br> <br><br>In the end to be mostly accurate, it’s processing biblio-koha-indexdefs.xml (it would be more accurate to process biblio-zebra-indexdefs.xsl although that’s much harder), processing bib1.att, processing ccl.properties, and maybe a dynamic lookup from Zebra. <br><br> <br><br>Ideally, I’d like to be able to show that Zebra CCL qualifier to MARC field relationship to both Staff and OPAC users, although I suppose your average user (on either interface) won’t know MARC anyway…<br><br> <br><br>David Cook<br><br>Senior Software Engineer<br><br>Prosentient Systems<br><br>Suite 7.03<br><br>6a Glen St<br><br>Milsons Point NSW 2061<br><br>Australia<br><br> <br><br>Office: 02 9212 0899<br><br>Online: 02 8005 0595<br><br> <br><br>From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Andrew Fuerste-Henry<br>Sent: Wednesday, 8 September 2021 11:14 PM<br>To: Fridolin SOMERS <fridolin.somers@biblibre.com><br>Cc: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Listing Zebra (and Elasticsearch) indexes for end-users' benefit<br><br> <br><br>Hi all!<br><br> <br><br>For what it's worth, there is a list of Zebra indexes in the manual: https://koha-community.org/manual/latest/en/html/searching.html#koha-search-indexes. I'm all for a fun tool that shows them within Koha, but it'd also be great if the manual were up to date.<br><br> <br><br>Speaking of showing search indexes right in the Koha staff client, Elastic already does that. The Search Engine Config page in administration shows you exactly how all of your MARC data is indexed for Elastic. It would totally make sense to rework this to also be able to show Zebra values.<br><br> <br><br>Andrew<br><br> <br><br>On Wed, Sep 8, 2021 at 3:49 AM Fridolin SOMERS <fridolin.somers@biblibre.com <mailto:fridolin.somers@biblibre.com> > wrote:<br><br>Hi, sounds nice.<br><br>FIY I am actually using a transformation of Zebra config in order to <br>present it in CSV:<br>https://git.biblibre.com/biblibre/tools/src/branch/master/zebra/list_indexes.xsl<br><br>We may use this to display in HTML.<br><br>Best regards,<br><br>Le 18/08/2021 à 17:12, dcook@prosentient.com.au <mailto:dcook@prosentient.com.au> a écrit :<br>> Hi all,<br>> <br>> As always, a new day brings a new Zebra idea.<br>> <br>> One of my librarians asked me if there was any way to get a list of <br>> Zebra indexes (particularly for Record Matching Rules), and I was all <br>> prepared to say no… when I remembered something I read the other day.<br>> <br>> It turns out you can send the query "@attr exp1 1=1 attributedetails" to <br>> the magical database “IR-explain-1”, and it will give you a list of all <br>> the indexes in that database along with the type of index and how many <br>> documents are indexed against that index in the database. I think this <br>> is something that we should add to Koha!<br>> <br>> I’m not familiar with Koha’s use of Elasticsearch, but I imagine there <br>> is an easy way of getting a list of Elasticsearch indexes?<br>> <br>> --<br>> <br>> Of course, while having a list of indexes is good, it would be nice to <br>> know what MARC data is in each of those indexes. I’m thinking about <br>> creating a Koha Plugin that parses "biblio-koha-indexdefs.xml" and shows <br>> a user-friendly view of what parts of the MARC record are put into which <br>> indexes.<br>> <br>> --<br>> <br>> What do folk think about that? I think having a list of Zebra indexes <br>> would be very useful for Record Matching Rules, but also for a “Search <br>> tips” guide for the Staff Interface and OPAC.<br>> <br>> While we could provide a static list of indexes, but I think that would <br>> be too much of a maintenance burden. I think having a list from Zebra <br>> (or Elasticsearch), which we could cache in Memcached, would be the way <br>> to go.<br>> <br>> Ideally, we could have an API route that surfaces this information, so <br>> that we could just do an AJAX lookup from a web interface.<br>> <br>> --<br>> <br>> I’m hoping my librarian will sponsor development of a plugin, but I <br>> think this would be useful in the core Koha code.<br>> <br>> David Cook<br>> <br>> Senior Software Engineer<br>> <br>> Prosentient Systems<br>> <br>> Suite 7.03<br>> <br>> 6a Glen St<br>> <br>> Milsons Point NSW 2061<br>> <br>> Australia<br>> <br>> Office: 02 9212 0899<br>> <br>> Online: 02 8005 0595<br>> <br><br>-- <br>Fridolin SOMERS <fridolin.somers@biblibre.com <mailto:fridolin.somers@biblibre.com> ><br>Software and system maintainer 🦄<br>BibLibre, France<br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> <br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br><br><br> <br><br>-- <br><br>Andrew Fuerste-Henry<br><br>Educator<br><br>(he/they)<br><br>ByWater Solutions<br><br> <http://bywatersolutions.com/> bywatersolutions.com<br><br>Phone: <tel:(888)%20900-8944> (888)900-8944<br><br> <https://drive.google.com/a/bywatersolutions.com/uc?id=1VVVFrey9XECr3VKtRsBrnaF0w5ESXYcA&export=download> <br><br> <http://bywatersolutions.com/what-is-koha/> What is Koha?<br><br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210909/5d4a10ad/attachment.htm><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 190, Issue 9<br>******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>