- Koha - lists.katipo.co.nz

Circulation Report generation which includes librarian and library user name
by Krishna Maraddi 27 Feb '19

27 Feb '19

Sir, I want to create the circulation history report which should include the library staff name and benefited user name. The report can be generate on the base of book number. Kindly help me in this regard Yours faithfully, K S Maraddi

1 0

Software error - /usr/share/koha/intranet/cgi-bin/acqui/neworderempty.pl line 247.
by Aliki 26 Feb '19

26 Feb '19

Hello everybody! It’s been 2 weeks that I’m trying to add a book suggestion to a vendor’s basket, and all I get when I click on the +order button, is the following message. Any ideas what is going wrong? *Software error:* Can't call method "effective_create_items" on an undefined value at /usr/share/koha/intranet/cgi-bin/acqui/neworderempty.pl line 247. Time zone in Athens (GMT+2) Monday, February 25, 2019, 4:19 PM *Koha version:* 17.11.05.000 *OS version ('uname -a'):* Linux linuxsrv 3.16.0-6-686-pae #1 SMP Debian 3.16.56-1+deb8u1 (2018-05-08) i686 *Perl interpreter:* /usr/bin/perl *Perl version:* 5.020002 Best regards -- Aliki Pavlidou

2 1

Re: [Koha] FW: Koha 18 support
by Fridolin SOMERS 26 Feb '19

26 Feb '19

Hi, Looks like your Zebra configuration is still in GRS-1 which is strongly deprecated. Try switch to DOM : https://wiki.koha-community.org/wiki/Switching_to_dom_indexing Which is you OS and how did you install Koha please ? Best regards, Le 23/01/2019 à 06:03, faiz(a)umt.edu.pk a écrit : > Dear Fridolin and Koha friends > > Our koha is not searching and when we rebuild Koha zebra it gives zebraidx error which is attached, our installation package is on ubuntu 16.04, when we rebuild Zebra from root login it works in the begning but as the indexing finishes after 20 min it starts generating errors, please share resolution. > > > Kind Regards > > > Muhammad Faiz Chishti > Team Lead Systems > Office of Technology Support (OTS) > University of Management and Technology > C 2 Johar Town > Tell: +42 111300200 Ext: 3640 Cell: +923054440632 > Website: www.umt.edu.pk Email: faiz(a)umt.edu.pk > > Please consider the environment before printing this email. > > > -----Original Message----- > From: faiz(a)umt.edu.pk <faiz(a)umt.edu.pk> > Sent: Tuesday, January 22, 2019 8:30 PM > To: 'Fridolin SOMERS' <fridolin.somers(a)biblibre.com>; 'koha(a)lists.katipo.co.nz' <koha(a)lists.katipo.co.nz>; 'koha-devel' <koha-devel(a)lists.koha-community.org> > Subject: RE: [Koha] Koha 18 support > > Dear brother > > We are using a pre compiled version by total library solution, We are facing error with zebra, it fails and the stops Koha search, we than rebuild Koha index and restart the server 2 or three times, this in return brings the service up. Now when we rebuild zebra it gives zebraidx error and does not rebuild. > > > The error is attached > > Kind Regards > > > Muhammad Faiz Chishti > Team Lead Systems > Office of Technology Support (OTS) > University of Management and Technology > C 2 Johar Town > Tell: +42 111300200 Ext: 3640 Cell: +923054440632 > Website: www.umt.edu.pk Email: faiz(a)umt.edu.pk > > Please consider the environment before printing this email. > > > -----Original Message----- > From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of Fridolin SOMERS > Sent: Tuesday, January 22, 2019 8:20 PM > To: koha(a)lists.katipo.co.nz; 'koha-devel' <koha-devel(a)lists.koha-community.org> > Subject: Re: [Koha] Koha 18 support > > Hi > > What is your zebraidx error ? > > How did you install ? Debian Package ? > > Regards, > > Le 22/01/2019 à 11:31, faiz(a)umt.edu.pk a écrit : >> >> We are facing error with our daily Cron jobs, it fails and the stops Koha search, we than rebuild Koha index and restart the server 2 or three times, this in return brings the service up. Now when we rebuild zebra it gives zebraidx error and does not rebuild. >> >> We require support and maintenance of our locally installed instance. >> >> >> - Current system >> * Koha 18.05 >> >> - Number of bibliographic records >> * 127K >> >> - Average annual circulation >> * 35K approx. >> >> >> >> Kind Regards >> >> >> Muhammad Faiz Chishti >> Team Lead Systems >> Office of Technology Support (OTS) >> University of Management and Technology C 2 Johar Town >> Tell: +42 111300200 Ext: 3640 Cell: +923054440632 >> Website: www.umt.edu.pk Email: faiz(a)umt.edu.pk >> >> Please consider the environment before printing this email. >> >> > > -- > Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha > -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0

Koha 17.11.15 release
by Fridolin SOMERS 26 Feb '19

26 Feb '19

The Koha community is proud to announce the release of Koha 17.11.15. This is a maintenance release. The full release notes are available at https://koha-community.org/koha-17-11-15-release/ Debian packages will be upgraded in a few days. I may end this maintaining with 19.05 release in may, so last version should be 17.11.18. Regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0

Dubai koha user
by vikram zadgaonkar 26 Feb '19

26 Feb '19

Dear All, I would be traveling to Bahrain for koha user training in next week. While coming back to India ,I am planning visit Dubai on 6th March for a day. Let me now if I can meet koha users from Dubai. Vikram Zadgaonkar

1 0

Re: [Koha] search result list is void of information
by Jonathan Druart 25 Feb '19

25 Feb '19

Hi Giuseppe (cc the list I forgot in my previous answer), I would try a full zebra reindex, then search for relevant errors/warnings in the Koha log files if the reindex did not fix the problem. Regards, Jonathan Le mar. 19 févr. 2019 à 10:32, Giuseppe Ciaccio <giuseppe.ciaccio(a)unige.it> a écrit : > > On Tue, 19 Feb 2019, Jonathan Druart wrote: > > > Hi Giuseppe, > > Hello, > > > Did you modify the value of OPACXSLTResultsDisplay? > > No > > > Did you correctly chose the MARC flavour value during the installation process? > > Yes (it is unimarc in our case, and it was the same with previous install of koha). > > Giuseppe > > > Regards, > > Jonathan > > > > Le lun. 18 févr. 2019 à 09:07, giuseppe <giuseppe.ciaccio(a)unige.it> a écrit : > >> > >> Hello all, > >> > >> I've replaced an old Koha 17.11 by a fresh install of Koha 18.11. After > >> install, as superlibrarian I successfully populated the DB with sample > >> records including a couple of items, for test purposes. > >> > >> <http://koha.1045719.n5.nabble.com/file/t341209/Screenshot_2019-02-17_17-55-…> > >> > >> Afterwards, as normal user I tried a search for a keyword matching more than > >> one record, and thus I got a list of search results. > >> > >> <http://koha.1045719.n5.nabble.com/file/t341209/Screenshot_2019-02-18_12-38-…> > >> > >> The list is correct, but, as you can see, each entry is void of textual > >> information -- no title/author/etc. . If I click on the "image preview" of > >> one single entry (not visible in the screenshot) I get access to the full > >> info of that entry, which shows correct. But the search results void of > >> textual information is uninformative for a user. This misbehaviour was not > >> present in Koha 17.11. Is this just a matter of misconfiguration? What > >> should I do to restore the original behaviour? > >> > >> Thank you. > >> > >> > >> > >> -- > >> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha(a)lists.katipo.co.nz > >> https://lists.katipo.co.nz/mailman/listinfo/koha > >

4 5

Re: [Koha] Koha Digest, Vol 160, Issue 16
by Peter Lau 23 Feb '19

23 Feb '19

Dear Katrin, Can the Collection code be displayed in OPAC as I can't see it in the OPAC column setting? Can I add field to the OPAC display like "Copy" information instead of being part of the Call nUmber? Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) 23384320 2 Tin Wan Hill Road, Tin Wan, Aberdeen YCCECE, Here We Grow Our Future | www.yccece.edu.hk -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: Monday, 18 February 2019 7:00 AM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 160, Issue 16 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Replacement of information in an item field by batch (Katrin Fischer) 2. Re: updating password field from other database (Katrin Fischer) 3. Re: Display of information on OPAC (Katrin Fischer) 4. Re: Koha Password Recovery (Jonathan Druart) ---------------------------------------------------------------------- Message: 1 Date: Sun, 17 Feb 2019 10:40:34 +0100 From: Katrin Fischer <katrin.fischer.83(a)web.de> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Replacement of information in an item field by batch Message-ID: <77ef0770-6ed5-7443-aa26-98afbe1a2efb(a)web.de> Content-Type: text/plain; charset=utf-8; format=flowed Hi Peter, the batch item edit tool exects a .txt file with only the barcodes. Every barcode needs to be on a separate line. Hope this helps, Katrin On 15.02.19 07:40, Peter Lau wrote: > Hi Carlos, > > > > I have an Excel file with the following information that I would like > to update the 3 existing records based on the item barcodes including > Collection Type and Call Number, > > > > AE00001131 > > REF > > AE5 E363 2010 guide > > AE00001132 > > REF > > AE5 E363 2010 index A-K > > AE00001133 > > REF > > AE5 E363 2010 index L-Z > > > > It has the following error message: > > > > Barcodes not found > > AE00001131 REF AE5 E363 2010 guide > > AE00001132 REF AE5 E363 2010 index A-K > > AE00001133 REF AE5 E363 2010 index L-Z > > > > Thanks & regards, > > Peter Lau > > Librarian > > Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) > 23384320 > > > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > YCCECE, Here We Grow Our Future | www.yccece.edu.hk > > > > -----Original Message----- > From: Carlos Lopez [mailto:clopez@dml.vic.edu.au] > Sent: Thursday, 14 February 2019 8:02 AM > To: Peter Lau <peter.lau(a)yccece.edu.hk>; Koha > <koha(a)lists.katipo.co.nz> > Subject: RE: [Koha] Replacement of information in an item field by > batch > > > > Hi Peter > > Koha is very good at this sort of batch processing. If you select the > records you want to edit (from a file of itemnumbers or barcodes, or > by scanning a barcode at a time) you can use the Batch Item > Modification tool (Koha > Tools > Batch item modification, or <<your > Koha > instance>>/cgi-bin/koha/tools/batchMod.pl > > > > Regards, > > Carlos. > > > > Carlos Lopez > > Cataloguer > > Dalton McCaughey Library > > 29 College Crescent > > Parkville, VIC 3052 > > AUSTRALIA > > > > Ph: +61 3 93408885 > > Fax: +61 3 86694418 > > clopez(a)dml.vic.edu.au > > > > -----Original Message----- > > From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of Peter Lau > > Sent: Thursday, 14 February 2019 10:11 AM > > To: Koha <koha(a)lists.katipo.co.nz> > > Subject: [Koha] Replacement of information in an item field by batch > > > > How can I replace the item collection code or call number in item by > batch? > > > > Thanks & regards, > > Peter Lau > > Librarian > > Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) > 23384320 > > > > > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > YCCECE, Here We Grow Our Future | www.yccece.edu.hk > _______________________________________________ > > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > > Message protected by MailGuard: e-mail anti-virus, anti-spam and > content filtering.http://www.mailguard.com.au/mg > > Click here to report this message as spam: > > https://console.mailguard.com.au/ras/1V6MsDH8Ro/6PPHtcJtolVYpyf47LxKsK > /-0.6 _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 2 Date: Sun, 17 Feb 2019 10:46:01 +0100 From: Katrin Fischer <katrin.fischer.83(a)web.de> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] updating password field from other database Message-ID: <fe704cc2-1fde-0dd7-1c9b-242289c7b448(a)web.de> Content-Type: text/plain; charset=utf-8; format=flowed Hi Shafendi, can you explain your use case a bit more? When using external authentication usually Koha doesn't need to store a password (LDAP, Shibboleth, CAS,...) There will be an API for changing the password soon, but not sure if that will be helpful in your context: *Bug 17006* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17006> - Add route to change patron's password Hope this helps, Katrin On 04.02.19 18:35, Shafendi wrote: > hi.. > > i would like to ask, is it possible for me to update my library koha > patron password through connecting my koha database to other source of > password database? not LDAP. > > > > -- > Sent from: > http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 3 Date: Sun, 17 Feb 2019 10:47:20 +0100 From: Katrin Fischer <katrin.fischer.83(a)web.de> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Display of information on OPAC Message-ID: <a9e9c8a1-dbab-2e63-9cf2-d49f3994ff4f(a)web.de> Content-Type: text/plain; charset=utf-8; format=flowed Hi Peter, your question is very general Can you explain a bit more about what you are trying to do and which information you are refering to? Katrin On 15.02.19 10:12, Peter Lau wrote: > I forgot how to choose information to be displayed on OPAC. > > Thanks & regards, > > *Peter Lau* > > Librarian > > Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) > 23384320 > > [image: > https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6OD > ZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ] > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Message: 4 Date: Sun, 17 Feb 2019 10:20:53 -0300 From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> To: Peter Lau <peter.lau(a)yccece.edu.hk> Cc: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Koha Password Recovery Message-ID: <CAJzKNY5yQyf805th9D1eqGA=HN2yvPiwU-XFVCawuXA1RGKcJw(a)mail.gmail.com> Content-Type: text/plain; charset="UTF-8" Hello Peter, Same as my previous answer, it seems that you modified the notice template. How? You want to display the fields "surname" and "firstname", not "userid". Regards, Jonathan Le ven. 15 févr. 2019 à 03:05, Peter Lau <peter.lau(a)yccece.edu.hk> a écrit : > > In the email that I received for the captioned, I don’t know when I > was addressed with my email account (peter.lau) instead of my name > (Peter Lau) > > Dear peter.lau > > This email has been sent in response to your password recovery request > for the account *peter.lau*. > > You can now create your new password using the following link: > http://koha.yccece.edu.hk//cgi-bin/koha/opac-password-recovery.pl?uniq > ueKey=$2a$08$vCwNb7rynR1t0PYc0w38ze > <http://koha.yccece.edu.hk/cgi-bin/koha/opac-password-recovery.pl?uniq > ueKey=$2a$08$vCwNb7rynR1t0PYc0w38ze> > > This link will be valid for 2 days from this email's reception, then > you must reapply if you do not change your password. > > Thank you. > > Thanks & regards, > > *Peter Lau* > > Librarian > > Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) > 23384320 > > [image: > https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6OD > ZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ] > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk > _______________________________________________ > Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 160, Issue 16 *************************************

3 2

3M self check error information with “Account” option
by Peter Lau 23 Feb '19

23 Feb '19

In one of the options on 3M self check, I can set to display Account information. Under the Account option, when I tried to list my loan record, there’s an error message referring me to the counter for help. Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) 23384320 2 Tin Wan Hill Road, Tin Wan, Aberdeen YCCECE, Here We Grow Our Future | www.yccece.edu.hk

1 0

OPAC research does not work
by Davide Spanu 23 Feb '19

23 Feb '19

Hello, I'm having problems configuring Koha. I've uselessly tried solving the issue on my own and also browsing forums. After the install I started cataloging, inserting titles and texts. However once inserted for some reason they don't appear in the OPAC. I can't figure out what I'm doing wrong and need assistance. Thank you in advance

2 1

Report for items held by 2 out of 3 branches
by Cab Vinton 22 Feb '19

22 Feb '19

Hi, All -- We have a report (see below) that generates a random list of items held by all 3 of our branches & purchased within the past 30 days. To generate more titles we'd like to loosen the criteria by specifying that the titles should be held by just 2 of the 3 branches. I know how I'd approach this outside of Koha's SQL-based reporting tool, but not sure how to write this without repeating a whole bunch of code ((A or B) or (A or C) or (B or C)). The code is used to populate a carousel on our OPAC's home page & it's already a bit "pokey", so efficient code is an important factor. Anyone have suggestions on how best to write this report? Many thanks in advance, Cab Vinton, Director Plaistow Public Library Plaistow, NH https://catalog.southernnh.bywatersolutions.com SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON i.biblionumber = b.biblionumber WHERE i.itype = 'NEWBOOK' AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='KIMBALL') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='PLAISTOW') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='SANDOWN') GROUP BY b.biblionumber HAVING isbn != "" ORDER BY rand() LIMIT 7

2 4