- Koha - lists.katipo.co.nz

Re: [Koha] Manual for Configuring Koha's Zebra
by Quanzhong Zhang 24 May '09

24 May '09

Hi Amandeep Kansal, Thank you very much for your reply! Your experience will be of great benefit to many users. Unfortunately I am failed at step 4. My database upgraded from Koha version 2.2.9, and can not find out the filed "marcxml" in it. Thank you Zeno Tajoli! I use MARC21. I do not find out the instructions you mentioned. Error message of step 4: ============================= ... ... DBD::mysql::st execute failed: Unknown column 'marcxml' in 'field list' at /usr/share/koha/lib/C4/Biblio.pm line 852. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Biblio.pm line 853. ============================= Thank you! Zhang QZ ------------------------------ Message: 6 Date: Tue, 19 May 2009 15:03:56 +0530 From: Amandeep Kansal <kansalbpa(a)gmail.com> Subject: [Koha] Manual for Configuring Koha's Zebra To: Koha Mailing List <koha(a)lists.katipo.co.nz> Message-ID: <94752abe0905190233g4ab5f4d6q7a9eb7e3d0ac9285(a)mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" Hi, Please follow following steps. (Steps are based on linux platform) 1. First of all uninstall zebra server(previous). 2. Download and install zebra server from ( I recomended) http://ftp.indexdata.dk/pub/zebra/idzebra-2.0.18.tar.gz steps: 1. tar xvzf idzebra-XXX cd idzebra ./confidure make make install 3. please find 'zebrasrv' probably it is in /usr/local/bin/ if yes, then edit these files, /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg replace modulePath: /usr/lib/idzebra-2.0/modules with modulePath: /usr/local/lib/idzebra-2.0/modules 4. ./rebuild_zebra.pl -b -a 5. start zebra hopefully every thing will fine -- Er. Amandeep Kansal B.Tech, RHCE Network Engineer Chitkara Educational Trust Plot No.11-12,Ground Floor, Dainik Bhasker Building ,Sector 25-D, Chandigarh- 160014. +91-172-4691800 http://linuxtosavemoney.blogspot.com/

2 2

Patron login, password, card number, PIN terminology
by Nelson Fredsell -CCE 23 May '09

23 May '09

Dear all, I'm a little befuddled about the login account/borrowing account information required by Koha. Do I need three distinct pieces of information, or may I use only two pieces? eg. Patron is George Orwell User: gorwell password/pin: 1234 George's card number: 3333 Using this information, I may either 1) On the default Koha home page I can either "Log in to Your Account" with "Login" and "Password", or 2) Click the link, "Log in to your account" in the upper right. This goes to a screen that asks for "Your card number" and "Password or PIN" What's the difference? Are login and cardnumber interchangeable re OPAC and/or Circulation? Thanks, Nelson implementing a union catalogue in Cape Town, South Africa

1 0

Re: [Koha] Adding your own book covers to koha
by Vimal Kumar 23 May '09

23 May '09

Here is a simple solution to display your own book jacket in OPAC. Find the following file, /usr/share/koha/opac/htdocs/opac-tmpl/prog/en/modules/opac-detail.tmpl Open this file in a tex editor and find the following code segment, Line 57. <a href=" http://www.amazon.com/gp/reader//ref=sib_dp_pt/002-7879865-0184864#reader-link"><img border="0" src=" http://images.amazon.com/images/P/.01._PIdp-schmooS,TopRight,7,-26_SCMZZZZZZZ_.jpg" alt="Cover Image" /></a> Replace above mentioned part using following code. <img src="http://www.yourserver.com/P/.jpg" alt="Book Cover Image" /> You can place Images folder in your webspace called “P”. Otherwise you can create a folder for book jacket in the same place “opac-detail.tmpl” resides. Book jacket images must be in jpg format. Image name must be ISBN number of Books (Eg. 0060779616.jpg). Drawback of this solution is OPAC will not display images from Amazon. This solution earlier suggested by Ata ur Rehman for Koha 2.9. But this solution will also work well with Koha 3. -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

languges
by vinod kumar 23 May '09

23 May '09

Hello I am using koha-3.0.0.0 in centos-5.2 koha working successfully but how to multilanguges serch enable in koha please sugest me vinod koumar

1 0

Can't create a new thread (errno 35).
by Venita Glasfurd 22 May '09

22 May '09

Hi all, I have koha running on a shared hosted server for a small private library. For the last couple of months, we've been getting an error off and on as below. The application has been running fine on the same service provider for the last two years, but the problem surfaced a couple of months back and the frequency of the problem has been increasing. Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug at /usr431/home/r/e/readersl/public_html/modules/C4/Context.pm line 411 Can't call method "prepare" on an undefined value at /usr431/home/r/e/readersl/public_html/modules/C4/Circulation/Fines.pm line 78. I would like to know if any of you have seen this issue on your installations. My guess is this is a MYSQL/ OS environment specific issue, but could you please provide any leads on how I can pursue this with my service provider? Could there be a mysql code optimization issue? Should we be doing any database maintenance? This question may seem like a database maintenance specific question, but any help/pointers will be appreciated. Thanks, Venita.

1 0

SQL Report with Links
by Eric Bégin 22 May '09

22 May '09

Hi, I don't know if you are like me, but often I find it useful to get some links in the results of my miscelleneous SQL report. This can be achieved using the SQL's CONCAT keyword. The following SQL report list all items in your catalogue and the title is link to the biblio. > SELECT itemtypes.description, CONCAT( '<a > href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=', > biblio.biblionumber, '\">',biblio.title,'</a>' ), items.itemcallnumber > FROM biblio > LEFT JOIN biblioitems on biblioitems.biblionumber = biblio.biblionumber > LEFT JOIN itemtypes on biblioitems.itemtype = itemtypes.itemtype > LEFT JOIN items on biblioitems.biblioitemnumber = items.biblioitemnumber Enjoy! -- Eric Bégin http://www.inLibro.com 514.777.6572

1 0

index
by Luis Diaz 22 May '09

22 May '09

Hello just this question after marc file import via import tools, the bib records are not present in OPAC. Do I iniciate a special job to index database?? Thanks a lot -- Luis Diaz PIC (Port d'Informació Científica) Campus UAB, Edificio D E-08193 Bellaterra, Barcelona Tel: +34 93 581 33 08 Fax: +34 93 581 41 10 http://www.pic.es Avis - Aviso - Legal Notice: http://www.ifae.es/legal.html

2 4

Strange issues with items after upgrading to Koha 3
by Andrew Yager 22 May '09

22 May '09

Hi, We appear to have an issue with our items table after upgrading to Koha 3. A number of books just do not appear in the items table, and as a result we can't issue them or modify the item details. We are running Marc 21 - is there a script we need to run to make this part of the import work? The Item Data appears in the Marc record in the biblioitems table. Thanks, Andrew -- Andrew Yager, Managing Director (MACS BCompSc MCP) Real World Technology Solutions Pty Ltd - your IT department ph: 1300 798 718 or (02) 9037 0500 fax: (02) 9037 0591 mob: 0405 152 568 http://www.rwts.com.au/ or http://www.stonebridgecomputing.com.au/

1 0

Adding your own book covers to koha
by Suchetha Wijenayake 22 May '09

22 May '09

Hello all. I am setting up koha for a developmental organisation here in Sri Lanka (you may have heard of the country, its been in the news a few times lately). They have a rather large collection of technical books that they have published, and they want to put the covers on the koha DB so that people can know what the book SHOULD look like. They also want to put the back cover and contents page(s) up in the same way. I have looked high and low for an efficient way of doing this, and I am at wit's end. Most places recommend using Amazon covers, but there is no chance the books will be on AMZN (self-published and all that dontcherknow). So where do I go from here? Does anyone have any ideas? Or has anyone done this? Thanks Suchetha -- Check my photo album: http://picasaweb.google.com/suchetha Rants Raves and Miscellaneous Musings: http://raramimu.blogspot.com Why do I smell brimstone? And what am I doing in this hand-basket?

3 4

LDAP schemas for Koha
by Ben Finney 22 May '09

22 May '09

Howdy all, I'm setting up Koha for a client. They have an existing LDAP directory for user account authorisation, and want to use that for Koha's borrowers and administrators. There is documentation on making custom LDAP mappings, but I'm not sure what LDAP schemas are *needed* by Koha. What more is necessary beyond the common ‘person’, ‘posixAccount’, ‘inetOrgPerson’? -- \ “I watched the Indy 500, and I was thinking that if they left | `\ earlier they wouldn't have to go so fast.” —Steven Wright | _o__) | Ben Finney

2 2