- Koha - lists.katipo.co.nz

Data Conversion - Call Numbers
by robweir＠alum.drexel.edu 19 Nov '02

19 Nov '02

I am converting data from an old system and need some help on which fields in Koha should be used to store the various components of the existing book call numbers. I'm a computer guy, not the librarian, so forgive me if my terminolgy is off. Given the following sample call number: R 220.7 J32c V.1 I am guessing that the first line 'R' for Refernce Book would be an itemtype defined in the itemtype table and then entered in the biblioitems.itemtype field for each book. The second line of course would be stored in biblioitems.dewey field. I'm stuck on the third line which I think is referred to as the Cutter number. Where should that be stored? I see a biblioitems.subclass field, but it is only char(3) which isn't long enough since cutter numbers are typicaly four characters. I think a few of the call numbers have a dewey line and two lines of cutter numbers. If there are two cutter lines, where should that second cutter line be stored? And then for the last line, would biblioitems.volumeddesc be the correct field? One more example call number from the old system: BIOG MORR H C.2 I can probably use biblioitems.itemtype for the first line. I'm stuck again on the second line. And I think the last line needs to be stored in the items table since it is specific to each copy of a book with multiple copies. But which field? I am hoping that once I get the data converted and everything stored in the proper fields, that a client who looks up a book using the OPAC interface will be able to see the entire call number for use in locating the book on the shelves. Will that be the case? Or are my librarians using a call number system that is incompatible with Koha? Thanks in advance for any help! Rob

1 0

Can't modify records
by Jim Thomas 19 Nov '02

19 Nov '02

Hi, My wife is the volunteer librarian at a small private school. I had been meaning to set up Koha for nearly two years, but lacked the time. I finally recruited a friend to pitch in. I gave him a dedicated box, and he installed Debian+Koha. I have plenty of experience with RedHat, so Debian is a new experience for me. He installed Koha 1.2.2. We are seeing two problems with the box. First, the koha web pages take a loooong time to load. I suspect this is a DNS problem, but I'm not sure. I do not have a DNS entry for the box yet, because it's still on a private lan, and I'm relying on our ISP for DNS service. We're trying to access Koha from the machine on which it is installed. The second problem is enough to make my wife question the feasibility of using Koha - after she enters a new book into the catalog, she cannot modify it to correct any typos. She finds the modify page OK, but the machine just ignores the modify button. The cursor doesn't change when she positions it over the button - it's as if shes clicking a non-button. Any help here would be greatly appreciated. Sorry for the lack of details, but I don't have access to the box right now. -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas(a)bittware.com http://www.bittware.com (703) 779-7770 The secret to enjoying your job is to have a hobby that's even worse - Calvin's Dad

1 0

Acquistions screen error
by C David Rigby 19 Nov '02

19 Nov '02

Dear all, I am having trouble entering books into the koha system for our small library. I can enter an ISBN from this screen: http://iclibrary.lib.virginia.edu:8080/cgi-bin/koha/acqui.simple/addbooks.pl and I reach this screen: http://iclibrary.lib.virginia.edu:8080/cgi-bin/koha/acqui.simple/addbooks.p… However, upon clicking on the "Add Item" button here, I am taken to a blank screen with this URL: http://iclibrary.lib.virginia.edu:8080/cgi-bin/koha/acqui.simple/addbooks.p… and /var/log/httpd/koha-error_log has added this line: DBI quote: invalid number of parameters: handle + 0 Usage: $h->quote($string [, $data_type ]) at /usr/local/koha/intranet/cgi-bin/acqui.simple/addbooks.pl line 269. [root@iclibrary httpd]# If there is anyone who can help with this, then you can have full access to the machine. Koha is the only thing that this machine is slated to do, and I can always change passwords later. I am open to suggestions, including completely reinstalling the koha system. I know a bit about Linux and such, but I am clueless when it comes to Perl, apache and MySQL. Thus, I really do not know how to correct this sort of problem. Thanks C David Rigby cr8s(a)virginia.edu

2 1

Loan Periods
by Larry Currie 16 Nov '02

16 Nov '02

I'm trying to determine whether there is some way within Koha to be able to restrict the loan of certain types of materials to certain types of borrowers. In the itemtypes table, there are blanket settings for loan lengths, number of permitted renewals, and rental charges, and in the categoryitem table rental discounts, reserve charges, fines, reminder notices, etc. are mapped against categories of borrowers and item types. There is also a field labeled "restrictedtype" and in the Koha sample database the value of this field seems to always be NULL. If I were to change the value of this field for a given itemtype and category of borrower, would this prevent that category of borrower from borrowing that particular type of item, or is there another way to prevent certain categories of borrowers from borrowing certain types of items? Larry Currie -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/

1 0

Re: [Koha] z3950 stalls after one search
by Kevin Johnson 12 Nov '02

12 Nov '02

Ok. I created an apache user, got all of the permissions on the parent directories correct, and ran a few test queries. Was working beautifully. I left if overnight and tried another query this morning. The results page says processing and it's incrementing the time, but it never finishes. In the log file there is the message: Event: '?? Connection.pm:138' died and then $Event::DIED died with: Can't call method "attributes" without a package or object reference at /usr/lib/perl5/site_perl/5.6.1/i386-linux/Event.pm line 88, <KC> line 10. at /usr/lib/perl5/site_perl/5.6.1/i386-linux/Net/Z3950/Manager.pm line 220 Does this process have to manually restarted every so often or is this anomalous? Thanks for your help. Kevin At 11:56 PM 11/4/2002 -0800, you wrote: >On Mon, 4 Nov 2002, Kevin Johnson wrote: > > > Hi. I recently install koha and it is mostly working. When I do a Z39.50 > > search however, it will process the first item in the queue, but stall > > after that with other processes marked as pending. If I send a kill > -HUP to > > z3950processqueue.pid it starts working on the next one, but this is > > probably not the desired behavior. If it makes a difference my > RunAsUser is > > not "apache". Other than that I think I followed all the instructions, and > > it is sort of working. Any help would be most appreciated. > > > >It is important that RunAsUser be set to the same user that your web >server process runs as. The web server runs the cgi scripts which signals >the script to wake up and process new requests when new requests are >queued up through the web interface. If the process is running as a >different user, the signal will not work, and the daeemon will never wake >up. > >Steve. > > >_______________________________________________ >Koha mailing list >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha ---- Kevin Johnson University of Texas, Institute for Geophysics Senior Systems Analyst 4412 Spicewood Springs Rd -- Bldg. 600 (512) 471-0410 Austin, TX 78759-8500 mailto:kevin@ig.utexas.edu http://www.ig.utexas.edu

2 1

Buying from the Koha Store - an update
by Rachel Hamilton-Williams 10 Nov '02

10 Nov '02

Hi http://www.cafeshops.com/koha Is the Koha "shop", and having just got an order delivered to us here in NZ, I can confirm that things do turn out pretty much as they look on screen. The mugs are a little darker than they look, and the baby doll t-shirts are tiny, but the hoodies, bag, and baseball shirts are all good. They are having a sale on the bags at the moment so if you've been dithering about one, I'd get in now :-) Don't forget we make no money from this, it's purely for a bit of promotion and fun Cheers Rachel _____________________________________________________________ Rachel Hamilton-Williams Katipo Communications WEBMISTRESS ph 021 389 128 or +64 04 934 1285 mailto:rachel@katipo.co.nz PO Box 12487, Wellington http://www.katipo.co.nz New Zealand Koha Open Source Library System http://www.koha.org

1 0

Itemtypes and Categoryitems Tables
by Larry Currie 09 Nov '02

09 Nov '02

Right now in the current version of Koha it looks like the itemtypes table assigns certain values to the loan length, the number of renewals allowed, and whether a rental charge applies for a given type of item, and then the categoryitem table assigns rental discounts, reserve charges, fines, first overdue reminder time periods, and loan periods based on the type of borrower. Are the later versions of Koha still going to use this protocol? It seems to parallel the type of filtering that our current commercial system uses to arrive at loan periods, but I'm wondering whether a particular loan period can be assigned at the item level, that is, to a particular book say, which overrides the loan period that would normally be assigned. We have been able to do this in our current system by setting a value in the "loan period" field at the item level, and we're wondering whether Koha also allows this to be done. Larry Currie -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/

1 0

RE: [Koha] Re: Books in Spanish (fwd)
by Bigwood, David 06 Nov '02

06 Nov '02

Pat, OCLC is not open to the world. It looks like the state of Idaho has purchased access privileges for all the libraries in the state. Now if you are meaning restricting searches by languages, that is fairly simple. In 008 there is a 3 letter code for language. There may also be a language code in 041 of the MARC record. Sincerely, David Bigwood bigwood(a)lpi.usra.edu Lunar & Planetary Institute Cataloging news: http://www.catalogablog.blogspot.com -----Original Message----- From: Pat Eyler [mailto:pate@eylerfamily.org] Sent: Tuesday, November 05, 2002 4:43 PM To: koha(a)lists.katipo.co.nz Subject: [Koha] Re: Books in Spanish (fwd) hmm, an interesting threadlet. is there a way that this could be useful to koha libraries? -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: Tue, 5 Nov 2002 14:30:34 -0800 From: Ron Force <rforce(a)uidaho.edu> To: LIBIDAHO(a)LISTSERV.BOISESTATE.EDU Subject: Re: Books in Spanish If you sign up for your free access to OCLC's First Search WorldCat you could use the advanced search (not hard, just more options than a simple search), search for your authors while limiting the search to books in the Spanish language. You get: Victoria Holt: 160 records Agatha Christie: 569 records Danielle Steel: 222 records Obviously, multiple editions. Each record has a list of the holding libraries, giving you a place to fire off an ILL request. Sign up info at: http://www.lili.org/worldcatdemo.htm Come'on people--it's the world's largest and greatest bibliographic database, all provided by your tax $$$. It's useful for ILL and Reference. You'll be surprised how easy it is to use, and the immense amount of stuff in there. ******************************************** Ron Force rforce(a)uidaho.edu Dean of Library Services (208) 885-6534 University of Idaho Moscow 83844-2350 ******************************************** > -----Original Message----- > From: LIBIDAHO - for Idaho Libraries and Librarians > [mailto:LIBIDAHO@LISTSERV.BOISESTATE.EDU]On Behalf Of stanlib > Sent: Tuesday, November 05, 2002 1:55 PM > To: LIBIDAHO(a)LISTSERV.BOISESTATE.EDU > Subject: Books in Spanish > > > Hola! Stanley has become bilingual! We have one patron who has requested > books in Spanish. Since we have absolutely no books in Spanish I need some > help. Our customer likes Daielle Steele, Agatha Christie and > Victoria Holt. > I'd like to hear from any libraies having holdings that would > appeal to this > customer. Thanks in advance for your help. > Jane Somerville > Library Director > _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

2 1

Re: Books in Spanish (fwd)
by Pat Eyler 05 Nov '02

05 Nov '02

hmm, an interesting threadlet. is there a way that this could be useful to koha libraries? -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: Tue, 5 Nov 2002 14:30:34 -0800 From: Ron Force <rforce(a)uidaho.edu> To: LIBIDAHO(a)LISTSERV.BOISESTATE.EDU Subject: Re: Books in Spanish If you sign up for your free access to OCLC's First Search WorldCat you could use the advanced search (not hard, just more options than a simple search), search for your authors while limiting the search to books in the Spanish language. You get: Victoria Holt: 160 records Agatha Christie: 569 records Danielle Steel: 222 records Obviously, multiple editions. Each record has a list of the holding libraries, giving you a place to fire off an ILL request. Sign up info at: http://www.lili.org/worldcatdemo.htm Come'on people--it's the world's largest and greatest bibliographic database, all provided by your tax $$$. It's useful for ILL and Reference. You'll be surprised how easy it is to use, and the immense amount of stuff in there. ******************************************** Ron Force rforce(a)uidaho.edu Dean of Library Services (208) 885-6534 University of Idaho Moscow 83844-2350 ******************************************** > -----Original Message----- > From: LIBIDAHO - for Idaho Libraries and Librarians > [mailto:LIBIDAHO@LISTSERV.BOISESTATE.EDU]On Behalf Of stanlib > Sent: Tuesday, November 05, 2002 1:55 PM > To: LIBIDAHO(a)LISTSERV.BOISESTATE.EDU > Subject: Books in Spanish > > > Hola! Stanley has become bilingual! We have one patron who has requested > books in Spanish. Since we have absolutely no books in Spanish I need some > help. Our customer likes Daielle Steele, Agatha Christie and > Victoria Holt. > I'd like to hear from any libraies having holdings that would > appeal to this > customer. Thanks in advance for your help. > Jane Somerville > Library Director >

1 0

Re: [Koha] Problems with Z39.50 - unix file permissions?
by C David Rigby 05 Nov '02

05 Nov '02

On Saturday 02 November 2002 02:39 pm, you wrote: > On Sat, 2002-11-02 at 05:27, C David Rigby wrote: > > On Friday 01 November 2002 05:18 pm, Tonnesen Steve wrote: > > > On Fri, 1 Nov 2002, C David Rigby wrote: > > > > /usr/local/koha-1.2.2/scripts/z3950daemon/z3950-daemon-launch.sh > > > > > > > > as root, I get the message: > > > > > > > > -sh: > > > > /usr/local/koha-1.2.2/scripts/z3950daemon/z3950-daemon-shell.sh: > > > > Permission denied > > > > > > > > I have, through commenting out various lines, determine that it is > > > > this line in z3950-deamon-launch.sh, near the end, where the problem > > > > occurs: > > > > > > > > su -s /bin/sh -c $KohaZ3950Shell - $RunAsUser & > > > > > > > > Why, I cannot determine. RunAsUser=apache is set earlier in the > > > > script, and using the line > > > > > > > > echo $KohaZ3950Shell $RunAsUser > > > > > > > > in place of the above su command returns > > > > > > > > /usr/local/koha-1.2.2/scripts/z3950daemon/z3950-daemon-shell.sh > > > > apache > > > > > > > > as one might expect. The user apache is defined in /etc/passwd. > > > > > > Check that the file z3950-daemon-shell.sh is readable and executable by > > > the apache user. > > > > > > ls -l z3950-daemon-shell.sh should show: > > > > > > -rwxr-x--- 1 root apache 1740 Oct 29 z3950-daemon-shell.sh > > > > > > likewise, processz3950queue should show: > > > > > > -rwxr-x--- 1 root apache 7849 Oct 29 processz3950queue > > > > > > > > > If the group isn't set to apache, or group doesn't have r-x > > > permissions, run: > > > > > > chown root.apache z3950-daemon-shell.sh processz3950queue > > > and > > > chmod 0750 z3950-daemon-shell.sh processz3950queue > > > > > > Steve Tonnesen > > > > Steve, > > Thanks, I did this, but I am still having problems. An ls -l of the > > scripts directory gives: > > > > > > [root@iclibrary z3950daemon]# ls -l > > total 32 > > -rwxr-x--- 1 root apache 7693 Oct 30 14:43 processz3950queue > > -rwxr-x--- 1 root apache 7694 Oct 30 14:42 > > processz3950queue.bup -rwxr-x--- 1 root apache 1183 Oct 30 > > 15:55 z3950-daemon-launch.sh -rwxr-x--- 1 root apache 1194 > > Oct 30 14:24 > > z3950-daemon-launch.sh.bup > > -rwxr-x--- 1 root apache 1321 Oct 30 15:52 > > z3950-daemon-shell.sh -rwxr-x--- 1 root apache 1321 Oct 30 > > 14:29 > > z3950-daemon-shell.sh.bup > > I would also try the parent directories: > > If you don't have permission to use one of the parent directories it > will give you the same error. > Dear Michael, That was the trick! processz3950queue is running gine. Thanks for your assitance. CDRigby > > But the execution of the z3950-daemon-launch.sh still gives this message: > > > > > > [root@iclibrary z3950daemon]# ./z3950-daemon-launch.sh > > [root@iclibrary z3950daemon]# -sh: > > /usr/local/koha-1.2.2/scripts/z3950daemon/z3950-daemon-shell.sh: > > Permission denied > > > > > > CDRigby > > cr8s(a)virginia.edu > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha

1 0