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

Re: [Koha-devel] Total issues
by Owen Leonard 23 Mar '04

23 Mar '04

> Owen, it's just a link to bookcount.pl. The > moredetail.pl script only > works with data on the biblioitem level ... > The bookcount.pl script goes a > layer deeper and retrieves data by itemnumber. That's just the information I was looking for. It sounds like the template could be changed to make it clearer. Thanks, Owen

1 0

Total issues
by Owen Leonard 22 Mar '04

22 Mar '04

One of the items listed by moredetail.pl is 'Total Issues:' It's an active link, but it doesn't list a number there on moredetail.pl. Should it? Or is it just a way to link to bookcount.pl? -- Owen

2 1

Re: [Koha-devel] new features to test
by paul POULAIN 22 Mar '04

22 Mar '04

Stephen Hedges wrote: >Paul - > >I've been testing the changes you made to search.marc/search.pl and >SearchMarc.pm and thought you would like to see some results. > yep, thanks. >First some questions. The "query" that gets displayed as you are building >the search is confusing. It always seems to start with "biblioitems.illus >contains ''." Is that actually correct? And does the query start by >using the koha fields? Is that where it's finding the tags to search on? >(I should have taken a closer look at your code.) > a bug, probably. that's why it's in HEAD branch :-D >Also three general problems. The marclist seems to be broken, since it is >not available in the pull-down menu (neither in the default template nor >the npl template). And MARCdetail.pl never seems to display any results. >And all of the queries are followed in the log with this error: > >DBD::mysql::st execute failed: Unknown column 'seealso' in 'field list' at >/usr/local/koha/intranet/modules//C4/Biblio.pm line 235. >[sounds like we need to updatedatabase] > yes ;-) >So now for some search results -- > >* Search on keyword "dog" (worked OK): >explain select distinct m1.bibid from >biblio,biblioitems,marc_biblio,marc_word as m1 where >biblio.biblionumber=marc_biblio.biblionumber and >biblio.biblionumber=biblioitems.biblionumber and >m1.bibid=marc_biblio.bibid and (m1.word like 'dog%' and >m1.tag+m1.subfieldid in ('')) order by biblio.title; >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| table | type | possible_keys | key | key_len | ref > | rows | Extra | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| m1 | range | bibid,word | word | 255 | NULL > | 2200 | Using where; Using temporary; Using filesort | >| marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid > | 1 | Using where; Distinct | >| biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | >marc_biblio.biblionumber | 1 | Distinct > | >| biblioitems | ref | bibnoidx | bibnoidx | 4 | >biblio.biblionumber | 12 | Using index; Distinct > | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ > Nice result set : 2200 x 1 x 1 x12 rows to parse. Not too many. >* Search on author "Henry" (worked OK): > <snip> >* Search on author "Sue Henry" order by author (worked _very_ well!) > <snip> >* Search on author "Sue Henry" order by title (worked _very_ well!) > <snip> >* BUT NOTE -- Search on author "Henry, Sue" did NOT work: >select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as >m1,marc_word as m2 where biblio.biblionumber=marc_biblio.biblionumber and >biblio.biblionumber=biblioitems.biblionumber and >m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word like >'henry,%' and m1.tag+m1.subfieldid in ('100a'))and (m2.word like 'sue%' >and m2.tag+m2.subfieldid in('100a'))) order by biblio.author >[no results returned] >* Search on title "I'll be home for Christmas" (failed): >select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as >m1,marc_word as m2,marc_word as m3 where >biblio.biblionumber=marc_biblio.biblionumber and >biblio.biblionumber=biblioitems.biblionumber and >m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid) >and ((m1.word like 'I'll%' and m1.tag+m1.subfieldid in ('245a'))and >(m2.word like 'home%' and m2.tag+m2.subfieldid in('245a'))and (m3.word >like 'Christmas%' and m3.tag+m3.subfieldid in('245a'))) order by >biblio.title >DBD::mysql::st execute failed: You have an error in your SQL syntax. >Check the manual that corresponds to your MySQL server version for the >right syntax to use near 'll%' and m1.tag+m1.subfieldid in ('245a'))and >(m2.word like 'ho >[we need to escape apostrophes] > we need to remove ' and , and other useless characters. enter a bugs.koha.org pls >* Search on barcode (worked very well): >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| table | type | possible_keys | key | key_len | ref > | rows | Extra | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| m1 | range | bibid,word | word | 255 | NULL > | 1 | Using where; Using temporary; Using filesort | >| marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid > | 1 | Using where; Distinct | >| biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | >marc_biblio.biblionumber | 1 | Distinct > | >| biblioitems | ref | bibnoidx | bibnoidx | 4 | >biblio.biblionumber | 12 | Using index; Distinct > | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ > wonderful :1 x 1 x 1 x 12 rows to parse in the DB !!! For a 1Gb DB if your test DB is a copy of your real one ? >* Search ("Q2") on keyword "England" and itemtype "AB" (failed--returned >no results); >explain select distinct m1.bibid from >biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2 where >biblio.biblionumber=marc_biblio.biblionumber and >biblio.biblionumber=biblioitems.biblionumber and >m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word like >'england%' and m1.tag+m1.subfieldid in (''))and (m2.word like 'AB%' and >m2.tag+m2.subfieldid in('item'))) order by biblio.title; >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| table | type | possible_keys | key | key_len | ref > | rows | Extra | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ >| m1 | range | bibid,word | word | 255 | NULL > | 5377 | Using where; Using temporary; Using filesort | >| marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid > | 1 | Using where; Distinct | >| biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | >marc_biblio.biblionumber | 1 | Distinct > | >| biblioitems | ref | bibnoidx | bibnoidx | 4 | >biblio.biblionumber | 12 | Using index; Distinct > | >| m2 | ref | bibid,word | bibid | 8 | m1.bibid > | 20 | Using where; Distinct | >+-------------+--------+----------------------+----------+---------+--------------------------+------+----------------------------------------------+ > mmm... this one is important : the marc_word does NOT store words <= 2 letters. sub MARCaddword { # split a subfield string and adds it into the word table. # removes stopwords my ($dbh,$bibid,$tag,$tagorder,$subfieldid,$subfieldorder,$sentence) =@_; $sentence =~ s/(\.|\?|\:|\!|\'|,|\-|\"|$|$|\[|\]|\{|\})/ /g; my @words = split / /,$sentence; my $stopwords= C4::Context->stopwords; my $sth=$dbh->prepare("insert into marc_word (bibid, tag, tagorder, subfieldid, subfieldorder, word, sndx_word) values (?,?,?,?,?,?,soundex(?))"); foreach my $word (@words) { # we record only words longer than 2 car and not in stopwords hash if (length($word)>2 and !($stopwords->{uc($word)})) { $sth->execute($bibid,$tag,$tagorder,$subfieldid,$subfieldorder,$word,$word); if ($sth->err()) { warn "ERROR ==> insert into marc_word (bibid, tag, tagorder, subfieldid, subfieldorder, word, sndx_word) values ($bibid,$tag,$tagorder,$subfieldid,$subfieldorder,$word,soundex($word))\n"; } } } } What should we decide here ? * also store <=2 letters word. * say that itemtype & other fields must be >2 chars ? >Hope this helps --- Stephen > yes, thanks a lot. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Bug importing MARC records?
by Edward M. Corrado 20 Mar '04

20 Mar '04

Hello all, I have a fresh install of Koha 2.0.0RC4 and I want to import some MARC records. I tried using the bulkimport.pl script, but it seems I am getting some errors. The errors say: DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 289 DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /usr/local/koha/intranet/modules/C4/Biblio.pm line 371 They just keep repeating. I assumed that it was getting the password from pass=XXX in /etc/koha.conf, so I checked that and I have the correct password there. I then tried the script with more verbose output. It said it was adding the records - so I looked and indeed they were added. Is the error messages a bug or am I doing something wrong? Thanks, Edward Corrado

5 9

Katipo style number validation
by T & J Kotula 19 Mar '04

19 Mar '04

Hi, Could someone point me to what would need to be done to include "Katipo" checksum validation of the barcode field on the /cgi-bin/koha/acqui.simple/additem.pl page. Many thanks tomasz kotula.

2 1

minor bugs (2.0.0RC4)
by T & J Kotula 19 Mar '04

19 Mar '04

Hi all, I noticed a few minor bugs - it looks like HTML is partially broken for the following pages (I kicked out IE and now I'm using Mozilla): http://192.168.5.22:8080/cgi-bin/koha/acqui.simple/websitesearch.pl http://192.168.5.22:8080/cgi-bin/koha/maint/catmaintain.pl In addition to this, when someone is logged in with: borrow & reserve & view catalogue permissions they can go to the following pages. I don't think this is serious as they can not do any damage from those pages (I can do lots more damage as kohaadmin with my very limited knowledge :-) http://192.168.5.22:8080/cgi-bin/koha/shelves.pl?shelves=1 and add shelves etc. http://192.168.5.22:8080/cgi-bin/koha/maint/catmaintain.pl On this page Koha does not show who is logged in. http://192.168.5.22:8080/cgi-bin/koha/acqui.simple/websitesearch.pl Tomasz Kotula.

2 1

Re: [Koha] Z3950 "Still ?? requests to go"
by MJ Ray 18 Mar '04

18 Mar '04

On 2004-03-18 18:22:54 +0000 Charles Erwin <cerwin(a)transy.edu> wrote: > Hello, I tried to add a biblio on the intranet menu for Koha 2.00RC4 > and I > get the message > "Still ?? requests to go". What does this mean? It acts like it's > not even > processing the ISBN I entered. Is the z3950daemon running? Its startup script is in intranet/scripts/z3950daemon. Developers, could we display "Z39.50 Not Running" instead of "Still ?? requests to go"? (Please reply to one list or other, not both.) -- 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/

1 0

Automated Library systems software - Urgent (fwd)
by Pat Eyler 15 Mar '04

15 Mar '04

I've already replied to the below, but if anyone is interested in replying to an RFP please let me know so that I can forward information when it gets to that point. -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org ---------- Forwarded message ---------- Date: Mon, 15 Mar 2004 13:53:51 -0600 From: Pat Wende <PWENDE(a)SPASD.K12.WI.US> To: LM_NET(a)LISTSERV.SYR.EDU Subject: Automated Library systems software - Urgent We need to send a RFP for an update/replacement for our automated system. We want a union catalog system. Please send me names of systems you recommend. TIA It's one of those things that I needed yesterday! Pat Wende K-12 Library Media Coordinator Royal Oaks Elementary School Sun Prairie, WI 53590 pwende(a)spasd.k12.wi.us 6088347223 "What a school thinks about its library is a measure of what it thinks about education." - Howard Howe, former U.S. Commissioner of Education =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=- All LM_NET postings are protected by copyright law. To change your LM_NET status, e-mail to: listserv(a)listserv.syr.edu In the message write EITHER: 1) SIGNOFF LM_NET 2) SET LM_NET NOMAIL 3) SET LM_NET MAIL 4) SET LM_NET DIGEST * Allow for confirmation. LM_NET Help & Information: http://www.eduref.org/lm_net/ Archive: http://www.eduref.org/lm_net/archive/ EL-Announce with LM_NET Select: http://elann.biglist.com/el-announce/ LM_NET Supporters: http://www.eduref.org/lm_net/ven.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-

1 0

SearchMarc.pm
by Chris Cormack 10 Mar '04

10 Mar '04

Hi All Especially Joshua. Ive been thinking on starting work on Query.pm our top level search module. And im thinking of using Joshua's SearchMarc.pm module as one (if not its main) backend. Heres what im thinking Query.pm creates an object. On creating the kohaquery object you pass it a string which describes your search. Pat and Steve were discussing perhaps using a syntax like googles. Eg something like my $query=Query::new("title: elephants (author: johnson | author: tonnesen)") you then can do things like $num_of_results=$query->count(); my $results=$query->results(-sortby => 'title', -limit=>10, -offset=>'10'); So the Query module does all the hard work, and then all search.pl needs to do is craft the search string. So making new searches, or searching new combinations of data should be easy. Now joshua has written a module SearchMarc.pm which searches the marc tables to return data, so I was thinking of using Query.pm to parse the searchstring and construct the appropriate variables to call catalogsearch in SearchMarc Good, Bad, stupid idea? Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

5 7

Language Field in Biblio table
by Chris Cormack 10 Mar '04

10 Mar '04

Hi All As part of the work we did for UNIDO we added a language field to the biblio, so you could specify the language a book was written in. We also made this searchable from the intranet and the opac. Now that we have a stable fork, I was thinking i'll add this into the cvs HEAD if people think its a useful feature. Ill also check what other changes I made and if they are useful add those as well. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

3 2