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

Re: [Koha-devel] SQL reports [error]
by Paul 30 Apr '12

30 Apr '12

At 11:21 AM 4/30/2012 -0400, Jared Camins-Esakov wrote: >Paul, >On Mon, Apr 30, 2012 at 11:17 AM, Paul Poulain <paul.poulain(a)biblibre.com> >wrote: >Question to all = could it be a good idea to let superlibrarians execute >dangerous SQLs like the one forbidden by the test ? >Otherwise asked: could we add a >unless permission eq 'superlibrarian' >condition ? > >( ie: "with great power comes great responsibility" -@spiderman uncle- ) > >We were actually just discussing that on #koha a few days ago. I argued >that only the database user (i.e. user 0) should be allowed to do it. If >you have the direct login, there's nothing you can't do with the system >just by logging into the database. Pls forgive my lack of understanding, but who is "user 0"? Is this just my credentials on the server? Because in our "patrons" list, there is no 'kohauser' and 'paul' (me, 'kohauser' for the server CLI) only appears as #1 and uses a different password. At a more general level, I would agree with Paul P.'s suggestion -- if the "top" administrator of the system is comfortable with the security (backups and script testing), why can't [s]he delegate admin tasks? Best - Paul (the other Paul|l'autre Paul)

1 0

Re: [Koha-devel] SQL reports [error]
by Paul 30 Apr '12

30 Apr '12

At 09:28 AM 4/30/2012 -0400, Chris Nighswonger wrote: >On Mon, Apr 30, 2012 at 9:27 AM, Chris Nighswonger ><<mailto:cnighswonger@foundations.edu>cnighswonger(a)foundations.edu> wrote: >On Mon, Apr 30, 2012 at 9:13 AM, Paul ><<mailto:paul.a@aandc.org>paul.a(a)aandc.org> wrote: > >Can anyone point me rapidly to the portion of script that I should have a >look at? > >Fair warning: Mung up at your own risk.... > ><http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=reports/guided_re…>http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=reports/guided_re… > >and > ><http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=reports/guided_re…>http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=reports/guided_re… > Chris, Many thanks, I'll see what I can do (after hours tonight.) Just wondering if a perl expert could suggest the code to add a "condition" to if ($sql =~ /;?\W?(UPDATE|DELETE|DROP|INSERT|SHOW|CREATE)\W/i) { push @errors, {sqlerr => $1}; } along the lines of " unless username='paul' " I'm not too worried about the security risks for two reasons a) the script works as intended, and b) very few of our people actually have their permissions set to "Allow to access to the reports module." Best regards - Paul

8 9

Right To Left in Arabic KOHA
by Karam Qubsi 28 Apr '12

28 Apr '12

---------- Forwarded message ---------- From: Karam Qubsi <karamqubsi(a)gmail.com> Date: Sat, Apr 28, 2012 at 9:57 PM Subject: Right To Left in Arabic KOHA To: Koha <Koha(a)lists.katipo.co.nz>, koha-translate(a)lists.koha-community.org Hi all . I'm looking to develop the result of koha translation process in Arabic as you know the Arabic language is deffer from English in Arabic we read and write from right to left this is possible to be modified by hand but if we want to create an Arabic version of koha we need to make the text by default goes from right to left . so what we have to do to make this koha Arabic Version ? and make it as a choice in the installations steps when selecting Arabic. I think my group can edit the css files and make this ok (direction rtl ) but how to make this changes Permanent for every new Arabic Koha installation can we make some default template for Arabic language , or that can be selected from the po files in some way ? or it must be included in the koha package , or what ? Both Arabic and Hebrew, and the non-Semitic languages using the Arabic or the Hebrew alphabet, such as Persian and Yiddish, are written from right to left (except for their numbers!). Urdu which is also derived from Arabic and Persian language and ancient indo - aryan language binti is written from right to left. Ancient Egyptian, Etruscan, Greek and the oldest Latin could be written in both directions. Also Chinese and Japanese can be written right to left (also written from top to bottom, vertically). Korean is NOT written from right to left I wish we discuss this to make the next koha version fully supported for Arabic language Kind regards -- Karam Qubsi Koha Arab translation Team http:koha.wikibrary.org Wikibrary for Arab librarians http://wikibrary.org

1 0

A k-c hosted koha-es mailing list
by Tomas Cohen Arazi 27 Apr '12

27 Apr '12

I'd like to ask for the creation of a mailing list for the spanish speaking koha users community. I think there was a koha-fr list, so koha-es(a)koha-community.org should make it. As for the maintainers / moderators of the list, I'd like to be one of them (tomascohen(a)gmail.com) and bgkriegel(a)gmail.com and pablo.bianchi(a)gmail.com should be also included. Regards To+

2 2

Official Koha Newsletter: Volume 3, Issue 4: April 2012
by Daniel Grobani 26 Apr '12

26 Apr '12

Official Koha Newsletter: Volume 3, Issue 4: April 2012 [Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-3-issue-4-april-2012] Official Koha Newsletter (ISSN 2153-8328) Volume 3, Issue 4: April 2012 Edited by Daniel Grobani, Koha Community Newsletter Editor. Please submit news items to danielg.koha(a)gmail.com. Table of Contents Koha Development Koha 3.8.0 Released Koha 3.10 Roles Koha Statistics Browse Headings Using Solr SemantiKoha Koha Community New Koha Libraries Community Gossip Pacific Islands Koha Users Call Past Koha Events April General IRC Meeting Upcoming Koha Events May General IRC Meeting Symposium Koha 2012 Koha and Dspace Training in India KohaCon12 Koha Development Koha 3.8.0 Released by Chris Cormack The Koha release team is happy to announce the release of Koha 3.8.0, the third major release since we shifted to time based releases. The release team would like to thank everyone involved in this release for making it possible. Koha 3.8.0 contains over 130 enhancements with over 1000 changesets from 71 developers. Please read the release notes for more information. Koha 3.8.0 can be downloaded here. Installation instructions can be found here or in the INSTALL files that come in the tarball. Koha 3.10 Roles by Chris Cormack Positions for the Koha 3.10.0 release cycle (due October 2012) were confirmed at the April general IRC meeting. It is our biggest release team yet and a really good sign of the health of the community that we had so many volunteers. The roles are: Release Manager : Paul Poulain, France Translation Manager: Shared between Samuel Desseaux and Frédéric Demians both from France Translation Assistants: Katrin Fischer, Germany; Marijana Glavica, Croatia Documentation Manager: Nicole Engard, USA DB Documentation Manager: Nicole Engard, USA Quality Assurance (QA) Manager: Ian Walls, USA Quality Assurance (QA) Assistants: Marcel de Rooy, Netherlands; Jonathan Druart, France; Mason James, New Zealand Release Maintainer 3.8.x: Chris Cormack, New Zealand Release Maintainer 3.6.x: Jared Camins-Esakov, USA Packaging Manager: Robin Sheat, New Zealand Packaging Assistant: Mason James, New Zealand Bug Wrangler: Magnus Enger, Norway; Katrin Fischer, Germany; Dobrica Pavlinušić, Croatia; Koustubha Kale, India Meeting Chair: BWS Johnson, USA So that’s 17 people in total who have volunteered and been accepted to positions for the next 6 months (starting after the release of 3.8.0 on April 23). I think it is also great we have a nice geographic spread, especially the bug wrangler team. Koha Statistics Chris Cormack, statistician par excellence, has posted bug statistics for March and statistics for Koha 3.8.0. Adding Browse Headings to Koha Using Solr by Stefano Bargioni The Library of the Pontificia Università della Santa Croce in Rome added browse headings to Koha. This is perhaps the first example of integration of Koha and Solr in a production environment. Users can scan lists of authors (established or unestablished forms), titles, title series, author/title, uniform titles, subjects, etc. An engine written in Perl runs on a regular basis to synchronize Solr entries with Koha data. The process is driven by an xml config file where chosen tags and subfields of authority or bibliographic records are described in order to feed one or more lists for browsing. More than 500,000 entries were generated, starting from about 111,000 authority records and 147,000 biblio records. Browse search was added at the top of “Browse by Subject” page; see http://catalogo.pusc.it/cgi-bin/koha/opac-authorities-home.pl. This topic will be presented exhaustively at KohaCon12 in Edinburgh. SemantiKoha by Magnus Enger Recently, there has been a fair amount of discussion about RDF/Semantic Web technologies being central to the efforts to replace the MARC family of “standards”, including from the US Library of Congress [1]. However, there has not been much testing of these technologies in the context of actual ILSes. I aim to do something about that with my “SemantiKoha” project. The goal is to explore how openly available semantic/linked data can be used in the Koha OPAC to enhance the user experience and aid in discovery. The practical work is at a very early proof-of-concept stage, but there is a live demo available [2] and the source code is also available [3]. If anyone wants to join the fun and contribute please don’t hesitate to contact me! [1] http://www.loc.gov/marc/transition/news/framework-051311.html and http://www.loc.gov/marc/transition/news/framework-103111.html. [2] http://semantikoha.libriotech.no/. See, for example, the page for Charles Darwin: http://semantikoha.libriotech.no/cgi-bin/koha/opac-view.pl?uri=http://data.…. [3] https://github.com/MagnusEnger/semantikoha. See especially the README, which explains how the demo is set up: https://github.com/MagnusEnger/semantikoha/blob/master/README.txt. Koha Community New Koha Libraries Middletown Township Public Library (via ByWater Solutions) Wilderness Coast Public Libraries (via ByWater Solutions) Community Gossip Owen Leonard has revisited the process of customizing OPAC cart and lists buttons, this time using CSS3 features. Adalid Ortiz reports that Biblioteca Loyola of the Universidad Iberoamericana Tijuana in Mexico has published an online manual in Spanish for their Koha OPAC. They previously published an online manual in Spanish on cataloging with Koha. Matt Adams has posted an update on LibLime’s application for the New Zealand Koha trademark. Pacific Islands Koha Users Call by Pam Bidwell, University of the South Pacific I would like to hear from users of Koha in the Pacific Islands. Many small Pacific countries struggle with extra issues when automating their libraries, such as unexpected power outages (and damaging power surges), intermittent and slow Internet access, old technology and limited IT expertise. For many Pacific libraries, Koha is their first automated system, and staff training is a real issue. Quite a few Pacific Koha projects have stalled as a result of these problems. We need to develop a supportive local community that shares knowledge and offers support. I hope to set up a smaller discussion forum for the Pacific Koha community (while still being involved in the wider Koha community discussions). The forum will talk about day to day use of Koha, answer basic questions about using the system and share resources such as training materials. I would also like to discuss regional training possibilities. Please email me at pamela.bidwell(at)usp.ac.fj if you would like to be involved. Past Koha Events April General IRC Meeting The April general IRC meeting was held on 4 April 2012. More info, including the agenda and links to the minutes, is here. Upcoming Koha Events May General IRC Meeting The May general IRC meeting will be held on Wednesday, 2 May 2012. More info is here. Symposium Koha 2012 Symposium Koha 2012 will be held at BULAC in Paris 14-15 May 2012. The symposium will be a forum for exchange and meetings between Koha users, future users, and providers. More info is here. Koha and Dspace Training in India Two-day Koha training and certification workshops are being offered in Mumbai, Bangalore, and Delhi. More info is here. Three-day Koha and Dspace training and certification workshops are being offered in Mumbai and Bangalore. More info is here. KohaCon12 KohaCon12 will be held in Edinburgh, Scotland, UK, 5-7 June 2012. A hackfest will be held 9-11 June. This is a free conference for everyone interested in the Koha library system. There is no registration fee, but attendees are asked to pre-register. The organizers are seeking sponsors to help defray the cost of the conference. Sponsors so far include Tamil, PTFS Europe, Catalyst, Libriotech, Projektlink Konsult, and The Galecia Group. Information on sponsorship is here. More details on the conference can be found here.

1 0

How to view Zebra indexes..?
by Сергій Дубик 25 Apr '12

25 Apr '12

Hi all! Koha Wiki has an page Understanding Zebra indexing (http://wiki.koha-community.org/wiki/Understanding_Zebra_indexing) about adding fileds/subfields to seach indexes. In particular are indices for the some case: Name-and-title = {"Goddard College"} Name = {"Faculty publications"} Subject = {"Faculty publications"} Subject:p = {"Faculty publications"} Corporate-name = {"Faculty publications"} General question: how to see the generated indexes for a specific record? ... For my case, I try to build the correct indexes for call numbers, UDC, Dewey, BBK codes etc. For ex. we have callnum = 222.12/4 I need a searches like next: 22* - 223.14/1, 224.1/2 ... 222* - all indexes start from 222 - 222.11/1, 222.12/2 ... 222.12* - in result I need only 222.12/1, 222.12/2, 222.12/3 ... During formation of index - point, space, parentheses or other mark should not break the index into pieces.

6 9

Koha 3.8 released... Koha 3.10 (or 4.0) started
by Paul Poulain 24 Apr '12

24 Apr '12

Hello Koha developers, Koha 3.8 has been released. It means we can start working on the next version that will be released in October. For this version, my goal, as RM, is to focus on: * cleaning the code. We have decided a while ago to move from C4 to Koha, separate business logic from data access (see http://wiki.koha-community.org/wiki/Namespace_QA_Rules) but only a few things have been made since then. I hope to be able to submit a proposal for going that way in the next weeks. That will be a long-term thing, but it's needed for a better stability, maintainability, readability. * Persistence layer (Plack) for Koha is stable for the OPAC, and experimental for the staff interface. I hope we will quickly have feedbacks that it works too. My goal is to be able to provide Plack configuration activated by default when you install Koha. * adding new features, of course. On this matter, there are 108 bugs that are waiting for your signoff, something like 75 being ENHancements ;-) PS: I leave for a week of holiday, I hope I'll have a lot of things to push when I come back, next Monday ;-) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Releasing Koha 3.8.0, last minute problem
by Paul Poulain 23 Apr '12

23 Apr '12

Hello koha-devel, i'm ready to release Koha 3.8.0, except i've a blocking problems in the release process (and 2 annoying ones): The annoying ones: * i've tagged v3.08.00 on my local git repo, how can I push it on git.koha-community.org ? * I think I can't create the branch 3.8.x (untested, but iirc, I can only create new/... branches) The main problem is for creating the tarball. What I do: * perl Makefile.PL * make * make manifest tardist => /usr/bin/perl "-MExtUtils::Manifest=mkmanifest" -e mkmanifest Unmatched [ in regex; marked by <-- HERE in m/(?:Makefile$)|(?:release_notes_2)|(?:release_notes_1)|(?:\bCVS/)|(?:~$)|(?:\.patch$)|(?:\.orig$)|(?:\.old$)|(?:\.bak$)|(?:[ <-- HERE )|(?:\.git/)|(?:MANIFEST.bak)/ at /usr/share/perl/5.12/ExtUtils/Manifest.pm line 433. make: *** [manifest] Erreur 255 I'm totally unable to fix this kind of problem, so, if someone can help, i'll stay around... -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

8 10

Babeltheque CSS in the OPAC
by Owen Leonard 23 Apr '12

23 Apr '12

There's a big commented-out section of opac.css, added by Bug 7470: Babeltheque integration (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7470) /* ## BABELTHEQUE ## */ /* Uncomment if babeltheque configuration no contains these lines */ /* ... If there is CSS which is only used when Babeltheque is enabled it can be put into its own CSS file. I can't see libraries editing opac.css themselves under normal circumstances. Can this be removed? Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 1

Re: [Koha-devel] A few things you could do before I release of Koha 3.8
by Paul 20 Apr '12

20 Apr '12

At 02:54 PM 4/19/2012 -0400, Owen Leonard wrote: > > ... very respectfully, it's bloatware. Firebug pagespeed finds a 23% > > increase in transfer size: > >There's no way to "respectfully" use the term "bloatware." If I've offended you, please accept my humble apologies. We use the term rather loosely to describe an increase in code size (in this case 23% - see my previous post) combined with a (perceived) decrease in user friendliness. If there's a better term, I'll be most happy to use it. > > The "old" fitted nicely onto one screen without scrolling; for the > "new" you > > have to scroll for all functions except search. > >What are the dimensions of your browser window? It should be possible >to make it more flexible. We us a standard setting of 1024 x 768 on all monitors in our organization (from end-user kiosks to my desk-top.) For a graphical comparison, please see: <http://navalmarinearchive.com/admin/koha_home_page_comparison.html>. > > Adding a new Marc record now requires 2 clicks instead of one. > >True, if you do all your cataloging using the default framework. Or any other framework, surely? It's only when you get to the koha-admin/cgi-bin/koha/cataloguing/addbiblio.pl page that the choice of frameworks is available. > > We'd have to experiment to see how our "news and links" can be functionally > > fitted to the left hand side of the screen. > >The display of news is essentially unchanged in this version. Not from what we can see - again please see the "comparison page" link above. > > Question: can the css, templates etc from 3.6 be retained? Or do the mods > > permeate further? > >The changes are primarily CSS-based with the exception of the removal >two links, "Add MARC record" and "System preferences." Fine - thanks. The css is no problem, but where is the removal of the two links? In a perl script or in a template? Best - Paul

4 5