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

zebra for multi-marc
by long_sam.tw 13 Jun '07

13 Jun '07

hi,programmers zebra support multi-marc ? i run koha for mysql can support coexistent marcs (marc21 & unimarc). marc21 http://lit145.lacc.fju.edu.tw/cgi-bin/koha/opac-MARCdetail.pl?bib=15 unimarc http://lit145.lacc.fju.edu.tw/cgi-bin/koha/opac-MARCdetail.pl?bib=17 laxendion ___________________________________________________ 您的生活即時通－溝通、娛樂、生活、工作一次搞定！ http://messenger.yahoo.com.tw/

5 4

Patch to catalogue by itemtypes report
by Nicholas van Rheede van Oudtshoorn 27 Mar '07

27 Mar '07

Hi all! I'm the IT guy for the Perth Bible College in Western Australia. We've been using Koha for the last 2 years or so, and are *very* happy with it. One thing that we required, however, was a report to show the value of the books in our library. This was necessary for all sorts of legal reasons. I patched the itemtypes report to include a third column for the price of each itemtype, and a grand total price at the bottom. A *very* simple patch. Would anyone be interested in this patch being submitted? I know that I've upgraded twice already (each time having to add the patch in manually :GRIN:) Once again, kudos to all the developers! Nicholas van Oudtshoorn Perth Bible College

3 3

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

new feature : catalogue browsing
by Paul POULAIN 07 Mar '07

07 Mar '07

Hello, I've just commited a new feature, called "catalogue browsing". A new script in misc/cronjobs/build_browser_and_cloud.pl will fill 2 new tables. - One for "tag cloud" searching : the tags are not filled by the users themselves, but from the catalogue. I plan to add later a feature to have a user-level tag system + a p2p system to share tags. for instance the "tag cloud" table will be filled from the catalogue only. - One for "Catalogue browsing" : depending on the parameters you give to build_browser_and_cloud.pl script, you'll fill the browser table, that let the user browse the catalogue. If you have dewey classification in your catalogue, you'll be able to dig the dewey hierarchy (3 => 31 => 311 => 311.2 ...), and define description for the 3, 31, 311... french dewey has been commited & you can see the result at : http://o17.bureau.paulpoulain.com/cgi-bin/koha/opac-browser.pl It should be easy to add english dewey, Loc classification or any other hierarchic classification. TO DO : - improve the build_... script, to have an option to update only last-week bilbio modifications. This can be made easily, but at the price of imprecision in the counters, which is cheap imho. The "complete" calculus can be run once a month anyway. But note that, on my computer, it calculates 50 biblios/seconds - add a screen, in admin section, to let the library define their descriptions for the browser. -- 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

2 2