- Koha - lists.katipo.co.nz

koha help
by Rupesh Gaur 29 Dec '09

29 Dec '09

I am using Koha 2.8 version, How can download marc LC record in resrvior and use it in our databaseWith warm regards,Rupesh GaurLibrarianI G N College (Affilated to Kurukshetra University Kurukshetra )Ladwa (Kurukshetra)Ph. No. 01744- 260334, 260114(O)Mobile No 919466694800919896294550 (R)E Mail: rupesh_gaur@rediffmail.comrupesh_gaur2003@yahoo.comgaurrupesh@gmail.com

2 1

Help needed in Conditional variables passing to templates
by nitesh rijal 28 Dec '09

28 Dec '09

Hello all. I am using KOHA 3.0.3 in Debian Lenny. I am trying to integrate the fulltext viewing option of GSDL in KOHA in a different way than the existing one. When we search for a string in KOHA then it displays a list of results. I am trying to make a link to GSDL fulltext option through KOHA records directly. In the search results we have a place holder named "ACTION" where I have placed a link "View Full Text". On clicking the link it goes to the GSDL and searches the records for the particular author and title. I found that matching both title and author is not possible in GSDL so I decided to match just the author and display results. My main problem is that, I have made a field 953 'a' for storing whether the particular record has fulltext or not. If the field says "YES" then I need to display the "View Full Text" link in the "ACTIONS" placeholder of the search results. I have come to know that we can use  to make conditional variable passing and displaying, but I am having a problem in deciding whether the field 953 'a' contains a "YES" or a "NO". How can I find out that for every record in the current search result. I have looked into the search.pl and search.tmpl but got no idea from that. Please Help me. Thank you. -- Nitesh Rijal BE IT email: rijal.it(a)gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173

1 0

Fwd: [Koha-devel] Koha Cache -- Problem with Changing Admin Password?
by Chris Nighswonger 24 Dec '09

24 Dec '09

Hi Rick, Please post the output from this SQL executed at a mysql prompt: SHOW GRANTS FOR 'kohaadmin'@'localhost'\G Also, please cc the list as there may be others who can help or be helped by this thread. Kind Regards and Merry Christmas, Chris ---------- Forwarded message ---------- From: Richard Forristall <Richard.Forristall(a)goodwillaz.org> Date: Thu, Dec 24, 2009 at 12:50 AM Subject: RE: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? To: Chris Nighswonger <cnighswonger(a)foundations.edu> Hi Chris, Yes, from the command line I get access to mysql with the password I put into koha-conf.xml and I already restarted apache2. Thanks, Rick -----Original Message----- From: Chris Nighswonger [mailto:cnighswonger@foundations.edu] Sent: Wed 12/23/2009 6:42 PM To: Richard Forristall Cc: koha-devel(a)lists.koha.org Subject: Re: [Koha-devel] Koha Cache -- Problem with Changing Admin Password? Hi Rick, 2009/12/23 Richard Forristall <Richard.Forristall(a)goodwillaz.org>: > Does Koha use a cache to remember config settings in OPAC and Intranet? Not these. > > I updated koha_conf.xml to change the password and now in the librarian view > and OPAC view I get this error: > > Access denied for user 'kohaadmin'@'localhost' (using password: YES) at > /home/koha/kohaclone/C4/Context.pm line 667. > Compilation failed in require at /home/koha/kohaclone/C4/Circulation.pm line > 25. This line indicates that somehow the password in koha-conf.xml does not match the one in mysql. Can you access the db via 'mysql -ukohaadmin -p' with the same password presently in koha-conf.xml? Kind Regards, Chris

2 2

Labels and zebra search not working after migrating data
by Marty 23 Dec '09

23 Dec '09

After installing koha-3.04 stable everything worked fine, I could enter biblios, patrons, use search with zebra and make labels. However, after moving my data from koha 2.2.9, following instructions from http::/wiki.koha.org/doku.php?id=22_to_30 koha ONLY works with nozebra, and the labels page shows: Layout: No Layout Specified: Select a Label Layout Template: No Template Specified: Select a Label Template Batch: Create a new batch And I cannot really do anything with any of these, it does not seem to save anything. Koha does work with zebra turned off, meaning I can search, checkout, check in, etc, but I really would like to have the zebra search options and the labels working. The logs don't show too much errors, see below. If there is a better method to migrate data from the 2.2.9 version, please let me know. Or any ideas to get this working. It is frustrating that it works so well until I migrate the data. Thanks, Marty rebuild_zebra.pl -b -w always ends with; zebraidx(3131) [warn] Record didn't contain match fields in (bib1,Local-number) koha-error_log output: (partial) [Wed Dec 23 13:42:29 2009] [error] [client 127.0.1.1] [Wed Dec 23 13:42:29 2009] circulation.pl: Use of uninitialized value in pattern match (m//) at /usr/share/koha/lib/C4/Biblio.pm line 2866., referer: http://debian:8080/cgi-bin/koha/circ/circulation.pl koha-zebradaemon-output.log 23:06:07-22/12 zebrasrv(6) [warn] Record didn't contain match fields in (bib1,Local-number) koha-zebraqueue-output.log DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 124. DBD::mysql::st execute failed: Unknown column 'done' in 'where clause' at /usr/share/koha/bin/zebraqueue_daemon.pl line 123. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/bin/zebraqueue_daemon.pl line 124. biblios@debian:/usr/share/koha/bin/migration_tools$ sudo perl -I /usr/share/koha/lib rebuild_zebra.pl -b -w 14:57:02-23/12 zebraidx(3131) [warn] Record didn't contain match fields in (bib1,Local-number) __________________________________________________________________ Ask a question on any topic and get answers from real people. Go to Yahoo! Answers and share what you know at http://ca.answers.yahoo.com

1 0

Circulation and import reservoir questions
by Amy Schuler 22 Dec '09

22 Dec '09

Hello, Using a combination of bulkmarcimport script and the web interface (stage MARC/manage MARC), I finally got my data into Koha 3.0. Thanks again for all of the help! I also got my patron information imported, and have been poking around and see a few odd things. Here is one, in circulation: In the profile for "Betty Smith", who is indeed one of my library patrons, there is a complete stranger listed as Betty's guarantee. I do not have any clue who this person (the guarantee) is, but she is affiliated with one of the other libraries that are in the drop-down menu when I log onto the staff client (is there a way to delete these?) Sure enough, when I look at the guarantee's profile, my patron Betty is listed as her guarantor. Can anyone tell me how - or if - I can sever this relationship? Here is another question about Koha cataloging. In the cataloging module, when I search for a record to edit, it results in the records currently in my catalog as well as previous iterations from the import reservoir (imports that I reverted). Is there a way I can clear out the reservoir of staged and reverted imports? If you can answer either or both of these questions, I appreciate it. Thanks a lot! Amy Amy C. Schuler Manager of Information Services Cary Institute of Ecosystem Studies PO Box AB Millbrook, NY 12545 (845) 677-7600 x164 schulera(a)caryinstitute.org<mailto:schulera@ecostudies.org>

1 0

Call numbers from 099
by Elaine Bradtke 22 Dec '09

22 Dec '09

I thought I got this to work, but now I'm hopelessly confused. (version : 3.00.01.005) We have our own system of call numbers, which I was planning on putting into 099a I thought I had figured out how to get Koha to take the contents of the 099a and put it into 952o. But now it doesn't seem to do it. I fear I've twiddled too many settings and have gotten myself into a muddle. a) what settings do I need in the MARC format to have Koha put the 099a call number into the 952o field? b) or is this something I should set up to happen during our data migration? It just seems like a lot of work to have to retype the same call number for every item. . . Thanks! -- Elaine

3 2

sorting authorities results
by Samo Se 22 Dec '09

22 Dec '09

helloWhen search in the authorities fields,,The ordering of results incorrectlyHow to Make the results arranged correctly _________________________________________________________________ Windows 7: Make your own home movies. Learn more. http://download.live.com/moviemaker

1 0

KOHA 3.0.5 - Add item(s) to batch link not working
by hasina＠bracu.ac.bd 22 Dec '09

22 Dec '09

Dear all We have just installed KOHA 3.0.5. It seems ok except when we click on Add item(s) to batch, it doesn't work. We need your help please. regards hasina afroz Deputy librarian (Head of Library) BRAC University Bangladesh

1 0

KOHA Error Redirecting Help
by nitesh rijal 22 Dec '09

22 Dec '09

Hello all. I am having some problem with redirecting a standard KOHA Error to some other page. Actually I've modified a function to navigate to next and previous biblionumber within the records in KOHA. The problem is that if I supply a existing biblionumber it works fine, but when I supply a biblionumber that is not present then it gives the following error. Koha error > > The following fatal error has occurred: > > Can't call method "title" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 878. > > Apache Server version: Apache/2.2.9 (Debian) Server built: Nov 14 2009 > 20:23:49 Koha 3.00.02.012 Koha DB 3.0002012 MySQL mysql Ver 14.12 Distrib > 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux > koha.healthnet.org.np 2.6.26-2-686 #1 SMP Wed Nov 4 20:45:37 UTC 2009 i686 > Perl 5.010000 I just want to format that ERROR message to display something else or just redirect to a "ADD New Record" form. I cannot find where the error is being displayed from. Please if anyone knows where to change these things, help me. Thank you. -- Nitesh Rijal BE IT email: rijal.it(a)gmail.com url: http://niteshrijal.com.np facebook: http://facebook.com/openrijal twitter: http://twitter.com/openrijal +9779841458173

1 0

critical omission in INSTALL.debian-lenny
by Emrys Minnig 21 Dec '09

21 Dec '09

Section 1.3 in the INSTALL.debian-lenny file should conclude with 'sudo apt-get update'. I suspect that many of the numerous Zebra problems that have been surfacing on this mailing list may be a result of this oversight. I recently did an install where I was a bit too focused on the instructions and stupidly forgot to run this command after adding the Indexdata (Zebra) URLs to sources.list. As a result, Zebra was not installed. Even though I configured my Koha installation to run Zebra, I never received warnings that the dependencies were not present. In fact, rebuild_zebra.pl seemed to run without errors, but all catalogue searches yielded no results. After discovering that Zebra had not actually been installed, I ran 'apt-get update' and was then able to install it. Unfortunately, either due to it not being the correct version or it not being present during koha's installation process, there are permissions problems and koha-zebra-ctl.sh is not functioning properly. (I have to use 'sudo zebrasrv -f /etc/koha/koha-conf.xml &', which works but is obviously not ideal.) I probably shouldn't have missed this (unwritten) step after installing Koha successfully several times. I'm certainly am not complaining! Koha is frikkin epic, as are all those people putting so much of their lives into it. Happy holidays! Emrys

1 0