Send Koha-devel mailing list submissions to
koha-devel@lists.koha-community.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
koha-devel-request@lists.koha-community.org
You can reach the person managing the list at
koha-devel-owner@lists.koha-community.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."
Today's Topics:
1. Re: Elasticsearch not auto-updating after cataloguing
(Philippe Blouin)
2. Re: Elasticsearch not auto-updating after cataloguing
(Thomas Klausner)
3. Handling normalized phone number data (dcook@prosentient.com.au)
----------------------------------------------------------------------
Message: 1
Date: Tue, 13 Sep 2022 14:58:49 -0400
From: Philippe Blouin <philippe.blouin@inlibro.com>
To: Tomas Cohen Arazi <tomascohen@gmail.com>
Cc: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Elasticsearch not auto-updating after
cataloguing
Message-ID: <ea590f7c-17c9-e7c1-359d-b25a0041a2c8@inlibro.com>
Content-Type: text/plain; charset="utf-8"; Format="flowed"
Hi!
Depends on the installation, but where background_jobs_worker.pl runs or
not makes not difference in where the cataloguing->indexing path works.
It seems to always work when Koha runs on the same machine as ES, and
not otherwise.
Still looking for possible clues.
Best regards,
Philippe Blouin,
Directeur de la technologie
Tél. : (833) 465-4276, poste 230
philippe.blouin@inLibro.com
inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
On 2022-09-11 22:47, Tomas Cohen Arazi wrote:
> Is koha-worker running?
>
> El vie, 9 sept 2022 12:42, Philippe Blouin
> <philippe.blouin@inlibro.com> escribió:
>
> Hello kohaers!
>
> Simply put: our production servers installation work very fine,
> each change into a record is immediately reindexed into ES.
>
> BUT on laptop (ubuntu 20 or 22), the reindexing never occurs. We
> have to call rebuild_elasticsearch.pl
> <http://rebuild_elasticsearch.pl> manually so the search finds
> anything. The configuration refers to a remote ES server (instead
> of localhost like the prod servers), but I don't see how that
> would make a difference since that works once rebuilt.
>
> Any clue on what I'm missing would be greatly appreciated.
>
> Best regards,
>
> --
> Philippe Blouin,
> Directeur de la technologie
>
> Tél. : (833) 465-4276, poste 230
> philippe.blouin@inLibro.com
>
> inLibro | pour esprit libre | www.inLibro.com
> <http://www.inLibro.com>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220913/9b00ac59/attachment-0001.htm>
------------------------------
Message: 2
Date: Tue, 13 Sep 2022 22:33:32 +0200
From: Thomas Klausner <domm@plix.at>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Elasticsearch not auto-updating after
cataloguing
Message-ID: <20220913203332.GM490306@plix.at>
Content-Type: text/plain; charset=us-ascii
Hi!
On Tue, Sep 13, 2022 at 02:58:49PM -0400, Philippe Blouin wrote:
> Depends on the installation, but where background_jobs_worker.pl runs or not
> makes not difference in where the cataloguing->indexing path works.
>
> It seems to always work when Koha runs on the same machine as ES, and not
> otherwise.
Is the remote ES exposed via https? Maybe you have slightly different
Perls or Mozilla::CA installation? Any errors in the logs?
Which Koha Verion are you running? Are you sure both latpop and server
run the same version?
In the source code there is a param 'skip_record_index', which will
prevent the immediate indexing after an edit (if I've skimmed the code
correctly). Maybe that is set? Though I don't know when it would be set
(by whom..)
Greetings,
domm
--
#!/usr/bin/perl https://domm.plix.at
for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}
------------------------------
Message: 3
Date: Wed, 14 Sep 2022 16:42:55 +1000
From: <dcook@prosentient.com.au>
To: "'koha-devel'" <koha-devel@lists.koha-community.org>
Cc: "'Kyle Hall'" <kyle@bywatersolutions.com>, "'Tomas Cohen Arazi'"
<tomascohen@theke.io>, "'Martin Renvoize'"
<martin.renvoize@ptfs-europe.com>
Subject: [Koha-devel] Handling normalized phone number data
Message-ID: <19c201d8c805$48f950c0$daebf240$@prosentient.com.au>
Content-Type: text/plain; charset="utf-8"
Hi all,
I've been working lately on
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23817 in an effort
to let staff users easily search phone numbers in the Patrons module.
Currently, phone number searching doesn't work if you have punctuation or
other formatting inconsistent with your search query.
So I'm proposing normalizing phone numbers. Normalizing the search query is
easy, but normalizing the data in the database is harder. In older versions
of Koha, I used SQL to normalize the phone column in the WHERE clause, but
that's seemingly impossible now that we're using DataTables and the REST
API.
So it seems to me the only way forward is to normalize the data in the
database. I've attached a patch which provides a Koha::Patron->phone() set
method which normalizes the phone number before it's saved in the database,
but I don't know what other Koha folk think about that.
Thoughts?
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220914/cc5f2cca/attachment-0001.htm>
------------------------------
Subject: Digest Footer
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
------------------------------
End of Koha-devel Digest, Vol 202, Issue 14
*******************************************