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

Koha 2.2.8 has been released
by Paul POULAIN 08 Mar '07

08 Mar '07

Koha 2.2.8 has been released & is available at : http://download.savannah.nongnu.org/releases/koha/koha-2.2.8.tar.gz Koha 2.2.8 is a bug fix only release. RELEASE NOTES ============= Koha is the first Open-Source Integrated Library System. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, it is currently maintained by a team of software providers and library technology staff from around the globe. Koha 2.2.8 is more than 250,000 lines of code (see : http://bureau.paulpoulain.com/cvslog/) , contributed by about 50 different developers (46, +translators). The 2.2.8 version of Koha is a mature product, with a lot of nice features. More than 100 libraries are registered as users on wiki.koha.org, and we are sure that at least 300 libraries use the software. There are 2 projects derived from Koha. ======= INSTALLER WARNING ======= During installation, you may get the 2 following lines in red : - Too late to run INIT block at /usr/lib/perl5/site_perl/5.8.8/i386-linux/ZOOM.pm line 37. - Use of uninitialized value in concatenation (.) or string at Install.pm line 1677, <HC> line 1117. You can safely ignore them ======= CHANGES ======= Changes 2.2.7 => 2.2.8 ********************** Koha 2.2.8 is a bug fix only release. * (critical) a security hole has been fixed in the fines payement process : anyone was able to "pay" some fine, even without any permission, if it knows how the URL to call. * (major) when searching z3950 on a biblio MODIF, the result was an add. This was really a problem for z3950 query after an acquisition. * (major) there was some mixing between itemnotes & biblioitems notes, depending on your MARC structure (does not apply to everybody) * (major) Books will no longer be returned by transferbook, thus, breaking the loop. Transfer book should be used when transfering books from branch to branch. if a book is returned at a branch, transfer the book there. if a book is transfered to a branch, while its on loan, set holding to the new branch. Useful if a borrower moves branches, while borrowing books. * (major) when searching z3950 on title, only the 1st word of the title was searched. * (major) when recieving serials, the recieve date was not properly calculated. It seems the problem occurs only since 2007/01/01 * datelastborrowed was not properly saved when issuing * some dependency checkings (during install) fixed * publisher code was not unicode compliant (applies only to unicode libraries) * for libraries with insecure=ON, a bug was sometimes rised * a normal librarian can't no more delete a "superlibrarian" * borrowers with a ' in their surname can be searched in members module * there was some bugs (and missing) links on acqui page for npl templates * biblios without isbn or issn can now be imported in the reservoir * (cosmetic) virtual shelves now go to opac-detail, not to opac-MARCdetail * (cosmetic) some dates are now shown as defined in the systempreferences * (cosmetic) some systempreferences were not on the proper place in system pref editing Technical note for developpers : the 2.2.8 version is in a specific branch, called R_2-2-7-1. This is because rel_2_2 had some unstable improvements and we wanted to release a stable version quickly. The 2.2.9 will rely on rel_2_2 as usual. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0

Re: [Koha-devel] Files missing from 2.2.7 ?
by Partha Mukhopadhyay 08 Mar '07

08 Mar '07

Hello friend Actually there are two directories value_builder and reports. In koha on windows installer these two folders wrongly placed. We solved this problem by copying these two folders from C:\usr\koha227\intranet\cgi-bin\koha\ to C:\usr\koha227\intranet. It completely solved the problem. May be some help to you. Parthasarathi Mukhopadhyay > ----- Original Message ----- > From: "Paul POULAIN" <paul.poulain(a)free.fr> > To: "Phill Hardstaff" <phillh(a)spc.int> > Subject: Re: [Koha-devel] Files missing from 2.2.7 ? > Date: Wed, 07 Mar 2007 18:04:35 +0100 > > > Phill Hardstaff a écrit : > > Hi All, just wondering why this file is missing from 2.2.7 ? > > And apache logs > > HTML::Template->new() : Cannot open included file > > /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/value_builder/marc21_field_008.tmpl : file not found. at /usr/share/perl5/HTML/Template.pm line > > 1580 > > The reason being that these 2 files > > marc21_field_008.tmpl marc21_field_008_authorities.tmpl > > are missing from the directory > > /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/value_builder/ > > I copied them over from my backup of 2.2.5 and it works again ? > > Hello, > > and sorry to have missed that mail until now... > > mmm... strange... in my CVS copy, those files have never be in > default templates. > iirc, we (hdl) did your install. So, hdl, did you copy those files > manually from npl to default ? in that case, could you add them to > rel_2_2 ? > -- Paul POULAIN et Henri Damien LAURENT > Consultants indépendants > en logiciels libres et bibliothéconomie (http://www.koha-fr.org) > Tel : 04 91 31 45 19 > > > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)nongnu.org > http://lists.nongnu.org/mailman/listinfo/koha-devel > = J-B Wholesale Pet Supplies We carry a huge selection of dog and cat products at discount prices. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=df59a9ab5fb66d989562f80…

1 0

Re: [Koha-devel] zebra for multi-marc
by Paul POULAIN 08 Mar '07

08 Mar '07

毛慶禎 a écrit : > 2007/3/8, Paul POULAIN <paul.poulain(a)free.fr>: >> In the future, we may/could add some facilities to do >> MARC21 ->UNIMARC and/or UNIMARC -> MARC21, but that's unplanned yet. > > There is a > "UNIMARC to MARC 21 Conversion Specifications" > Version 3.0 (August 2001) > Prepared for the Network Development and MARC Standards Office Library > of Congress, http://www.loc.gov/marc/unimarctomarc21.html > > What we need is a > MARC 21 to UNIMARC Conversion > > Any idea who and how to realize it? I already have migrated a library from MARC21 to UNIMARC (with very complete MARC records), so I already have some code written. But I don't have even a minute do investigate wether my code can be re-used & remove Koha specific stuff. -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

1 0

rel_3_0, head & tumer stuff
by Paul POULAIN 07 Mar '07

07 Mar '07

Hi all, as you probably know, the CVS tree can have branches. We have - one stable rel_2_2. - one unstable, but actively developped & that will result in official koha 3.0 "soon". - one managed by Tumer Garip, that is, actually in HEAD. some interesting features from head have been ported to rel_3_0. Many things don't. with rel_3_0 becoming stable, we think we should reorganize the CVS a little bit : - tumer stuff would be branched to a "tumer" branch (rel_TG ?), from actual head. - rel_3_0 will be feature freezed and only bugfixed. - rel_3_0 will be copied to head (overwriting actual head), to be the official HEAD. any interesting stuff from tumer would be ported here from rel_TG To do this, we have to do things one after the other : - 1st tumer : could you confirm you don't have anything waiting to be commited to head (i've been told that there are things in fact ;-) ). Once it's done, we will be able to : - create rel_TG branch from HEAD - copy all scripts from rel_3_0 to a local HEAD copy - commit all those scripts to have HEAD= rel_3_0. Once it will have been done : - tumer, you'll have to be carefull to branch your local copy to rel_TG to avoid commiting stuff into head by mistake - we will have rel_3_0 for bugfixes only - we will have HEAD for new ideas & coding. A last question : does someone candidate to synch stable rel_3_0 into HEAD ? toins may take care of it, but I would prefer someone else (and I remind you that he works with us till july, nothing sure for september -august being for wedding ;-) ). -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

3 3

Files missing from 2.2.7 ?
by Phill Hardstaff 07 Mar '07

07 Mar '07

Hi All, just wondering why this file is missing from 2.2.7 ? If you do (Default Template, hut same with NPL) catalog - add biblio - create empty biblio - Tab 0 - Field 008 - Click on the three little dots to open the "Leader Builder" and you will get a 500 server error, if you take a look at the Koha logs you see this. [Tue Dec 12 14:44:15 2006] [error] [client 172.16.2.23] Premature end of script headers: plugin_launcher.pl, referer: http://kohar.spc.int:8080/cgi-bin/koha/acqui.simple/addbiblio.pl And apache logs HTML::Template->new() : Cannot open included file /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/value_builder/m arc21_field_008.tmpl : file not found. at /usr/share/perl5/HTML/Template.pm line 1580 The reason being that these 2 files marc21_field_008.tmpl marc21_field_008_authorities.tmpl are missing from the directory /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/value_builder/ I copied them over from my backup of 2.2.5 and it works again ? Cheers Phill Phill Hardstaff Senior Support Engineer Secretariat of the Pacific Community B.P. D5 - Noumea Cedex - 98848 New Caledonia Phone +687-260141 Mobile +687 838091 Fax +1 (603) 299-5640 http://www.spc.int

2 1

Suspensions and the Fines system
by José Parrella 07 Mar '07

07 Mar '07

Greetings, I'm wondering if Koha has a way to suspend users when they fail to return their books instead of charging them with money. In Venezuela (and at least in other Latinamerican country, as I saw in the mailing list archives) users are not fined, but instead are barred of using the library for usually three days. I've implemented a sloppy solution which I'm studying right now. In C4::Circulation::Fines.pm, under the UpdateFine function, I added a statement which sets the debarred value in the borrowers table to "1", effectively impeding the user to request books. This is supposed to happen when the user is starting to get fined by Koha. OTOH, in the fines2.pl script, I took profit of the $difference variable which is used to re-calculate the fines daily. When that $difference variable reaches 3 (days), the debarred flag gets set to "0" again. Then, the librarian clicks "Pay fine" and just "as if", the user's back again. Of course this lacks some stuff, for example, having a sane way to specify the number of days of suspension (via the Parameters system) and also it assumes that the user has returned the item in that 3-day slot. I would like to know if somebody has any experience regarding this, and maybe some ideas about a proper development for this feature. Yours, Jose -- José M. Parrella -> Debian Sid, k2.6.17.13 Escuela de Ingenieria Electrica Universidad Central de Venezuela -> ucvlug.info

2 1

koha top query
by long_sam.tw 07 Mar '07

07 Mar '07

Koha Top query summary: User query something via hiddin modthod. Keywords will recorded in databases.It will help user when he/ she query catalog. enviroments: koha 2.2.5 & koha 2.2.7 (templete for npl) modfied files: perl scripts - opac-search.pl、opac-main.pl tmpl - opac-main.tmpl database - create Cookie table 1. Cookie table CREATE TABLE `cookie` ( `id` int(255) NOT NULL auto_increment, `names` text NOT NULL, `counts` int(255) NOT NULL default '1', PRIMARY KEY (`id`), KEY `blbnoidx` (`id`) ) ENGINE=MyISAM ; 2. opac-search.pl if ($op eq "do_search") { ...... my @tags; ..... # put into cookie for my $count (@value) { my $dbh=C4::Context->dbh; $sth = $dbh->prepare("insert into cookie(names) values (?)"); $sth->execute($count) || die $sth->errstr; } 3. opac-main.pl my $dbh = C4::Context->dbh; my $top="Select names,SUM(counts) \"co\" from cookie group by names order by co desc limit 0 , 10"; my $sth=$dbh->prepare($top); $sth->execute; my @top; my $top; while (my ($names,$counts) = $sth->fetchrow_array) { my %rows = ( searchterm => $names, counts => $counts, ); push @top, \%rows; } $sth->finish; $template->param(top => \@top); 4. opac-main.tmpl <form action="/cgi-bin/koha/opac-search.pl"> ..... <input size="27" name="value" id="value" type="text"></p> # add  <p> Top query keywords：  <a href="/cgi-bin/koha/opac-search.pl?op=do_search&type=opac&marclist=&and_or=and&excluding=&operator=contains&value= "></a> （）  5. demo site http://lit145.lacc.fju.edu.tw http://koha.nkes.ntct.edu.tw http://koha.jente.edu.tw 6.chinese information http://koha.wikispaces.com/query ___________________________________________________ 您的生活即時通－溝通、娛樂、生活、工作一次搞定！ http://messenger.yahoo.com.tw/

2 1

Record.pm improvements
by Joshua M. Ferraro 07 Mar '07

07 Mar '07

Hi all, I just committed some improvements I made last week to Record.pm that allow better support for record handling and Dublin Core and MODS export functions. You can see how these functions could be used at NPL's catalog on the detail pages: http://search.athenscounty.lib.oh.us/bib/16595 (see the 'save record' feature) There's also a new misc/xslt folder with a MODS stylesheet that I nabbed from the Library of Congress. I note that the Record.pm functionality has been removed from rel_3_0, perhaps for good reason, but I'll be adding it back in pretty soon. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

2 1

Holdings and MARC Frameworks
by Joshua M. Ferraro 07 Mar '07

07 Mar '07

Hi all, In rel_2_2, every framework can have holdings fields, and this can lead to confusion when there are conflicts. I propose that in rel_3_0 we eliminate that confusion and only have holdings fields for the default framework. Any objections to this? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

4 8

Currencies in Koha
by Joshua M. Ferraro 07 Mar '07

07 Mar '07

Hi all, Prompted by this post on the Koha users' list: http://lists.katipo.co.nz/public/koha/2007-February/011153.html I'd like to take a look at how we currently handle currency symbols in Koha. There's a standard defined for currency codes, ISO 4217: http://en.wikipedia.org/wiki/ISO_4217 I think it would be worthwhile to consider whether integrating those 'official' currency codes into Koha wherever currency is displayed would be useful. For adding records, obviously the MARC21/UNIMARC standard, along with AACR2 or another standard for representing the currency symbol should be used by the librarian. Probably Koha should be able to read that properly in the display pages and display the right currency automatically? Also, for places like fines, acquisitions, etc., where Koha handles monetary transactions, perhaps we should have a system preference for how to display the default currency? Any thoughts, comments, etc.? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

2 1