- Koha - lists.katipo.co.nz

Re: [Koha] subject shelflist card sql report
by Nalisha Tamang 18 Mar '21

18 Mar '21

I did but it doesn't mention the subjects...i need subjects area especially On Wed, Mar 17, 2021 at 7:46 PM MASTeR Library <mamcet.library10(a)gmail.com> wrote: > Visit sql reports : > https://libpowertech.blogspot.com/search/label/Koha%20Reports?m=1?&max-resu… > > On Wed, 17 Mar 2021, 10:03 am Nalisha Tamang, <nt(a)ptsindia.com> wrote: > >> 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 >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> >

1 0

KohaCon21 hosting organization announced!
by Caroline Cyr-La-Rose 17 Mar '21

17 Mar '21

Hello dear Koha Community! Today at the General meeting, it was announced that the Koha Pakistan Community and the National Library of Pakistan will be hosting KohaCon21! The proposed dates for the conference are November 14 to 30, 2021 and will be organized as a hybrid in-person/online conference. For those who are able to travel, the in-person conference will be held at the National Library of Pakistan, in Islamabad. The Pakistani community has a lot of experience in organizing conferences as they have been organizing Open Source Summits and Koha Conferences for the past several years with great success. I'm sure KohaCon21 will not be an exception! You can find all the information about their proposal on the Koha wiki : https://wiki.koha-community.org/wiki/KohaCon21_Proposals#Hosting_organizati… The Koha Pakistan Community will keep us updated on the details in the upcoming months. Thank you all! Caroline -- Caroline Cyr La Rose, M.L.I.S. Librarian | Product Manager Phone: 1-833-465-4276, ext. 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Document Technologies Specialists | www.inLibro.com <http://www.inLibro.com>

1 0

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