- Koha - lists.katipo.co.nz

koha hardware requirement
by Yatheesh lis 17 Mar '21

17 Mar '21

hi can any one suggest hardware requirement for 50,000 books and 5,000 users -- Y.Yatheesh Babu 8247838231

2 1

update ubuntu 16.04
by George Mikuchadze 17 Mar '21

17 Mar '21

I have one problem and want to solve it as easily as possible. I've installed koha v3.22 on Ubuntu 16.04LTS. Now the support period of this version of ubuntu goes to the end and, I want to upgrade it to version 18.04. My first question is - does koha will work after os upgrade? and the second one is - if no, what is additional software I have to install on ubuntu 18.04? Thanks in advance.

2 1

subject shelflist card sql report
by Nalisha Tamang 17 Mar '21

17 Mar '21

dear all, please help me to create subject shelflist card, the following things must be included callnumber, barcode, author, title, place,publisher,date, pages,subjects eg. Callnumber Author Barcode Title, sub-title. Publication place: Publisher, year. page no. 1.subjects 2. Subjects with regards, Nalisha

1 0

Problem with some SQL
by Carlos Lopez 17 Mar '21

17 Mar '21

Hi everyone I have the following reports that I would like to combine into one: SELECT categories.description, COUNT(borrowers.borrowernumber) FROM borrowers, categories WHERE borrowers.categorycode = categories.categorycode AND borrowers.date_renewed BETWEEN <<Expiry date BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> GROUP BY borrowers.categorycode (count the number of borrower renewals between 2 given dates and provide a breakdown by borrower category) And SELECT categories.description, COUNT(borrowers.borrowernumber) FROM borrowers, categories WHERE borrowers.categorycode = categories.categorycode AND borrowers.dateenrolled BETWEEN <<Expiry date BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> GROUP BY borrowers.categorycode (same thing but for new enrolments rather than renewals) What I would like is a report that will give me 3 columns: Borrower category (from categories.description), a count of newly-enrolled borrowers, and a count of renewed borrowers, with a breakdown by borrower category, but I only want the user to have to enter a single starting date and a single end date (not 2 identical date ranges). I tried to run this one but it looks as though we're not allowed to set variables before the SELECT statement: SET @start_date = <<Start of date range (yyyy-mm-dd)|date>> SET @end_date = <<End of rate range (yyyy-mm-dd)|date>> SELECT categories.description AS "BORROWER CATEGORY", SUM(CASE WHEN borrowers.dateenrolled BETWEEN @start_date AND @end_date THEN 1 ELSE 0) NewBorrowers, SUM(CASE WHEN borrowers.date_renewed BETWEEN @start_date AND @end_date THEN 1 ELSE 0) RenewedBorrowers FROM borrowers, categories WHERE borrowers.categorycode = categories.categorycode GROUP BY borrowers.categorycode Is something like what I'm trying to do even possible on Koha, or should I be happy with my 2 reports? 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

3 3

"Invalid 'to' parameter" when trying to send notices
by Michael Kuhn 16 Mar '21

16 Mar '21

Hi In our library we have last week updated from Koha 19.11.05 to 20.11.03 on Debian GNU/Linux 9. Since then we have two problems: 1. In Koha it is not possible to send the same e-mail to two recipients at once - to solve this problem we have regularly updated field "message_queue.to_address" of pending messages by SQL to contain two addresses instead of one (e. g. "abc@def.com,xyz@def.com") and in Koha 19.11 script "process_message_queue.pl" sent these notices to both addresses without a problem. Since Koha 20.11 the new script "process_message_queue.pl" doesn't do this anymore - instead the script says: Invalid 'to' parameter: abc@def.com,xyz@def.comxxx: 11 status returned by "/usr/share/koha/bin/cronjobs/process_message_queue.pl" If there is only e-mail address present the new script will work as expected, though. 2. According to the setting in Koha system preference "NoticeBcc" all notices should be sent to a certain e-mail address, but since the update none of these e-mails to the BCC-Address were sent. Maybe this is the same problem as described in https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26705 Does anyone know the solution for these problems or should I create a bug report? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 1

Koha service provider in Germany
by Anne Christensen 16 Mar '21

16 Mar '21

Hello, Koha-Community, I would like to introduce my company, effective WEBWORK, as a service provider for Koha. We are a 12 enthusiastic software developers and librarians with lots of experience working with open source software such as VuFind, DSpace, Kitodo and others. We have recently started to provide services for Koha covering consultation work, implementation support, data migration, customization and hosting. Among our first clients is the European Institute for Gender Equality in Vilnius (Lithuania). We are based in Hamburg, Germany and provide support in both German and English. Here are our contact details: Company Name: effective WEBWORK GmbH Location: Hamburg, Germany Contact person: Ms Anne Christensen Contact email: mailto:christensen@effective-webwork.de Website: https://www.effective-webwork.de/loesungen-tools/koha/ Phone: +49 40 6094085794 We would very much like to added to the list of providers for paid support. Kind regards Anne -- Anne Christensen Gesellschafterin, Projektmanagement & Beratung effective WEBWORK GmbH Neuer Wall 18 20354 Hamburg Telefon: +49 40 60940857-94 Telefax: +49 40 60940857- 1 E-Mail: christensen(a)effective-webwork.de Blog: https://www.effective-webwork.de/blog/ ORCID: https://orcid.org/0000-0001-7753-1078 Handelsregister: HRB 101108 (Hamburg) UStId: DE254169943

2 1

subject Shelflist card
by Nalisha Tamang 16 Mar '21

16 Mar '21

dear all, please help me to create subject shelflist card, the following things must be included callnumber, barcode, author, title, place,publisher,date, pages,subjects eg. Callnumber Author Barcode Title, sub-title. Publication place: Publisher, year. page no. 1.subjects 2. Subjects with thanks Nalisha Tamang

1 1

Time to translate: string freeze to prepare Koha 19.11.16 has begun
by Victor Grousset/tuxayo 15 Mar '21

15 Mar '21

Hi, saluton, hola, bonjour, String freeze is into effect as of now for the 19.11.x maintenance branch. The release is scheduled for around the 23th. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Reminder: if you add or change a translation in version 19.11, then you must also copy it to 20.05 and 20.11. Otherwise your work will be lost for future versions. Happy translating, -- Victor Grousset/tuxayo

1 0

Koha 20.11 - RabbitMQ and lock_dir
by Tom Hanstra 15 Mar '21

15 Mar '21

After our upgrade to Koha 20.11, we have noticed a couple of errors. I'm trying to track them down and understand the changes. - lockdir in XML configuration file I get a warning about lockdir missing from the XML file, even after adding the line. I added: <lockdir>/var/lock/koha</lockdir> to my /etc/koha-conf.xml file but the error is still showing up in the About Koha screen. Do I have to do something to clear it? Or did I miss something? - RabbitMQ as message broker Reading the documentation, the addition of RabbitMQ as a message broker is specifically done for PLACK. Do I really have to set up a local RabbitMQ or is there another workaround? What am I gaining that did not work before? Because adding another little piece of software is a bit of hassle. If it is needed, where do I find documentation on setup? The Wiki has nothing that I found to be worthwhile. And if it is not (yet) needed, then how do I remove the error? Thanks, Tom -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu

2 2

Hide Purchase suggestion
by vinod mishra 14 Mar '21

14 Mar '21

Hello I wish to activate online purchase suggestion but hide the same for a specific category of users. Any help is appreciated with JQuery, etc. With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 URL: http://vinod.itshelp.co.in/ ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

2 2