- Koha - lists.katipo.co.nz

List of serials SQL
by Carlos Lopez 21 May '21

21 May '21

Hi folks I'm having trouble with an SQL query: I'd like to bring up a list of serial titles on the system their subscription status (open or closed), BUT not all serials have a subscription record (pre-Koha closed subscriptions) AND all serial items have the item type of SERIAL I thought something like this might work SELECT DISTINCT b.title, IF(s.closed = 0,"OPEN","CLOSED") FROM biblio b, items i LEFT JOIN subscription s ON s.biblionumber = b.biblionumber WHERE b.biblionumber = i.biblionumber AND i.itype = "JOURNAL" ORDER BY b.title but it keeps failing ("Unknown column 'b.biblionumber' in 'on clause'" - if I take out the "ON s.biblionumber = b.biblionumber" bit I get a list but they're all duplicated, one OPEN the other CLOSED, even if they have no subscription record Would anyone be able to help us out with this? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au<mailto:library@dml.vic.edu.au> | library.dmlibrary.org.au

2 1

21.05 release candidate available for testing on sandboxes
by Jonathan Druart 20 May '21

20 May '21

Hello everybody, The 21.05 should be released at the end of next week. We don't expect much changes on the master branch so it is the perfect moment to catch remaining bugs or even test your favourite new features :) To make testing easier you can use the new sandboxes server BibLibre provided us: https://sandboxes.biblibre.eu So far it is only available for testing master, I've created 7 sandboxes using the latest version (note that Elastic search is the default search engine). Important to highlight as well, I picked (a couple of hours ago) the translations for all the languages we have on pootle, and they are all installed on those sandboxes (you just need to modify the 'languages' and OPACLanguages systempreferences). New enhancements can then be tested in your préféré idioma. More information on sandboxes can be found on the wiki - https://wiki.koha-community.org/wiki/Sandboxes Happy testing! Jonathan

1 0

Request to be listed as a Koha Support provider in Namibia
by Russel G. P. Shihepo 20 May '21

20 May '21

Dear Community We would like to be listed as a local support provider in Namibia. Company Name: Notitia Systems cc Contact Person: Russel Shihepo Contact email: notitiasystems(a)hotmail.com Website: https://notitiasystems.blogspot.com/ Telephone:+264 81 3223143 Please find our page which mention koha-community.org site: https://notitiasystems.blogspot.com/p/koha-background.html Please do let us know if we need to provide any further information. Best Regards Russel Shihepo Notitia Systems cc Tel: +264 81 3223 143

1 0

Re: [Koha] Koha API - Authentication Failure
by dcook＠prosentient.com.au 20 May '21

20 May '21

That KohaRest driver looks interesting! I haven't dug into it too deeply, but how do you handle the user/patron authentication? Do you have the user log into VuFind and at that point you use the backend confidential client user to validate it via your plugin API endpoint? Have you thought about using SSO between VuFind and Koha? I suppose even then you'd still have to do a user lookup against Koha unless there is an attribute/claim containing their borrowernumber... I'd love to see the core REST API replace the ILS-DI API for discovery services... David Cook Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- Date: Wed, 19 May 2021 11:49:48 +0300 From: Ere Maijala <ere.maijala(a)helsinki.fi> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha API - Authentication Failure Message-ID: <82f7fb00-a4da-fcaa-3431-3fe58d12f9d4(a)helsinki.fi> Content-Type: text/plain; charset=utf-8; format=flowed My documented steps to make sure OAuth2 is working are here: https://github.com/vufind-org/vufind/blob/dev/config/vufind/KohaRest.ini#L20 This may be useful for you. I suppose it would make sense to document this properly in Koha wiki as well, I just haven't had time... Best, Ere Aswin Unnikrishnan kirjoitti 17.5.2021 klo 20.53: > Thanks for pointing that out Stephen, I will have to look into that, > it might be the issue here. > > Tomas, I am not exactly sure if we have plack running or not. Plack > seems to be enabled, but plack logs are all empty. the logs are all at > intranet-error.log and opac-error.log > > I will try out the apache CGIPass method as Stephen suggested and get > back if it works. > > Thanks, > Aswin > > On Mon, May 17, 2021, 9:02 PM Tomas Cohen Arazi <tomascohen(a)gmail.com> > wrote: > >> Are you running Plack? >> >> El lun, 17 may 2021 a las 11:53, Aswin Unnikrishnan (< >> aswinunni01(a)gmail.com>) escribió: >> >>> Thanks Stephen, Tomas for the quick response. >>> >>> Aswin - are you using the correct URL to call your custom endpoint. >>> It >>>> should be under the contrib namespace e.g. >>>> >>> >>> The app i am making is not part of koha, its a seperate web app >>> which makes calls to /api/v1/ end points of the koha server. >>> >>> Does the user (owner of the id/secret pair) have privileged access >>> to >>>> Koha? Remember it needs to have permissions to enter the staff >>>> interface (the 'catalogue' permission) in order to access routes >>>> (other than those in the /api/v1/public namespace). >>>> >>> Yes, the user has permission set to access all librarian functions, >>> I also tried accessing the api end point via browser after logging >>> in to the staff portal with this user, and im getting the correct response. >>> >>> Im also not able to access api/v1/.html from the browser, it gives a >>> 403 Error page. I checked the error logs and found this >>> >>> [authz_core:error] [pid 25846] AH01630: client denied by server >>>> configuration: /usr/share/koha/api/v1/.html >>>> >>> >>> >>> Is there any logging systems in place which could give more info >>> regarding the authorization failure error? or any idea whats wrong? >>> >>> Thanks, >>> Aswin >>> >>> >>> On Mon, 17 May 2021 at 19:13, Tomas Cohen Arazi >>> <tomascohen(a)gmail.com> >>> wrote: >>> >>>> Does the user (owner of the id/secret pair) have privileged access >>>> to Koha? Remember it needs to have permissions to enter the staff >>>> interface (the 'catalogue' permission) in order to access routes >>>> (other than those in the /api/v1/public namespace). >>>> >>>> BTW: All routes also have some required permissions you should take >>>> a look at. Specific ones. >>>> >>>> Kind regards >>>> >>>> El lun, 17 may 2021 a las 9:40, Aswin Unnikrishnan (< >>>> aswinunni01(a)gmail.com>) escribió: >>>> >>>>> Hi, >>>>> >>>>> I wanted to build an app that uses the koha API, and so i was >>>>> testing it out, but I keep getting "Authentication Failure" error >>>>> whichever end point I try to access. >>>>> The steps i did are >>>>> >>>>> 1. Got the client_id / secret from koha 2. Sent a POST request to >>>>> api/v1/oauth/token with required parameters and got an >>>>> "access_token" returned 3. Added the token to my authorization >>>>> header with header-prefix "Bearer" >>>>> 4. Sent a GET request to different end points, but getting the >>>>> same 401 Unauthorized error code with error : Authentication >>>>> failure >>>>> >>>>> However if i access one of the public end points like >>>>> /api/v1/biblios/{biblio_id} i can get a response >>>>> >>>>> If anyone has any idea why this is happening, please let me know. >>>>> >>>>> Thanks in advance, >>>>> Aswin >>>>> _______________________________________________ >>>>> >>>>> Koha mailing list http://koha-community.org >>>>> Koha(a)lists.katipo.co.nz >>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>>>> >>>> >>>> >>>> -- >>>> Tomás Cohen Arazi >>>> Theke Solutions (http://theke.io) >>>> ✆ +54 9351 3513384 >>>> GPG: B2F3C15F >>>> >>> >> >> -- >> Tomás Cohen Arazi >> Theke Solutions (http://theke.io) >> ✆ +54 9351 3513384 >> GPG: B2F3C15F >> > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > -- Ere Maijala Kansalliskirjasto / The National Library of Finland

1 0

Koha-US Education Committee mtg Wed., May 19
by Hernandez, Heather H 18 May '21

18 May '21

Hello! The next meeting of the Koha-US Education Committee will be Wednesday morning, May 19, 2021, at 8:30 PT/9:30 MT/10:30 CT/11:30 ET, and is open to all (you don't need to be a member of Koha-US to attend). Info on joining the meeting here: https://koha-us.org/event/koha-us-education-committee-3/?instance_id=6830 Cheerio! h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032, heather_hernandez(a)nps.gov<https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov> Library catalog: http://keys.bywatersolutions.com/

1 0

[German] 3. virtuelles Koha-D-A-CH-Anwendertreffen am 9.6.2021
by Fischer, Katrin 18 May '21

18 May '21

+++ This announcement addresses German-speaking Koha users as the user meeting will be held in German +++ Liebe Koha-Anwender*innen und Koha-Interessierte, wir laden herzlich zum dritten virtuellen Koha-Anwendertreffen am 9.6.2021, 10:00 - 12:00 Uhr und 14:00 - 15:45 Uhr ein. Das Anwendertreffen wird mit Hilfe von Zoom stattfinden: https://uni-jena-de.zoom.us/j/64109228877 Kenncode: 423321 Eine vorherige Anmeldung ist nicht erforderlich. Der Konferenzraum ist vormittags ab 9:45 Uhr und nachmittags ab 13:45 Uhr offen. Die Veranstaltung beginnt um Punkt 10:00 Uhr bzw. 14:00 Uhr. Vormittag * Koha und Archiv Warum das denn? Dr. Jessika Wichner, Deutsches Zentrum für Luft- und Raumfahrt (DLR) * Von Aleph zu Koha : ein Werkstattbericht Sabine Thänert und Simon Hohl, Deutsches Archäologisches Institut * Koha mobil Die Fahrbibliothekslösung der Stadtbibliothek Heilbronn Ewa Gozd, Stadtbibliothek Heilbronn * Neuheiten der Version 21.05 Katrin Fischer, Bibliotheksservice-Zentrum Baden-Württemberg * Was Sie schon immer über Koha wissen wollten? - Allgemeine Fragerunde zu Koha, Wünsche für die nächste Veranstaltung Nachmittag * Kataloganpassungen mit CSS Barbara Petritsch, Wien Museum * Koha und Datenbanken Rainer Stowasser, ZAMG * "Koha Out Of The Box" ein studentisches Projekt der Hochschule der Medien Stuttgart Paul Derscheid, Lukas Schreiner und Mara Spieß * Technische Fragerunde zu Koha Wir freuen uns auf eine rege Teilnahme und Beteiligung! Für das Organisationsteam (AG Koha D-A-CH, BSZ, ThULB) Katrin Fischer -- Katrin Fischer Bibliotheksservice-Zentrum Baden-Wuerttemberg (BSZ) 78457 Konstanz / Germany Phone: +49 7531 - 88 4934 E-Mail: katrin.fischer(a)bsz-bw.de http://bsz-bw.de

2 1

UNIMARC to MARC21
by Himanshu Aggarwal 17 May '21

17 May '21

Is there any way we can convert in Koha UNIMARC to MARC21. Basically if I am importing data in UNIMARC but I have MARC21 flavor chosen for most of my records. -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)

2 1

Dateformat to dd.mm.yyy , user card expiration
by Victor Barroso Oliveira 14 May '21

14 May '21

Hi, I changed the date to the format in the "dateformat" to dd.mm.yyy more when I generate the user card with <dateexpirt> the format yyy.mm.dd still appears How to set the date in dd.mm.yyy format for expiration in the cards? Thanks, Victor

2 1

2021 koha-US Conference: Presentation submission deadline is fast approaching!
by Jason Robb 14 May '21

14 May '21

The deadline to submit presentation proposals for the 2021 koha-US conference is *next Friday*, May 21st. Submit your proposals here: *https://forms.gle/JCkDLvDTrUwUx3UE9 <https://forms.gle/JCkDLvDTrUwUx3UE9>* The conference will be hybrid in format with the opportunity to present and attend both in-person and virtually. We understand that there is a level of uncertainty surrounding the ability to travel. We encourage you to submit your proposals and are happy to work with you on switching your presentation format from in-person to online or vice versa should the need arise. More info about the conference can be found on our website: https://koha-us.org/conference2021/ If you have questions please direct them to the koha-US conference committee at conferences(a)koha-us.org. ----- Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Time to translate: string freeze to prepare Koha 19.11.18 has begun
by Victor Grousset/tuxayo 14 May '21

14 May '21

Hi, saluton, hola, bonjour, String freeze is into effect as of now for the 19.11.x maintenance branch. The release is scheduled for around the 24th/25th. **If you missed it the upcoming 21.05 release is translatable now.** 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 19.11, then you must also copy it to 20.05, 20.11 and 21.05. Otherwise your work will be lost for future versions. (We've had a recent significant case of that!) Happy translating, -- Victor Grousset/tuxayo

1 0