- Koha - lists.katipo.co.nz

Request to get listed on Koha support providers list
by Lari Taskula 31 Aug '19

31 Aug '19

Dear Koha community, Hypernova Oy would like to sign up to get listed on Koha support providers list. We are offering Koha hosting, development and consultation services. Our team currently consists of Finnish Koha professionals whom worked for public libraries in Finland and later founded a company for providing Koha to (small) special libraries. We are now extending our market to other countries. We support Koha community version and the local Finnish Koha version. Company Name: Hypernova Oy Contact Person: Lari Taskula Contact email: info(a)hypernova.fi Website: https://www.hypernova.fi Telephone: +358449857337 Address: Kauppakatu 25 C 409, 80100 Joensuu, Finland Feel free to check out our site and find a link back to koha-community.org ;) -- Lari Taskula CEO, Hypernova Oy +358449857337 Kauppakatu 25 C 409 80100 Joensuu, Finland

1 0

Wordpress "Search this site/Search our catalog" code
by George 30 Aug '19

30 Aug '19

Hello everyone, Does anyone have any code for creating a single search box on a Word Press site that can switch between "Search our website" and "Search our catalog?" If you have any code to do that, could you share it with us? George -- George Williams Next Search Catalog Coordinator Send NEXT support e-mails to nexthelp(a)nekls.org

3 2

Bulk search/delete by ISBNs?
by King, Fred 29 Aug '19

29 Aug '19

Esteemed Colleagues, My library has a collection of about 5000 online books that are in Koha with bib records and no items. The publisher periodically archives titles so they're no longer available, and I have a list of them that I'd like to remove from Koha. The problem is that my list consists of ISBNs and that there are over 450 of them. I could search and delete one-by-one, but that's an awful lot of searching and deleting. Is there an easier way? We're on Koha 17.05* and Ubuntu 16.04. *I know, I know, but I'm hoping to get a new server before I upgrade. Fred King, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net<mailto:fred.king@medstar.net> 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org Rest is not idleness, and to lie sometimes on the grass under trees on a summer's day, listening to the murmur of the water, or watching the clouds float across the sky, is by no means a waste of time. --Sir John Lubbock, The Use of Life (1894) ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary.

2 1

Issue enabling Google OpenID authentication
by Guillermo Castellano 29 Aug '19

29 Aug '19

Hi there, We are trying unsuccessfully to connect an instance of Koha 17.11.18.000 to Google OpenID following the instructions provided here: https://koha-community.org/manual/17.11/html/02_administration.html?highlig…. This is the error that we get: 400. That’s an error. Error: invalid_request Invalid parameter value for redirect_uri: Missing scheme: /cgi-bin/koha/svc/auth/googleopenidconnect Learn more Request Details response_type=code redirect_uri=/cgi-bin/koha/svc/auth/googleopenidconnect client_id=151271246332-2rutdao24k2as059d4ht7gmo0utln43l.apps.googleusercont… scope=openid email profile state=auth_660a4a0ed00714e959894abe360a3532 That’s all we know. We have checked that we have a client ID and a client secret; and that the authorized JavaScript origins, as well as the authorized redirect URLs, match the URL of the OPACBaseURL and http://YOUROPAC/cgi-bin/koha/svc/auth/googleopenidconnect <http://YOUROPAC/cgi-bin/koha/svc/auth/googleopenidconnect>. We have also checked that the values of GoogleOAuth2ClientID and GoogleOAuth2ClientSecret in Koha match the values of the Google client ID and the client secret. Could anyone please provide us some guidance on this? Many thanks in advance, Guillermo Castellano

1 1

Invalid username/password with web installer - original installation
by Matthew Sampson 29 Aug '19

29 Aug '19

Hi all, I'm planning to use Koha 19.05 to set up a library management system for a small library collection, as an independent project to make searching for resources easier for the small group of users. On a computer running Ubuntu I've followed the basic instructions to download Koha and the supporting software such as Apache2 and Perl. All this seems to have gone well. When I get to the Koha 19.05 web installer on Firefox I'm not getting anywhere with the username and password. I've tried *koha_kohadev* and *password* based on the Koha Manual 19.05 documentation, plus *koha_<libraryname> *and the password retrieved through the terminal command *sudo xmlstarlet sel -t -v 'yazgfs/config/pass' /etc/koha/sites/library/koha-conf.xml;echo*, as according to Open School Solutions' installation guide. Whatever I do I seem to come up with this message above the web installer: *Error: Invalid username or password* In my research I've learned that Koha 19.05 doesn't permit logging in with the database user and creating a superlibrarian patron is recommended. I've attempted to follow the steps at https://lists.katipo.co.nz/public/koha/2018-May/050688.html but am getting a series of DBI connect failures in the terminal. I don't have library codes or category codes set up (haven't cracked the web installer yet) so maybe this has something to do with it? >From the kohageek blog ( http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line…) I get a different response after loading the environmental variables and attempting to create the superlibrarian: *Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module)* and then an explanation of what @INC contains. Any ideas? Any help would be much appreciated. Cheers, Matthew Sampson

3 4

Koha Community Newsletter: August 2019
by kohanews 29 Aug '19

29 Aug '19

The Koha Community Newsletter for August 2019 is here: https://koha-community.org/koha-community-newsletter-august-2019/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Koha 18.11.09 release
by Lucas Gass 29 Aug '19

29 Aug '19

The Koha community is proud to announce the release of Koha 19.11.09. This is a maintenance release. The full release notes are available at: https://koha-community.org/koha-18-11-09-release/ Debian packages will be available in a couple of days. Thanks to everyone involved, Lucas

1 1

Software error: Invalid data
by Myriam Torres 28 Aug '19

28 Aug '19

Hello Koha Community, We are getting this error message when we try to get the information of our books, we started to get this error after the last update. Do you know how can we solve this problem? Software error: Invalid data, cannot decode object (id=16023, format=marcxml, schema=MARC21, MARCXML error=':9: parser error : PCDATA invalid Char value 31 <controlfield tag="008"> 0051206s xxu 001|0|eng d</controlfie ^') Thanks in advance

2 1

Re: [Koha] Koha Not calculating and charging overdue fines
by muirunyeri 28 Aug '19

28 Aug '19

Hi, While Koha is now calculating fines, its only possible to see the fine after item checkin. Its only showing a user as having overdue items but no amount of fine accrued before checkin. What can be done to show on the screen the amount accrued even while the item is still checked out? Best Regards Sent from my Samsung Galaxy smartphone.-------- Original message --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 16/08/2019 14:12 (GMT+03:00) To: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi, Thanks Alvaro. The code worked and now overdue is calculating Best regards Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> Date: 15/08/2019 16:42 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com> Cc: Carlos Lopez <clopez(a)dml.vic.edu.au>, koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi Muirunyeri You can access mysql and run a command like: UPDATE `items` SET `homebranch` = `YourHomeBranchID' [WHERE homebranch is NULL];As you will be editing your database directly, you should backup your system before. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le jeu. 15 août 2019 à 01:54, muirunyeri <muirunyeri(a)gmail.com> a écrit : Hi Carlos, I ran the report which returns a single column with item numbers. It indeed confirms all items are without home branch. However, no batch editing option. Any assistance to solve this is highly appreciated. Thanks Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Carlos Lopez <clopez(a)dml.vic.edu.au> Date: 15/08/2019 02:02 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com>, koha(a)lists.katipo.co.nz Subject: RE: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines Hi Muirunyeri If the homebranch field is empty, you could run a report from this query: SELECT itemnumber FROM items WHERE homebranch is NULL You should even get a little "Batch modify" button at the top of your results. 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 | library.dmlibrary.org.au -----Original Message----- From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of muirunyeri Sent: Thursday, 15 August 2019 5:56 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines Sent from my Samsung Galaxy smartphone.-------- Original message --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 14/08/2019 22:54 (GMT+03:00) To: katrin.fischer.83(a)web.de Subject: Re: Re: [Koha] Koha Not calculating and charging overdue fines Hi, I have around 44,000 items that were imported from excel. The homebranch field is blank and this might be the cause if the non-calculating overdue fines. How can i edit items to fill this field (batch)? The homebranch field is not available on the items form. If its hidden, how can I unhide it? You could also give me an SQL code if it'll get the Sent from my Samsung Galaxy smartphone. -------- Original message -------- From: Katrin Fischer <katrin.fischer.83(a)web.de> Date: 06/08/2019 19:14 (GMT+03:00) To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha Not calculating and charging overdue fines Hi all, I think what Caroline described would work well for a dev (git) or standard (tarball) installation, while things with the packages work a little differently like Michael describes. So it might depend on your installation type on what you should do. For package installations the fines.pl should be scheduled by default to run daily. Have you checked everything else that might prevent fines from calculating? - finesmode systempreference? - Holidays in the calendar? - Circulation rules correct? For example sometimes it's easy to miss that rules for 'all libraries' might have been overwritten by branch specific ones. Hope this helps, Katrin On 06.08.19 17:07, Michael Kuhn wrote: > Hi > > >> I think this' where my solution lies however the cron -l command > >> replies no cron command for my user account. I have 2 accounts > >> showing i.e. the admin account and the koha_instance account. > >> > >> I hope i was supposed to run it thru the main account coz thats where > >> I log in. > >> > >> Or what might I be doing wrong? I believe the cron list should have > >> something. Please advise. > > I'm not sure if this is of any help, but in the Koha 19.05 standard > the script "fines.pl" is executed in file > "/etc/cron.daily/koha-common" as follows: > > koha-foreach --chdir --enabled /usr/share/koha/bin/cronjobs/fines.pl > > Thus not in any user controlled crontab. Also the path is not > "misc/cronjobs/fines.pl". > > Best wishes: Michael _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha -- Click here to report this message as spam: https://console.mailguard.com.au/ras/1WjDFG6Rrm/6w1jxU3YIDrNJIQQ56V7oe/0.4 _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Koha upgrade from 3.20.00.000 (2015) to any latest and stable version
by Sultan Qaboos Cultural Center Library 27 Aug '19

27 Aug '19

Hello, Our library is planning to upgrade Koha from the version 3.20.00.000 to any Koha latest and stable version. - What Koha version do you recommend us ? - Could you please give us a complete tutorial, system requirements, and the things we have to do (backup ?, etc,) before starting the upgrade ? - Is it possible to upgrade directly from 3.20 (2015) to the latest version ? or we have to upgrade to lower versions before? Given that almost all Koha modules are up-to-date. Best regards, Walid -- *Sultan Qaboos Cultural Center Library* 1100 16th St, NW Washington, DC 20036 library(a)sqcc.org 202-677-3967, x104

4 4