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

Additional DB indices for Koha?
by Victor Grousset/tuxayo 24 Mar '22

24 Mar '22

Hi :) Has there already been the need of additional DB indices for Koha? To speed up some queries that doesn't use a primary or foreign key. From what I see in kohastructure.sql , there is no index besides the implicit ones for keys. Cheers, -- Victor Grousset/tuxayo

6 6

I played with Cypress (and ERM and Vue)
by Jonathan Druart 23 Mar '22

23 Mar '22

Hi devs, Following my previous email here, I have started to work on the ERM project and wanted to try Vue in a more complex example. You can find the whole tree at https://gitlab.com/joubu/Koha/-/commits/erm It contains CRUD operations for ERM's agreement (can link users and periods), all based on Vue requesting our REST API routes, and covered by tests using Cypress. Feedback welcome! Cheers, Jonathan

4 6

Time to translate: string freeze to prepare Koha 19.11.28
by Wainui Witika-Park 18 Mar '22

18 Mar '22

Hello, String freeze is into effect as of now for the 19.11.x maintenance branch in preparation for the 19.11.28 release. The minor release is scheduled for around the 23rd of March. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Happy translating! Wainui Witika-Park (she/her)

1 0

Time to translate: string freeze to prepare Koha 20.11.17 has begun
by Victor Grousset/tuxayo 17 Mar '22

17 Mar '22

Hi, String freeze is into effect as of now for the 20.11.x maintenance branch. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Reminder: if you add or change a translation in version 20.11, then you must also copy it to 21.05 and 21.11. Otherwise your work will be lost for future versions. Happy translating :) -- Victor Grousset/tuxayo

1 0

Koha security release available ⚠
by Victor Grousset/tuxayo 16 Mar '22

16 Mar '22

Hello! :) The Koha Community is happy to announce the release of Koha 21.05.12, 20.11.16, 19.11.27. The previous release of 21.11.03 already contained the fixes. Users are advised to upgrade their Koha to these versions The full release notes can be found at: https://koha-community.org/koha-21-05-12-released https://koha-community.org/koha-20-11-16-released/ https://koha-community.org/koha-19-11-27-released/ The latest Koha packages and tarballs are ready. Thanks to everyone involved :) -- Victor Grousset/tuxayo

1 0

REST API integration issues .
by Esharat Mia 15 Mar '22

15 Mar '22

Dear All, Here is my python code for testing REST API - import requests import json data = { "client_id": "52ba706f-902c-4208-b28d-c05df607f3c4", "client_secret": "de1c0400-ec02-4143-972e-752931968aed", "grant_type": "client_credentials", } headers = { 'Content_type': 'application/x-www-form-urlencoded' } response = requests.post("http://123.49.46.157:8080/api/v1/oauth/token", data=data, headers=headers) credentials = response.json() print(credentials) access_token = credentials['access_token'] print("Access_token: ",access_token) auth2 = { 'Authorization': 'Bearer' +access_token } response= requests.get("http://123.49.46.157:8080/api/v1/patrons", headers=auth2 ) print(response) When I run this code , I get access_token . Then I use this access token and try retrieve data. But getting authentication failure or response code 401 . My output below - (base) esharat@esharat-desktop:~/Desktop/Library$ python3 test.py {'access_token': 'MTY0NzM2MDQ3Mi00MzgwNzctMC42OTA2NTM5MzA1MDgxODQtM0pTSTcwdUhGcVdzaTlUUnhGcGVDaTFmaVg3Nm9v', 'expires_in': 3600, 'token_type': 'Bearer'} Access_token: MTY0NzM2MDQ3Mi00MzgwNzctMC42OTA2NTM5MzA1MDgxODQtM0pTSTcwdUhGcVdzaTlUUnhGcGVDaTFmaVg3Nm9v <Response [401]> Thanks in advance .

3 4

Template::Toolkit WRAPPER to reduce template boilerplate
by dcook＠prosentient.com.au 14 Mar '22

14 Mar '22

Hi all, I've opened up an issue to use Template::Toolkit's WRAPPER directive to reduce template boilerplate: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30289 I've been using it for 7 years on a non-Koha project and it's very handy. And I whipped out a draft wrapper today and attached it to Bugzilla, because I was working on some custom OPAC pages and I was just getting tired of trying to figure out what a generic Koha page should look like in terms of HTML, CSS, JS, includes, etc. By using 1 wrapper, I can just do it once, and not worry about it. I can just focus on the actual content for all my particular page-specific templates. Anyway, have a look and let me know what you think. For a first step, we wouldn't even have to replace every OPAC page. We could just start with opac-main.tt and then refactor as we go along. 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

1 0

Call for news - Newsletter March 2022
by Michael Kuhn 13 Mar '22

13 Mar '22

Hi I'm collecting news for the March 2022 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * News items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format criteria: * Just structured plain text, or * HTML text to include tables or similar For events: * Consider adding your event to the Koha Community calendar at https://koha-community.org/calendar/ Thank you! Michael Kuhn Editor, Koha Community Newsletter -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

1 0

Hello
by Ms. Naveen Ali 10 Mar '22

10 Mar '22

Hello, This is Naveen from Pakistan. I work at a Public Sector Higher Education University and am trying to implement KOHA. We have been using in house developed LIS. However it needed upgrade and KOHA seems a good next step as many of our requirements have been implemented and tested. I am currently analyzing what policy and functional changes are required for koha implementation. I have found out so far that majority of functions are adaptable. However need some minor customization and am looking into plug ins which I believe are the way to go. With thanks and best regards, Naveen.

2 4

Increasing Debian package compatibility level
by dcook＠prosentient.com.au 10 Mar '22

10 Mar '22

Hi Mason and folks, Occasionally, I notice this warning when building Koha Debian packages: dh_install: Compatibility levels before 9 are deprecated (level 7 in use) I was thinking we should increase the compatibility level. It would need some testing but I don't think we do anything too wild. On a different project, I'm switching from RPMs to DEBs and I'm going with level 12 or something using a fairly similar methodology to Koha for most of my Debian files. Anyway, just a thought. 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

1 0