- Koha - lists.katipo.co.nz

Call for Presentation Proposals
by Vicepresident koha-US 01 May '19

01 May '19

Hello, Koha-US would like to invite you to propose a presentation for our annual conference, held in September 2019. Proposals will be due the 31st of May 2019. Please plan for a 45 minute long session with 5 minutes of questions after. The koha-US 2019 Conference will be held in Pueblo Colorado September 18th-21st 2019. You can submit proposals here. <https://docs.google.com/forms/d/e/1FAIpQLSfUyOAowsiGoOwAI_jj_YIiMRbIlbZgvSk…> Our theme for the 2019 conference will be: *Patron Power – Enable Your Users* It will be hosted by Pueblo City/County Library District (map.) <https://www.google.com/maps/dir/Pueblo+City-County+Library+District+-+Rawli…> The cost for the conference will by $35.00 for members and $55.00 for non-members. *Due to low registration fees, registration for presenters will not be waived. Please e-mail info(a)koha-us.org if you have any questions. Lisette Scheer Vice President koha-US

1 0

Re: [Koha] Subject Wise Report
by Owen Leonard 30 Apr '19

30 Apr '19

Please reply to the mailing list so that others can participate. On Wed, Apr 17, 2019 at 12:25 AM Rizwan Majeed <rizwanmajeed(a)ue.edu.pk> wrote: > > this is the query > > SELECT * > FROM(SELECT > items.dateaccessioned, > items.barcode, > items.itemcallnumber, > biblio.title, > biblio.author, > biblioitems.publishercode, > (SELECT ExtractValue(biblioitems.marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]')) > AS Subject > FROM items > LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.dateaccessioned BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>) AS t > WHERE Subject LIKE concat('%',<<Subject>>,'%') > ORDER BY dateaccessioned DESC >

4 4

Fine Calculation Settings
by Rizwan Majeed 30 Apr '19

30 Apr '19

Dear All In our university, the fine calculation rule is as under: - after due date, Rs.10/- per day will be charged upto seven days - Rs.50/- per day will be charged after seven days Does anybody know about the settings to calculate the fine as mentioned above? I shall be thankful. Regards! Rizwan

3 2

Re: [Koha] Relator Term
by Ma. Victoria H. Silva-Manuel 30 Apr '19

30 Apr '19

Hi. Thank you for replying. I compared the two frameworks and no authorized value is linked to $4 in both frameworks. They also have the same subfields and visibility setting. Is there another way to fix this? Thank you. On Mon, Apr 29, 2019 at 4:54 PM Katrin Fischer <Katrin.Fischer.83(a)web.de> wrote: > > Hi, > > compare your frameworks and check if an authorised value is linked to $4 > in one of them. Koha can pull the relator terms from an authorised value > and replace the codes with the descriptions if you link them. I'd also > check if you have the same subfiels and visibility settings in both. > > Hope this helps, > > Katrin > > > *Gesendet:* Montag, 29. April 2019 um 10:44 Uhr > *Von:* "Ma. Victoria H. Silva-Manuel" <mavicsilva(a)gmail.com> > *An:* koha <koha(a)lists.katipo.co.nz> > *Betreff:* [Koha] Relator Term > Hi. > In our Koha, relator terms from Book MARC Framework and Kit MARC Framework > show in OPAC differently. > > In Book Framework: > > Gonzalez, Fernando Rosal [author] > > > While in Kit Framework: > > Gonzalez, Fernando Rosal, author > > > How can we edit this? We prefer the one in Kit Framework. > > Hope someone can help us. > > Thank you. > Ma. Victoria H. Silva-Manuel > Registered Librarian, 3892 > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Creation of separate OPAC for each library in Library group
by Habib Jaffri 29 Apr '19

29 Apr '19

Dear community members Kindly help us to develop the separate OPAC interface for each library in on library group Syed Habib Akhter Jaffri Sent from Mail for Windows 10 --- This email has been checked for viruses by AVG. https://www.avg.com

1 0

Creating a Report to List Books published with a Date Range
by Njideaka Tobechukwu 29 Apr '19

29 Apr '19

Hi All, Please, I am trying to create a report of my KOHA database to list books published within 2016-2019, in a tabular form having just the book title, author, and date of publication. However, I do not know how to go about creating this report. Please, can someone help with steps to follow to create such a report., OR an SQL Schema for such a report. Thank you -- *Tobechukwu Njideaka* *Knowledge/Information Management Specialist*

3 2

SQL for Auto Increment verification
by Tom Hanstra 29 Apr '19

29 Apr '19

Based upon a blog post from a couple of versions back, we regularly run some SQL on our databases to ensure that auto increment is working properly on a number of tables. We have had some problems with this, however, in version 17.11 with database locks on table updates which have resulted in downtime for Koha. My question is whether this code is still necessary in 17.11 and beyond or if this is now obsolete. If I don't need to run this, I will stop doing so. And the second question would be, if it is necessary, have others run into similar issues and how might it be cleared up? Thanks in advance for any guidance you can provide, Tom -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu <http://library.nd.edu/>

3 3

May 2019 koha-US meeting dates
by Jason Robb 29 Apr '19

29 Apr '19

*koha-US meetings are open to any and all.* *Board Meeting -* When: Wednesday, May 1st at 10:30 am CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+board+mee…> ) Where: https://kslib.zoom.us/j/450230564 Agenda: *https://docs.google.com/document/d/168-sgZMrM-LP62Qz9JqbJ8Km7q809KjK5xxlrF8ZXYw/edit?usp=sharing <https://docs.google.com/document/d/168-sgZMrM-LP62Qz9JqbJ8Km7q809KjK5xxlrF8…>* *Board meetings* focus on business-related matters and topics that would otherwise slow down general meetings. *General Meeting* - When: Wednesday, May 8th at 10:30 am CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) 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. Meetings are held via Zoom video conferencing. A microphone and camera 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>* 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

Relator Term
by Ma. Victoria H. Silva-Manuel 29 Apr '19

29 Apr '19

Hi. In our Koha, relator terms from Book MARC Framework and Kit MARC Framework show in OPAC differently. In Book Framework: Gonzalez, Fernando Rosal [author] While in Kit Framework: Gonzalez, Fernando Rosal, author How can we edit this? We prefer the one in Kit Framework. Hope someone can help us. Thank you. Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

1 0

Library patron records - edit Sort 1 & Sort 2 available options
by Peter Lau 29 Apr '19

29 Apr '19

How can I make changes in the available options to Sort 1 & Sort 2 in Library Management Under Patron records? Library management 1. Card number: *Required* Card number must be between 4 and 8 characters. 2. Library: *Required* 3. Category: *Required* 4. Sort 1: 5. Sort 2: 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…] *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE is a member of YCEF, and both are registered non-profits in Hong Kong*

1 0