- Koha - lists.katipo.co.nz

koha-US meeting invite: Wednesday, February 13th, 2019
by koha-US Secretary 08 Feb '19

08 Feb '19

Date: Wednesday, February 13th, 2019 Time: 10:30 AM - 11:30 AM CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+February+…> ) Location: https://kslib.zoom.us/j/110290143 Agenda: *https://docs.google.com/document/d/1qhCWpU2o76jOGEk8UGIMG6buXX49ETtbApcfAlJYuVk/edit?usp=sharing <https://docs.google.com/document/d/1qhCWpU2o76jOGEk8UGIMG6buXX49ETtbApcfAlJ…>* This month, we're looking at an update to the committees section of the bylaws. Members should review this document prior to the meeting. Changes are red, additions are yellow: https://docs.google.com/document/d/1qTHKr-BF2QPD0UdYW8IupQP2KlN_Zev2D6YTv2f… We will also have reports from various committees and time to discuss bugs, issues, and general Koha questions. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Re: [Koha] Report Checked out and Checked in report with school class and section
by Ashok Francis 08 Feb '19

08 Feb '19

Thank you so much MAMSET LIBRARY. It works well. Great work. On Fri, Feb 8, 2019 at 9:14 AM MAMCET Library <mamcet.library10(a)gmail.com> wrote: > Report form Checked out > Report SQL: > > SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, > DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, > p.cardnumber AS Card_No, > p.firstname AS First_Name, > p.surname AS Last_Name, > p.borrowernotes AS Class_section , > p.Categorycode AS Category, > i.barcode AS Barcode, > b.title AS Title, > b.author AS Author, > p.branchcode AS Library > > FROM issues c > LEFT JOIN items i ON (c.itemnumber=i.itemnumber) > LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > WHERE c.issuedate > BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> > ORDER BY c.issuedate DESC > > On Fri, Feb 8, 2019 at 9:02 AM MAMCET Library <mamcet.library10(a)gmail.com> > wrote: > >> Report Checked in report >> >> SELECT old_issues.Returndate, >> borrowers.Cardnumber AS Card_No, >> borrowers.Surname AS Name, >> borrowers.borrowernotes AS Class, >> borrowers.Categorycode AS Category, >> items.Barcode AS Barcode, >> biblio.Title AS Title, >> biblio.Author AS Author >> >> FROM old_issues LEFT JOIN borrowers ON >> borrowers.borrowernumber=old_issues.borrowernumber >> LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN >> biblio ON items.biblionumber=biblio.biblionumber WHERE >> old_issues.returndate >> BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> >> ORDER BY old_issues.returndate DESC >> >> On Thu, Feb 7, 2019 at 1:12 PM Ashok Francis <ashokfrancis.tgs(a)gmail.com> >> wrote: >> >>> Dear All, >>> >>> I am running Koha 17.11.04.000 in Ubuntu at CBSE school. I have created >>> new >>> field Student class and section in Additional attributes and identifiers. >>> Every day we are taking circulation report "Date wise list of Checked out >>> Books" and also Checked in books. Is it possible to include student >>> class >>> and section in this report. It will be very useful for us. If it is >>> possible, can you please guide me? I will be thankful to you. >>> >>> Report SQL: >>> >>> SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, >>> DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, >>> i.barcode AS Barcode, >>> b.title AS Title, >>> b.author AS Author, >>> p.cardnumber AS Card_No, >>> p.firstname AS First_Name, >>> p.surname AS Last_Name >>> FROM issues c >>> LEFT JOIN items i ON (c.itemnumber=i.itemnumber) >>> LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) >>> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) >>> WHERE c.issuedate >>> BETWEEN '2019-02-07' AND '2019-02-08' ORDER BY c.issuedate DESC >>> >>> >>> Thank you, >>> >>> Ashok Francis >>> >>> New Delhi >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >> >> -- >> Thanking you.. >> >> Librarian, >> MAMCET <http://mamcet.com/> >> Trichy-Chennai Trunk Road, >> Siruganur, Tiruchirappalli-621 105. >> >> > > -- > Thanking you.. > > Librarian, > MAMCET <http://mamcet.com/> > Trichy-Chennai Trunk Road, > Siruganur, Tiruchirappalli-621 105. > >

1 0

Report Checked out and Checked in report with school class and section
by Ashok Francis 07 Feb '19

07 Feb '19

Dear All, I am running Koha 17.11.04.000 in Ubuntu at CBSE school. I have created new field Student class and section in Additional attributes and identifiers. Every day we are taking circulation report "Date wise list of Checked out Books" and also Checked in books. Is it possible to include student class and section in this report. It will be very useful for us. If it is possible, can you please guide me? I will be thankful to you. Report SQL: SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, i.barcode AS Barcode, b.title AS Title, b.author AS Author, p.cardnumber AS Card_No, p.firstname AS First_Name, p.surname AS Last_Name FROM issues c LEFT JOIN items i ON (c.itemnumber=i.itemnumber) LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE c.issuedate BETWEEN '2019-02-07' AND '2019-02-08' ORDER BY c.issuedate DESC Thank you, Ashok Francis New Delhi

1 0

February 2019 koha-US meeting dates
by koha-US Secretary 04 Feb '19

04 Feb '19

*koha-US meetings are open to any and all.* *Board Meeting -* When: Wednesday, February 6th at 10:30 am CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+February+…> ) Where: https://kslib.zoom.us/j/450230564 Agenda: *https://docs.google.com/document/d/12xnIOR7fUMzUVmt_TdjXd4GOQSrne9hsXOijNiGp4GQ/edit?usp=sharing <https://docs.google.com/document/d/12xnIOR7fUMzUVmt_TdjXd4GOQSrne9hsXOijNiG…>* *Board meetings* focus on business-related matters and topics that would otherwise slow down general meetings. *General Meeting* - When: Wednesday, February 13th at 10:30 am CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+February+…> ) Where: https://kslib.zoom.us/j/110290143 *General meetings* put an emphasis on Koha -- bugs, issues, development ideas, workflows -- bring your problems and questions so we can discuss! These meetings also include major organizational decisions and reports from various committees. To view minutes and recordings from previous meetings, visit *http://koha-us.org/about-koha-us/administration/meeting-archives/ <http://koha-us.org/about-koha-us/administration/meeting-archives/>* If you have topics for discussion at either meeting, please send them to secretary(a)koha-us.org. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

ILL Process
by Sarah Fletcher 04 Feb '19

04 Feb '19

Hello Koha community! I am looking for feedback regarding your ILL process. Do you use Koha at all in the process or do you use a separate software entirely, or a combination of the two? We currently use a combination of Koha for charging patrons when necessary and OCLC WorldShare for tracking. Any input would be greatly appreciated! Thank you! -- Sarah Fletcher Library Systems Manager North Central Regional Library 16 North Columbia Street Wenatchee, WA 98801 509-663-1117 x101

4 3

Your account has been locked
by Peter Lau 02 Feb '19

02 Feb '19

Where can I see and fix the problem of an account with the error message “Your account has been locked”. The username and password were re-set but still can’t login. 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-6ODZyoYE…] 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk

2 1

Re: [Koha] opac search returned results doesn't show title
by Peter Zhao 02 Feb '19

02 Feb '19

Hi Katrin, Thanks a lot. I fixed the problem with "Bug 22085". Peter > >Hi Peter, > >assuming that your system is set up throughout as UNIMARC (this has to >be set when creating the instance and for the db), I think you might be >seeing this bug: > >*Bug 22085* ><https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22085> - >UNIMARC default XSLT broken by Bug 14716 ><https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14716> > >It will be fixed in 18.11.03 > >Hope this helps, > >Katrin > >On 26.01.19 02:27, Peter Zhao wrote: >> Hi, >> >> When I upgraded koha17.11 to 18.11 （unimarc）, the opac search returned results list doesn't show title information,but the intranet search returned results show very well. >> How to solve this problem? >> Peter

3 2

Re: [Koha] Item cannot be checked out twice on 3M self-check within the same day
by Katrin Fischer 02 Feb '19

02 Feb '19

Hi Peter, sorry, I am out of ideas then. What you see seems to be related to *Bug 19457* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19457> - If CheckPrevCheckout is set to "Do", then checkouts are blocked at the SIPServer (Needs Signoff] Turning the feature off should still have worked I think. Katrin On 31.01.19 16:38, Peter Lau wrote: > Dear Katrin, > > Thanks for your information. > > I was told that the SIP server was restarted for configuration changes > to take effect frequently. > > Thanks and regards, > > *Peter Lau* > > Librarian > > Tel: (852) 3977 9868 | Email: peter.lau(a)yccece.edu.hk > <mailto:library@yccece.edu.hk> | Fax: (852) 23384320 > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk > <http://www.yccece.edu.hk/> > > > > On Thu, Jan 31, 2019 at 6:10 PM Katrin Fischer > <Katrin.Fischer.83(a)web.de <mailto:Katrin.Fischer.83@web.de>> wrote: > > Hi Peter, > > that sounds right. Sometimes it takes a SIP server restart for > configuration changes to take effect. That's what I'd try next. > > Katrin > > > Gesendet: Donnerstag, 31. Januar 2019 um 10:21 Uhr > > Von: "Peter Lau" <peter.lau(a)yccece.edu.hk > <mailto:peter.lau@yccece.edu.hk>> > > An: "Katrin Fischer" <Katrin.Fischer.83(a)web.de > <mailto:Katrin.Fischer.83@web.de>> > > Cc: "koha list" <koha(a)lists.katipo.co.nz > <mailto:koha@lists.katipo.co.nz>> > > Betreff: RE: [Koha] Item cannot be checked out twice on 3M > self-check within the same day > > > > Hi Katrin, > > > > > > > > I have checked that our setting is “Do not check borrower > checkout history > > to see if the current item has been checked out before.” > > > > > > > > That’s why it has no problem over the Circulation Counter but > the problem > > is with 3M self-check machine. > > > > Thanks & regards, > > > > *Peter Lau* > > > > Librarian > > > > Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk > <mailto:Peter.Lau@yccece.edu.hk> | Fax: (852) 23384320 > > > > [image: > > > https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE…] > > > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > > > *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk > <http://www.yccece.edu.hk> > > > > > > > > *From:* Katrin Fischer [mailto:Katrin.Fischer.83@web.de > <mailto:Katrin.Fischer.83@web.de>] > > *Sent:* Thursday, 31 January 2019 5:12 PM > > *To:* Peter Lau <peter.lau(a)yccece.edu.hk > <mailto:peter.lau@yccece.edu.hk>> > > *Cc:* koha list <koha(a)lists.katipo.co.nz > <mailto:koha@lists.katipo.co.nz>> > > *Subject:* Aw: [Koha] Item cannot be checked out twice on 3M > self-check > > within the same day > > > > > > > > > > > > Hi Peter, > > > > > > > > every time Koha would ask for confirmation on the circulation > desk, it > > might just say "no" on the self check. This messages is because > of your > > setting of the CheckPrevCheckout system preference. > > > > > > > > Hope this helps, > > > > > > > > Katrin > > > > > > > > *Gesendet:* Donnerstag, 31. Januar 2019 um 09:08 Uhr > > *Von:* "Peter Lau" <peter.lau(a)yccece.edu.hk > <mailto:peter.lau@yccece.edu.hk>> > > *An:* "koha list" <koha(a)lists.katipo.co.nz > <mailto:koha@lists.katipo.co.nz>> > > *Betreff:* [Koha] Item cannot be checked out twice on 3M > self-check within > > the same day > > > > With our 3M self-check machine, we have found that once we have > checked out > > and checked in an item, we can’t check-out this item 2nd time. > > > > > > > > The error message is “Item not checked out. Item cannot be issued > > PREVISSUE. Please take the item to the desk”. > > > > Thanks & regards, > > > > *Peter Lau* > > > > Librarian > > > > Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk > <mailto:Peter.Lau@yccece.edu.hk> | Fax: (852) 23384320 > > > > [image: > > > https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE… > > ] > > > > 2 Tin Wan Hill Road, Tin Wan, Aberdeen > > > > *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk > <http://www.yccece.edu.hk> > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > https://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

Long Shot - Looking for workaround suggestions for "Lost and Paid For" items
by Kelly Drake 02 Feb '19

02 Feb '19

Collective wisdom, I'm guessing this is a long shot but perhaps someone out there is dealing with a similar situation. We're looking for a work around that would allow us to remove Lost and Paid for items from a patron's account while still maintaining the replacement cost, and having all other items with a Lost status remain on the patrons account. 1. have the system charge a patron the replacement fee for a lost item (which it does) 2. Allow the patron to pay for that item 3. Have that item removed from the patron account 4. Leave the replacement cost fine on the account or to put it an other way What we would like to happen when a patron pays for Lost item: 1. The patron's is charged for the item (either through the Long Overdue (Lost) process or manually) 2. The replacement fee shows on their account 3. Staff changes the item status to "Lost and Paid for" 4. The item is removed from their account... However, we want all other items, with any of the other Lost status, to remain on the patron's account. (MarkLostItemsAsReturned is set to "Do not mark") Hence the conflict. We've tried the workaround of checking in the item prior to the patron paying the fee with the idea that we could then set the item to Lost with no associated patron but then the replacement fee is forgiven. (Which is what we want to happen when a patron actual does return a lost item) (WhenLostChargeReplacementFee set to charge. If we try and clear the item from the patron's account by returning the item prior to their paying the bill, then the item is no longer lost and the replacement fee is forgiven. ) -- Kelly Drake HELM Project Manager kelly(a)flo.org | Conference calls: https://zoom.us/j/9606207016

2 1

Problem with batch cover image upload
by Mai 02 Feb '19

02 Feb '19

Dear all, I'm running Koha 16.11 on debian 3.16 and every time I attempt uploading a .zip file with cover images and datalink.txt I get an error 500. An error has occurred!*Error 500*This message may have been caused by any of the following reasons: - You made use of an external link to an item that is no longer available - You followed an outdated link e.g. from a search engine or a bookmark - You tried to access a page that needs authentication - An internal link in the client is broken and the page does not exist What's next? - Use top menu bar to navigate to another part of Koha. - To report a broken link or any other issue, please contact the Koha Administrator I've checked out Bug 20564 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20564> and this thread <http://koha.1045719.n5.nabble.com/Bulk-Patron-Image-upload-zip-file-giving-…>. When I check my intranet error logs, I even get the same but still, I don't understand how to fix this. I've also tried it on Koha 18.05 with the same outcome. Can anybody help me? Thank you all in advance. -- Maite Arakaki

2 1