Re: [Koha-devel] Koha 24.05 is here!

[Marcel de Rooy via Koha-devel]

Great, Katrin. Congrats!


Van: Koha-devel  namens Fischer, 
Katrin via Koha-devel 
Verzonden: dinsdag 28 mei 2024 11:15
Aan: koha-devel@lists.koha-community.org ; 
'koha' 
Onderwerp: [Koha-devel] Koha 24.05 is here!

The Koha community is proud to announce the release of Koha 24.05.00.

Koha 24.05.00 is a major release that comes with many new features.

It includes 9 new features, 239 enhancements, 529 bugfixes.

The full release notes are available here:
https://koha-community.org/koha-24-05-00-released/
 ‎

Debian packages are available.

--
Katrin Fischer
Bibliotheksservice-Zentrum Baden-Wuerttemberg (BSZ)
78457 Konstanz / Germany
Phone: +49 7531 - 88 4934
E-Mail: katrin.fisc...@bsz-bw.de
http://bsz-bw.de/




___
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/

[Koha-devel] Signoff request

[Marcel de Rooy via Koha-devel]

Hello all,

I need help on the following bugs (signoffs), all related to acquisition,
although some marked as architectural:

36002 Koha Acquisit m.de.r...@rijksmuseum.nl Need --- enh Get rid of
aqorders.purchaseordernumber 2024-02-06
36018 Koha Architec m.de.r...@rijksmuseum.nl Need --- enh Improve
consistency in Acquisition/Order(s) regarding active/current orders
2024-03-25 (rebased)
35994 Koha Architec m.de.r...@rijksmuseum.nl Need --- enh New acquisition
status method to see if biblio record is still in acquisition 13:04:46
(changed title)

Still apply on master today. Would be nice to see them getting further.
35994 has dependencies.

Thanks,
Marcel
___
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/

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

[Marcel de Rooy via Koha-devel]

+1

Van: Koha-devel  namens David Cook 
via Koha-devel 
Verzonden: vrijdag 12 april 2024 03:36
Aan: 'Koha-devel' 
Onderwerp: [Koha-devel] Finding invalid XML characters in Koha data via SQL


Hi all,



I just wanted to share a (MariaDB) SQL report that I wrote for finding bib 
records with invalid XML characters:

select biblionumber from biblio_metadata where metadata REGEXP 
'[^\\x{0009}\\x{000A}\\x{000D}\\x{0020}-\\x{D7FF}\\x{E000}-\\x{FFFD}\\x{1}-\\x{10}]+';



Newer versions of Koha strip invalid character from the XML so that you can fix 
your records. I figure this report is very valuable when coupled with that 
functionality. In fact, I just advised a library today to use them together to 
fix up some bad data in their catalogue.



--



On a related note, I’ve noticed that you can have a record with good bib XML 
but invalid item XML, and you won’t notice until your record fails to be 
indexed. So I’m planning on writing a report for that too.



I’m thinking it might be good to add these reports to core Koha, so that people 
can find and fix their own metadata problems. What do people think?



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


___
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/

Re: [Koha-devel] Random XSLT knowledge

[Marcel de Rooy via Koha-devel]

Cool. Nice example. Thanks.

From: David Cook 
Sent: Monday, March 11, 2024 12:27 AM
To: Marcel de Rooy ; 'Koha Devel' 

Subject: RE: [Koha-devel] Random XSLT knowledge

Hi Marcel,

Sure!

Before Koha started using “http://exslt.org/strings” to encode URIs, I used to 
use register_function to add my own function to do that.


  1.  vi C4/XSLT.pm
  2.  Add a line near the top like:
 *   
XML::LibXSLT->register_function("http://.prosentient.com.au/xsltperl;, 
"uri-escape",\::Prosentient::Biblio::Urls::xslt_uri_escape);
  3.  Write a function like this:
sub xslt_uri_escape {
my ($uri) = @_;
#$uri should always be a XML::LibXML::Nodelist, even if that Nodelist just 
contains 1 URI
if (ref $uri eq "XML::LibXML::NodeList"){
$uri->foreach(
sub {
my ( $node ) = @_;
#If the node has child (text) nodes
if ($node->hasChildNodes()){
my @childNodes = $node->childNodes();
if (@childNodes){
foreach my $childNode (@childNodes){
if (my $textdata = $childNode->data){
#Trim whitespace
$textdata =~ s/^\s+|\s+$//g;
my $encoded_url = 
URI::Encode::uri_encode($textdata, { encode_reserved => 0 });
if ($encoded_url){
#Replace the existing URI data with the 
encoded URI data
$childNode->setData($encoded_url);
}
}
}
}
}
}
);
}
return $uri;
}


  1.  Add the namespace at the top of your XSLT:
 *   xmlns:pro="http://.prosentient.com.au/xsltperl;
  2.  Call the function on some XML:
 *   

--

More recently, I’ve done more complicated things like looking up item urls for 
that biblio record, deduplicating them against the 856$u, and adding them to 
the online access in the search results. I continue to take into account 
OpacHiddenItems and its associated preferences. Since it’s operating at the 
Perl level, I’m able to check the C4::Context->userenv for the patron details 
as well.

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

From: Marcel de Rooy mailto:m.de.r...@rijksmuseum.nl>>
Sent: Friday, 8 March 2024 6:13 PM
To: 'Koha Devel' 
mailto:koha-devel@lists.koha-community.org>>;
 David Cook mailto:dc...@prosentient.com.au>>
Subject: Re: [Koha-devel] Random XSLT knowledge

Hi David,
Thanks for sharing.
Would you have an example of how you use register_function with Koha functions 
to share?

Marcel


Van: Koha-devel 
mailto:koha-devel-boun...@lists.koha-community.org>>
 namens David Cook via Koha-devel 
mailto:koha-devel@lists.koha-community.org>>
Verzonden: vrijdag 8 maart 2024 03:02
Aan: 'Koha Devel' 
mailto:koha-devel@lists.koha-community.org>>
Onderwerp: [Koha-devel] Random XSLT knowledge


Hi all,



I’ve been working on performance issues, and in the process I got looking at 
XSLTs.



I just wanted to share that it’s possible to pass strings to the XSLT’s 
transform() method:



-return $engine->transform($xmlrecord, $xslfilename ); #file or URL

+return $engine->transform({

+xml => $xmlrecord,

+file => $xslfilename,

+parameters => {

+test => "'$test_str'",

+},

+}); #file or URL



It’s somewhat limited in that you can only pass strings and I think there’s a 
small limit on the number of parameters you can pass (not sure if it’s 32 or 
255), but I thought it was interesting. It would allow you to pass some data 
that you have at hand on a per-XML record basis without having to mangle the 
XML record (like we do with items and system preferences).



In the end, I didn’t end up using it though. Instead, I use 
XML::LibXSLT->register_function() to provide access to Koha functions from the 
XSLT, and in this case that meets my needs.



Anyway, back to it..



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


___
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/

Re: [Koha-devel] Random XSLT knowledge

[Marcel de Rooy via Koha-devel]

Hi David,
Thanks for sharing.
Would you have an example of how you use register_function with Koha functions 
to share?

Marcel


Van: Koha-devel  namens David Cook 
via Koha-devel 
Verzonden: vrijdag 8 maart 2024 03:02
Aan: 'Koha Devel' 
Onderwerp: [Koha-devel] Random XSLT knowledge


Hi all,



I’ve been working on performance issues, and in the process I got looking at 
XSLTs.



I just wanted to share that it’s possible to pass strings to the XSLT’s 
transform() method:



-return $engine->transform($xmlrecord, $xslfilename ); #file or URL

+return $engine->transform({

+xml => $xmlrecord,

+file => $xslfilename,

+parameters => {

+test => "'$test_str'",

+},

+}); #file or URL



It’s somewhat limited in that you can only pass strings and I think there’s a 
small limit on the number of parameters you can pass (not sure if it’s 32 or 
255), but I thought it was interesting. It would allow you to pass some data 
that you have at hand on a per-XML record basis without having to mangle the 
XML record (like we do with items and system preferences).



In the end, I didn’t end up using it though. Instead, I use 
XML::LibXSLT->register_function() to provide access to Koha functions from the 
XSLT, and in this case that meets my needs.



Anyway, back to it..



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


___
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/

Re: [Koha-devel] koha SIP" over HTTPS

[Marcel de Rooy via Koha-devel]

Look for stunnel. This seems to be the usual way to secure SIP2 traffic.


Van: Koha-devel  namens Mark 
Hofstetter via Koha-devel 
Verzonden: donderdag 7 maart 2024 09:21
Aan: koha-devel@lists.koha-community.org 
Onderwerp: [Koha-devel] koha SIP" over HTTPS

Hi,

we need (at least I think) SIP2 over https. I found some clues googling
but no actual code for koha

Is there something, does somebody do it, does it need implementing?

thx for hints

Mark


--
--
Mag. Mark Hofstetter
2452 Mannersdorf
Zwischen den Weingärten 3
+43 676 7345660

___
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.koha-community.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fkoha-devel=05%7C02%7Cm.de.rooy%40rijksmuseum.nl%7Ca8e089486cbd4fc318a008dc3e7f9f78%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638453965085503915%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=jmSISfnJbsVypUPxk6kDOStt%2B7VmmAdFBMqeUylx670%3D=0
website : 
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.koha-community.org%2F=05%7C02%7Cm.de.rooy%40rijksmuseum.nl%7Ca8e089486cbd4fc318a008dc3e7f9f78%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638453965085512421%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=nmEwtwJ50HazqrOpIA2TieLFiqkswStK%2Fc0NHoUFQ80%3D=0
git : 
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgit.koha-community.org%2F=05%7C02%7Cm.de.rooy%40rijksmuseum.nl%7Ca8e089486cbd4fc318a008dc3e7f9f78%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638453965085519494%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=WapKIWa6JrLuVGeV3r17VMCgkzyIXiDq9HapKTzsRi8%3D=0
bugs : 
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2F=05%7C02%7Cm.de.rooy%40rijksmuseum.nl%7Ca8e089486cbd4fc318a008dc3e7f9f78%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638453965085525429%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C=Dl8GdvPp4BXK%2BSWzoJSb%2B5pEHhNhMn4NczZt44i4Jn4%3D=0
___
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/

Re: [Koha-devel] Koha CSRF protection

[Marcel de Rooy via Koha-devel]

Great work!

From: Koha-devel  On Behalf Of 
Nick Clemens via Koha-devel
Sent: Friday, March 1, 2024 2:26 PM
To: Koha Devel ; Koha 

Subject: [Koha-devel] Koha CSRF protection

Hello all!

We have pushed the CSRF work from 34478 and related bugs today. We know there 
are more follow-ups needed, and have filed a series of bugs under an omnibus:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36192

We have a framapad where issues can be reported/found:
https://annuel.framapad.org/p/koha_34478_remaining

And we have bugs for each of the sections of the document. We need all 
developers to submit patches when they encounter issues, and for other users 
testing master to report found issues on the pad. Testers can report issues on 
the pad as well.

There is a new coding guideline - all POSTs to forms in Koha will need to 
include a csrf token:
https://wiki.koha-community.org/wiki/Coding_Guidelines#Security

This has been a big work, many thanks to all involved, and there is still work 
to be done, but this is an important fix that we must do.

You can reach out to me on IRC (kidclamp) or via email and I will do my best to 
help anyone contribute.

Thanks,
Nick

--
Nick Clemens
ByWater Solutions
bywatersolutions.com
Phone: (888) 900-8944
Pronouns: (he/him/his)
Timezone: Eastern
[https://docs.google.com/uc?export=download=1eLlHaKRZxg0CP6nlW7rG0J4qdtoIuoNr=0B0ga69kSs543QWlEa3V4aGI4dFlXMlVQd0ZEbVY5dFBXQUk0PQ]
Follow us:
[https://docs.google.com/uc?export=download=1UU2Vj_xX_WgcBojhYbea9ck0TaLwoLky=0B0ga69kSs543R2xUajk5MnF0VE9EcjhtSjZBc1R0YVpSL0NFPQ]
 
[https://docs.google.com/uc?export=download=1SCTJQAzf1zB5c7NmTLQwtexAgNl4_jPC=0B0ga69kSs543N0tKSG9ZRk55MXk2Qmt3TXJ2TE1Ca1g4T1hFPQ]
   
[https://docs.google.com/uc?export=download=1zVkZyWeLDKyDM5RhOLMRHigl4VYN5j43=0B0ga69kSs543eU9ZUVVyalFqNlVodEtZTmRSNElrQlV2MlhJPQ]
   
[https://docs.google.com/uc?export=download=1b9EkTbJHwpA_Lf4iKYdoSyIlxwyasLPq=0B0ga69kSs543WWFieW52VkRpZEhkdGRjcXVBejBTZUltS0hrPQ]
 
___
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/

[Koha-devel] Translation

[Marcel de Rooy via Koha-devel]

Hi,

I came across this link on opac-detail in our Dutch OPAC:

Dalbajewa, 
Birgit [contributor]

As you may see, various class names, attribute names etc. are being translated 
(while they should not have been translated). In the PO file it just says for 
instance msgstr "contributor", so things get translated.
In the above co-auteur and Persoon should not have been there.

Anyone have an idea how we could prevent such entries from coming into the PO 
file at the first place?

Thanks,
Marcel

___
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/

Re: [Koha-devel] REMINDER: Development IRC meeting 13 December 2023

[Marcel de Rooy via Koha-devel]

How late btw?

Van: Koha-devel  namens Fischer, 
Katrin via Koha-devel 
Verzonden: dinsdag 12 december 2023 10:10
Aan: koha-devel@lists.koha-community.org 
Onderwerp: [Koha-devel] REMINDER: Development IRC meeting 13 December 2023

Hi all,

we have a development IRC meeting scheduled for tomorrow:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.koha-community.org%2Fwiki%2FDevelopment_IRC_meeting_13_December_202=05%7C02%7Cm.de.rooy%40rijksmuseum.nl%7C0fa2aa2e15174458edb208dbfaf235df%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638379690436207435%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=E8wmDJ5TKdmztAA1P7fV9g0yHdU1I9z6lsYZTWoOI3E%3D=0
3

We will take time to talk about the roadmap for 24.05:
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.koha-community.org%2Fwiki%2FRoad_map_24.05=05%7C02%7Cm.de.rooy%40rijksmuseum.nl%7C0fa2aa2e15174458edb208dbfaf235df%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C638379690436207435%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C=ReNVFjGr63xi4p6Oa0T49k%2BBQ5Dh%2B%2Bh7m%2Frdaempv2k%3D=0

Please have a look and add your projects and support.

See you tomorrow!

Katrin

___
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/

[Koha-devel] FW: [Koha] Koha 23.11 released

[Marcel de Rooy via Koha-devel]

Great, Tomas!

Note btw that I still do not receive a lot of mails on koha-devel on my MS 
email address (like this one too).
Yes, I know what you want to say 

Marcel


Van: Marcel de Rooy
Verzonden: dinsdag 5 december 2023 16:55
Aan: Marcel de Rooy 
Onderwerp: Fwd: [Koha] Koha 23.11 released



-- Forwarded message -
Van: Tomas Cohen Arazi mailto:tomasco...@gmail.com>>
Date: vr 1 dec 2023 om 14:29
Subject: [Koha] Koha 23.11 released
To: koha mailto:k...@lists.katipo.co.nz>>


The Koha community is proud to announce the release of Koha 23.11.00.

Koha 23.11.00 is a major release that comes with many new features.

It includes 10 new features, 330 enhancements, 573 bugfixes.

The full release notes are available here:
https://koha-community.org/koha-23-11-released/

Debian packages should be available soon

Best regards

--
Tomás Cohen Arazi
Theke Solutions (https://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
___

Koha mailing list  http://koha-community.org
k...@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___
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/