- Koha - lists.katipo.co.nz

18.05.08 Release
by Lucas Gass 23 Jan '19

23 Jan '19

The Koha community is proud to announce the release of Koha 18.05.08. Koha 18.05.08 is a bugfix/maintenance release. It includes 23 bugfixes. The full release notes are available at: https://koha-community.org/koha-18-05-08-released/ Debian packages will be updated within a few days. Best, Jesse and Lucas

2 1

Upgrade to Koha 18.11 on Ubuntu 16.04
by user233162 23 Jan '19

23 Jan '19

Hi, I have instance of Koha 17.11.05 installed on an Ubuntu 16.04 LTS. I would like to upgrade Koha to the current version 18.11., but I get the error: sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done koha-common is already the newest version (17.11.05-1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Any idea how resolve this problem please? Many thanks, Karel Matějka -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 2

Regarding SQL query for Analytical entries
by Suresh Kumar Tejomurtula 23 Jan '19

23 Jan '19

Hi, we have analytical entries created for conference papers purchased in our library. We generated a report using the below query. But, unable to get the report the way I need. I wanted a separator between the subject entries that are repeated. But the separator is not getting added and all the subjects for a particular biblio record are coming without separator. We are using koha 16.05 SELECT biblioitems.biblionumber, ExtractValue(marcxml, '//datafield[@tag="088"]/subfield[@code="a"]') AS "Reportno", ExtractValue(marcxml, '//datafield[@tag="245"]/subfield[@code="a"]') AS "title", ExtractValue(marcxml, '//datafield[@tag="773"]/subfield[@code="a"]') AS "main_entry", ExtractValue(marcxml, '//datafield[@tag="773"]/subfield[@code="t"]') AS "main_entry_title", ExtractValue(marcxml, '//datafield[@tag="773"]/subfield[@code="o"]') AS "barcode", GROUP_CONCAT(ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code="a"]') SEPARATOR '||') AS "Subject" FROM biblioitems LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) where biblioitems.itemtype='CON' Group by ExtractValue(marcxml, '//datafield[@tag="773"]/subfield[@code="t"]') Could you please let me know where iam going wrong. -- Regards T. Suresh Kumar

2 2

Re: [Koha] Ordering MARC subfields
by Stefano Bargioni 23 Jan '19

23 Jan '19

A solution could be to alter the order they appear in the web page using jQuery. Something like this (not fully tested, and probably fails with more than one occurrence of involved subfields): s3362 = $('[id^="subfield3362"]'); s336a = $('[id^="subfield336a"]'); s336b = $('[id^="subfield336b"]'); s336a.insertAfter(s3362); s336b.insertAfter(s336a); HTH. Stefano > we are facing problem with ordering of subfields in some specific MARC fields. For example we need to have 787 with subfields having exactly this order: i, t, g. And there are several other fields suffering from the same issue like 336 2, a, b. Is there a way how to instruct a cataloguing framework to follow the given order of subfields? Or, should we file a request for improvement in bugzilla? >

1 0

Library items non-display in OPAC
by Peter Lau 23 Jan '19

23 Jan '19

How can I stop some library items from showing in OPAC? 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…] 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk

3 8

Re: [Koha] How to find a great number of visitors in the library on mysql report.
by Indranil Das Gupta 23 Jan '19

23 Jan '19

Hi Please see the reference SQL reports listed here https://wiki.koha-community.org/wiki/SQL_Reports_Circulation You should be able to set up one to your requirements using these as reference. regards Indranil Das Gupta L2C2 Technologies -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg On Wed, Jan 23, 2019 at 10:17 AM MAMCET Library <mamcet.library10(a)gmail.com> wrote: > > How to find a Books highest readers in mysql report. > > On Wed, Jan 23, 2019 at 9:45 AM Indranil Das Gupta <indradg(a)gmail.com> wrote: >> >> You cant do this using only Koha. You need to use an Analytics tools like PiWik / Matamo or an analytics service like Google Analytics. Or you wish to do it the old school way then you need to use a tool like AWstats. >> >> Hope this helps >> >> Indranil Das Gupta >> L2C2 Technologies >> >> On Wed 23 Jan, 2019, 9:22 AM MAMCET Library, <mamcet.library10(a)gmail.com> wrote: >>> >>> Dear sir/Madam >>> How to find a great number of visitors in the >>> library. How to prepare the mysql Report. please help me. >>> >>> -- >>> Thanking you.. >>> >>> Librarian, >>> MAMCET <http://mamcet.com/> >>> Trichy-Chennai Trunk Road, >>> Siruganur, Tiruchirappalli-621 105. >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > Thanking you.. > > Librarian, > MAMCET > Trichy-Chennai Trunk Road, > Siruganur, Tiruchirappalli-621 105. >

1 0

How to find a great number of visitors in the library on mysql report.
by MAMCET Library 23 Jan '19

23 Jan '19

Dear sir/Madam How to find a great number of visitors in the library. How to prepare the mysql Report. please help me. -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

2 1

Koha 18.11.02 release
by Renvoize, Martin 22 Jan '19

22 Jan '19

The Koha community is proud to announce the release of Koha 18.11.02. This is a maintenance release. The full release notes are available at https://koha-community.org/koha-18-11-02-release/ Debian packages will be uploaded in a few days. Best regards and happy new year ;) *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

1 0

Koha 18 support
by faiz＠umt.edu.pk 22 Jan '19

22 Jan '19

We are facing error with our daily Cron jobs, it fails and the stops Koha search, we than rebuild Koha index and restart the server 2 or three times, this in return brings the service up. Now when we rebuild zebra it gives zebraidx error and does not rebuild. We require support and maintenance of our locally installed instance. - Current system * Koha 18.05 - Number of bibliographic records * 127K - Average annual circulation * 35K approx. Kind Regards Muhammad Faiz Chishti Team Lead Systems Office of Technology Support (OTS) University of Management and Technology C 2 Johar Town Tell: +42 111300200 Ext: 3640 Cell: +923054440632 Website: www.umt.edu.pk Email: faiz(a)umt.edu.pk Please consider the environment before printing this email.

2 1

Koha 17.11.14 release
by Fridolin SOMERS 22 Jan '19

22 Jan '19

The Koha community is proud to announce the release of Koha 17.11.14. This is a maintenance release. The full release notes are available at https://koha-community.org/koha-17-11-14-release/ Debian packages will be upgraded in a few days. Best regards and happy new year ;) -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0