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

Special 3.4 Issue: Official Koha Newsletter: Volume 2, Issue 4: April 2011
by Nicole Engard 25 Apr '11

25 Apr '11

Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 4: April 2011 Special Issue Table of Contents Introduction Koha 3.4 Koha 3.4 Released Koha 3.4 Statistics Koha 3.4 Documentation Koha 3.4 Release Notes Introduction by Nicole C. Engard In honor of the timely release of Koha 3.4 and the amazing community who made it happen this issue of the Koha Newsletter will focus on the release. The following articles will provide you with all of the information you’ll need to learn about Koha 3.4. Please read the entire newsletter on the official Koha site at: http://koha-community.org/koha-newsletter-volume-2issue-4-april-2011/ Newsletter edited by Nicole C. Engard, Koha Documentation Manager. Please send future story ideas to me.

1 0

Koha 3.4.0 released
by Chris Cormack 23 Apr '11

23 Apr '11

Kia ora tatou The Koha development team is happy to announce the release of Koha 3.4.0. Koha 3.4.0 is a major feature release that contains major changes to underlying architecture (adoption of Template::Toolkit for templating) and performance enhancements (removal of item data from biblio records). These changes, in addition to the inclusion of many new features, mean a lot of new strings for translators to translate. For these reasons we recommend that people who are already running Koha in production delay their upgrade until 3.4.1, due May 22, to give the translators time to finish, and for the removing of item data to be streamlined. If you do wish to upgrade please make sure you read the UPGRADE section of the INSTALL document. The development team would like to thank all the people who have made this release possible. Please take time to read the release notes. RELEASE NOTES FOR KOHA 3.4.0 - 22 April 2011 ======================================================================== 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.4.0 is released in memoriam of Elizabeth Mae Gallagher-Mitchell December 20, 2010 - March 10, 2011. Haere. Mōu tai ata; mōku tai ahiahi Koha 3.4.0 can be downloaded from: http://download.koha-community.org/koha-3.04.00.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.4.0 is a major feature release. New features in 3.4.0 ====================== ACQUISITIONS: * Can filter budgets by active status and date on the acquisitions homepage * Freetext field added to specify one-off delivery * addresses/comments * Can create multiple orders from a staged MARC file * New cronjob to delete old suggestions * Warning when ordering from an external source when a catalogue record already exists * Currency can be set when ordering ADMINISTRATION * Many additional granular permissions are added * Ability to replace the favicon from within the admin interface * Ability to import and export MARC frameworks * Separate field for library state/province * WYSIWYG editor for Koha News * Ability to add news items to slips * Label batch edit interface allows entry of items by scanning barcodes * Can choose the MARC framework when importing records CATALOGING * NORMARC support added * Edits to Authority records are now logged * 005 field updated when a Biblio or Authority record is edited * Added edit record/edit items to the search result if logged in user has cataloguing privileges * Add support of record linking by record control number in $w * 006/008 plugins much improved CIRCULATION * Callnumbers are displayed when an item is checked in * Waiting holds now show the date they were marked waiting * Show guarantees checkouts when checking out to a guarantor and * vice versa * Show holds waiting for a patron on check in * New report wizard for Holds * Syspref to disable the ability for borrowers to choose their pickup library for holds * Self Checkout supports login * Ability to set 'hard' due dates, which will not allow items to be checked out past that * Printed receipts can now include the library phone, address and other fields * Fast Add framework at circulation * Ability to define due dates in the past * Checkin page now lists fines owed by patron * Preferences for defining the fine level when a staff override is needed * Search to Hold feature OPAC * New system preference added to allow the librarians to hide items from the OPAC. See docs/opac/OpacHiddenItems.txt for more information. * Authority display improved in OPAC * Allow the patron to choose which library they wish to make a purchase suggestion for * Added the ability to hide the name of a reviewer/commenter in the OPAC * CSS/HTML and other UI improvements * Lists respect the XSLT bibliograhic display preferences * Truncation of facets now controllable by a system preference * Can use 856$u to store an image URI which Koha can then display in * the OPAC * User can renew multiple items at once * A new librarian-controlled column added to the 'My Summary' page * on the OPAC * Recent comments view for the OPAC (allow users to see recently * reviewed items) * Feature to make the OPAC private (allow only logged in users to * search/view items) * Ability to edit what displays when no results are found * Privacy feature allowing the user to specify when their reading (or circulation) records are anonymised * opacstylesheet can link to a url anywhere, not just a local file PATRONS * Separate field for state/province * Ability to duplicate a Patron * Print overdue and hold notices for patrons without email addresses REPORTS * Run a report immediately after creation * The list of saved reports has pagination and can be sorted * SQL formatting improvements when viewing a report * Parameters can be set in guided reports SEARCHING * NoZebra mode is officially deprecated. * Added shelf location to the indexes * Added a search link for analytics to serial records * Subjects can now search complete subfields * MARC21 tag 751 (geographical entry) is now searchable * UNIMARC EAN/UPC/Music fields added to the indices * usecontrolnumber syspref allows you to link the 78X fields to other names of the same serial SERIALS * 50 bugs fixed in serials management 5508 STAFF INTERFACE * Enumchron added to the biblio detail page * Improvements to suggestion management * Can use 856$u to store an image URI which Koha can then display in the staff interface. * Cart is emptied when a user logs out * IntranetUserCSS preference added to allow styling of staff * interface INTERFACE * New icon set for itemtypes (Nimes) * LibLime kids iconset resized to consistent size * Seshat itemtype iconset added (Naropa College) * CSS classes added to the XSLT results to enable styling INTERNATIONALIZTION * New initialization SQL files for Norwegian INTERNALS, PACKAGING AND PERFORMANCE * Koha now uses Template::Toolkit rather than HTML::Template::Pro * Improvements to test case coverage * .packages file for Ubuntu Maverick * Testing using Test::Perl::Critic * CGI::Session can now be stored in Memcached * mod_deflate added to save bandwidth * Move items out of biblioitems COMMAND LINE UTILITIES * Script to update all items and biblio * Script to set and get system preferences from the command line BUGFIXES * Approximately 633 tracked bugs and enhancement requests are addressed in this release System Preferences ====================== The following system preferences are new in 3.4.0: * AllFinesNeedOverride * AllowFineOverride * AllowPurchaseSuggestionBranchChoice * AllowSelfCheckReturns * AlternateHoldingsField * AlternateHoldingsSeparator * AuthoritiesLog * COinSinOPACResults * Display856uAsImage * displayFacetCount * FacetLabelTruncationLength * FineNotifyAtCheckin * HoldNotifyAtCheckin * IntranetFavicon * IntranetUserCSS * itemBarcodeInputFilter * maxItemsInSearchResults * maxRecordsForFacets * OPACAllowUserToChooseBranch * OPACDisplay856uAsImage * OpacFavicon * OpacHiddenItems * OPACMySummaryHTML * OPACNoResultsFound * OpacPrivacy * OpacPublic * SelfCheckHelpMessage * SelfCheckTimeout * ShowReviewer * StaffAuthorisedValueImages * TraceCompleteSubfields * TraceSubjectSubdivisions * UseAuthoritiesForTracings * UseControlNumber * UseTablesortForCirc * WaitingNotifyAtCheckin System requirements ====================== Changes since 3.2: * Template::Toolkit 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://koha-community.org/documentation/3-4-manual/ 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: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish 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.4 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> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> QA Manager: Colin Campbell Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.4: * Aix-Marseille University, France * East Brunswick Public Library, USA * Food and Agriculture Organisation of the United Nations * Goddard College, USA * Hauraki District Council, New Zealand * Horowhenua Library Trust, New Zealand * La Trappe Monastery, France * Lyon3 University, France * Marlboro College, USA * MassCat, USA * Merrill Memorial Library, Maine, USA * Middletown Township Public Library, USA * Ministry of Culture, Spanish Government, Spain * Naropa College, USA * Nelsonville Public Library, USA * Nimes, France * Regionbibliotek Halland, Sweden * Rijksmuseum Research Library, Netherlands * SAN Ouest Provence, France * SAR, USA * St Etienne University, France * VOKAL, USA We thank the following individuals who contributed patches to Koha 3.4.0. * Alex Arnaud * Amit Gupta * Andrew Elwell * Bernardo Gonzalez Kriegel * Brian Engard * Brice Sanchez * Chris Cormack * Chris Nighswonger * Christophe Croullebois * Christopher Hall * Cindy Murdock Ames * Claudia * Colin Campbell * D Ruth Bavousett * Daniel Grobani * David Schuster * Dobrica Pavlinusic * Doug Dearden * Edward Allen * Frédéric Demians * Frédérick Capovilla * Frère Sébastien Marie * Galen Charlton * Garry Collum * Henri-Damien LAURENT * Ian Walls * Jane Wagner * Janusz Kaczmarek * Jared Camins-Esakov * Jean-André Santoni * Jerome Charaoui * Jesse Weaver * Joe Atzberger * Johnboy * Jonathan Druart * Julian Maurice * Katrin Fischer * Koustubha Kale * Lars Wirzenius * Liz Rea * Magnus Enger * Marcel de Rooy * Mark Gavillet * Mason James * Matthew Hunt * Matthias Meusburger * MJ Ray * Nahuel ANGELINETTI * Nate Curulla * Nicolas Morin * Nicole C. Engard * Owen Leonard * Paul Poulain * Reed Wade * Ricardo Dias Marques * Robin Sheat * Salvador Zaragoza Rubio * Savitra Sirohi * Serhij Dubyk {Сергій Дубик} * Sophie Meynieux * Spartaness * Srdjan Jankovic * Stéphane Delaune * Tomas Cohen Arazi * Will Stokes * Zach Sim * Zeno Tajoli 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 Koha 3.4.x (i.e., this version of Koha and future bugfix releases) is 3.4.x. The next major feature release of Koha will be Koha 3.6.0. 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 -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

5 4

issues with label creator item search
by Cole Hudson 22 Apr '11

22 Apr '11

Hi all, I seem to be having some trouble with label creator item search tool in Koha 3.02.06, running on Ubuntu 10.10. When I go to search for items to add to a batch, I have a couple problems. First, I'm not able to search with the added on date fields. I select a date, click search, and nothing appears. Also, when I manage to search for an item, I don't get all of my results. After about the first 20 or so results appear, I just get blank entries in the form of this: [], [], [], [], [], [], I checked my koha-error_log file and am getting the following errors. [Wed Apr 20 15:21:39 2011] [error] [client 35.12.33.50] [Wed Apr 20 15:21:39 2011] label-item-search.pl: Use of uninitialized value $biblionumber in hash element at /usr/share/koha/intranet/cgi-bin/labels/label-item-search.pl line 124., referer: http://koha.com.msu.edu:8080/cgi-bin/koha/labels/label-item-search.pl [Wed Apr 20 15:21:39 2011] [error] [client 35.12.33.50] [Wed Apr 20 15:21:39 2011] label-item-search.pl: Use of uninitialized value $biblionumber in sprintf at /usr/share/koha/intranet/cgi-bin/labels/label-item-search.pl line 142., referer: http://koha.com.msu.edu:8080/cgi-bin/koha/labels/label-item-search.pl [Wed Apr 20 15:21:39 2011] [error] [client 35.12.33.50] [Wed Apr 20 15:21:39 2011] label-item-search.pl: No item numbers retrieved for biblio number: at /usr/share/koha/intranet/cgi-bin/labels/label-item-search.pl line 142., referer: http://koha.com.msu.edu:8080/cgi-bin/koha/labels/label-item-search.pl I'm not really sure how to go about fixing this. Any suggestions? Thanks. Cole Cole Hudson Library Assistant Michigan State University College of Osteopathic Medicine

2 3

Bug 2453
by Paul 22 Apr '11

22 Apr '11

I've just been reading Bug 2453 - (very) large biblio/item handling; it appears to have received no comments since 2010-05-21. If I understand the situation correctly (from Paul Poulain's comments) if a biblio/items record exceeds 100Kb then zebra may fail. He suggests: [snip] 2 possibilities : - fix Koha to limit the size of a biblio/items (check that we don't ge more than 100kB) - fix the export during rebuild_zebra. I think the 1st solution is the best. I am currently defining our serials cataloguing policy - choices: one biblio for perhaps 1,200 items; one biblio per item (probably unmanageable in OPAC); or one biblio per year|volume. Currently the third choice is preferred, one (perhaps repetitive) biblio with up to 12 items, occasionally 52 (we do not handle dailies.) However, even at twelve items per biblio we will often go beyond 100Kb; we are a research library where abstracts, indexes and keywords are, by definition, fairly voluminous and are the "bread and butter" of our users. Should this bug prompt me to perhaps rethink the policy? Has 3.4 changed this situation? Is there anything else in the pipeline that I should be aware of? Many thanks for any guidance, Paul Tired old sys-admin

4 5

[koha] unable to locate Koha configuration file koha-conf.xml
by Massimo Plevani 21 Apr '11

21 Apr '11

Hi All, I am getting the same problem: When I tried to install Koha 3.2.5 on ubuntu 9.04 and I got the following message in first line after executing the perl Makefile.PL command: unable to locate Koha configuration file koha-conf.xml at /build/koha-3.2.5/C4/Context.pm line 307. some help? thanks

1 1

koha: error in MARC Bibliographic Framework Test
by Linda Culberson 21 Apr '11

21 Apr '11

All, I had done 12 customized frameworks in Koha version 3.02.02.003 and at some point I made an error - and I'm embarrassed that I don't know when the error got in since I worked on them pretty much all at once. I have only the one error and it is: Item tag There is more than 1 MARC tag related to items tab (10) : 952,955,956,960,967,980,981,982,983,984,987,990,995,998. I've gone through every framework and don't use any of those fields except the 952. I did this sql statement to verify that was the case: SELECT distinct tagfield FROM `marc_subfield_structure` WHERE `tagfield` IN ('952', '955', '956', '960', '967', '980', '981', '982', '983', '984', '987', '990', '995', '998' ) AND `kohafield` LIKE 'items.%'; and the results was one row: 952. I've checked all the frameworks and even matched them against the demos so kindly posted on koha-community.org. I'm thinking that I may not be understanding what the error means, because I was assuming that it indicated that there might be a duplication in the koha link. Can someone tell me what I should be looking for? Thanks in advance. -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824

3 3

List Cross Posting Trend
by Chris Nighswonger 20 Apr '11

20 Apr '11

Hi everyone, There seems to be a growing trend lately of cross posting to both the Koha user's and developer's list of questions which are usage related. Perhaps this is a good time to remind everyone to please post user questions to the user list and development/code questions to the developer's list in order to preserve each list from the clutter of the other. Only posts truly relevant to both audiences (like this one) should be cross posted. Thanks to all, both users and developers, for helping to make Koha the great ILS that it is! Kind Regards, Chris Koha 3.2.x/3.4.x Release Maintainer

2 1

Koha move to 3.4
by Linda Culberson 19 Apr '11

19 Apr '11

All, How is the recommended way to move to the upcoming 3.4? We were thinking of having two instances. One with our current 3.02.02.003 and one with 3.4. Is that a good way to do it or should we upgrade to 3.2.7 and go from there? Can we move our data or is it better to do a fresh load? How different is the database in 3.4? Your advice to this newbie is greatly appreciated. -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives & History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824

3 3

Issues table and foreign keys in general
by Srdjan 19 Apr '11

19 Apr '11

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I have noticed some things: 1. issues table has nullable borrowernumber and itemnumber; foreign key constraints are consequently declared as "ON DELETE SET NULL ON UPDATE SET NULL" 2. That is not an isolated issue, there are many cases where foreign key field/constraints are declared like that Can anyone shed more light, that looksvery wrong to me. Thanks, Srdjan -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk2k/pcACgkQX6p/D9UE7dy2fQCfZP/QeVQSb7VNNMJvA5yYWdBj AvAAn0fRuZ1KinfIiIIWCR+EgXhmYBu8 =2WSQ -----END PGP SIGNATURE-----

4 4

Re: [Koha-devel] Subfields 952 $i, $k
by Paul 18 Apr '11

18 Apr '11

At 04:18 PM 4/18/2011 +0200, Fischer, Katrin wrote: >Hi Paul, >in 3.4 a mapping and a new search index was introduced for 952$i and >items.stocknumber (Bug 5839). Many thanks for the answers. So if we upgrade to 3.4, I'll have to modify kohadb to take out the (varchar 32) constraint? So far, we have endeavoured to remain "faithful" to the Master version, but cataloguing our serials is an uphill challenge. >You can easily add new subfields in your bibliographic frameworks. If you >leave the mapping field empty the data will be stored in the >more_subfields_xml column. As the name indicates it's stored in a XML format. Perhaps easier to add specific items.xyx - I don't think the XML will be problematic, but wonder if these are all concatenated for OPAC display? (e.g. at the moment 520 $a and $b ARE concatenated. I'm looking for a way to undo this.) >There are not many lowercase letters left for 952. According to the MARC21 >Standard it's also possible to use uppercase letters, but I am not >completely sure if Koha works correctly if you do. This would need some >more testing, although we have done so in the past without running into >problems. This sounds like a possible solution - instead of "local" specialized uses (German remapping of 995$j to 952$i in this case) getting into the Master, surely it is more logical to leave more flexibility? I don't think everyone has the time to follow all bugs (I certainly missed this one), maybe the development team could assure us that 952 $[A-Z] are fully working and available for local use, while 952 $[a-z] are for Koha use? Best - Paul >For search you would need to add new indexes to your Zebra configuration. >This is independent from the way you store the data in your database. > >Hope this makes sense and is helpful for you, > >Katrin > > > > -----Original Message----- > > From: koha-devel-bounces(a)lists.koha-community.org [mailto:koha-devel- > > bounces(a)lists.koha-community.org] On Behalf Of Paul > > Sent: Monday, April 18, 2011 4:04 PM > > To: koha; koha-devel(a)lists.koha-community.org > > Subject: [Koha-devel] Subfields 952 $i, $k > > > > [Apologies for cross-posting, users and devel] > > > > Marc 952 $i, $k are not used in "standard" Koha. They can be added to the > > default framework (allowed by Koha), but this appears to require a > > modification to the Mysql structure. Has anyone tried to do this? > > > > Background: for Serials, we want to add at *item* level "Extended > > Keywords" (952$z is limited to 255 characters) and "Abstracts" (at *biblio* > > level, we use 520 $a and $b.) > > > > This will require new "Koha Fields" - e.g, in the same way that 952$z uses > > "items.itemnotes" we will need to introduce "items.itemkeywords" and > > "items.itemabstracts". > > > > I am looking for suggestions as to how to best add these fields so that > > they can be usefully searched by the OPAC - and of course for any pitfalls > > or showstoppers. > > > > Thanks > > > > Paul > > Tired old sys-admin > > > > _______________________________________________ > > 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/ > >

2 1