- Koha - lists.katipo.co.nz

Item not for loan problem
by Pauley 31 Aug '07

31 Aug '07

Hello; I have imported items using bulkmarcimport.pl and most seem to work fine. My reference materials say they are available but when I try to issue one I get : Error Issuing Item: Item not for loan The itemtype is REF and description is Reference. I have filled out all the fields in the Issuing Rules, changed and resaved them a number of times. Am I missing something somewhere that would block the issuing of these items? I have looked at the field for "use restrictions" (field y in "Items") and that is set to 0. Here is the error I get from the error log: HERE : 0 / (3 for 1 at /usr/local/koha/intranet/modules/C4/Circulation/Circ2.pm line 650., referer: http://library.lyncs.org:8010/cgi-bin/koha/circ/circulation.pl I was getting a fetchrow() error but I enabled large tables in mySQL and that seemd to go away. So, any Ideas? Thanks for your help Paul Davis Lynden Christian Schools -- View this message in context: http://www.nabble.com/Item-not-for-loan-problem-tf4351355.html#a12398715 Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Z39.50 error important
by mohamed fekry 31 Aug '07

31 Aug '07

hi all i'm using koha 2.2.8 and whem i'm tried using z39.50 gives me server error . could any one help me to solving this problem .many thanx _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx…

2 1

XSS Vulnerabilities in Koha
by Andrew Yager 30 Aug '07

30 Aug '07

Hi, First let me say that this is not a very serious security issue, so please don't freak out. We've just done an audit of Koha (OPAC and Intranet) and have found a number of XSS vulnerabilities in the code. This allows a malicious attacker, with a carefully crafted web site to potentially trick your users into providing sensitive information to a site other than yours (e.g. usernames and passwords). Is anyone aware of patches for these currently in circulation? If not, I'll have a look at the problems and attempt to address them and then release a patch. Thanks, Andrew Some info about XSS: http://sandsprite.com/Sleuth/papers/RealWorld_XSS_1.html http://www.cert.org/tech_tips/malicious_code_FAQ.html http://www.cgisecurity.com/articles/xss-faq.shtml _________________________ Andrew Yager, Managing Director (BCompSc MACS) Real World Technology Solutions Pty Ltd ph: 1300 798 718 or (02) 9563 4840 fax: (02) 9563 4848 mob: 0405 152 568 http://www.rwts.com.au/ _________________________ Real World Technology Solutions is an Authorised Apple Reseller, Telstra Dealer, Microsoft Small Business Solutions Specialist, Cisco Registered Partner and Member of Open Source Industry Australia.

2 1

(no subject)
by Obaidullah 30 Aug '07

30 Aug '07

We are facing a problem after transferring data from WINISIS to Koha. The following steps are adopted during data transfer. 1. In the first stage the Data is transferred from WINISIS to MS Excel. 2. In the 2nd step the Data in MS Excel is transferred to MS Access . 3. In the 3rd step the Data in MS Access is transferred to MYSQL But unfortunately, when the data search operation is applied in Koha, the transferred data through above steps cannot be searched. If we insert data through Koha directly, that data can be searched but if we transfer the data through the above mentioned three steps then the data cannot be searched. Your valued comments and guidance will be highly appreciated. Obaidullah

1 0

Barcode generation
by Noel Goodman 29 Aug '07

29 Aug '07

Has anyone tried using a barcode generating software to generate custom barcodes for koha? If any successful attempt was made I would like to know what software works and how do we interface it with koha. Thanks Noel Goodman - University of Guyana Image by FlamingText.com --------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.

3 2

Re: [Koha] Barcode generation
by BWS Johnson 29 Aug '07

29 Aug '07

Salvete! >What I wish we could do on Koha is use the ISBN barcodes on our books >as the identifier. That would simplify everything, excepting the >multiple copies and those books that lack barcodes entirely. >Paul Scaer >Science Leadership Academy >Philadelphia Koha absolutely could do this. You'd just need to turn the auto generate barcode feature off then scan in the ISBN barcode when you get to the items screen in Add Biblio cataloguing. For multiple copies, you could always use an existing barcode you have on hand OR put an additional digit for the copy number after the ISBN barcode by hand. Depending on how many you had that lacked barcodes entirely, you could purchase vendor barcodes or generate a few thousand using either a separate utility or the built in generator prior to turning that feature off. Does this make any sense to you? Cheers, Brooke @ Hinsdale MA

1 0

addbiblio.pl still failing
by Grant Johnson 29 Aug '07

29 Aug '07

Related to 050/090 in Parameters? - addbiblio.pl scripts is still failing. Does this have to with the MARC tags in the records trying to be imported? I can import a batch into the Reservoir but "add a biblio and go to Item" causes addbiblio.pl to ask "What do I want to do with the file?" Can I see the contents of the Reservoir? Here's koha-error_log: Hoping for some idea's! Cheers [Tue Aug 07 15:43:56 2007] [error] [client 137.149.66.73] File does not exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] something went wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 135., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] something went wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 135., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] doing the search at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] doing the search at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 1 (connect), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 6 (send apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 2 (send data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 0: event 1 (connect), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 0: event 6 (send apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 0: event 2 (send data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 0: event 10 (end), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] info.library.mun.ca at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 161., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] 0 info.library.mun.ca error @attr 1=4 "245": Connect failed (10000) info.library.mun.ca:2200, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 3 (receive data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 7 (receive apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 6 (send apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 2 (send data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 3 (receive data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 7 (receive apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 9 (receive search), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] connection 1: event 10 (end), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:43:59 2007] [error] [client 137.149.66.73] unicorn.cs.upei.ca at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 161., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:00 2007] [error] [client 137.149.66.73] File does not exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl [Tue Aug 07 15:44:14 2007] [error] [client 137.149.66.73] File does not exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] something went wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 135., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] something went wrong: No error at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 135., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] doing the search at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] doing the search at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 145., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 1 (connect), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 6 (send apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 2 (send data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 0: event 1 (connect), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 0: event 6 (send apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 0: event 2 (send data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 0: event 10 (end), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] info.library.mun.ca at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 161., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] 0 info.library.mun.ca error @attr 1=4 "sunwing": Connect failed (10000) info.library.mun.ca:2200, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 3 (receive data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 7 (receive apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 6 (send apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 2 (send data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 3 (receive data), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 7 (receive apdu), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 9 (receive search), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] connection 1: event 10 (end), referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] unicorn.cs.upei.ca at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 161., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl?oldbiblionumber=&t… [Tue Aug 07 15:44:16 2007] [error] [client 137.149.66.73] File does not exist: /usr/local/koha/intranet/htdocs/intranet-tmpl/default/en/includes/intranet.css, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/z3950/search.pl [Tue Aug 07 15:44:43 2007] [error] [client 137.149.66.73] Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,marc_subfield_table as m6 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.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid) and ((m1.word like 'Sunwing' and m1.tagsubfield in ('245a'))and (m2.word like 'Oppel' and m2.tagsubfield in('245b'))and (m3.word like 'Kenneth' and m3.tagsubfield in('245b'))and (m4.word like '21' and m4.tagsubfield in('100a'))and (m5.word like 'cm' and m5.tagsubfield in('100a'))and (m6.subfieldvalue = 'HarperCollins,' and concat(m6.tag,m6.subfieldcode) in ('300c'))) order by biblio.title ASC term is Sunwing Oppel Kenneth 21 cm HarperCollins, at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 274., referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbibli… [Tue Aug 07 15:44:43 2007] [error] [client 137.149.66.73] Arguments must be MARC::Field object at /usr/local/koha/intranet/modules/C4/Biblio.pm line 1430, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbibli… [Tue Aug 07 15:44:43 2007] [error] [client 137.149.66.73] Premature end of script headers: addbiblio.pl, referer: http://osls.cs.upei.ca:8080/cgi-bin/koha/acqui.simple/addbiblio.pl?oldbibli… F. Grant Johnson Systems Coordinator Robertson Library University of Prince Edward Island

3 5

Re: [Koha] Import query (S P Suresh)
by Martin Morris 29 Aug '07

29 Aug '07

Hello Suresh, I'm no koha expert, but I would solve your problem by writing a little perl script to convert your data into MARC format and then import it into your new Koha installation. I had to do something similar to import data for a library I'm migrating to koha, which currently uses a little custom script to parse its biblios which are held in a text file, each line something like this: munns donaldw|londonanidoj|p||MUNNS, Donald W|812 -311.2 MUN| Londonanidoj|Rickmansworth (GB)|Esperanto Publishing Company|1946| 98p. 18cm.||K19b Munns 424| The script I used is very quick and dirty, and looks like this (I can send the whole thing if you'd like...): ------ #!/usr/bin/perl -w use strict; use MARC::Record; use Data::Dumper; open (KOHADATA, "ludkatalogo.txt"); open(OUTPUT, '> katalogo.mrc'); my $c = 0; my @marcfields; while ( <KOHADATA> ) { $c++; print "\n$c\n"; @marcfields = split(/\|/,$_); print $marcfields[5]; # Create a new record my $record = MARC::Record->new(); $record->encoding( 'UTF-8' ); # Cataloging Source my $catsource = MARC::Field->new( '040','','', a => 'Biblioteko Butler', b => 'epo', c => 'Martin Morris <martin(a)martinmorris.org>', d => 'Martin Morris <martin(a)martinmorris.org>' ); # UDC Classification my $udc = MARC::Field->new( '080','','', 2 => 'Biblioteko Butler', a => $marcfields[5] ); # Geoff King's Classification my $gkclass = MARC::Field->new( '084','','', a => $marcfields[12], 2 => 'Geoffrey King <ancientbriton(a)tiscali.co.uk>' ); # Author my $author = MARC::Field->new( '100',1,'', a => $marcfields[4] ); [.....various other fields imported appropriately] $record->append_fields($catsource, $udc, $gkclass, $author, $titleinfo, $publicationplace, $physicals, $bibliographic, $kohastuff, $koha952); print OUTPUT $record->as_usmarc(); } close(OUTPUT); close(KOHADATA); Yours would probably need to interrogate your simple table and create the array that way, before dumping as MARC records. Anyway, that may help. I imagine some of the gurus on here will come up with a better idea though! Martin On 29 Aug 2007, at 01:00, koha-request(a)lists.katipo.co.nz wrote: > Message: 1 > Date: Tue, 28 Aug 2007 19:26:02 +0530 > From: S P Suresh <spsuresh(a)cmi.ac.in> > Subject: [Koha] Import query > To: koha(a)lists.katipo.co.nz > Message-ID: <709A1480-F1C5-46BD-BE47-00CD9FB33448(a)cmi.ac.in> > Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed > > Dear all, > > Can some developers on the list please help me. We have an existing > library system maintained currently as a rudimentary mysql table with > a minimum of fields (barcode, authors, title, publisher, year). How > best can we import this data into Koha? Does it suffice to write some > Perl code to load these values into the biblio, items, biblioitems > tables? Or will it break something? Another idea is to just load the > relevant fields into the biblio table, without worrying about the > items and biblioitems tables. (We are planning to manually look into > each record (searching by author or title) and fill in the biblio > details with a Z39.50 import, as well as other relevant fields like > barcode.) Can some of the experts tell me whether this will work > properly, without breaking the way Koha works? We want to have our > old data up and running with Koha. > > Thanks in advance for the help. We are experimenting with Koha in our > library, and it is vital that we start on some rudimentary > functionality at least. Later when some of us are more familiar with > its workings, we can realise its full benefits. But it is taking > time, and we need this help urgently. > > If the above approaches are wrong, can someone please tell me what is > the best approach? > > Thanks in advance, > Suresh

1 0

importing pictures
by Noel Goodman 29 Aug '07

29 Aug '07

Hey... Does the picture upload feature work on koha 2.2.8 for windows? I was trying to use the picture upload option for koha found in parameters. The zip file contains the images and the datalink.txt file. The file has data: 1 Nicole.jpg 2 John.jpg 3 Amy.jpg -Is this the correct way to write the info in the file. I tried zipping a folder containing the datalink file and images as well as zipping the images and datalink file just as is. Both failed to work. When I click unpack button I keep getting a server error. -Would the picture-upload.pl script have anything to do with it? Thanks Noel Goodman - university of Guyana Image by FlamingText.com --------------------------------- Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.

2 1

Fwd: koha on Debian
by K G 29 Aug '07

29 Aug '07

Does anyone have any knowledge of how to install koha on Debian with out an internet connection or Does anyone know where i can locate some documentation on it Also - if the installer.pl does not work anyone know of any other ways of installing without using the installer.pl Shalom --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

1 0