January 2004 - Koha-devel - lists.koha-community.org

re searching databases
by COURYHOUSE＠aol.com 14 Jan '04

14 Jan '04

Pate - Steve et al. here is the link i mentioned http://69.94.4.132/perlarchive.com/guide/Searching/Databases/index.shtml

1 0

Perl / regexp question
by paul POULAIN 12 Jan '04

12 Jan '04

Hi, In the translator tool, we have a little problem. We have the following strings in templates : <a href="/koha/search.pl">search</a> the library. In the translation file for french, we have : search chercher So, the regexp : $line =~ s/(\W)$text(\W)/$1$subst$2/g; gives : <a href="/koha/chercher.pl">chercher</a> dans la bibliothèque. that is WRONG !!! (search.pl must not be replaced !) & I couldn't find the regexp that could work better. I tried to use HTML::Tree, HTML::TreeBuilder, but without success : it doesn't enjoy HTML::Template syntaxt & create bad HTML :-( I also tried to play with HTML::Parser, but without success neither. For instance, the workaround is NOT to replace strings translated by IGNORE, but that's really a poor way to do it, as some things are no more translated. but i'm still looking for a better solution to do this. Note : remembre we can also have <img src="XX" alt="search"> and this search is to be replaced... -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

biblioitems.place & item location (Call Number ?)
by paul POULAIN 12 Jan '04

12 Jan '04

Hi, I try to figure what biblioitems.place field is done for & I can't find. I also try to find where is the "location" (Call Number ?) of a given item is hidden in items table & i can't find neither. It may be stored in biblioitems (biblioitems.classification) table, but it's a poor choice imho, as 2 differents items can be located in 2 differents places. So I think we lack a field in items table. If you confirm we do, i'll rename "bulk" field to CN & modify OPAC accordingly. Other way to say this : I think Koha works fine if location is found with dewey or another classification number, but NOT when you have a library with a "strange" location method (like the one i'm working on at the moment...) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Re: Koha translation
by paul POULAIN 12 Jan '04

12 Jan '04

Desarrollo Koha a écrit : > >>> DO NOT translate manually the spanish templates, that are outdated >>> you're right. >>> But look in misc/translator directory, file translator_doc.txt >>> >>> ¿where ?. I have downloaded the koha-2.0.0RC1.tgz file from >>> sourceforge and i can not find the file you are talking about. >> >> It is NOT in 2.0.0RC1, only in CVS. >> if you don't want to play with CVS, i can send you the 4 interesting >> files. Ask me. > > > Ok, I have found that in CVS, but it seems to have problems in order > to translate to spanish. > > Some of the strings (with more than one word) are ignored (the > "Advanced Search (More Options)" for instance). > > I don't know how to solve that. And I don't think the english > expressions can be easily translated (with the embeded variables). > I will be working in the translations :-):-) (with the automated > translator while possible) I think the problem is only on strings where there is a regexp special char, like ()$^... I've fixed this in CVS/rel2_2_0. Tell me if it's better now. PS : pls post in koha-devel/koha-translate. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Re: [Koha] Kohas Z39.50 Server - re UNIMARC
by baljkas＠mb.sympatico.ca 12 Jan '04

12 Jan '04

Friday, January 9, 2004 18:20 CST Hi, Joshua. et al. Just a quick reply re your parenthetic point for Paul, to wit, >(BTW, Paul, you said to remind you to commit this change to CVS; I'm > not sure but I wouldn't be surprised if UNIMARC's leaders were a bit > different, so maybe we should hold off on that [snip]) my reading of the UNIMARC standards (cf. URL <http://www.ifla.org/VI/3/p1996-1/concise.htm>) indicates that the Leader and Directory have the same structure as MARC21 (and for that matter, USMARC and CANMARC). Just FYI. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada

3 2

Koha's Z39.50 Server
by Joshua Ferraro 09 Jan '04

09 Jan '04

Hiya, I've just committed a _basic_ Z3950 Server to CVS (in the HEAD Branch; in the z3950/server/ directory) and I wanted to make a few comments about it. (BTW: is everyone ok with moving the files in z3950 to z3950/client/ ?) First of all, the it's built using Indexdata's SimpleServer perl module Version 0.07, so if you want to use it you will have to install SimpleServer which you can get from: http://ftp.indexdata.dk/pub/simpleserver/ (BTW: whoever is doing the Koha installation script and documentation on dependencies may want to add SimpleServer). Secondly, you will need to change the leader information in Koha's MARCgetbiblio subroutine in Biblio.pm to reflect the following (or if you know how to manipulate the leader you can change it to reflect your data; this example leader should be functional for all MARC21 data). Look for the following near line 700: #---- TODO : the leader is missing $record->leader(' '); and change it to: #---- TODO : the leader is partly fixed for MARC21 $record->leader(' nac 22 1u 4500'); (BTW, Paul, you said to remind you to commit this change to CVS; I'm not sure but I wouldn't be surprised if UNIMARC's leaders were a bit different, so maybe we should hold off on that; also, I've also got some other leader qualms but they will have to wait for another email) So the actual server is implemented in a single Perl script for now (I plan to break it up for the next version) and you can get it from CVS or from my website at: http://kados.org/LibraryScience/zed-koha-server.pl (it's there for the folks who don't use CVS) You may need to change the permissions on the script--as root run: [jmf@koha]koha#chmod 755 zed-koha-server.pl Run the zed-koha-server.pl script as root: [jmf(a)koha]#./zed-koha-server.pl The server will take care of managing the network connections for you (it runs on port 9999), and it will spawn a new process whenever a new connection is received. The script implements a search handler and a fetch handler which allows Z3950 clients to query and retrieve records in MARC21 (the only record format it supports so far). It's set up to log to the terminal so you will need to keep the terminal running or the script will stop (I think it's the same with Koha's Z3950-Client; some day it would be nice to log to a file and run it as a service...). Let me say a word about holdings data. Right now, for historical reasons, most MARC21 installations of Koha probably use the 852 tag to store holdings data (actually I'm not sure there are any other MARC21 installations of Koha besides Nelsonville :-) ). For example, Nelsonville Public Library uses the following: 852a Organization code 852b Home branch 852h Classification 852p Barcode However, many Z3590 clients aren't set up to pull holdings data from the 852x fields but from the 952x/942x fields. So for now I've hard-coded the server to automatically duplicate the data like this: ## Convert from 852/4 to 952: ## 942a --> 852a Organization code ## 952b --> 852b Home branch ## 942k --> 852h Classification ## 952p --> 852p Barcode So the MARC record has the data in both places. If you're fluent in Perl and you look through the documentation for SimpleServer you will see that I have implemented query-parsing using a series of very clumsy substitutions. Right now I'm working on rewriting the search_handler to use the RPN member which will allow for much cleaner parsing of the query and will make it much easier to implement new features like Boolean. But the clumsy version should work fine in most cases--Nelsonville Public Library System has been using it for about two months to interface with the statewide resource sharing program MORE with no problems. I think that's it. Let me know how it works out or if you have any questions. -- Joshua Ferraro

1 0

z3950 searches
by paul POULAIN 09 Jan '04

09 Jan '04

Hi, on rel_2_0 branch, i've just commited a processqueue improved, bugfixed & documented. Seems to work ihghly better (in non working situations & when killed/relaunched) & (hopefully) is more readable. TEST IT PLEASE & report any feedback. Note : an index has been added to z3950results table : CREATE TABLE z3950results ( id int(11) NOT NULL auto_increment, queryid int(11) default NULL, server varchar(255) default NULL, startdate int(11) default NULL, enddate int(11) default NULL, results longblob, numrecords int(11) default NULL, numdownloaded int(11) default NULL, highestseen int(11) default NULL, active smallint(6) default NULL, PRIMARY KEY (id), UNIQUE KEY query_server (queryid,server) <<<<==== INDEX ADDED ) TYPE=MyISAM; -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

And finally... bug 662
by MJ Ray 09 Jan '04

09 Jan '04

I've almost finished committing fixes for bug 662 to the 2.0 branch. That's the one with DBI calls using interpolation instead of placeholders, which is a common way for user input SQL insertion attacks. I think it's a blocker, but Paul hasn't agreed. Can these fixes be copied to HEAD/2.1, please? I'm assuming that the updater scripts are never run from the web and leaving them alone for now. Is that correct? Three comments from the last round of fixes: 1. The same code repeated lots is probably an indication that something isn't right; 2. Helpers like counters of array length can often be done another clearer way; 3. dbh->quote() is very rarely needed. Finally, sorry if I broke anything. Since the first problems, I'm checking with perl -c as much as possible, but it's not all been tested in place yet. -- MJR/slef My Opinion Only and possibly not of any group I know. Please http://remember.to/edit_messages on lists to be sure I read http://mjr.towers.org.uk/ gopher://g.towers.org.uk/ slef(a)jabber.at Creative copyleft computing services via http://www.ttllp.co.uk/

3 4

New User
by Desarrollo Koha 08 Jan '04

08 Jan '04

Hello: I come from Sevilla (Spain) and I am trying to translate koha 2,0RC1 to spanish in order to use it at the "Conservatorio Superior de Musica Manuel Castillo de Sevilla", a school music where we want to replace the Windows proprietary software for the library management with an Open Source solution (better for Linux systems). I have been looking for different systems and I think koha may be the best solution for our requeriments. I would like to know how to release the work to the community while I am translating that (Currently working on the default theme). I have found that could be a good thing to work in some kind of replacing the "hard coded" text with gettext (the original spanish translation is quite old comparing the templates with the english ones and it doesn't work well), and it could take advantages to maintain the translations without changing code. I would like to know future plans and new feature releasing. Thank you for that great product. Pablo Villanueva

3 3

Languge problem
by zuxiaolong 08 Jan '04

08 Jan '04

Hi, my system: debian sid+ mysql+apache2.0.48(compiled)+gnome2.4 First question:I installed Koha2.0rc1 in my debian sid system. Everytihing is in english. After I installed some environment packages(something like french-environment), koha displays in french. Then I uninstalled it using apt-get remove, the file (http://debian:8080/cgi-bin/koha/acqui.simple/addbiblio.pl)still displays french even after reinstalled Koha. How can I do to turn it back to english? Second question: catmaintain.pl does not work with a error message:Internal Server Error. Third question: z3950search, e.g. javascript:PopupZ3950(), just give me a window saying "still ?? requests to go ". As a newcomer,I wonder if Koha could afford a remote accesss as a part of a wider website? Best Regards -- zuxiaolong hugojoe(a)fastmail.fm -- http://www.fastmail.fm - Send your email first class

1 0