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

Re: [Koha-devel] [Koha-translate] KOCT translatable, please translate !
by Paul Poulain 26 Jul '12

26 Jul '12

Hello all, > (in koct/chrome/locale directory if you clone the git repo) It seems I was not clear enough: KOCT is not in the Koha git repo, but in contrib, where are KOCT and sandboxes scripts: git clone git://git.koha-community.org/contrib/global.git -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

5 7

Ubuntu : MySQL GUI Tools
by Fridolyn SOMERS 26 Jul '12

26 Jul '12

Hie devs, I work on Ubuntu 12.04. I'm used to MySQL tools : Query Browser and Administrator. If found this tools are not available anymore in Ubuntu repositories, proposing MySQL Workbench instead. If you whant to find old tools, use the Tolaris repository : http://www.tolaris.com/apt-repository/ Thanks to Ubuntu community. -- Fridolyn SOMERS Biblibre - Pôle Support fridolyn.somers(a)biblibre.com <mailto:fridolyn.somers@biblibre.com>

1 0

Sandbox servers provided by BibLibre
by Paul Poulain 25 Jul '12

25 Jul '12

Hello, On the wiki page, you can see that the wiki page dealing with sandboxes provided by BibLibre now present 6 sandboxes (3 UNIMARC and 3 MARC21), instead of 9 The reason is: * there was only a few use of the sandboxes, 6 publicly open should be enough * we have found some volunteers in France to dedicate time to testing (for example, one of them promised to dedicate half a day every week). So we have decided to dedicate them a specific/named sandbox. previous testN.sandbox.biblibre.com have been reclycled If you see URL with french cheese in the name of some comment (http://camembert.sandbox.biblibre.com) you'll know it's a "recycled" sandbox (complete spoiler = the 1st letter of the cheese being also the 1st letter of the 1st name of the volunteer. In this case : Camembert = Corinne. You'll also have Pelardon for Pierre and Serac for Sonia. New ones should be coming with Mathilde, Leila, and hopefully some others) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Biblio.pm subject of a bug?
by Paul 25 Jul '12

25 Jul '12

Re: 3.6.6 Biblio.pm With preference set to "do not use zebra", saving an "item" fails: "Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 3104" (z39.50 and adding biblios works fine.) I see that there's a # FIXME ... ?? in the .pm but can't [easily] find a related bug: 3102 # get title of the record (to store the 10 first letters with the index) 3103 my ( $titletag, $titlesubfield ) = GetMarcFromKohaField( 'biblio.title', '' ); # FIXME: should be GetFrameworkCode($biblionumber) ?? 3104 $title = lc( $record->subfield( $titletag, $titlesubfield ) ); I tried using the FIXME, same error. I'm getting very close to restarting this sandbox project -- certainly with 3.6.7, but also maybe reverting to Ubuntu 11.10 (at least for me, I'll have a solid comparison with our production server.) Thoughts anyone? I genuinely set out to try and help the community (and it just might turn out that Ubuntu 12.04 is problematic - does anyone here use it?) as well as ensure a smooth upgrade to our production server. Thanks - Paul

5 4

Proposal for a new coding guideline for command line scripts
by Paul Poulain 25 Jul '12

25 Jul '12

Hello koha-devel, I just pushed a few minuts ago a new script in misc (bug 8376, but it doesn't matter for this mail) This script has a help that is displayed when you run it with -h. So far so good. BUT, it has no PODDOC. Not so good. I've discovered recently that we could use: > use Pod::Usage; > > sub usage { > pod2usage( -verbose => 2 ); > exit; > } > <snip> > usage() if $help; That will deal with both POD and -h flag. It's used in some scripts like misc/maintenance/touch_all_biblios.pl Do we agree it's a good idea to request that for future scripts, and add this in the coding guidelines ? -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

10 9

zebraidx errCode=109
by Paul 25 Jul '12

25 Jul '12

Yesterday, I took the plunge and installed 3.6.6 on a brand new install of Ubuntu 12.04 server. Everything went swimmingly well ('restored' an old Koha db, data conversion succeeded) until: koha@sandbox:/usr/share/koha/bin/migration_tools$ KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib perl rebuild_zebra.pl -b -r -v -x ........ Records exported: 37190 ==================== REINDEXING zebra ==================== zebraidx(1981) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [No such file or Directory] zebraidx(1981) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [No such file or Directory] zebraidx(1981) [fatal] Could not select database biblios errCode=109 (repeated for pid 1982 and 1983) ==================== CLEANING ==================== koha@sandbox:/usr/share/koha/bin/migration_tools$ I find in the records, that Chris C. had addressed this in June 2011 "Your answer is here, you are missing those directories, you will need to create them and make sure they are writable by the user you run zebra as" and that Robin had followed up "There is a patch I need to write (that I did as a one-off on a laptop that was experiencing this issue) that I really need to submit that will prevent this occuring." Could someone please tell me what the patch might be? (and possibly point me to what and where to create?) For the record, when I installed 3.6.1 (our production machine) earlier this year, this error did not occur. The only slight difference [not relevant?] was that I used Ubuntu 11.10 (12.04 had not been released), and that this time I did install a memcache server prior to Koha (I installed it after Koha was running on the production box.) Thanks and br, Paul --- 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 5

Re: [Koha-devel] Biblio.pm subject of a bug?
by Paul 25 Jul '12

25 Jul '12

At 06:05 PM 7/24/2012 -0400, Jared Camins-Esakov wrote: >Paul, >Re: 3.6.6 Â Biblio.pm > >With preference set to "do not use zebra", saving an "item" fails: "Can't >call method "subfield" on an undefined value at >/usr/share/koha/lib/C4/Biblio.pm line 3104" (z39.50 and adding biblios >works fine. >There's your problem. You have your system set to not use Zebra. Sorry Jared, I wasn't clear -- I cannot get zebra working (yet). What I did, was *temporarily* turn off "use zebra" in preferences, just so that I could use search in the staff-client screens and pull up a biblio. With zebra absent, *none* of the search functions work at all with the "use zebra" preference turned on - you can't find any item, biblio. While I was there I tried editing a biblio, adding a biblio etc (that works), then adding an item, which failed. I then tried using two screens, one to pull up the add/edit item page, and then on the other screen, turning (non-functional) zebra preference back on, then going back to the first to "add item"... and of course it worked. Proof positive that zebra is an absolute necessity. >I found Ubuntu 12.04 very problematic, but Mark Tompsett has been doing a >ton of work on making Koha 3.6.7 install so on Ubuntu 12.04 so smooth that >you could sleep through it. Not only that, he and Tomas Cohen have been >working on making the installation of all versions of Koha on Ubuntu >smoother. They have a great set of instructions atÂ ><http://wiki.koha-community.org/wiki/Koha_on_Ubuntu>http://wiki.koha-community.org/wiki/Koha_on_Ubuntu I'm well aware of that page (I've compared it line by line with my notes, could not find any difference, except he does not use memcached and memoise, and he apt-get's the LAMP server, while I prefer to do Apache2, Perl and MySQL separately, and he does not mention either ssh or Samba both of which I use.) I also note that it's only in the last day or so that he has added the mention of Ubuntu 12.04, which he now says works for Koha 3.6.7. Anyway, I've just repartioned the sandbox, installed a fresh 12.04 server, and am right now wget'ting 3.6.7 More later -- I'm just keeping my fingers crossed that I screwed something up last time :{ Again thanks - Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

Koha 3.8.3 released
by Chris Cormack 22 Jul '12

22 Jul '12

The Koha community is proud to release Koha version 3.8.3. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.8.3 from the http://download.koha-community.org site. Debian packages will be available from the http://debian.koha-community.org shortly also. Please read the release notes below for more information RELEASE NOTES FOR KOHA 3.8.3 22 Jul 2012 NZST ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.8.3 can be downloaded from: http://download.koha-community.org/koha-3.08.03.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.8.3 is a bugfix/maintenance release. Highlights of 3.8.3 ====================== 5981 blocker OPAC: Add limits to search history 7619 blocker 3M self checkout don't work in France 8154 blocker The export today's checked in barcodes generated file is always empty 8267 blocker Overdue notices not working 5644 critical dropbox mode doesn't set the correct date 7818 critical support DOM mode for Zebra indexing of bibliographic records 8289 critical Upgrading from 2.2 does not work anymore 5327 major Unit tests required for all C4 modules 7848 major Issues data missing from circulation notices 8229 major Tabs in marc subfield structure is not shown correctly 8315 major fix 'C4::Output 3.02' errors in Koha 8356 major moveitem.tt and linkitem.tt have cataloging typo 8384 major Some Perl scripts do not compile Bugs fixed in 3.8.3 ====================== 3280 normal opac/opac-sendbasket.pl security leaky 6394 normal purchase order has french hard coded in 6634 normal manager_id not populated when paying fines 6720 normal Saved authorities always show as 'Default' 6939 normal DefaultClassificationSource not used in 942$2 7299 normal ILSDI HoldItem service does't set the itemnumber in reserves table 8043 normal today's checkouts are in Previous checkouts in circulation.pl 8152 normal Clicking cancel on edit suggestion redirect to the suggestion detail 8224 normal aqplan.pl and aqbudgets: authorized values doesn't appear in planning list 8255 normal Local cover images should be cacheable 8282 normal Bug in modules list in about.pl 8311 normal Mis-scoped function call in C4::Auth 8375 normal Common diacritics not shown correctly when exporting batch label to PDF 8383 normal Need test to check that Perl files will compile 8386 normal Error in duplicate detection message for authorities 8398 normal Missing image file in staff global css 6855 minor bullet point showing in wrong place on error message 7630 minor Warning on moremember.pl about param without key 7642 minor The number that appears when hovering over a tag in the tag cloud isn't the number of items with that tag 8006 minor Loading offline circulation does not anonymize 8191 minor New value for 8 position in coded data field 100 in unimarc 8194 minor Layout problem on subscription add when showing manual history 8217 minor Focus on search box in Detail page (staff search) 8232 minor Comments in OPAC contain untranslatable javascript messages 8235 minor Packaging scripts get upset with non-Debian perl modules 8242 minor Permission for "change password" button in members toolbar should be "borrowers" instead of "staffaccess" 8272 minor OPAC : date expiration format 8288 minor showmarc.tt should not include full doc-head-close.inc 8314 minor Missing MARCISBNS param in opac-detail.pl 8335 minor Missing Icon PR.png or typo in MARC21slim2OPACDetail.xsl 6350 trivial Bug for tracking updates to the history file 7143 trivial Bug for tracking changes to the about page 7367 trivial General OPAC typo omnibus 7368 trivial General staff client typo omnibus 7994 trivial Syntax error in yaml (syspref) files 8313 trivial add ASHS to 'Koha team' page, for sponsorship of the 'star-ratings' feature 8323 trivial User created lists not sorting properly 7286 enhancement Introduce rebuild_zebra_sliced.zsh to recursively rebuild zebra & be error proof 8216 enhancement Enable critic tests on SIP modules 8223 enhancement Properly format SQL query in C4::Bookseller::GetBookSeller System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.8/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Arabic (100%) * Armenian (80%) * Chinese (Taiwan) (99%) * Danish (75%) * English (New Zealand) (78%) * English (USA) * French (100%) * French (Canada) (67%) * German (100%) * Greek (69%) * Italian (100%) * Norwegian BokmÃ¥l (68%) * Portuguese (Brazil) (90%) * Spanish (87%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.8 is Release Manager: Paul Poulain <paul.poulain(a)biblibre.com> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: FrÃ©dÃ©ric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <koha.sekjal(a)gmail.com> QA team: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl>, Jonathan Druart <jonathan.druart(a)biblibre.com> Mason James <mason(a)kohaaloha.com> Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Release Maintainer (3.8.x): Chris Cormack <chrisc(a)catalyst.net.nz> Credits ====================== We thank the following individuals who contributed patches to Koha 3.8.3. 3 Alex Arnaud 6 Jared Camins-Esakov 3 Colin Campbell 10 Galen Charlton 1 David Cook 11 Chris Cormack 2 FrÃ©dÃ©ric Demians 3 Jonathan Druart 2 Katrin Fischer 1 Chris Hall 5 Kyle M Hall 2 Claire Hernandez 2 Mason James 5 Owen Leonard 1 FrÃ¨re SÃ©bastien Marie 1 Julian Maurice 2 Matthias Meusburger 1 Sophie Meynieux 1 Dobrica Pavlinusic 1 Maxime Pelletier 4 Paul Poulain 3 Marcel de Rooy 2 Robin Sheat 1 Lyon3 Team 1 Mirko Tietgen 2 Mark Tompsett 1 Duncan Tyler 2 Marc Veron 1 Stacey Walker 1 wajasu We also especially thank the following individuals who tested patches for Koha 3.8.3. 1 Tomas Cohen Arazi 17 Jared Camins-Esakov 10 Galen Charlton 82 Chris Cormack 1 FrÃ©dÃ©ric Demians 1 Jonathan Druart 3 Nicole C. Engard 10 Katrin Fischer 4 Kyle M Hall 1 Mason James 2 Owen Leonard 1 Julian Maurice 1 Dobrica Pavlinusic 62 Paul Poulain 1 Liz Rea 2 Martin Renvoize 3 Marcel de Rooy 1 Robin Sheat 1 Delaye Stephane 5 Marc Veron 2 Stacey Walker 1 wajasu We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.8.x. The last Koha release was 3.8.2, which was released on June 22, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

1 0

Koha 3.6.7 released
by Jared Camins-Esakov 22 Jul '12

22 Jul '12

The Koha community is proud to release Koha version 3.6.7. This is a bugfix release, and contains a number of important fixes You can obtain Koha 3.6.7 from the http://download.koha-community.org site. Debian packages will be available from the http://debian.koha-community.org shortly also. Please read the release notes below for more information RELEASE NOTES FOR KOHA 3.6.7 21 Jul 2012 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.6.7 can be downloaded from: http://download.koha-community.org/koha-3.06.07.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.6.7 is a bugfix/maintenance release. Highlights of 3.6.7 ====================== 7894 blocker Broken detail page for first link on page 2 from search result page in OPAC 8140 blocker Error when exporting label xml 8144 critical 775 tag in the MARC record causes display issue 8082 major The: IssuingInProcess configuration setting is working in reverse. 8201 major can't change receive date Bugs fixed in 3.6.7 ====================== 3638 normal Status of hold not changed when item checked in via SIP2 Interface 4330 normal Copyright statements out of date 5795 normal Missing ReservesControlBranch system pref in database installer 7548 normal Missing arguments in the pagination of receptions 7599 normal Cart JavaScript contains untranslatable English strings 7604 normal Link on basket group name for closed basket groups is broken 8111 normal Language chooser display problem in self-checkout 8116 normal z3950 empty search causes silent warning in koha-error_log 8176 normal $sqlwhere is undefined in C4::Serials in GetSubscriptions 7948 minor Printing transfer slip loses barcode field focus 3521 trivial Items table in catalogue/detail.pl and cataloguing/additem.plis sorted nonsensically 7496 trivial Personally identifying information sent in opac user TITLE 6684 enhancement koha-remove should check the number of arguments it gets 7847 enhancement OPAC search dies with plack 8001 enhancement Add some styling to the tags to allow them to be distinctive 8080 enhancement login and password is pre-filled by the browser when creating a new patron 8489 enhancement Revised ubuntu-pkg-check.sh, renamed ubuntu package files, tweaked 12.04 package file, copied 12.04 package file to ubuntu.packages New sysprefs in 3.6.7 ====================== * ReservesControlBranch System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.6/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * Arabic (51%) * Chinese (China) (96%) * Chinese (Taiwan) (99%) * Danish (99%) * English (New Zealand) (97%) * English (USA) * English (United Kingdom) (64%) * French (99%) * French (Canada) (95%) * German (100%) * Greek (94%) * Italian (100%) * Norwegian BokmÃ¥l (62%) * Portuguese (Brazil) (99%) * Spanish (100%) * Tetun (52%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.6 is Release Manager: Chris Cormack <chrisc(a)catalyst.net.nz> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <ian.walls(a)bywatersolutions.com> Bug Wranglers: MJ Ray, Marcel de Rooy, Paul Poulain, Mason James Past Release Maintainer (3.6.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.6: * Arcadia Public Library * Athens County Public Libraries * East Brunswick Public Library * Halton Borough Council * Horowhenua Library Trust * Los Gatos Public Library * NEKLS * South Taranaki District Council We thank the following individuals who contributed patches to Koha 3.6.7. 4 Jared Camins-Esakov 3 Colin Campbell 7 Chris Cormack 1 Frédéric Demians 4 Katrin Fischer 1 Amit Gupta 4 Kyle M Hall 1 Piotr Kowalski 3 Owen Leonard 3 Paul Poulain 1 MJ Ray 1 Robin Sheat 1 Simon Story 1 Mark Tompsett We also especially thank the following individuals who tested patches for Koha 3.6.7. 39 Jared Camins-Esakov 33 Chris Cormack 3 Jonathan Druart 2 Magnus Enger 23 Paul Poulain 2 MJ Ray 5 Liz Rea 1 Marc Veron We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.6.x. The last Koha release was 3.8.0, which was released on April 22, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

1 0

Koha using Security gate for library!
by Uy 21 Jul '12

21 Jul '12

I'm building a library with Koha. I had a barcode reader, 4 camera with a computer. I going to buy a security gate for market. I don't know, does koha work with this security gate or not? Does security work with barcode? Or security gate works with its private system. Kindest Regards! Nguyen Quoc Uy

3 2