- Koha - lists.katipo.co.nz

Wrong SAX Parser - does it matter?
by agiesler＠wisc.edu 12 Nov '08

12 Nov '08

Hello, I'm installing Koha 3 on Ubuntu 8.10. When I try this: # ./misc/sax_parser_print.pl .instead of the expected "XML::LibXML::SAX::Parser=." I get "XML::SAX::Expat=.". Does it matter? A few days ago I made it through a Koha install this way and things seemed to work fine anyway. Will this lead to subtle errors if I don't fix it? I've read this post (http://www.nabble.com/XML::LibXML-problem-td19159082.html) but I still don't see the expected parser string. Before trying the script I've done all of these: # apt-get install libgdbm-dev # apt-get install libxml-libxml-perl # cpan XML::LibXSLT # cpan XML::LibXML # cpan XML::LibXML::SAX # cpan XML::LibXML::SAX::Parser ----------------------------------------------------------------- Andy Giesler University of Wisconsin-Madison

4 4

Error while Creation of Budget for Book Funds
by Sai Bhalaji D. 12 Nov '08

12 Nov '08

Hi, I have an issue in creating budget for the bookfunds. When I try to create a budget for the book fund, when I click on OK, it does not display the entered budget. I checked the log and found the error message as shown below: [Wed Nov 12 11:26:34 2008] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Incorrect integer value: '' for column 'aqbudgetid' at row 1 at C:/usr/koha229/intranet/cgi-bin/koha/admin/aqbudget.pl line 170., referer: http://intranet/cgi-bin/koha/admin/aqbudget.pl?op=add_form&bookfundid=BIO I checked the script and just deleted the aqbudgetid parameter that was being passed in since the database had an autoincrement. This gave me a solution to the issue. But is there any other proper way of doing this. Also, I found in the database that, the branchcode for the budget is not getting entered. Please let me know, what needs to be done regarding this. Thanks, Sai Bhalaji Sri Sathya Sai University.

2 1

Migrating old data to a new installation of Koha
by benson Mugambi 12 Nov '08

12 Nov '08

Hi folks, I have done a clean install of Koha 3.0 on Ubuntu 8.0 and i need to migrate my old data from Koha 2.2.9 but am facing some problems. THe old database has about 74 tables, the new one has 125. When i import data using phpmyadmin, the system terminates at the first table due to primary key differences in the both structures. Can someone advice me the best way i should migrate this data to maintain integrity of the MARC structure flawlessly. Thanks Benson Mugambi SHAREDOC What comes out of you when you are squeezed is what is inside you. - Wayne Dyer

2 2

related fields
by Marisa Wood 12 Nov '08

12 Nov '08

Hi there, I have, hopefully, a simple question. I've recently installed 3.0, and previously had 2.2.8. I had to scratch the old install, so I'm starting over. The only configuration that I am having trouble duplicating is "related-fields." In the previous iteration this was managed when defining the subfields within the bib. frameworks, but I'm not seeing the option in 3.0 and I'm not finding any mention of it in the manual. Can someone point me in the right direction? I'm sure I'm being terribly dense, so any advice would be great. Many thanks! Marisa Wood, MLIS BCR 14394 E. Evans Ave. Aurora, CO 80014 303.751.6277/800.397.1552

2 1

Consumed resources (leaflets) in the Koha catalogue
by MJ Ray 12 Nov '08

12 Nov '08

Is anyone here using Koha to catalogue, stock-control and re-order leaflets? What's your workflow for doing that? I searched the archives and didn't find much discussion of this, but it seems quite a common need for information libraries. Is there some other piece of software for leaflet and flier management, or is it all done visually by most libraries? Thanks for any feedback, -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237

1 0

Re: [Koha] Uploading Bibs from staging area...Koha
by Scott Kushner 11 Nov '08

11 Nov '08

Actually, I can UPLOAD records, but when I go to STAGE FOR IMPORT, that's where it gets stuck. Then if I go to the MANAGE STAGE MARC RECORDS, I can see the bib files loaded, but there is no way to STAGE, or COMMIT them to the catalog. Not sure what's happening here. Thanks, Scott Kushner Information Technologies Middletown Public Library From: Susan Bennett [mailto:susan.bennett@geaugalibrary.info] Sent: Tuesday, October 28, 2008 9:02 PM To: Scott Kushner Subject: Re: [Koha] Uploading Bibs from staging area...Koha Hi Scott, So you've staged the records, gone into manage the staged MArC records and imported them, and they are not showing up in the catalog? Do I have the problem right? How often are you re-indexing? We had similar problem that turned out to be a corrupt record keeping the imported items "stuck" it the reservoir. We had to find the bad record and make the needed corrections to it and then all the records behind it were imported. Susan Bennett ILS System Administrator Geauga County Public Library 440 286-6811 x 125 440 286-7419 FAX On Tue, Oct 28, 2008 at 6:34 PM, Scott Kushner <skushner(a)mplmain.mtpl.org> wrote: Thanks, we're on Koha 3.0, but I don't see a place to "commit" the bibs to koha. I think it's some kind of Zebra timing issue Thanks, Scott Kushner Information Technologies Middletown Public Library From: Susan Bennett [mailto:susan.bennett@geaugalibrary.info] Sent: Tuesday, October 28, 2008 4:17 PM To: Scott Kushner Subject: Re: [Koha] Uploading Bibs from staging area...Koha Hi Scott, Are you on Koha 3? If so go into manage staged MARC records under tools. If you don't already have it the manual is at: http://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents I've had pretty good luck finding what I need here. Susan Bennett ILS System Administrator Geauga County Public Library 440 286-6811 x 125 440 286-7419 FAX On Tue, Oct 28, 2008 at 11:09 AM, Scott Kushner <skushner(a)mplmain.mtpl.org> wrote: I have no problem uploading bibs to staging area, but then there is no button or instructions on how to commit the upload to the database. What seems to be happening here? Anyone...? Scott Kushner Information Systems Librarian Middletown Public Library _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha <http://lists.katipo.co.nz/mailman/listinfo/koha>

1 2

Fw: Catalog search returns "No results found"
by Magnus Enger 11 Nov '08

11 Nov '08

Hi, Melisa! Have you checked the error-logs? On a standard install they should be in something like /var/log/koha and have names like koha-error_log, koha-zebradaemon-output.log, koha-opac-error_log, koha-zebraqueue.err, koha-zebradaemon.err, koha-zebraqueue-output.log (I think some of those are "non-standard" and have to be turned on actively.) You might get some idea of where the trouble is by looking at the end of these files. I had the same problem on a recent install, and the solution turned out to be that I was running zebra as a user named koha, while some of the necesarry files were owned by root. The solution was to run a command like $ chown -R koha:koha /var/koha/* to change the ownership of the necessary files. Good luck! Magnus "May the source be with you!" ----- Original Message ----- From: "Melisa Canales" <mcanales29(a)gmail.com> To: koha(a)lists.katipo.co.nz Sent: Tue, 11 Nov 2008 11:43:43 -0600 Subject: [Koha] Catalog search returns "No results found" > Hello, > We have a Ubuntu server running an older version of Koha (2.2.6). We are > trying to move to Koha 3.0, so I have done a fresh install of Koha > 3.00.00.107 on a different machine where I have installed Debian "etch". I > have also installed Zebra 2.0.32. I have followed the instructions in the > INSTALL.debian file and the Koha installation seemed to work out ok. To get > our existing data from the old machine, I did a mysqldump and moved the data > to the new box. I then followed the instructions in the "Upgrading from > Koha 2.2 to Koha 3.0" document to get the database in shape for Koha 3.0. > That seemed to work as I can search patrons and I can view all the data in > mysql or phpmyadmin. However when I try to search for titles through the > Koha intranet or opac, I get the "No results found" message. I have started > zebra and run the rebuild_zebra script and still get the same message. I > have tried to enter a new record, run rebuild_zebra, search - and still no > results found. I'm not sure what to do at this point. Any ideas? > > Thanks, > mc

1 0

Catalog search returns "No results found"
by Melisa Canales 11 Nov '08

11 Nov '08

Hello, We have a Ubuntu server running an older version of Koha (2.2.6). We are trying to move to Koha 3.0, so I have done a fresh install of Koha 3.00.00.107 on a different machine where I have installed Debian "etch". I have also installed Zebra 2.0.32. I have followed the instructions in the INSTALL.debian file and the Koha installation seemed to work out ok. To get our existing data from the old machine, I did a mysqldump and moved the data to the new box. I then followed the instructions in the "Upgrading from Koha 2.2 to Koha 3.0" document to get the database in shape for Koha 3.0. That seemed to work as I can search patrons and I can view all the data in mysql or phpmyadmin. However when I try to search for titles through the Koha intranet or opac, I get the "No results found" message. I have started zebra and run the rebuild_zebra script and still get the same message. I have tried to enter a new record, run rebuild_zebra, search - and still no results found. I'm not sure what to do at this point. Any ideas? Thanks, mc

1 0

Online survey
by Anuradha KT 11 Nov '08

11 Nov '08

Dear KOHA user, As part of an ongoing project on Integrated Library Automation Packages (ILAP) carried out at National Centre for Science Information, Indian Institute of Science, Bangalore, India, a survey of ILAP is carried out. We know that you are busy and hard pressed for time. But your response will help us to get a clear view of the present scenario of ILAP. Hence we request you to take some time off to fill in the questionnaire. We assure you that whatever information you provide us will be used for academic purpose only and kept confidential. Please note that the survey is open for all. The online survey form can be accessed at: http://dharmaganja.ncsi.iisc.ernet.in/index_files/surveyinstrument.html However, if you have problem in accessing the online survey, for your convenience a few questions are given below, which you can fill in and reply back to survey(a)dharmaganja.ncsi.iisc.ernet.in 1. Your Name: 2. Official Address: 3. E-Mail ID: official: other: 4. If you are using any of following software for your library automation, kindly name them: 4.1 Library Automation Software (such as Koha, Evergreen, NewGenLib): 4.2. Meta Search (such as AGent , MetaFind, ZPortal): 4.3. Link Resolver (such as 360 Link Serial Solution, V-Link): 4.4. Electronic Resource Management (such as 360 Resource Management): 4.5. Institutional Repository (such as EPrints, DSpace, Fedora): 4.6. Digital Collection Tool (such as Greenstone Digital Library): 5. Kindly give corresponding URL of the above implementation(s): 6. If you know any other library using the above mentioned software give URL of them also: ------------------------------------------------------------------------------------- Regards, Anuradha -------------------------------------------------------------------------- Ms.K.T.Anuradha E-mail: anu(a)ncsi.iisc.ernet.in Senior Technical Officer URL:vidya-mapak.ncsi.iisc.ernet.in National Centre for Science Information Indian Institute of Science FAX:(+91-80) 23601426/23600683 Karnataka, Bangalore 560 012 Tel:(+91-80) 23600271/22932511 India --------------------------------------------------------------------------- Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/

1 0

URI field link options
by Doug Dearden 10 Nov '08

10 Nov '08

Hello all, I have a successful install of Koha 3.0 (revision 17 I believe) running on Debian etch, Apache2, Mysql 5.0. In some cases we will be using this to catalog a computer file of some sort - text or maybe images or sound. I find I can get this to work by putting in the full path to the file - http://ipaddressofserver/directory/filename, but am trying to figure out a way to use a variable for the first part of that so that I can move the directory in the future and not have to reenter all of the links. For instance, a cataloged entry pointing to text_directory_variablename/filename is reinterpreted to http://kohaserver_ip_address/localtext/filename. Or sound_directory_variablename is reinterpreted to http://another_web_server_ip_address/some_directory/filename. I have tried using some SetEnv statements in the koha-httpd.conf file and also an extra entry in the <config> section of the koha-conf.xml file, but these did not work - the link shows up without reinterpreting the variable name. At this point the best I have been able to do is to use http://kohaserver/a_directory/filename and then create a DNS entry for the kohaserver that points to the correct IP address. My concern is looking toward the future, and trying to make things as flexible as possible - so that these files could be moved later and the only change to make it work would be reconfiguring what the variable points to. Writing this I am thinking that there is probably not code in Koha to automatically do this, but not being a perl programmer I am not sure where I would start looking. If a code modification is what it would take, a little bird dogging to the right place would help me also. Thanks, Doug

2 4