- Koha - lists.katipo.co.nz

How to Set up
by Andrew Harris 28 Apr '09

28 Apr '09

Hello. I am working with an NGO and we shipped 2 libraries (about 2000 titles) to korea. We are looking for a open source system to catalogue, and hear Koha is the best bet. We are very green at this and are hoping for some advice, on how to download, set up, and run the libraries. I'll be heading over to Korea this friday, so any info before would be great appreciated. Thank you Andrew Harris andrewericharris(a)gmail.com 778-997-3435 4LIFE

1 0

Cannot find recently added items?
by Marty 28 Apr '09

28 Apr '09

After doing a force (re)install of MARC::File::SAX I do not get a 'production mode - trapped fatal error' error. It's something. However, after adding some books for testing, I cannot find them in Koha 3. Searching on barcode or title does not return anything. They do show up in mysql (see below). I did a rebuild_nozebra. All previously imported items (from koha 2.2.9) do show up. The koha logs don't show any errors apart from some missing stylesheets. The apache2 log however, returns heaps, I just show the bottom end of it here: [Tue Apr 28 15:45:41 2009] additem.pl: Use of uninitialized value in addition (+) at /usr/share/koha/lib/C4/Biblio.pm line 2538. [Tue Apr 28 15:45:41 2009] additem.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/Biblio.pm line 2485. [Tue Apr 28 15:45:41 2009] additem.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/Biblio.pm line 2485. [Tue Apr 28 15:50:56 2009] search.pl: kw,wrdl= pearl harbor at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. [Tue Apr 28 15:53:08 2009] [error] [client 192.168.0.100] File does not exist: /var/www/HNAP1 [Tue Apr 28 15:53:11 2009] [error] [client 192.168.0.100] File does not exist: /var/www/TEADevInfo [Tue Apr 28 15:55:40 2009] search.pl: bc,wrdl= 32541 at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. [Tue Apr 28 15:55:53 2009] search.pl: 33333 at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. [Tue Apr 28 16:04:14 2009] opac-search.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1001. [Tue Apr 28 16:04:14 2009] opac-search.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1001. [Tue Apr 28 16:04:14 2009] opac-search.pl: Use of uninitialized value in concatenation (.) or string at /usr/share/koha/lib/C4/Biblio.pm line 1001. [Tue Apr 28 16:13:12 2009] [error] [client 192.168.0.100] File does not exist: /var/www/HNAP1 [Tue Apr 28 16:13:15 2009] [error] [client 192.168.0.100] File does not exist: /var/www/TEADevInfo [Tue Apr 28 16:13:38 2009] search.pl: bc,wrdl= 33333 at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. [Tue Apr 28 16:13:55 2009] search.pl: library at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. [Tue Apr 28 16:14:20 2009] search.pl: library at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. [Tue Apr 28 16:14:34 2009] search.pl: library at /usr/share/koha/intranet/cgi-bin/catalogue/search.pl line 463. mysql> select biblionumber, author, title from biblio where biblionumber > 7069; +--------------+-------------------+------------------------+ | biblionumber | author | title | +--------------+-------------------+------------------------+ | 7070 | Manguel, Alberto. | The library at night / | | 7071 | Manguel, Alberto. | The library at night / | | 7072 | Wallace, Randall. | Pearl Harbor / | | 7073 | Wallace, Randall. | Pearl Harbor / | +--------------+-------------------+------------------------+ 4 rows in set (0.07 sec) mysql> select biblionumber, barcode from items where biblionumber > 7069; +--------------+---------+ | biblionumber | barcode | +--------------+---------+ | 7072 | 32541 | | 7073 | 33333 | +--------------+---------+ 2 rows in set (0.43 sec) Please help, Marty

1 0

SIP Problems
by Scott Kushner 28 Apr '09

28 Apr '09

Trying to run SIP Server in Koha 3.01 and running into problems. Followed installation instructions to the letter...Getting error message..any info on this would be greatly appreciated. Thanks, mplkoha:~/kohadev/C4/SIP# make test cd t; make test make[1]: Entering directory `/root/kohadev/C4/SIP/t' prove -I../ -I./ 000_sc_config_auth.t 00sc_status.t 01patron_status.t 02patron_info.t 03checkout.t 04patron_status.t 05block_patron.t 06patron_enable.t 07hold.t 08checkin.t 09renew.t 10renew_all.t 11item_info.t 000_sc_config_auth....NOK 2/15 # Failed test 'use SIPtest;' # at 000_sc_config_auth.t line 13. # Tried to use 'SIPtest'. # Error: Can't locate C4/Auth.pm in @INC (@INC contains: ../ ./ /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at /SIPtest.pm line 47. # BEGIN failed--compilation aborted at 000_sc_config_auth.t line 13. # Compilation failed in require at (eval 4) line 2. # BEGIN failed--compilation aborted at (eval 4) line 2. 000_sc_config_auth....NOK 3/15 # Failed test 'use C4::Auth;' # at 000_sc_config_auth.t line 14. # Tried to use 'C4::Auth'. # Error: Can't locate C4/Auth.pm in @INC (@INC contains: ../ ./ /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at (eval 10) line 2. # BEGIN failed--compilation aborted at 000_sc_config_auth.t line 14. 000_sc_config_auth....NOK 4/15 # Failed test 'use C4::Context;' # at 000_sc_config_auth.t line 15. # Tried to use 'C4::Context'. # Error: Can't locate C4/Context.pm in @INC (@INC contains: ../ ./ /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at (eval 11) line 2. # BEGIN failed--compilation aborted at 000_sc_config_auth.t line 15. Global symbol "$username" requires explicit package name at 000_sc_config_auth.t line 22. Global symbol "$username" requires explicit package name at 000_sc_config_auth.t line 22. Global symbol "$password" requires explicit package name at 000_sc_config_auth.t line 23. Global symbol "$password" requires explicit package name at 000_sc_config_auth.t line 23. Global symbol "$username" requires explicit package name at 000_sc_config_auth.t line 25. Global symbol "$username" requires explicit package name at 000_sc_config_auth.t line Scott Kushner Information Technologies Middletown Public Library

1 0

upgrade from 2.2.0 to 3
by john smith 28 Apr '09

28 Apr '09

Hi to all I have talk a backup datafrom koha 2.2.0 " koha.sql " and i have installed koha 3 on ubuntu 8.04 i need help to how convert data to koha 3.0.1 thnks _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/

2 1

Migrating data from phpmylibrary to Koha
by Melanie Saldua 28 Apr '09

28 Apr '09

How to do it exactly? I have an idea but I don't know if it is right or not. Here's my idea. 1. Extract the database and export it as an excel file 2. Map/Match the fields from phpmylibrary and koha 3. Manipulate the data (excel file) to match koha's database structure 4. Save the data as text file with tabs as separation 5. Import/Dumb the data (text file) into koha's database by using webmin's import from text file feature. Anyone have a better idea? A faster way to migrate the data? A script for data migration maybe? It will help me a lot. Thanks

1 0

Workshop ON Koha- Brochure
by Bruce Mathew 27 Apr '09

27 Apr '09

Dear KOHA Users/Administrators We are happy to organise a 2 day workshop on KOHA at UNION CHRISTIAN COLLEGE, ALWAYE, KERALA INDIA jointly with NRCFOSS, ANNAUNIVERSITY, CHENNAI. I have attached the brochure along with this mail. But can anyone help me in putting this information at KOHA website? Please also update me with website changes. -- Happy Hacking--- Bruce Mathew, MCA Department, Union Christian College Aluva 683102 Kerala . ------------------------------------------------------------------ Ph: Office- +91-484-2603533 Mob: +91-9447209932 =============================================================== Microsoft is not the answer; Microsoft is the question. Avoid the Gates of Hell. Use Linux ===============================================================

2 1

creating macros
by Rebecca J. Fitzgerald 27 Apr '09

27 Apr '09

Does anyone know how to create macros in koha or how to save your selections? This would be especially helpful in the staging of marc records. Thanks for your help! Rebecca Fitzgerald Acquisitions Librarian/Office Manager Scheele Memorial Library Concordia College Phone: (914)337-9300 x2205 Cell: (845)558-5246

1 0

Migration how to
by Nelson Fredsell -CCE 27 Apr '09

27 Apr '09

Were setting up a small consortium of NGO/non-profit libraries, using a single Koha installation. Some of them use Dewey, some dont. Settings for multiple classification schemes -- In Home | Admin | SysPrefs | Cataloguing itemcallnumber: I suppose Dewey collections would assign 082, but non-Dewey 852? What setting to use when multiple schemes exist? Catalogue Migration: Is there any documentation on how to do this, in addition to the brief descriptions in the Koha manual? Ø Were moving from proprietary-format Microsoft Access to MARC-format Koha. Freeware utilities to make this possible? Im not sure MarcEdit is quite there yet, maybe with next release? Ø Cleaning up the data. Wed like to run Z39.50 searches on our items once in Koha, but wont this delete important MARC data 9xx, like barcode / itemcallnumber / etc.? What if we used proprietary keywords, notes, categories that we want to keep? Does the native Koha Z39.50 search remove all this? Ø Does anyone ever use a utility to access the (Zebra?) data directly, rather than via the Koha front end? Couldnt I cleanup data more quickly using a model like Microsoft Access attached tables? Is Zebra a relational database? Ø Do I want to consider XML format as an intermediary between MARC and Access? I dont know anything about XML format. Any further documentation on migration of Circulation, Authorities? I did manage to import Patrons with the Koha interface! Thanks very much, Nelson Fredsell Cape Town, South Africa www.cfce.org.za

2 1

Modifying Field's Data Type In the Koha Database
by Melanie Saldua 27 Apr '09

27 Apr '09

Hello! I'm a new koha user and I'm trying to migrate my existing database to the koha database. I was wondering if it is possible to change the data type of the fields in the koha database? I need to modify biblionumber's data type from int(11) to bigint(100). Is there a faster way to do it than modify every table?

3 2

Re: [Koha] koha features
by BWS Johnson 27 Apr '09

27 Apr '09

Salvete! >We have been trying Fedora also as it supports both Zebra and Lucene. Is >anyone working on Fedora? > If you're looking for Lucene, you might want to take a look at the cool stuff going on over at AgNic with SOLR. http://www.agnic.org/advsearch/?keywords=hybrid+corn&submitted=1&searcht ype=All Amazing stuff for a more or less one man shoppe putting that up. Cheers, Brooke

1 0