July 2020 - Koha-devel - lists.koha-community.org

sample_notices.yml instead of sql
by Marcel de Rooy 28 Jul '20

28 Jul '20

Hi all, What is the current procedure around changing notices and translation? I see that we have an English yml file, but I see sql files in the translated languages. Like de-DE/mandatory/sample_notices.sql We dont have a coding guideline yet about this. Should it be added? If I change an English notice, should I still change the other languages ? Thanks, Marcel

2 1

Autentication LDAP Error Koha 20.05
by Humberto Blanco Castillo 27 Jul '20

27 Jul '20

Hi for all, We are trying to connect koha to LDAP, but appears as credentials its not working, and cant fount what the problem its. this configuration works fine in production environment in version 3.16 Follow are the paras in the /etc/koha/sites/catalogo/koha-conf.xml file <useldapserver>1</useldapserver> <ldapserver id="ldapserver" listenref="ldapserver"> <hostname>ldap://ourldapServer:389</hostname> <base>DC=University,DC=EDU</base> <user>CN=ldap_user,OU=Cuenta de servicio,DC=University,DC=EDU</user> <pass>myPassword</pass> <replicate>1</replicate> <update>0</update> <auth_by_bind>1</auth_by_bind> <anonymous_bind>0</anonymous_bind> <update_password>0</update_password> <principal_name>%s(a)urosario.edu.co</principal_name> <mapping> <firstname is="givenName" ></firstname> <surname is="sn" ></surname> <userid is="cn"></userid> <email is="mail"></email> <phone is="telephonenumber"></phone> <cardnumber is="postOfficeBox"></cardnumber> </mapping> </ldapserver> We test the connection from the command line, so: export PERL5LIB=/usr/share/koha/lib/ && export KOHA_CONF=/etc/koha/sites/catalogo/koha-conf.xml && perl /usr/share/koha/opac/cgi-bin/opac/opac-user.pl userid=humberto.blanco password=password_for_humberto.blanco and gets the following error: LDAP bind failed as kohauser humberto.blanco: LDAP error #49: LDAP_INVALID_CREDENTIALS# The wrong password was supplied or the SASL credentials could not be processed Does no matter what kind of information i put on the password field, ever gets the same error. any idea? -- sincerelly, Humberto Blanco

2 1

Rancor/Advanced MARC Editor templates?
by dcook＠prosentient.com.au 27 Jul '20

27 Jul '20

Hi all, Is it possible to define templates for Rancor/Advanced MARC Editor? On systems like Horizon, it's possible to have different templates, so cataloguers can at a glance see what fields they need to fill in for a particular type of record (e.g. book vs journal vs dvd). If it's not possible, I want to make it possible, but I'm not sure if we should use the "Editor" setting in MARC Bibliographic Frameworks, or create a new feature for providing Rancor Templates. Personally, I've always hated how MARC Bibliographic Frameworks act as both Editor templates (for rendering HTML) and data filters (ie if the field is not in the framework, it gets stripped out of the record at save time). In my ideal world, editor templates and data filters would be 2 separate features. For Rancor, I think MARC Bibliographic Frameworks already act as data filters, and it would be backwards incompatible to use them for templates as well, so adding a new feature for Rancor templates is probably the logical conclusion? David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Online: 02 8005 0595

2 6

Release maintenance: Proposal for handing over stable branches
by Victor Grousset/tuxayo 26 Jul '20

26 Jul '20

Hi o/ This was discussed a month ago in the IRC dev meeting. So here is the proposal to review and comment so it can be presented in the next dev meeting this Wednesday. https://wiki.koha-community.org/wiki/User:Victor_Grousset_-_tuxayo/RMaint-h… Cheers, -- Victor Grousset/tuxayo

1 0

KC apt server, time for an upgrade?
by Mason James 26 Jul '20

26 Jul '20

hi Folks we are starting to bump into some problems with the old debian version on debian.kc.org (its running deb7) it seems that the VM's old version of reprepro is not capable of importing/processing signed debian packages, due to using an older version of gpg, (not gpg2?) the error is described below, yet none of the solutions work :/ https://serverfault.com/questions/770130/reprepro-export-could-not-find-sig… # reprepro -V export unstable Exporting unstable... generating main/Contents-i386... generating main/Contents-amd64... Could not find any key matching 'DD219672'! ERROR: Could not finish exporting 'unstable'! can we make a plan to get the VM upgraded (or the repo moved) to debian/ubuntu stable cheers, Mason

3 3

Koha doesn't use /cgi-bin/koha/errors/500.pl for most internal server errors
by dcook＠prosentient.com.au 23 Jul '20

23 Jul '20

Hi all, While looking at Bug 24574, I realized that Koha doesn't use /cgi-bin/koha/errors/500.pl when it throws a fatal error; instead it shows very stark not user-friendly messages, which vary depending on if you're using Plack Koha or CGI Koha. I've opened https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26048 which details the reasons why it doesn't and some possible resolutions. I'd love to get some community input on that bug, as there are different options that each have their pros and cons. Apologies for all the text in that bug. As per usual, I was very detailed. If you're not interested in details, you can probably skip right to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26048#c7. Thanks in advance, David Cook Systems Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Online: 02 8005 0595

2 2

855 Field and SQL Query
by Stephen Graham 22 Jul '20

22 Jul '20

Hi All - when I try and pull out subfield $u of the 856 field I always get the public note as well (i.e. $z). An example of the query I'm running: select biblionumber, ExtractValue(metadata,'//datafield[@tag="245"]/subfield[@code>="a"]') AS title, ExtractValue(metadata,'//datafield[@tag="856"]/subfield[@code>="u"]') as URL from biblio_metadata where ExtractValue(metadata,'//datafield[@tag="856"]/subfield[@code>="u"]') like '%dawsonera.com%'; This is correct isn't it? I haven't requested $z, so not sure why it is always in the results? Feature? Bug? Or me doing something wrong? Cheers, Stephen PS we are on 19.11. -------------------------------------- Stephen Graham Library Technology Consultant Content and Collections Team Library and Computing Services University of Hertfordshire Tel: 01707 286111 Ext: 77751 Email: s.graham4(a)herts.ac.uk<mailto:s.graham4@herts.ac.uk>

2 1

Koha 19.11.08 released
by Aleisha Amohia 22 Jul '20

22 Jul '20

Hello! The Koha community is proud to announce the release of Koha 19.11.08. Koha 19.11.08 is a bugfix/maintenance release that includes 8 enhancements and 18 bugfixes. Full release notes can be found here: https://koha-community.org/koha-19-11-08-released/ -- *Aleisha Amohia* Koha Developer Catalyst IT - Expert Open Source Solutions

1 0

Persistent identifiers in MARC record?
by Marcel de Rooy 21 Jul '20

21 Jul '20

Hi all, Last couple of weeks I had a discussion with David about this subject on bug 24544. Please see https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24544 What do you think? If your authority, biblio or item has a PID, should we save it in MARC too? Noting that MARC is just a representation or view of your data. We already have a biblio_metadata table that allows for more. What if we already had multiple views? If you can, you are welcome to contribute to that discussion on the bug report. Thanks, Marcel

2 1

JSON templates and translation
by Fridolin SOMERS 17 Jul '20

17 Jul '20

Hi, We faced a bug on a JSON template broken by PO translation of the column "borrowernumber" /koha-tmpl/intranet-tmpl/prog/en/modules/members/tables/members_results.tt How could we avoid this ? 1/ Disable translation of JSON templates and JS caller must translate using _(). 2/ Add a way to define string to translate in JSON templates, like _() in JS. Best regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

2 1