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

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

speed koha
by long_sam.tw 20 Dec '06

20 Dec '06

Hello,all I find koha slowly,I suggest using CGI::SpeedyCGI perl module, it really make koha fast. laxendion ___________________________________________________ 您的生活即時通－溝通、娛樂、生活、工作一次搞定！ http://messenger.yahoo.com.tw/

1 0

rel_3_0, zebra 2.0 & updating Koha through ZOOM (or : high load tests at SAN-OP)
by Paul POULAIN 15 Dec '06

15 Dec '06

Hi, The SAN-OP did some high load tests this week, with all librarians (around 100 computers) working with rel_3_0... Just to remember : 300 000 items, 7 branches. Here are some results : - with mod_perl activated & innoDB database for mySQL = good response times, some major problems on tuesday, solved on wednesday, everything OK on thursday - without mod_perl & innoDB database for mySQL = (really) too slow to be usable. - without mod_perl & myISAM database for mySQL = good response times, but we lack advanced features from innoDB (like foreign keys... + if I don't mind, myISAM is no more the default DB under mySQL 5.0) - they worked on zebra 2.0, with zebra real-time updates activated (zebraop NOT commented in Biblio.pm). The bad news : they face the same behaviour as joshua with zebra 1 :-((((( So, our friends from Indexdata still can't insure that we can use ZOOM to update biblios... - as a reminder : the 3.0 french translation is almost done, but pascale Nalon, that works on it has found some inconsistency in OPAC strings (like book bag & basket both used) The move to production will be on january, 3rd, keep fingers crossed... cheers -- 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 1

spell suggestion in rel_3_0 (for kados 1st)
by Paul POULAIN 15 Dec '06

15 Dec '06

Hi world, in opac-search.pl, rel_3_0, there is a spelling suggestion when the search don't return any answer. It is based on some hardcoded database : DBI->connect( "DBI:mysql:suggest:66.213.78.76", "auth", "Free2cirC" ); I tried to activate it, but get a : > [Fri Dec 15 16:33:55 2006] [error] [client 193.251.63.39] DBI connect('suggest:66.213.78.76','auth',...) failed: Host 'paulpoulain.pck.nerim.net' is not allowed to connect to this MySQL server at /home/paul/koha.dev/rel_3_0/opac/opac-search.pl line 578, referer: http://o18.bureau.paulpoulain.com/cgi-bin/koha/opac-search.pl which is not a surprise to me ;-) then I took my mining light, and entered the caves... I found : make_spellcheck_suggest.pl, in misc directory. This script seems to have some problems : - it relies on marc_subfield_table & marc_word, that don't exist anymore - something is missing at line 97 : %tables variable is missing some tables descriptions (& a "; at the end...) - it works with soundex algorythm, that is very poor in french (it doesn't take care of accents & other french-specific things) opac-search.pl itself seems to have problems too : - $koha_spsuggest_insert is never called : is it a feature you have abandonned ? I was wondering : - if there is a more uptodate script that you forgot to commit, because this one can't work (I can't find the script in dev_week) ? - if we could use a specific soundex, depending on the language : there are some well working soundex_like algorythm for french & I bet other languages have their. That would require removing the str_cmp(soundex(suggestion),soundex(?)) from opac-search - if we could use Aspell for spellchecking. I tried to investigate this option, it works very very well with common names, and we mostly want it to work for proper names like authors, so I think it's not something to investigate too deeply. - who will be the next french president, in 2007, May ? ooooops... you probably don't have the answer to the last question, but the other one yes ;-) -- 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 1

Koha Blog Aggregator
by Joshua M. Ferraro 15 Dec '06

15 Dec '06

So what's up with the Koha Blog Aggregator? It seems to be unmaintained. I think we should either link it to the places developers are blogging (or other feeds, etc.) or remove it from the home page. Here are a few active feeds (not all blogs) that might be worth adding: MJ Ray: http://mjr.towers.org.uk/blog/all.rss Katipo developers blog: feed://http//blog.katipo.co.nz/?feed=comments-rss2 My personal blog://http//kados.org/feed/ LibLime's news: http://liblime.com/news/RSS The developer wiki: http://wiki.koha.org/feed.php Anyone know of any other koha-related blogs/feeds? 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 4

About serials claim/late issues
by Henri-Damien LAURENT 13 Dec '06

13 Dec '06

Hi I have some questions about serials Module. It seems that some functions are broken in rel_3_0. For instance, when getting on claims page, looking at the logs, i see : Undefined subroutine &main::bookseller This function I guess is supposed to get a bookseller and (hopefully) retrieve the list of late or waiting issues. But this function exists nowhere in rel_3_0 Code. Would you have a Copy of the *.pm files you use ? I also saw claim form 1 2 3 4 in claims.pl code. And I wonder what those forms are linked to ? Where they are ? What they are likely to be ? How they get processed ? -- Henri-Damien LAURENT

2 1

koha 2.2.7 & koha rel2_2
by long_sam.tw 11 Dec '06

11 Dec '06

Hello,all After install koha 2.2.7,koha don't work well. you must modify koha-http.conf Add SetEnvIf Request_URI "\.pls" PERL5LIB"/usr/local/koha/intranet/modules" SetEnvIf Request_URI "\.pls" KOHA_CONF "/etc/koha.conf" to koha.conf,koha still have some functions don't work. my soultion,you can add use lib 'your path/modules';（place in front of use C4::modules.） to every koha perl script,use script help you do it. So, you don't modify koha-http.conf script：http://kohaa.blogspot.com/2006/12/test-note.html Longshan ___________________________________________________ 您的生活即時通－溝通、娛樂、生活、工作一次搞定！ http://messenger.yahoo.com.tw/

1 0

Problems with exchange rates
by José Parrella 11 Dec '06

11 Dec '06

Greetings, I'm trying to setup the exchange rates in a test Koha setup. The currency of my country, VEB, is at 2150 VEB per USD. So I'm setting up VEB with a rate of 1, and USD with a rate of 2150, but I always end up with 99.99999 VEB per USD. This is happening with Koha 2.2.7 in a Debian Sarge system. After peeking in currency.pl and C4::Acquisition, I changed the data type for the "currency" table with the following SQL statement: ALTER TABLE currency CHANGE rate rate float(9,5); I'm now able to use this value in the Acquisitions module. Is this the right way to achieve this? If so, are you planning on changing the default data type for the "rate" column in the next releases? Jose -- José M. Parrella -> Debian Sid, k2.6.17.13 Escuela de Ingenieria Electrica Universidad Central de Venezuela -> ucvlug.info

1 0

Subject heading translation in Z.3950 records
by José Parrella 10 Dec '06

10 Dec '06

Greetings, Is anyone working with heading translation in the Z3950 modules? I had an idea about translating MARC 650 fields from a Z3950 records, so the subject headings are "translated" when they are imported into Koha. As of now, I'm using Lingua::Translate to translate 650a records taken from LOC's Z3950 server from english to spanish. I would like to work on this feature if nobody's working on that, or if the new Z3950 features are not going to change that much in next releases. I've currently accomplished this through a last-minute access to the proper MARC::Field in the desired MARC::Record before it gets into the marc_breeding table. I'm yet to do several stuff, like trying to integrate this into the parameters system and providing other options, like Tie::'ing to a dictionary (definitely Babelfish translations aren't that accurate) Two brief questions: is z3950_results going to be used from now on? and, only 650a records are taken into account by Koha? Also, please let me know if there's something blatantly wrong in what I'm doing. Thank you very much for your time, Jose -- José M. Parrella -> Debian Sid, k2.6.17.13 Escuela de Ingenieria Electrica Universidad Central de Venezuela -> ucvlug.info

1 0