- Koha - lists.katipo.co.nz

transferring records to koha
by Roger Hart 12 Nov '06

12 Nov '06

I would like to ask for some help on transferring bibliographic records into koha. I agreed to do some volunteer work at our child's new school, a small private academy, and I was aghast to see that one of the tasks was typing -- by hand -- bibliographic records into what turned out to be terribly out-of-date PC library program that lacked not just MARC import capabilities but could only be accessed from a single terminal, etc. After doing some research, it seemed to me that koha might be the best library program for them. Am I correct in this? I've managed to set up koha on an old Apple PowerBook G4 I have at home running Mac OS X Server 10.4. After some effort, most everything seems to be working, including MARC imports. Now I would like to transfer their old records into koha. There are almost 10,000. I could try to do this by mapping the fields (they are tab-delimited) to koha's and using MySQL to import. However, their bibliographic records are, as you might guess, incomplete and idiosyncratic (especially in the subject headings, for example). So it seems to me that it might be better, if it is not too difficult, to try to use the author, title, and perhaps date fields from their old records to download standardized MARC records, from LOC for example, by perhaps modifying one of the koha perl scripts; then I would like to use a perl script to assign the barcode they have used to each item, and perhaps place the old information in a "notes" section. Can anyone give me some guidance on whether this seems feasible, and if so, any suggestions on how I might best accomplish this? Thanks so much, Roger ******************************** Roger Hart Assistant Professor, Departments of History and Asian Studies University of Texas at Austin office: Room 470, Burdine Hall office phone: 512-475-7258 department fax: 512-475-7222 email: rhart(a)mail.utexas.edu http://uts.cc.utexas.edu/~rhart *********************************

1 0

Afghanistan Union catalog on Koha
by Han, Yan 10 Nov '06

10 Nov '06

I should announce this earlier. The Afghanistan Union catalog was built on top of Koha with some modifications such as Arabic support and label printing etc. The system has been configured, modified and running since Nov 2005. The catalog is a part of a digital library initiative to help Afghanistan universities to manage their library collections. Currently 3 university library records are in the catalog. Check http://150.135.45.128/cgi-bin/koha/opac-main.pl Yan Han, MS. Computer Science, MLIS Systems Librarian The University of Arizona Libraries Tucson, AZ, hany(a)u.library.arizona.edu

1 0

Adding Item Types
by Darla Grediagin 10 Nov '06

10 Nov '06

Good day all, I am trying to add item types. I am getting stymied at the authorized value. What am I look for to put into this blank? Is it where my current MARC record holds this information? I haven't separated out my collection to that point before now so my current MARC values don't divide it like this. Any input is will help. Thank you in advance, Darla -- Darla Grediagin District Librarian Bering Strait School District Unalakleet, Alaska Web Address : http://bssdonline.org/course/view.php?id=51 Blog: http://aklibrarian1.edublogs.org/

1 0

Bulkmarcimport and special characteres
by José Lagoas 10 Nov '06

10 Nov '06

Can anyone help me with 2 questions about Koha? First Question: How can we use, under OPAC, the "OR" logical operator? Second Question: The Portuguese Language uses some special characters like "ã". We have used bulkmarcimport for importing our database. This program changes "ão" to "ô", "ãe" to "ê " and "áu" to "ù". Have you any idea how to solve this problem? Best Regards. -- José Lagoas Laboratório Nacional de Engenharia Civil

5 5

Problems with using authorities!!!
by library cdac 10 Nov '06

10 Nov '06

Hi! Could anyone let me know the following: 1. I have created an authority for Subject headings and also created the subfield 9 to link the authority record and the Marc record in the marc tag 650. I have also entered the records in the above authority type. While adding the biblio records, it gives three dots in the field 650a. When I search the records from the subject headings authority records, it does not list the title of the heading in the summary. Please see the result of the search. Also I would like to know is 150a, the right field to enter the authority record for Subject Heading? I have been entering the subject headings there. Authority search results Search on Authority type SHL Main entry start by contains Anywhere contains start by *Results 1 to 1 of 1* Summary Used Get It! Clear <javascript:jumpfull('blinddetail-biblio-search.pl?authid=0&index=823')> 0 times <javascript:jumpfull('blinddetail-biblio-search.pl?authid=10&index=823')> 2. Since the above authority did not work, I disabled the link and directly entered the subject Headings in the 650 a subfield of MARC, but when I see the display on the opac it does display the subject headings but it is identified as Relator links and not Subject. What cud be the problem? Please see the search below. Library Catalog Search Catalog Home <http://202.141.151.218/cgi-bin/koha/opac-main.pl> - Advancerch <http://202.141.151.218/cgi-bin/koha/opac-search.pl> Mastering Database Programming with Visual Basic 6 By Petroutsos, Evangelos<http://202.141.151.218/cgi-bin/koha/opac-search.pl?marclist=biblio.author&a…> Detailed notes: - Reference Only - Indian Reprint Related links: - Visual Basic 6<http://202.141.151.218/cgi-bin/koha/opac-search.pl?op=do_search&marclist=bi…> - Database Programming<http://202.141.151.218/cgi-bin/koha/opac-search.pl?op=do_search&marclist=bi…> - Database Management -- <http://202.141.151.218/cgi-bin/koha/opac-search.pl?op=do_search&marclist=bi…> Copyright: 2000 Series Title: BPB Series<http://202.141.151.218/cgi-bin/koha/opac-search.pl?marclist=biblio.seriesti…> ISBN: 81-7656-199-1 Publisher: New Delhi, BPB Publication Physical Details: xii, 400, CD-ROM (1) Record No.: 5 3. I have also added additional authors for the above Record No.5, which are not displayed on the opac. For auhtors also, I have created the authority and added it through that authority. 4. If I want to use the Library of Congress Subject Headings, how do I link through MARC? thanks --trupti

1 1

changes to preferences - how to update?
by bluejaydesign＠sympatico.ca 09 Nov '06

09 Nov '06

Hi all, I think this must be an easy question, but I could not find the answer. We made some changes in the preferences (Koha 2.2.5) for the limit of issues. I vaguely remember I have to run some script to update, but I can't remember what it's called... Thanks, Marty

1 0

Re: Re: [Koha] MySQL using 99% CPU and making web site slow to a crawl
by Greg Vickers 09 Nov '06

09 Nov '06

Hi Chris, > Chris Cormack <chris(a)katipo.co.nz> wrote: > > show processlist \g; Is a great command to run in mysql, it will show > you what is causing it to lock up. > So if you can find the offending query with that command, then we can > start to look into why its going bad. OK this problem has occurs when a Koha admin user was trying to resave a Biblio. Please find attached a file containing the mysql processes, top and vmstat. >From what I understand, it looks like biblio record 2802 or 2671 was being updated, and someone tried to change it while it was being updated? Maybe they navigated back on their browser to a previous web page and changed some details and resubmitted the record? (I don't know, I don't use Koha, I just try to support it! :) ) Thanks, Greg

1 1

Problem running ./bulkmarcimport.pl
by Jim Kronebusch 08 Nov '06

08 Nov '06

I am trying to run ./bulkmarcimport.pl on a new install of 2.2.6 on Debian 3.1 and having the following error when run: Can't locate object method "ignore_errors" via package "MARC::Charset" at ./bulkmarcimport.pl line 24. I have built the server 3 times now and keep getting stuck at this point. I don't know why my Charset.pm is missing this method. Any ideas? I currently have a Fedora Core 3 server running 2.2.4 that worked just fine. I have built this with Ubuntu and ended up with the same problem. Very frustrating to have a working server ready to go, but I can't import data. Thanks.

4 8

Problem running ./bulkmarcimport.pl
by Jim Kronebusch 08 Nov '06

08 Nov '06

I am trying to run ./bulkmarcimport.pl on a new install of 2.2.6 on Debian 3.1 and having the following error when run: Can't locate object method "ignore_errors" via package "MARC::Charset" at ./bulkmarcimport.pl line 24. I have built the server 3 times now and keep getting stuck at this point. I don't know why my Charset.pm is missing this method. Any ideas? I currently have a Fedora Core 3 server running 2.2.4 that worked just fine. I have built this with Ubuntu and ended up with the same problem. Very frustrating to have a working server ready to go, but I can't import data. Thanks. Jim Kronebusch Cotter Tech Department 507-453-5188 -- This message has been scanned for viruses and dangerous content by the Cotter Technology Department, and is believed to be clean.

2 3

RE: [Yazlist] Problems with YAZ > 2.1.8 on OpenBSD
by Mike Dalgity 08 Nov '06

08 Nov '06

Hi Mike, I have no idea if this is a YAZ problem, something with the perl modules or something I'm (not) doing. I'm not a Koha developer; I'm just a user trying to work out the kinks on OpenBSD. The reason I'm posting on this list is because it seems to be directly related to the Yaz version installed. I've written a perl program (my first!) that demonstrates that after checking for a Yaz dependent perl module that input from <STDIN> no longer works. As I stated before, I only seem to have this problem with Yaz versions newer than 2.1.8. I have seen this issue with Yaz versions 2.1.10, 2.1.18, 2.1.24, and 2.1.38. #!/usr/bin/perl -w use strict; print "Type something: "; my $response = <STDIN>; chomp $response; print "You typed $response\n"; #here's the line that breaks it unless (eval {require Net::Z3950}) { print "missing Net::Z3950\n" }; #unless (eval {require ZOOM}) { print "missing ZOOM\n" }; print "Type something if you can: "; $response = <STDIN>; chomp $response; print "You typed $response\n"; *** Checking for Net::Z3950 *** OK -- OpenBSD 4.0 (fresh install, no Net::Z3950) # perl test.pl Type something: test1 You typed test1 missing Net::Z3950 Type something if you can: test2 You typed test2 # OK -- OpenBSD 4.0, Yaz 2.1.8, Net::Z3950 0.51, Event 1.08 # perl test.pl Type something: test1 You typed test1 Type something if you can: test2 You typed test2 # NOT OK -- OpenBSD 4.0 (fresh install), Yaz 2.1.38, Net::Z3950 0.51, Event 1.08 # perl test.pl Type something: test1 You typed test1 Type something if you can: Use of uninitialized value in scalar chomp at test.pl line 15, <STDIN> line 1. Use of uninitialized value in concatenation (.) or string at test.pl line 16, <STDIN> line 1. You typed # *** Checking for ZOOM *** OK -- OpenBSD 4.0, Yaz 2.1.38, (no ZOOM) # perl test.pl Type something: test1 You typed test1 missing ZOOM Type something if you can: test2 You typed test2 # NOT OK -- OpenBSD 4.0, Yaz 2.1.38, ZOOM 1.13, Marc::Record 1.38 # perl test.pl Type something: test1 You typed test1 Too late to run INIT block at /usr/local/libdata/perl5/site_perl/i386-openbsd/ZOOM.pm line 37, <STDIN> line 1. Type something if you can: Use of uninitialized value in scalar chomp at test.pl line 15, <STDIN> line 1. Use of uninitialized value in concatenation (.) or string at test.pl line 16, <STDIN> line 1. You typed # The following warnings appear during ./configure: checking for libXML2... Not found configure: WARNING: libxml2 development libraries not found. configure: WARNING: There will be no support for SRU. checking for libXSLT... Not found configure: WARNING: libXSLT development libraries not found. checking for libEXSLT... Not found configure: WARNING: libEXSLT not enabled. pkg-config not found. checking for xsltSaveResultToString... no I have no idea if they have any relevance or not. Thanks, Mike D. -----Original Message----- From: yazlist-bounces(a)lists.indexdata.dk [mailto:yazlist-bounces@lists.indexdata.dk]On Behalf Of Mike Taylor Sent: November 7, 2006 4:57 AM To: Discussion on the YAZ Z39.50 toolkit Subject: [Yazlist] Problems with YAZ > 2.1.8 on OpenBSD Hi, Mike. I don't understand what makes you think that any of this is anything to with YAZ. It seems like a Koha installer bug to me. If you'd like us to look into it, please make a small test program that clearly demonstrates the problem, and that we can use to reproduce it. _/|_ ___________________________________________________________________ /o ) \/ Mike Taylor <mike(a)indexdata.com> http://www.miketaylor.org.uk )_v__/\ "No no, it's spelt `Luxury Yacht', but it's pronounced `Throat-wobbler Mangrove'" -- Monty Python's Flying Circus. Mike Dalgity writes: > Hi, > > I'd like to report a problem introduced between YAZ versions 2.1.8 and > 2.1.10 on OpenBSD. Ive tried the following later versions which all > exhibit the same problem: 2.1.10, 2.1.18, 2.1.24 and 2.1.38. > > Summary of the problem: During installation of Koha 2.2.x (koha.org) using > the installer.pl perl script it performs a perl module check. After this > check completes, interactive input is no longer accepted by the script and > it gets caught in an infinite loop because all responses are automatically > blank. During troubleshooting I narrowed the cause of this problem to the > following line in the checkperlmodules function of Install.pm: > unless (eval {require ZOOM}) { push @missing,"ZOOM" }; > If I comment that out then the installation proceeds normally. The same > issue was observed with Koha 2.2.5 which used Net::Z3950 instead of ZOOM. > > I then decided to test YAZ using yaz-client. I looked up the documentation > and was able to connect to Index Data's test server and test commands such > as find and scan. I don't know where to go from here so any help is > appreciated. > > I have not tried to reproduce this with other BSDs but I did compile YAZ > 2.1.10 (back in January) on Redhat FC2 and didn't have the problem. I doubt > the Koha install script is the problem as it works fine with YAZ 2.1.8. I > brought this up on the Koha mailing list at the beginning of the year but > did not receive any responses. You can read it here > http://lists.katipo.co.nz/public/koha/2006/009583.html. I've brought it up > again recently as their switch to ZOOM has caused me to run into this > problem again http://lists.katipo.co.nz/public/koha/2006/010710.html. > > I'd like to resolve this issue as Koha 2.2.6 has dropped the Net::Z3950 > module and started using ZOOM but of course ZOOM requires a recent version > of YAZ. I'll be happy to provide any additional info if requested. > > Thanks, > Mike D. > > > > _______________________________________________ > Yazlist mailing list > Yazlist(a)lists.indexdata.dk > http://lists.indexdata.dk/cgi-bin/mailman/listinfo/yazlist _______________________________________________ Yazlist mailing list Yazlist(a)lists.indexdata.dk http://lists.indexdata.dk/cgi-bin/mailman/listinfo/yazlist

2 1