- Koha - lists.katipo.co.nz

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

FW: [Koha] data import question
by Bigwood, David 30 Jul '03

30 Jul '03

It seems folks are having problems getting their data clean. Here are some free tools that might help get it in better shape before importing. Showmarc is a DOS program that will show all the MARC fields used and how many times each is used. http://www.auto-graphics.com/download/SHOWMARC.EXE MarcEdit (Windows) can change records into human readable format and back again. It includes an editor, ability to mass add or delete fields, a field counter, and find and replace. A nice tool, should be a part of every cataloging dept. http://oregonstate.edu/~reeset/marcedit/html/index.html MARC RTP (DOS) has the ability to report the subfields as well as the fields used. It also gives how long the longest instance is. http://marc.ise.canberra.edu.au/ MARC/Perl is a powerful tool with functions only limited by your coding ability. http://marcpm.sourceforge.net/ Hope this helps some folks clean up their records. Sincerely, David Bigwood bigwood(a)lpi.usra.edu Lunar & Planetary Institute Cataloging News http://www.catalogablog.blogspot.com -----Original Message----- From: Larry Stamm [mailto:larry@larrystamm.com] Sent: Monday, July 21, 2003 11:14 PM To: koha Subject: Re:[Koha] data import question Hi Derek, I find the bulkmarcimport script to be interminably slow, entering only about 6000 items per hour on our 950 MHz CPU server running Mandrake 9.0. It is not much slower on my 266 MHZ home machine that I am using as a test machine. Because I have to enter all 15,000 items from our collection to really test for errors in my MARC "munging", it means another 2 1/2 hr wait to load up all the items again after fixing a mistake before testing. I might get frustrated enough to try my hand at writing a faster upload script... -- Larry Stamm, Chair McBride and District Public Library McBride, BC V0J 2E0 Canada http://www.mcbridebc.org/library

3 2

Re: [Koha] Problem when searching by subject in OPAC
by Owen Leonard 30 Jul '03

30 Jul '03

> When I try and search by subject with the search > term of "tuna" in the OPAC > system I get this internal server error: > type = subject at > /www/servers/koha/modules/C4/Search.pm line 858. > Can't use string ("1") as a HASH ref while > "strict refs" in use at > /www/servers/koha/modules/C4/Search.pm line > 1118. I ran into the same problem, but it only occurred when I specified both a subject term and a class from the drop-down menu: http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=556 Are you specifying a class as well? -- Owen ---- Nelsonville Public Library Koha 2.0.0-pre2-R2

1 0