July 2003 - Koha - lists.katipo.co.nz

Migration to 2.0 betas going smoothly?
by Ben Ostrowsky 07 Aug '03

07 Aug '03

If I decide not to wait until 2.0-STABLE, and install Koha 1.x now, how much hassle am I in for when I upgrade to 2.0? (Assume I'm not tweaking the installation much, just setting up basic parameters and doing a bit of data entry.) I'm willing to wait for 2.0-STABLE if it's a good idea. Despite lurking on the list, I've never actually used Koha. Ben -- Email is packaged by intellectual weight, not volume. Some settling of contents may have occurred during transmission.

4 3

2.0.0pre2 bugs and questions
by T & J Kotula 07 Aug '03

07 Aug '03

Hi everyone, Sorry again for not using Bugzilla.... I seem to be striking quite a number of bugs. Am I doing something wrong? System RH8, Koha 2.0.0pre2 1. When adding members, card number is not checked for being unique. 2. When adding items, barcode is not checked for being unique. 3. When trying to issue a Reserved book and clicking 'NO' to "Allow issue?", displays "Set reserve for Member to waiting and transfer to Library". Clicking either "Yes" or "No" takes me back to "Allow issue?". There seems to be no way out of this cycle. 4. When trying to issue a non-returned book and clicking 'YES' to "Allow issue?", it correctly lends the book out, but there is no "Due Date" shown for this item. 5. Once there is a book with a repeated bar-code number, issuing a couple of books (not necessarily the one with a repeated bar-code number) gets Koha totally confused, by incorrectly duplicating some entries: Todays Issues Due Date Bar Code Title Author Class 18/07/2003 L19999895 This book's title This book's author 18/07/2003 L19999895 This book's title This book's author 18/07/2003 L19999895 This book's title This book's author 24/07/2003 L19999899 Book's title Book's author 6. Clicking on the "Bar Code" link from "Todays Issues", generates 'Object Expected', lines 214 and 258 errors of circ/circulation.pl 7. Clicking on the "payment" link generates 'Object Expected', lines 144 error of circ/circulation.pl 8. Clicking on the "memeber's card number" link generates 'Object Expected', lines 142 error of circ/circulation.pl 9. maint/catmaintain.pl seems to be an empty page 10. Should acqui.simple/addbiblio.pl MARK table have entries for categories 3 to 9? Minor ones: 1. acqui.simple/additem.pl and MARCdetail.pl menu font size smaller than on all other pages. 2. When adding a new biblio with acqui.simple/addbiblio.pl?isbn=123456789, PHYSICAL DESCRIPTION's subitems are in order a, b, c, f. However when editing an existing biblio with acqui.simple/addbiblio.pl?oldbiblionumber=123, PHYSICAL DESCRIPTION's subitems are in a different order f, a, b, c. Suggestions: 1. Would be very nice if circulation pages used focus() and TABINDEX. This way one could issue books with just scanning and a TAB key. 2. Would be nice to have an default option for either 'MARC search' or 'Quick search'. If some of these descriptions do not make sense - ask and I'll try to clarify. Thanks. tomasz kotula

3 2

data import question
by Derek Dresser 01 Aug '03

01 Aug '03

Hello, I'm still having some trouble getting our data migrated from an old Winnebago system to koha 2.0.0pre2. I am using a MICROLIF (USMARC) file and attempting to use the bulkmarcimport.pl script like so. /usr/local/koha/scripts/misc/bulkmarcimport.pl -file MICROLIF.001 it appears to import fine. Here is a piece of the script output as it is importing the data ==>LDR 01088cam 2200265 i 4500 001 79001533 //r86 008 790514s1979 nyu b 00110 eng 020 _a0835211533 : _c$14.95 043 _ae-uk--- _an-us--- 050 0 _aPR830.F3 _bT9 082 _a016.823/0876 100 10 _aTymn, Marshall B., _d1937- 245 10 _aFantasy literature : _ba core collection and reference guide / _cMarshall B. Tymn, Kenneth J. Zahorski, and Robert H. Boyer. 260 0 _aNew York : _bR. R. Bowker Co., _c1979. 300 _axiii, 273 p. ; _c24 cm. 504 _a"Directory of publishers": p. 232-239. 500 _aIncludes index. 650 0 _aFantastic fiction, English _xHistory and criticism _xAddresses, essays, lectures. 650 0 _aFantastic fiction, American _xHistory and criticism _xAddresses, essays, lectures. 650 0 _aFantastic fiction, English _xBibliography. 650 0 _aFantastic fiction, American _xBibliography. 700 10 _aZahorski, Kenneth J., _d1939- _ejoint author. 700 10 _aBoyer, Robert H., _d1937- _ejoint author. 852 1 _9p14.95 _h016.823 T976f _p10022 961 _t6 at /usr/local/koha/intranet/scripts/misc/bulkmarcimport.pl line 79. biblio 22 : items found ADDED biblio NB 45 in DB ==>LDR 00739nam 2200193 i 4500 001 77622252 008 770803s1976 meu b s00010 eng 020 _a0913764086 043 _an-us--- _an-us-me 050 0 _aZ1238 _b.C48 _aE263.M4 082 _a016.9733/09741 100 10 _aChurchill, Edwin A. 245 10 _aMaine communities and the War for Independence : _ba guide for the study of local Maine history as related to the American Revolution / _cby Edwin A. Churchill. 260 0 _a[Augusta] : _bMaine State Museum, _c1976. 300 _avi, 110 p. ; _c22 cm. 651 0 _aMaine _xHistory _yRevolution, 1775-1783 _xBibliography. 651 0 _aUnited States _xHistory _yRevolution, 1775-1783 _xBibliography. 852 1 _h016.9733 C475m _p10023 961 _t6 at /usr/local/koha/intranet/scripts/misc/bulkmarcimport.pl line 79. biblio 23 : items found ADDED biblio NB 46 in DB The issue I am still having is that it is creating biblios and biblioitems in the database, but no "items" This seems to be a problem of correctly mapping the fields in the MARC record to koha's database. specifically, the item information seems to be in MARC field 852. I haven't yet been able to map things correctly though. I have a few questions. When installing, I am selecting MARC21 parameters instead of UNIMARC. Is this correct? What's the difference? Is there an already defined option to extract the "item" data from the MARC 852 field (I believe from some responses that I have received that this is a fairly standard location for the "item" data). Any help or additional information would be appreciated. Perhaps there is a way for me to rewrite my MARC data so that that information will be read properly? I'm giving a demo next week to a bunch of school technologists on the basics of installing and configuring Koha as part of an open source seminar we are putting on. I should be able to pull that off using the sample data if necessary, but it would be really nice if I could show them our actual library data. :-) Thanks in advance for any help or suggestions, Derek -- Derek Dresser http://network.gouldacademy.org/ Gould Academy Bethel, ME 04217 (207)824-7700 "Nothing endures but change" --Heraclitus ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

4 7

RE: [Koha] (no subject)
by Jeff Cave 31 Jul '03

31 Jul '03

Noticed a typo in the sample data (book title): INSERT INTO biblio VALUES (18,'Kenny, Kathryn','Trixie belden - they mystery of the missing millionaire',NULL,NULL,NULL,NULL,NULL,20020415130854,NULL); should be? INSERT INTO biblio VALUES (18,'Kenny, Kathryn','Trixie belden - the mystery of the missing millionaire',NULL,NULL,NULL,NULL,NULL,20020415130854,NULL); Thats in the biblio table. The 18th item. Title has "they mystery" which looks like it should be "the mystery". If this is coming from someones live data they may want to fix that. > -----Original Message----- > From: Derek Dresser [mailto:Derek.Dresser@gouldacademy.org] > Sent: Thursday, July 31, 2003 6:54 AM > To: koha > Subject: [Koha] (no subject) > > > Hello, > > I found that the sampledata distributed with koha-2.0.0pre2 > has a problem. > The number of fields in the member table doesn't match the > data supplied. A > friend of mine, Scott Ellis, took a few minutes and fixed the > sample data. > (thanks scott) > > the fixed sample data can be found here. > > http://network.gouldacademy.org/randomfiles/sampledata-1.2a.gz > > HTH, > Derek > > -- > Derek Dresser > http://network.gouldacademy.org/ > Gould Academy > Bethel, ME 04217 > (207)824-7700 > > "Nothing endures but change" > --Heraclitus > > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

(no subject)
by Derek Dresser 31 Jul '03

31 Jul '03

Hello, I found that the sampledata distributed with koha-2.0.0pre2 has a problem. The number of fields in the member table doesn't match the data supplied. A friend of mine, Scott Ellis, took a few minutes and fixed the sample data. (thanks scott) the fixed sample data can be found here. http://network.gouldacademy.org/randomfiles/sampledata-1.2a.gz HTH, Derek -- Derek Dresser http://network.gouldacademy.org/ Gould Academy Bethel, ME 04217 (207)824-7700 "Nothing endures but change" --Heraclitus ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/

2 1

New to list....looking for info on E-smith/SME and Koha
by David Trask 31 Jul '03

31 Jul '03

Hi, I'm new to to the list (finally)....I'm a technology coordinator in Maine, USA and have been using E-Smith/, K12LTSP, and so forth extensively in my school for a couple years now. I'm really interested in getting Koha running, but want to keep the installation as simple as possible....I saw in the archives that some work has been done with releasing an RPM for installing on SME/Mitel/E-Smith.....can anyone point me to these files or let me know what the status of it is? Thanks! David N. Trask Technology Teacher/Coordinator Vassalboro Community School dtrask(a)vcs.u52.k12.me.us (207)923-3100

3 2

librarian staff acess
by rahayu rms 31 Jul '03

31 Jul '03

Hi.. 1. I am using koha v1.2.3 on windows.How to create password for librarian staff? So that they can acess only to their part. 2. To log in to intranet interface I have to use koha as a password and as a user.How to set our own password and username? _________________________________________________________________ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp

1 0

RE: [Koha] Koha Install - CGI Script Error
by Jeff Cave 30 Jul '03

30 Jul '03

Ya, I am installing on windows. I may already be a littel infamous over on the win32 mail list. I thought that I might have better luck over here since it was a perl specific question. You are right though this is configuring perl on windows. I will send this message to both groups but will continue the discussion over there. For those on the Win32 list, this is the error I am getting: DBI object version 1.37 does not match $DBI::VERSION 1.14 at C:/Perl/lib/DynaLoader.pm line 249. BEGIN failed--compilation aborted at C:/Perl/lib/DBI.pm line 182. Compilation failed in require at C:/Perl/lib/C4/Database.pm line 25. BEGIN failed--compilation aborted at C:/Perl/lib/C4/Database.pm line 25. Compilation failed in require at C:/Perl/lib/C4/Auth.pm line 25. BEGIN failed--compilation aborted at C:/Perl/lib/C4/Auth.pm line 25. Compilation failed in require at c:\dev\www\opac\cgi-bin\koha\opac-main.pl line 6. BEGIN failed--compilation aborted at c:\dev\www\opac\cgi-bin\koha\opac-main.pl line 6. I have also started discussing it on tek-tips: http://www.tek-tips.com/viewthread.cfm?SQID=616196&SPID=219&newpid=219&page… Since posting this I have completely uninstalled everything (Perl, mySQL, and Koha) and am starting from scratch. If that makes the error go away... GREAT! Otherwise, I'm hoping to have some better notes on what I am doing. > -----Original Message----- > From: MJ Ray [mailto:markj@cloaked.freeserve.co.uk] > Sent: Wednesday, July 30, 2003 11:16 AM > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha Install - CGI Script Error > > > Jeff Cave <jeff.cave(a)sunergon.com> wrote: > > on a similar error. They were caused by conflicting modules > but I'm not = > > sure what I would have to do to fix this. > > It sounds like the high-level database driver (DBI) and the > low-level one > (DBD::MySQL) are not the same version. That causes big problems. DBI > presents a relatively stable interface to application programmers, > but does need some more detailed knowledge of how the low-level module > works. > > It also looks like you are installing on Windows and I don't > really know > how perl modules are installed there. I'd suggest hopping > onto koha-win32 > list and asking there. > > -- > MJR/slef My Opinion Only and possibly not of any group I know. > http://mjr.towers.org.uk/ jabber://slef@jabber.at > Creative copyleft computing services via http://www.ttllp.co.uk/ > Thought: Edwin A Abbott wrote about trouble with Windows in 1884 > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

1 0

Install Solutions
by Joshua Ferraro 30 Jul '03

30 Jul '03

Hi everyone, I just thought it would be useful to post the solutions to some problems I had while installing 2.0.0pre2. I'm running a barebones Debian 2.4 stable (woody) installation. 1. Dependency problems: Can't get Event or Net::Z3950 to install Event error: Event.xs:97: poll.h: No such file or directory In file included from Event.xs:279: c/signal.c:2: signal.h: No such file or directory make: *** [Event.o] Error 1 /usr/bin/make -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible So...it's looking for some c header files that are in libc6-dev #apt-get install libc6-dev Net::Z3950 error: ERROR: Unable to call script 'yaz-config': is YAZ installed? at Makefile.PL +line 6. Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install So...yaz was installed but the devel yaz wasn't btw...if you're using debian you can grab yaz by adding deb http://www.indexdata.dk/debian indexdata/woody released deb-src http://www.indexdata.dk/debian indexdata/woody released to your /etc/apt/sources.list apt-get update apt-get install yaz apt-get install libyaz-dev Net::Z3950 installed with no problems after that. 2. apache configuration Ok...this is pretty simple. I had to add Include /etc/koha-httpd.conf to the bottom of the /etc/apache/httpd.conf file and I had to uncoment the env_module in the LoadModules section of /etc/apache/h ttpd.conf Hope that's helpful, Joshua

2 1

Koha Install - CGI Script Error
by Jeff Cave 30 Jul '03

30 Jul '03

I just installed koha on my machine and got everything linked up, went to test it and... DBI object version 1.37 does not match $DBI::VERSION 1.14 at C:/Perl/lib/DynaLoader.pm line 249. BEGIN failed--compilation aborted at C:/Perl/lib/DBI.pm line 182. Compilation failed in require at C:/Perl/lib/C4/Database.pm line 25. BEGIN failed--compilation aborted at C:/Perl/lib/C4/Database.pm line 25. Compilation failed in require at C:/Perl/lib/C4/Auth.pm line 25. BEGIN failed--compilation aborted at C:/Perl/lib/C4/Auth.pm line 25. Compilation failed in require at c:\dev\www\opac\cgi-bin\koha\opac-main.pl line 6. BEGIN failed--compilation aborted at c:\dev\www\opac\cgi-bin\koha\opac-main.pl line 6. I am not much of a perl guy (though I'm willing to learn), so I'm not sure how to read this. I ran a couple of google searches and got results on a similar error. They were caused by conflicting modules but I'm not sure what I would have to do to fix this. Any advice on what could be causing this would be apreciated.

2 1