- Koha - lists.katipo.co.nz

Upgrade planning tools and processes.
by Raymund Delahunty 30 Nov '20

30 Nov '20

We are looking to upgrade our relatively heavily customised version of 18.11 to 20.11 in maybe June 2021. Our server is hosted externally and we do not have command-line access to it. The Koha system is supported and will be upgraded by a software support company which specialises in supporting Koha and other open source products. I'd be interested to know what upgrade management tools and procedures support companies and other Koha users in a position similar to us have used in the past, and how successful the upgrade experience was, and if you think it was helped be less painful than it could have otherwise been, given the tools and procedures you used. We have used a google document managed by the support company in the past and at times I found it difficult to see a timeline and to know where we were, issue by issue, with the multiple issues being reported and needing advice / fixes. Rather than clutter up this List I'd be happy to receive suggestions and comments directly at lib-systems(a)arts.ac.uk<mailto:lib-systems@arts.ac.uk>. Thanks. Ray Delahunty, University of the Arts London. This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

2 1

Koha 20.11.00 released
by Jonathan Druart 30 Nov '20

30 Nov '20

Hello everybody, It is with great pleasure that the Koha community announces the release of Koha 20.11, a major release of the Koha open source integrated library system. Read the full release notes here: https://koha-community.org/koha-20-11-released/ The Debian packages for this new version will be available soon. Stay tuned! Cheers, Jonathan

5 4

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