- Koha - lists.katipo.co.nz

Koha in France
by Serge Renaux 20 Mar '03

20 Mar '03

Hi, I am working in a French high school and preparing our library to migrate to Koha. Because i am working for a French public organization i am looking for other French public libraries which are using Koha, moving or testing Koha. Please let me know if you are in this case . Thanks for advance. Regards Serge -- Serge Renaux Groupe ESIEE / CCI Paris EMail:s.renaux@esiee.fr Tel:(33)1.45.92.67.46

1 0

MARC Bulk Koha Import Perl
by Johan Ugander 20 Mar '03

20 Mar '03

Hello Kohaers, I'm trying to set up Koha for our meager library here at Deep Springs, 25k volumes or so, and we're currently going through the process of building a digital register (essentially replacing an abandoned collection of poorly kept records)...which has been timely, but with lots of help we're more than half way through. However, this register was built on some assumptions that I'm hoping hoping hoping are true. 1) Is there is a scriptable way (even if i have to write it myself) of getting full MARC records into a database from a tabulated list of ISBNs, LCNs, Titles, Authors, Publishers, or some combination there of? This would essentially involving querying the Library of Congress database directly somehow. Through a perl module? hmm. There is an old MARC database lying around on a CD that has ~15k of the records, but we don't know which ones...heh heh heh. This place suffers from a horribly short institutional memory. But enough about us. So while this first step is a pretty big step, I am also very interested in getting this second step working indifferent of step 1 since we _do_ have the ~15k records in MARC. 2) Doing a Bulk import of MARC into Koha. This I assume you all know a lot about, and I just need to be pointed in the right direction. I'm a fairly proficient perler, so I should be able to figure it out...I've read about something called bulkmarcimport? is this in full operation? The first issue is one I would greatly appreciate help with, though it is something I need to figure out pre-Koha, and is not necessarily the forte of this list. Of course, any and all help anyone can provide would be much appreciated. Thank you, Johan Ugander Deep Springs College

3 2

General Introduction
by Luke Ottrey 19 Mar '03

19 Mar '03

Dear All, Thought that I should introduce myself to the community - My name is Luke Ottrey and operate a small IT-consultancy in Melbourne, Australia. I am currently studying at university in the "Bachelor of Multimedia Business Computing" at Monash University, Berwick. My approach to Koha is with a view of implementing it in the Victorian education sectors - in particular with my current primary & secondary school contacts. I would be extremely keen to learn of any deployments of Koha particularly in Victoria, Australia - and if there are any other education (school, university) institutions that may not have deployed Koha yet - but who are considering doing so. Also, many thanks to Adam of Strategic Data for his brief run down of how his company has implemented Koha in the past - your assistance was greatly appreciated. As a brief background to myself, my company has strategic alliances with many of the major Internet carriers in Australia, provide internet access, also consulting with both the education and logistic industries (freight forwarders, shipping companies) and am currently involved with developing an extensive logistics platform for a company. Looking forward to working with you all. Luke Ottrey Purple Lion IT Solutions Web: www.purplelion.net Ph: 0408 675 648 Fax: +61 3 9886 7349

1 0

need help... fine setup
by awie dicu 18 Mar '03

18 Mar '03

hi all, I need some help from experts out there. I've installed koha 1.2.3 but experience some problem to setup fine. when I run http://163.128.16.100:12000/cgi-bin/koha/charges.pl, it will pass the data that I key-in to http://163.128.16.100:12000/cgi-bin/koha/updatecharges.pl but in the script says: my $sth=$dbh->prepare("Update categoryitem set fine=$dat[0],startcharge=$dat[1],chargeperiod=$dat[2] where categorycode='$bor' and itemtype='$cat'"); unfortunately, thereis no column named "startcharge" in the table categoryitem. Is this a bug? hope there'll be somebody willing to help me. rgds -nawawi- __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com

1 1

Re: UK Koha users?
by Andrea Chandler 17 Mar '03

17 Mar '03

I'm sure I'm not the only British librarian lurking on this mailing list. Is there anyone out there in the UK using or considering Koha who would like to share ideas? And is there anyone offering formal support in England? There was nothing up on the website. Email me off-list if you wish. Regards, Andrea Chandler

2 1

Re: UK Koha users?
by Andrea Chandler 17 Mar '03

17 Mar '03

I'm sure I'm not the only British librarian lurking on this mailing list. Is there anyone out there in the UK using or considering Koha who would like to share ideas? And is there anyone offering formal support in England? There was nothing up on the website. Email me off-list if you wish. Regards, Andrea Chandler

2 1

MARC scheme for item data
by Larry Currie 17 Mar '03

17 Mar '03

We're getting ready to load item data from a file into our MARC records, and I proposed that the following fields be added to each MARC record: 945 b biblio.biblionumber c biblioitems.biblioitemnumber 946 a biblioitems.biblioitemnumber b biblioitems.itemtype c biblioitems.dewey and for each copy or, in the case of multivolume works, each volume, a 949 field with the following subfields: 949 a items.itemnumber b items.biblionumber c items.multivolumepart d items.biblioitemnumber e items.barcode f items.dateaccessioned g items.homebranch h items.price i items.datelast seen j items.issues k items.itemsnotes l items.holdingbranch .... .... My question is, I came upon this scheme only because it seemed to pass the Check MARC test within the MARC Related section of version 1.9.0, but is this the optimal scheme to use? I noticed that Paul Poulain has proposed that the 995 tag be used for the item data in conjunction with Biblio.pm and I can certainly make this change. Am I correct in assuming that there will be one such field for each volume and copy of a work (i.e., that the 949s or 995s will be repeatable)? What about the information I have chosen to go into 945 and 946 fields? Is this appropriate? We have also tried to get some guidance from the Library of Congress MARC specifications pages as to whether we should either 1) be creating separate MARC holdings records and/or 2) modifying the leaders of our MARC records to indicate that they contain holdings tags. I personally don't think that we have to concern ourselves with either of these specifications, but I just want to be sure. 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/

2 1

Koha - Failed to set fines
by awie dicu 17 Mar '03

17 Mar '03

Hi.. I'm using koha 1.2.3 and try to set fines for overdue books. I've manually edited table categoryitem but it's not working. I've tried to setup using http://163.128.16.100:12000/cgi-bin/koha/charges.pl but failed with arrors below: [Mon Mar 17 11:53:14 2003] [error] [client 163.128.18.107] script not found or unable to stat: /usr/local/cgi-bin/charges.pl Global symbol "$query" requires explicit package name at /usr/local/koha/intranet/cgi-bin/updatecharges.pl line 22, <KC> line 11. Execution of /usr/local/koha/intranet/cgi-bin/updatecharges.pl aborted due to compilation errors. [Mon Mar 17 11:55:32 2003] [error] [client 163.128.18.107] Premature end of script headers: /usr/local/koha/intranet/cgi-bin/updatecharges.pl What did I go wrong? Can anybody guide me? thanks & regards, -Nawawi- __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com

1 0

Re: [Koha] anyone using rfid, robot sorter, or self checkout interfaces?
by Stephen Hedges 16 Mar '03

16 Mar '03

Christopher - I think the folks at Ann Arbor District Library have done some work with rfid and Koha. I'm not sure if they watch this list -- you might drop an e-mail to eli(a)aadl.org if you don't hear from them first. As for self-checkout, I think that will require SIP2 support, which is still on the way for Koha. Stephen Hedges Director, Nelsonville Public Library 95 W. Washington St., Nels.,OH 45764 (740) 753-2118 fax (740) 753-3543 > Pardon me if this is a FAQ. A group of us at the > University at Buffalo are > working on a proposal to test various interfaces > between radio frequency > ID self-checkout machines and library software in > our learning lab. Our > vision includes the use of hand held devices by > patrons and staff, as well > as patron self checkout systems and perhaps robot > sorters. I would like > this to be an all Linux (or some sort of *nix) > system, right down to > palmtops like the Sharp Zaurus. However, right > now, I am wondering if > anyone is using any self checkout devices or > sorters with Koha? > > cbs > -- > Christopher Brown-Syed, PhD. Editor, Library & > Archival Security. > School of Informatics, University at Buffalo. > <clb24(a)buffalo.edu> > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

2 2

Exporting MARC Records from OCLC CatME to Koha
by Larry Currie 14 Mar '03

14 Mar '03

Just about all of our cataloging is done through the OCLC CatME software program. I just now exported 15 MARC records from OCLC CatME into a file called mar142003.dat (see attached) and then ran them through a Perl script called marcmanip.pl (see attached) and MARC::Lint. The marcmanip.pl script should simply extract the control number along with data from about 6 of the MARC tags, if those tags are present. # From marcmanip.pl I got absolutely no results, and from MARC::Lint I only got a few minor warnings (see attached). I'm wondering why this was so: I believe that each record has an 001 field, and that its value in each case is the character string "ocm" followed by the OCLC record number. Since we would somehow need to get our MARC records from OCLC CatME into Koha, I'm wondering about several things: 1. Can anyone detect what is wrong with this set of 15 MARC records? The marcmanip.pl script seems to be bypassing the 001 fields for some reason. 2. Koha presently seems to require a number value for the key field biblionumber in the biblio table, and it seems like this should correspond to the 001 field of the MARC record. Has anyone devised a method of taking a single exported OCLC record or a batch of exported OCLC records, changing the OCLC record number-based 001 field to a value acceptable to Koha, and then loading these MARC records into Koha? 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/ RECORD 1 246: Indicator 2 must be 0, 1, 2, 3, 4, 5, 6, 7 or 8 but it's " " RECORD 3 022: Indicator 1 must be blank but it's "0" 260: Must have a subfield _c. RECORD 4 700: Subfield _p is not allowed. RECORD 5 246: Field is not repeatable. 246: Indicator 2 must be 0, 1, 2, 3, 4, 5, 6, 7 or 8 but it's " " RECORD 6 246: Field is not repeatable. RECORD 7 490: Subfield _x is not allowed. RECORD 8 040: Subfield _b is not allowed. 440: Subfield _x is not allowed. RECORD 9 040: Subfield _b is not allowed. RECORD 10 110: Subfield _d is not allowed. 110: Subfield _c is not allowed. 440: Subfield _x is not allowed. RECORD 11 110: Subfield _d is not allowed. 110: Subfield _c is not allowed. 246: Field is not repeatable. 440: Subfield _x is not allowed. RECORD 12 440: Subfield _x is not allowed. RECORD 14 440: Subfield _x is not allowed.

1 0