- Koha - lists.katipo.co.nz

Koha Community Newsletter: November 2020
by Koha News 30 Nov '20

30 Nov '20

The Koha Community Newsletter for November 2020 is here: https://koha-community.org/koha-community-newsletter-november-2020/ 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. -- Editor, Koha Community Newsletter

1 0

[koha] SQL Report for withdrawn books.
by muiru james 28 Nov '20

28 Nov '20

I have the below query which runs well without the date filter. On including the date placeholder, it gives me zero results. What am I missing? I need to be able to select a date range. Please help SELECT biblio.author AS Author, biblio.title AS Title, biblioitems.publishercode AS Publisher,biblioitems.publicationyear AS Date_of_Publication, biblioitems.isbn AS ISBN, items.itemcallnumber AS Call_Number,items.barcode AS Barcode_Number, items.price AS Price, items.itemlost_on AS 'Date Lost' FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype= <<Section|itemtypes>> AND items.itemlost=<<Status|lost>> AND items.itemlost_on BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> ORDER BY items.itemcallnumber ASC

3 3

Different rules for borrowers from different libraries based on library
by Carlos Lopez 28 Nov '20

28 Nov '20

Hi folks We're exploring setting up circulation rules for different branches where borrowers from library A can borrow items from both library A and library B but borrowers from library B can only borrow items from library B. The only way I can think of it that will work would be to have item-type based rules in place (where borrowers from library B can borrow only items of type "LibraryBItems" but borrowers from library A can borrow items of type "LibraryAItems" and LibraryBItems") but is there some way to base these rules on the branch itself (without setting up different itypes for both branches)? We're on version 20.05. 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

Managing replacement price during orders and receiving
by BOUIS Sonia 28 Nov '20

28 Nov '20

Hi, I'm searching a way to keep the information of the replacement price during all the order process (order with a file) but it seems that I miss something.. I've tried on a master koha version like this : I've set the preference system 'MarcFieldsToOrder' like this : quantity: 980$g|960$o replacementprice: 980$e During the process of importing, I can see the replacement price appears : https://snipboard.io/GvQjMS.jpg But not anymore in the basket after the import : https://snipboard.io/Or8YqX.jpg Neither in the pending orders waiting to be received : https://snipboard.io/pj4lME.jpg Nor in the receive page : https://snipboard.io/XslNx3.jpg Does anyone have an idea of what I missed ? Thanks. Cheers Sonia BOUIS ------------------------------------------------------ Responsable du Service des applications documentaires Bibliothèques universitaires Université Jean Moulin Lyon 3 ADRESSE GÉOGRAPHIQUE > Manufacture des Tabacs | 6 cours Albert Thomas | LYON 8e ADRESSE POSTALE > Bibliothèque de la Manufacture | 1C avenue des Frères Lumière | CS 78242 - 69372 LYON CEDEX 08 Ligne directe : 33 (0)4 78 78 79 03 http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/>| Suivez-nous > Facebook<https://www.facebook.com/bulyon3/> | Twitter<https://twitter.com/bulyon3>| Instagram<https://www.instagram.com/bu.lyon3/?hl=fr> --------------------------------------------------- L'Université Jean Moulin est membre de l'Université de Lyon

2 1

Koha 20.11 string freeze is now!
by Jonathan Druart 25 Nov '20

25 Nov '20

Hi translators, Here we are, I am happy to announce string freeze today! I am expecting only a few strings to be adjusted before the end of the week. Happy translating! Cheers, Jonathan

1 1

Plugin Administration and Installation
by Charles Kelley 24 Nov '20

24 Nov '20

Hello, all! I would like to install one plugin, the room reservation system. In the 20.05 update seminar, the panelists said that the plugin administration (installation, deletion, etc.) is on the administration page. Where? We installed 20.05 over the summer, and I do not see it in either Tools or Administration. I checked Global System Preferences for it, but I did not see it. I used the common terms (*plugin* and *plugins*), but it did not appear. Does another entity have to turn it on? Is it in one of the bugfix updates since the summer, e.g., 20.05.03? Please enlighten us. Thanks for your help, everyone. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

4 4

Koha and nginx
by Beda Szukics 24 Nov '20

24 Nov '20

Good evening Has anybody running koha with nginx instead of apapche? I found some mentions in the koha-community wiki but these seem to be special cases. Three years ago biblibre published https://git.biblibre.com/biblibre/koha-nginx?lang=de-DE Has anyone used this? Greetings Beda

2 1

Re: [Koha] New patrons SQL Report
by muiru james 24 Nov '20

24 Nov '20

Hello Martha and All Thank you for your reply and assistance. You solved my problem. Warm Regards James On Mon, Nov 23, 2020 at 5:24 PM Martha Fuerst <mfuerst(a)hmcpl.org> wrote: > Good morning James - > > This should work: > > SELECT categorycode, sex, COUNT(borrowernumber) AS 'new patrons' > FROM > (SELECT borrowernumber, categorycode, dateenrolled, sex FROM borrowers > UNION ALL > SELECT borrowernumber, categorycode, dateenrolled, sex FROM > deletedborrowers) AS > patrons > WHERE dateenrolled BETWEEN <<Added BETWEEN (yyyy-mm-dd)|date>> AND <<and > (yyyy-mm-dd)|date>> > GROUP BY categorycode, sex > > > Marti Fuerst > Systems Librarian > Huntsville-Madison County Public Library > 915 Monroe St, Huntsville, AL 35801 > http://hmcpl.org/ — mfuerst(a)hmcpl.org > > On Nov 21, 2020, at 2:54 AM, muiru james <muirunyeri(a)gmail.com> wrote: > > Hello team, > > I need a report that counts and sums new patrons registered within a > certain date range by gender for each category. > > How can I enhance this report? I dont mind a different on delivering > results. > > SELECT categorycode, COUNT(borrowernumber) AS 'new patrons' > FROM (SELECT borrowernumber, categorycode, dateenrolled FROM borrowers > UNION ALL > SELECT borrowernumber, categorycode, dateenrolled FROM deletedborrowers) AS > patrons > WHERE dateenrolled BETWEEN <<Added BETWEEN (yyyy-mm-dd)|date>> AND <<and > (yyyy-mm-dd)|date>> > GROUP BY categorycode > > It is not giving me the count by gender. I also want a drop down arrow > allowing me to select the category that I want. > > Warm Regards > > James > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

Koha 19.11.12 released
by Aleisha Amohia 24 Nov '20

24 Nov '20

Hello! The Koha community is proud to announce the release of Koha 19.11.12. Koha 19.11.12 is a security and bugfix/maintenance release including 1 security fixes, 1 enhancements, 22 bugfixes. The full release notes are available here: https://koha-community.org/koha-19-11-12-released/ -- *Aleisha Amohia*(she/her) Koha Developer Catalyst IT - Expert Open Source Solutions Tel: +64 4 499 2267 | www.catalyst.net.nz <http://www.catalyst.net.nz> Catalyst Logo CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

1 0

Koha 20.05.06 released
by Lucas Gass 24 Nov '20

24 Nov '20

Hello everyone! The Koha community is proud to announce the release of Koha 20.05.06. Koha 20.05.06 is a maintenance release including 3 enhancements and 73 bugfixes. The full release notes are available here: https://koha-community.org/koha-20-05-06-release/ <https://koha-community.org/koha-20-05-04-released/> Debian packages should be available in a few days! -- Lucas Gass Web Developer

1 0