- Koha-devel - lists.koha-community.org

SQL Reports
by SUZUKI Arthur 06 Jan '17

06 Jan '17

Hello Devs, Happy new year! My problem today is the following : I'm writing a Koha plugin to display recommendations on the OPAC: http://github.com/liliputech/koharecommenderengine The way I'm doing it involve modifying the web server configuration, which is *not so convenient*. I wanted to reformat part of my code to place the "SQL Select" part of my plugin in a public report to be able to access it with the following url : http://[koha-url]/cgi-bin/koha/svc/report?id=[reportId]&sqlparam=[biblionum… The problem is the first method gives good performance results while the second one is so damn slow. The "guidedreport.sql" is 100 times slower than "rawsql". Any advice? I used the tutorial here : https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables Many thanks in advance. PS : Hi Baptiste, much welcomes to you! -- Arthur SUZUKI Service informatique des bibliothèques BIBLIOTHÈQUES UNIVERSITAIRES Université Jean Moulin Lyon 3 6 Cours Albert Thomas - B.P. 8242 – 69355 Lyon Cedex 08 ligne directe : +33 (0)4 78 78 79 16 | http://bu.univ-lyon3.fr L'Université Jean Moulin est membre fondateur de l'Université de Lyon

1 0

New intern arriving soon
by Paul Poulain 06 Jan '17

06 Jan '17

Hi all, Happy new year ! In less than 4 weeks (feb 1st), BibLibre will welcome a new intern, Baptiste Wojtkowski (French, as his name don't show ;-) ) that will work full time on Koha for the next 6 month. We plan to dedicate him on bugzilla, then the Mana project and some Elastic Search stuff. I'm sure you'll welcome him. -- Paul Poulain, Associé-gérant / co-owner BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open Source software and services for libraries

1 0

Dashboard headings...
by Mark Tompsett 03 Jan '17

03 Jan '17

Greetings, http://dashboard.koha-community.org/ The month and year are wrong, but totals correct. [Smile] Who is able to correct those? GPML, Mark “#6 is out of the gate early” Tompsett

2 1

Benchmarks for 16.11
by Jonathan Druart 02 Jan '17

02 Jan '17

Hi devs, I have done some benchmarks for versions of Koha from 3.14 to the latest 16.11 You can find the results on the wiki: https://wiki.koha-community.org/wiki/Benchmark_for_16.11 To be able to go back in time, I had to modify the koha-misc4dev scripts. I am now able to get a Koha installations fully testable (items, reindexation, psgi file, etc.) with any of these versions in a few minutes, which is pretty awesome and will be very useful for debugging (and git bisecting). Note that not everything is clean at the moment and will still need some works (path in psgi file for instance). All of you should be able to replay the full benchmark script on your kohadevbox, so please do it. That way we will confirm (or not) these numbers. If you want to compare 3.8, feel free to adapt the different scripts (I can help for that) and post the results. Cheers, Jonathan

3 2

Koha Community Newsletter: December 2016
by kohanews 30 Dec '16

30 Dec '16

Fellow Koha users: The Koha Community Newsletter for December 2016 is here: https://koha-community.org/koha-community-newsletter-december-2016/ 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. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Re: [Koha-devel] Koha Maps
by Marshall Breeding 28 Dec '16

28 Dec '16

Here is the version of Prosentient Systems Koha clients via Library Technology Guides: https://librarytechnology.org/libraries/map.pl?ILS=Koha%20--%20Prosentient%… List version: https://librarytechnology.org/libraries/search.pl?ILS=Koha%20--%20Prosentie… -marshall Marshall Breeding marshall.breeding(a)librarytechnology.org www.librarytechnology.org/ twitter.com/mbreeding http://www.linkedin.com/in/breeding http://scholar.google.com/citations?user=NnvfJ5cAAAAJ -----Original Message----- From: Edmund Balnaves [mailto:ebalnaves@prosentient.com.au] Sent: Wednesday, December 21, 2016 5:46 PM To: 'Chris Cormack'; Marshall Breeding Cc: 'koha'; 'Koha-devel' Subject: RE: [Koha-devel] Koha Maps Hi Marshall, Chris We already have a map of our libraries - http://www.prosentient.com.au/index.php/koha An API where we could push these details in bulk through to you would be great - we could send through the details of the library geocode details. Regards Edmund Edmund Balnaves, PhD Hosted Services Prosentient Systems P/L ABN 31 078 409 168 72/330 Wattle St, Ultimo NSW 2007 tel: 02 92120899 fax: 02 92120885 mobile: 0414737560 ejb(a)prosentient.com.au -----Original Message----- From: koha-devel-bounces(a)lists.koha-community.org [mailto:koha-devel-bounces@lists.koha-community.org] On Behalf Of Chris Cormack Sent: Wednesday, 21 December 2016 7:39 AM To: Marshall Breeding <marshall.breeding(a)librarytechnology.org> Cc: koha <koha(a)lists.katipo.co.nz>; Koha-devel <koha-devel(a)lists.koha-community.org> Subject: Re: [Koha-devel] Koha Maps * Marshall Breeding (marshall.breeding(a)librarytechnology.org) wrote: > I have been following the discussion about how the Koha community can > better market itself, including using a map display to emphasize its > global impact. > > > > Naturally, I would be happy to have the map generated from Library > Technology Guides to be used. Doing so would help me ensure that my > registry of libraries using Koha is more complete since libraries might > be more motivated to be included. Regardless of whether the Koha > community decides to rely more on my mapping tool, I will continue to try > to obtain data on the many libraries using Koha that are not yet > registered on my site or any other database. I continue to think that > Koha is most likely the most implemented ILS, but I do not yet have the > data to validate that assertion. > > > > The purity of working only with open source software and open access data > seems to me like an impossible goal. Richard Stallman, who I heard speak > last year, takes this concept to its logical conclusion, and ends up with > quite a limited realm of software or data which meet his tests for purity. > Is the Koha community comfortable using the Google Map API, for example, > since it is based on a closed and proprietary information infrastructure > and underlying software components that may or may not be open source? Or > does it plan to invent its own global mapping ecosystem? > That's what Open Street Maps is. Are you sure you want to get into a discussion about the ethics of open vs closed/proprietary on this mailing list? > > > I have looked at the Hea tool and I have a hard time imagining it gaining > the functionality of a global mapping visual and becoming well populated > by the mechanisms provided. Since it is generated mechanically through > each instance of Koha, it will be difficult to translate this data to > represent the libraries that are actually using Koha in production. Many > of the entries shown now (http://hea.koha-community.org/libraries) seem to > be duplicates or test implementations. Its single entry for the NExpress > Shared Catalog is represented by 53 libraries on my maps. I don’t see hea > as having the structure has the ability to represent the branches > associated with a library system or consortia and many other aspects of > tracking the libraries which use any given automation system. I think > that many, if not the majority, of Koha implementations globally are based > on older or forked versions of Koha, making it difficult or impossible for > them to automatically contribute their data to Hea. > > > > I also wonder why the Koha development community would divert resources > into re-creating such a tool from other efforts to develop and promote > Koha. Having maintained a registry of libraries for almost two decades, > my experience tells me that it is much more difficult to create and > maintain a well-organized list than others might imagine. > > > > I have also just re-written the map tool on Library Technology Guides to > generate the display more quickly when there are a very large number of > libraries. Although it depends on how quickly the Google API responds, it > now builds the maps in a few seconds, compared to almost a minute > previously. I have also added some basic search selection tools at the > bottom of the page: > > https://librarytechnology.org/libraries/map.pl?ILS=Koha > > > > I’ll be interested to hear further discussion on the topic. > The main thing I would be interested in hearing is that you have licensed the data in the tool under an open license. And then we could use it without issue. Chris > > > Marshall Breeding > > marshall.breeding(a)librarytechnology.org > > www.librarytechnology.org/ > > twitter.com/mbreeding > > http://www.linkedin.com/in/breeding > > http://scholar.google.com/citations?user=NnvfJ5cAAAAJ > > >_______________________________________________ >Koha-devel mailing list >Koha-devel(a)lists.koha-community.org >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >website : http://www.koha-community.org/ git : >http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

1 0

Important patches waiting for love
by Jonathan Druart 22 Dec '16

22 Dec '16

Hi devs, We need to focus on some important bugs, here is the list: Needs signoff: Bug 17766 - Patron notification does not work with multi item holds Bug 16951 - Item search sorting not working properly for most columns Bug 17743 - Item search: indexes build on MARC do not work in item's search Bug 16914 - Export csv in item search, exports all items in one line Bug 17766 - Patron notification does not work with multi item holds Needs QA: Bug 17692 - Can't add library EAN under Plack Needs a patch: Bug 17775 - Add new user with LDAP not works under Plack Bug 17754 - MARCXML upload in Intranet is broken (encoding) Some are major, critical or blocker! I am going to QA 17692 and trying to fix 17754, I need help for others. I'd also like to see bug 17796 (Koha::Issues should be moved to Koha::Checkouts) pushed quickly to avoid conflicts and rebases. Cheers, Jonathan

3 3

Re: [Koha-devel] Enabling Arabic and Kurdish Indexing
by Paul A 21 Dec '16

21 Dec '16

At 05:39 PM 12/20/2016 +0000, MHE I.T. Admin (DRR) wrote: >Hi,Â > >Our Koha is hosted on a dedicated server, Debian 8.6 and the installation >folder isÂ /etc/koha/zebradb/etc , I think as long as they are in the same >folder it should not be an issue. It says that (it can not load it) not >(it can not find it), Intriguing. If you're *not* publicly accessible, I might try resetting permissions; directory (probably needs 755) and files... work up from 644 ... or "bull in the chinashop" approach, set both to 777 and work back down to where it fails. If it fails for dir and file at 777, then path is wrong "somewhere?" Best -- P. >I did try with bot default and specific language in the file but still got >the same error. I thought if I get it work first then I can add more >language and see Â > > > >On 20 December 2016 at 17:15, Paul A ><<mailto:paul.a@navalmarinearchive.com>paul.a(a)navalmarinearchive.com> wrote: >At 04:11 PM 12/20/2016 +0000, MHE I.T. Admin (DRR) wrote: >>Than you for the prompt response, Yes they are in the same folder as >>(/etc/koha/zebradb/etc) and it is on 0644 > >Is there a typo? (it was suggested that this is crucial) > >Recommended: koha/zebradb/etc ... >Found: /etc/koha/zebradb/etc ... (our system confirmed, and happy with 644) >/---/ ><<http://www.indexdata.com/yaz/doc/yaz-icu.html>http://www.indexdata.com/yaz/doc/yaz-icu.html> >neither confirms nor denies that multiple lang options are possible, >rather than the default <icu_chain locale=""> -- if you can get your >server to find the file, have you tried both with and without the default? >Maybe putting the default below specifics? > >Best -- Paul > > >>Can you list several languages inÃ words-icu.xml likeÃ >> >> >> >>Â <icu_chain locale="ar"> >> >>. >> >> >> >>. >> >> >> >>. >> >> >> >>. >> >>Â </icu_chain> >> >> >> >> >> >> >> >>Â <icu_chain locale="ku"> >> >>. >> >> >> >>. >> >> >> >>. >> >> >> >>. >> >>Â </icu_chain> >> >> >> >>On 20 December 2016 at 15:57, Barton Chittenden >><<mailto:barton@bywatersolutions.com>barton(a)bywatersolutions.com> wrote: >>On Tue, Dec 20, 2016 at 10:15 AM, MHE I.T. Admin (DRR) >><<mailto:admin@mhe-krg.org>admin(a)mhe-krg.org> wrote: >>15:58:14-20/12 zebraidx(9140) [warn] default.idx:13: Could not load >>icuchain config 'words-icu.xml' >> >> >>I see two unrelated issues in your logs. The most crucial was >> >>Could not load icuchain config 'words-icu.xml' >> >> >>This is what's causing the indexes to fail. >> >>words-icu.xml should be in the same directory asÃ >>koha/zebradb/etc/default.idx. Make sure that it's there, and that it's >>readable. >> >>See >> >><https://wiki.koha-community.org/wiki/ICU_chains_configuration>https://wiki.koha-community.org/wiki/ICU_chains_configuration >> >>The second issue is that you don't have item types for some of your >>items. That won't cause issues with searching, but it will cause errors >>when you try to check the items in or out. The item numbers are given in >>the error messages, and you can use sql to find the barcodes. >> >>--Barton >> >> >> >> >>-- I.T Admin (Dr. D.R. Roshani) >><http://www.mhe-krg.org>Ministry of Higher Education >>T. +964.XXX.XXX XXX | E. <mailto:admin@mhe-krg.org>admin(a)mhe-krg.org >>_______________________________________________ >>Koha-devel mailing list >><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>website : <http://www.koha-community.org/>http://www.koha-community.org/ >>git : <http://git.koha-community.org/>http://git.koha-community.org/ >>bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ > >--- >Maritime heritage and history, preservation and conservation, >research and education through the written word and the arts. ><<http://navalmarinearchive.com/>http://NavalMarineArchive.com> and ><<http://ultramarine.ca/>http://UltraMarine.ca> > >_______________________________________________ >Koha-devel mailing list ><mailto:Koha-devel@lists.koha-community.org>Koha-devel(a)lists.koha-community.org >http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >website : <http://www.koha-community.org/>http://www.koha-community.org/ >git : <http://git.koha-community.org/>http://git.koha-community.org/ >bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/ > > > > >-- > >I.T Admin (Dr. D.R. Roshani) ><http://www.mhe-krg.org>Ministry of Higher Education >T. +964.XXX.XXX XXX | E. <mailto:admin@mhe-krg.org>admin(a)mhe-krg.org --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 3

Fwd: RE: [Koha] Koha Community Newsletter:November 2016
by kohanews 21 Dec '16

21 Dec '16

-------- Forwarded Message -------- Subject: RE: [Koha] Koha Community Newsletter:November 2016 Date: Thu, 1 Dec 2016 12:50:43 +0000 From: Rosalie Ndejuru <lapleni(a)hotmail.com> To: kohanews <kohanews(a)gmail.com> Hello Koha developers, How is it possible to release 2 different versions of Koha in the same time? * Koha 16.11 Released <https://koha-community.org/koha-community-newsletter-november-2016/#165> * Koha 3.22.13 Released <https://koha-community.org/koha-community-newsletter-november-2016/#322> Thanks a lot R. Ndejuru ------------------------------------------------------------------------ *De :* Koha <koha-bounces(a)lists.katipo.co.nz> de la part de kohanews <kohanews(a)gmail.com> *Envoyé :* 30 novembre 2016 17:48 *À :* koha-devel(a)lists.koha-community.org; koha(a)lists.katipo.co.nz *Objet :* [Koha] Koha Community Newsletter:November 2016 Fellow Koha users: The Koha Community Newsletter for November 2016 is here: https://koha-community.org/koha-community-newsletter-november-2016/ 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. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter _______________________________________________ Koha mailing list http://koha-community.org <http://koha-community.org> Official Website of Koha Library Software <http://koha-community.org/> koha-community.org Koha Library Software The world's first free and open source library system Koha is a fully featured, scalable library management system. Development is sponsored by ... Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Call for news: December 2016 Newsletter
by kohanews 20 Dec '16

20 Dec '16

Fellow Koha users ~ I'm collecting news for the December newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events -- **** one month back is the cut-off ***. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. -- Chad Roseburg Editor, Koha Community Newsletter

1 0