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

Upcoming IRC meeting and Roles for 3.14
by Chris Cormack 11 Mar '13

11 Mar '13

Hi all Our next meeting is at 13 March 2013 at 18:00 UTC http://wiki.koha-community.org/wiki/General_IRC_meeting,_13_March_2013 One of the important things we will be discussing is roles for 3.14 http://wiki.koha-community.org/wiki/Roles_for_3.14 We have candidates for almost all positions, but a big one we are missing is the Release Manager. If you think you could do this job justice, please add yourself to the list. Chris

1 0

Indexing KOHA - SOLR or ELASTICSEARCH
by Rafael Antonio 11 Mar '13

11 Mar '13

Dear members, All of us know some difficulties with ZEBRA mainly for UNIMARC flavour. Some friends are pushing SOLR as an alternative but now we are seeing ELASTICSEARCH. What you think about it ? I have another question about replacing ZEBRA. How do we maintain Z39.50 server ? best regards, Rafael Antonio

3 3

Translator tool, changing ?
by Paul Poulain 10 Mar '13

10 Mar '13

Hello koha-devel & koha-translate, Users translating Koha to french are regularly reporting that pootle is a poor tool, not very efficient. Someone suggested transifex, that is free for OpenSource softwares (https://www.transifex.com) I just opened an account, created a koha project, added french translation for 3.12 It seems *much* more friendly & efficient than pootle. Is there someone wanting to investigate a little bit more this tool ? (if yes, create an account & drop me a mail with your transifex nick) Could switching to this tool be a good idea ? -- Paul POULAIN - BibLibre http://www.biblibre.com Free & Open Source Softwares for libraries Koha, Drupal, Piwik, Jasper

5 7

Old bugs to check
by MJ Ray 08 Mar '13

08 Mar '13

Would you check some of these rather old bugs to suggest what to do, please? Maybe some can be RESOLVED FIXED by now or need a question. Please leave your reply on the bug web page - I might not see replies to this mail. Ideally, tell irc.oftc.net #koha know that you're looking at a bug. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3310 Unusable Display of report results with large number of columns and rows http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5766 Add system preference for excluding articles from jQuery table sorter http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3937 'sounds like' searching for tags http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5198 HOLDPLACED being logged in patron messages http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3200 missing quotes in rebuild_unimarc_100.pl http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2699 Organization for Reports http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5393 test case for verifying XML/XSLT files are well-formed http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5999 Biblibre : Performance enhancements for 3.4 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3511 Integration with Moodle http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5129 Show submitted advanced form fields upon patron search http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5442 Transfer enhancements http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5316 Limit 39.50 targets to specific users http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5270 007 variable control builder/Specific Material Designation http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3367 Overdue Rules not processed for patrons with checkouts more than 90 days overdue. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4125 Bulkmarcimport.pl script has changed a lot without beeing documented http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5732 Adding permissions on viewlog http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5144 Duplicate holds allowed if patron clicks back button after placing hold http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5103 Dates in MARC details not formatted correctly http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4879 lint-like tool for Koha database contents -- Email robot driven by MJ Ray (slef), member of www.software.coop, http://koha-community.org supporter, web and library systems developer. Available for hire (including development) at http://www.software.coop/

1 0

[QA] koha-qa is regularly updated
by Jonathan Druart 08 Mar '13

08 Mar '13

Hi QA team, Note that the koha-qa script is regularly updated. For example, a single quote strings test is now present and a big bug on the line number (on the line number of forbidden patterns) has been fixed. The code is available on the github of Koha-Community ( https://github.com/Koha-Community/koha-qa-test) I would also like to take this opportunity to tell you that if you have some ideas of improvements (some others tests), I could implement it! Freely, Jonathan

2 1

Re: [Koha-devel] db from 3.8.5 to 3.8.10
by Paul 07 Mar '13

07 Mar '13

At 04:46 PM 3/7/2013 -0300, Tomas Cohen Arazi wrote: >Paul, we've been through 3.8.0 to 3.8.10 without any issues. Doing a full >rebuild should make your registers appear. rebuild_zebra.pl is just not a >fullrebuild, but an incremental one. Thanks for the reply. Yes, as I said (below), a full c/l re-index -a -r -v and -b -r -v -x solves the problem: $ su koha $ cd usr/share/koha $ ./bin/migration_tools/rebuild_zebra.pl -a -r -v $ ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x but I'm trying to avoid an hourly (or more frequent) cronjob on our production server (3.8.5.) I've got it set up at 30 min intervals on the sandbox (3.8.10) and it's not too painful in low usage, but am truly looking for a programmatic solution for "real life." Although -r is given as "reset", I thought it was equivalent to "rebuild" as compared to -z "process_zebraqueue" which is truly incremental. Certainly given the CPU time and the "verbose" output, it looks as though -r is not just incremental but a complete rewrite. But I'll also freely admit that <http://www.indexdata.com/zebra/doc/> is a challenging "read" in Koha context. Best - Paul >Regards >To+ > > > >On Thu, Mar 7, 2013 at 3:53 PM, Paul <paul.a(a)aandc.org> wrote: >At 12:04 PM 3/7/2013 -0500, Jared Camins-Esakov wrote: >Paul, > >[snip] >The standard CRON job runs successfully. > >[snip] >A full c/l re-index -a -r -v and -b -r -v -x solves the problem. As I can >reproduce this behaviour (by restoring the same dump) is there anything >helpful that I could look into? Ã Could this be related to Bug 9511? The >fix does not appear to work for me, I've just updated bugzilla. > > >This doesn't sound like a bug. When restoring a dump you *must* completely >reindex from the command line. Always. There are no exceptions. > > >Sorry, I wasn't clear. After restoring the dump and running 'installer', >the -z -x CRON functions with 99% [???] accuracy. What I'm looking at is >any possible "similarity" of Zebra behaviour to try and get the CRON >working in 3.8.10 which is reported on bugzilla 9511 to be functional for >two libraries that have updated from 3.8.5, but does not (for me) resolve >the problem of deleted biblios, nor of overwriting an existing biblio with >a Z39.50 import. > >I've been chasing around after a solution for a couple of days (part time) >with no success whatsoever. Maybe I'm grasping at straws? > >Our volunteers are adding 150-200 biblios per day, 7/7, many of which are >Z39.50 "overwriting" of embryonic data from previously importing >spreadsheets into 3.4.6, and regrouping items (particularly serials) under >a single biblio. Â I find that I'm asked about once an hour on average to >"completely re-index" and am somewhat desperate to find a programmatic >solution. > >I appreciate any/all suggestions. > >Best - Paul

1 0

Re: [Koha-devel] db from 3.8.5 to 3.8.10
by Paul 07 Mar '13

07 Mar '13

At 12:04 PM 3/7/2013 -0500, Jared Camins-Esakov wrote: >Paul, [snip] >>The standard CRON job runs successfully. [snip] >>A full c/l re-index -a -r -v and -b -r -v -x solves the problem. As I can >>reproduce this behaviour (by restoring the same dump) is there anything >>helpful that I could look into? Â Could this be related to Bug 9511? The >>fix does not appear to work for me, I've just updated bugzilla. > >This doesn't sound like a bug. When restoring a dump you *must* completely >reindex from the command line. Always. There are no exceptions. Sorry, I wasn't clear. After restoring the dump and running 'installer', the -z -x CRON functions with 99% [???] accuracy. What I'm looking at is any possible "similarity" of Zebra behaviour to try and get the CRON working in 3.8.10 which is reported on bugzilla 9511 to be functional for two libraries that have updated from 3.8.5, but does not (for me) resolve the problem of deleted biblios, nor of overwriting an existing biblio with a Z39.50 import. I've been chasing around after a solution for a couple of days (part time) with no success whatsoever. Maybe I'm grasping at straws? Our volunteers are adding 150-200 biblios per day, 7/7, many of which are Z39.50 "overwriting" of embryonic data from previously importing spreadsheets into 3.4.6, and regrouping items (particularly serials) under a single biblio. I find that I'm asked about once an hour on average to "completely re-index" and am somewhat desperate to find a programmatic solution. I appreciate any/all suggestions. Best - Paul

2 1

db from 3.8.5 to 3.8.10
by Paul 07 Mar '13

07 Mar '13

I found a [minor?] problem with the 3.8.10 tarball on Ubuntu 12.04.2 LTS on my sandbox after restoring a 3.8.5 mysql dump from our production box, at which point 'installer' does its magic. All the biblios appear to transfer correctly ('mysql> select biblionumber from biblio;' gave identical results; same with author, etc.) The standard CRON job runs successfully. Problem: a small number of biblios "went missing" in 3.8.10. It *seemed* to be limited to 'serials' but I can't be sure, as I could only find them on a 'hit or miss basis' -- in fact I only found the first one accidentally: e.g. a biblio and three items for the serial Flugsport could not be found by title, by author, by Barcode, by author in authorities ... even "No results match your search for 'biblionumber=19762' in NMA Catalog." Yet, run a Koha report: SELECT * FROM biblioitems, biblio, items WHERE biblio.biblionumber=19762 AND biblioitems.biblionumber=19762 AND items.biblionumber=19762 and everything was there, including the blobs, MARC, XML ... A full c/l re-index -a -r -v and -b -r -v -x solves the problem. As I can reproduce this behaviour (by restoring the same dump) is there anything helpful that I could look into? Could this be related to Bug 9511? The fix does not appear to work for me, I've just updated bugzilla. Thanks - Paul

2 1

reserveconstraints
by Marcel de Rooy 06 Mar '13

06 Mar '13

Hi, I stumbled over some code involving reserveconstraints. I just assume that it is an old table from before 3.0. Am I correct? Can we remove associated code? Is there a scenario that someone comes from 2.X with records in that table that should still be considered somehow? Note that it looks like records in there will never be deleted anymore, so if that is true, we should just get rid of them? BTW Funny to see that update22to30 even creates the table with only field reservedate, if it was not there.. Thx for your response if you know some more details. Marcel

1 0

Will you do a presentation at California Library Association Annual Conference?
by Lori Bowen Ayre 05 Mar '13

05 Mar '13

Hi All, Anyone interested in doing a program at the California Library Association's annual conference? It will be in Long Beach, CA November 3-5 and I've done some kind of session on Open Source every year for the last few years but it would be great to get some new perspectives. Submit a proposal! We need Evergreen represented! http://conference.cla-net.org/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant / The Galecia Group (707) 763-6869 // Lori.Ayre(a)galecia.com Availability: http://doodle.com/loriayre <Lori.Ayre(a)galecia.com>Specializing in open source software solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

2 1