- Koha - lists.katipo.co.nz

Is KOHA suitable for Digital Library?
by atiqse 11 Mar '11

11 Mar '11

I am new to KOHA ILS Solution, Can any body guide me that whether or not to use the KOHA ILS in place of digital library requirements? To what extend can KOHA cater to manage digital contents (PDF and TIFF and etc)? Regards, ATEEQ -- View this message in context: http://koha.1045719.n5.nabble.com/Is-KOHA-suitable-for-Digital-Library-tp34… Sent from the Koha - Discuss mailing list archive at Nabble.com.

10 12

Recovering from corrupt innodb tables
by Chris Hobbs 11 Mar '11

11 Mar '11

Hi all, Just got done pulling off a (very) minor miracle, but thought I'd document it in the hopes that someone else in the same boat finds it useful. We've been having performance problems for over a week, and I finally got around to checking the correct logs, and discovered that we had a corrupt page in one of those lesser used koha tables, something called biblio :-/ Of course, since I'd let it slide for over a week, bringing biblio back from backup would have meant lots of re-work for any cataloging done since the corruption began. Because of the corrupt page, whenever a request was made against that particular page, the mysql database would restart, dropping the connections and causing general chaos. And thanks to google's robot, that corrupt page was getting hit pretty regularly as it turns out. Some googling gave me an idea of how to retrieve what I could from the table (think binary search), finding the edges of the corrupt page. I ended up being able to recover all of the biblio records from 1-30227, and from 30313-91859, leaving a gap of 85 missing biblios. I could have made our library technician (hi Katie) rebuild those records by hand, but biblioitems has all of the required information stored in the marcxml field. Thanks to prior questions being asked and answered on the list, I was able to put together the following query to recreate the missing records. insert into biblio select biblionumber, '' framework, extractValue(marcxml,"record/datafield[@tag='100'][1]/subfield[@code='a']") author, extractValue(marcxml,"record/datafield[@tag='245'][1]/subfield[@code='a']") title, NULL, NULL, extractValue(marcxml,"record/datafield[@tag='440'][1]/subfield[@code='a']") REGEXP '[a-zA-Z]' series, extractValue(marcxml,"record/datafield[@tag='440'][1]/subfield[@code='a']") series_title, substring(extractValue(marcxml,"record/datafield[@tag='260'][1]/subfield[@code='c']"),2,4) copyright, NULL, '2010-07-23', extractValue(marcxml,"record/datafield[@tag='520'][1]/subfield[@code='a']") abstract from biblioitems where biblionumber >= 30228 and biblionumber <= 30312; Hope somebody else finds this useful! -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean.

2 2

Is this the correct way to upgrade koha
by sheldon_tappin 11 Mar '11

11 Mar '11

Hi All, I the past, whenever we wanted to upgrade koha, we would copy the database of the version that we want to upgrade. Then erase Koha completely off the system, then install the new version from scratch. When this is finished, we would replace the existing database and koha would run an update. My question: 1. Is this the best way to upgrade koha? 2. If I have fresh koha installed on a system, and all my configurations, patron data including issues and bibliographic data is located on another. Is there any other way how I can get all that information (including checkouts, fines etc.) without copying the database and replacing it on fresh installation of koha. Sheldon -- View this message in context: http://koha.1045719.n5.nabble.com/Is-this-the-correct-way-to-upgrade-koha-t… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Serials
by Vitor Fernandes 11 Mar '11

11 Mar '11

Hi there. I have a question about the Koha serials. I now that a serial/periodical is a bibliographic record. But one issues/number of one serial is saved in which table of Koha database? They are itens for the biblio record? I'm answering this questions because I have a problem migrating the serials from BiblioBase (which is a library management system software). The serials in BiblioBase are exported in two files: - one xml with biblio records (serials record) which i've already converted to marcxml and imported to Koha - one ISO with the issues/numbers of those serials I need to import the ISO. Did anybody worked with BiblioBase and done this? If one issue/numer is one item of the biblio record maybe i can do a parser to the ISO file. Thanks in advance. Regards. Vitor Fernandes

1 0

configuring postfix and koha to send email
by masabai 11 Mar '11

11 Mar '11

Using koha 3.2 on ubuntu 10.10 and set up postfix to send late book emails from koha. Can send email directly from postfix or from root but not from koha. Are there edits that have to be made to koha files to make it work with postfix? Have tried testing by making new accounts and asking koha to send new account messages but get errors listed below... Is there a better way to test? Thanks for any suggestions. [Fri Mar 11 19:30:44 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:30:44 2011] memberentry.pl: Use of uninitialized value in split at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 484., referer: http://koha:8080/cgi-bin/koha/members/members-home.pl [Fri Mar 11 19:31:20 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:20 2011] memberentry.pl: Argument "" isn't numeric in numeric eq (==) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 453., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl?op=add&category_ty… [Fri Mar 11 19:31:20 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:20 2011] memberentry.pl: Argument "|Ma" isn't numeric in numeric eq (==) at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 453., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl?op=add&category_ty… [Fri Mar 11 19:31:20 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:20 2011] memberentry.pl: Use of uninitialized value in split at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 484., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl?op=add&category_ty… [Fri Mar 11 19:31:33 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:33 2011] moremember.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Members/Messaging.pm line 101., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl [Fri Mar 11 19:31:33 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:33 2011] moremember.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Members/Messaging.pm line 101., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl [Fri Mar 11 19:31:33 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:33 2011] moremember.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Members/Messaging.pm line 101., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl [Fri Mar 11 19:31:33 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:33 2011] moremember.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Members/Messaging.pm line 101., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl [Fri Mar 11 19:31:33 2011] [error] [client 192.168.1.20] [Fri Mar 11 19:31:33 2011] moremember.pl: Use of uninitialized value in hash element at /usr/share/koha/lib/C4/Members/Messaging.pm line 101., referer: http://koha:8080/cgi-bin/koha/members/memberentry.pl

1 0

Fwd: Cataloging books which doesn't have ISBN etc.,
by Somasekhar Rao K 11 Mar '11

11 Mar '11

Hi, Thanks for your quick response. But I am still unable to enter book details into koha database. I am missing some basics. Can you please help me? Thanks & Regards, Somasekhar Rao K ---------- Forwarded message ---------- From: Somasekhar Rao K <raosoma(a)gmail.com> Date: Fri, Mar 11, 2011 at 6:08 PM Subject: Re: [Koha] Cataloging books which doesn't have ISBN etc., To: Koustubha Kale <kmkale(a)anantcorp.com> Hi, Thanks for your quick response. But I am still unable to enter book details into koha database. I am missing some basics. Can you please help me? Thanks & Regards, Somasekhar Rao K On Fri, Mar 11, 2011 at 6:05 PM, Koustubha Kale <kmkale(a)anantcorp.com>wrote: > 2011/3/11 Somasekhar Rao K <raosoma(a)gmail.com>: > > Hi, > > > > I am trying to catalog the books which doesn't have any ISBN etc., for me > to > > import. I was using Marcedit and sometimes directly from Koha to add > books. > > However, I was not able to make out how to store the cover image of the > > book. I want to scan the book myself and store it so that when the book > is > > searched, it shows the image as well along with the other details of the > > book entered. > > > > Can you please help me out? Koha version: 3.02.3 > > > > Thanks & Regards, > > Somasekhar Rao K > > This facility is currently not available in Koha but I have a patch > under client testing at present. > > :) > > > Regards, > Koustubha Kale > Anant Corporation > > Contact Details : > Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes > Naka, Thane (w), > Maharashtra, India, Pin : 400601. > TeleFax : +91-22-21720108, +91-22-21720109 > Mobile : +919820715876 > Website : http://www.anantcorp.com > Blog : http://www.anantcorp.com/blog/?author=2 >

1 0

KOHA & Digital Library Integration
by atiqse＠hotmail.com 11 Mar '11

11 Mar '11

Dear Sir, Thank you for your input on the forum. I want to know how do you integrate the two difference repositories (KOHA Catalogues which is MARC21 Compliance & DSPACE Catalogue which is Dublin Core Compliance), What is synchronization method of the meta data and other Administrative (User/Patron Records) data between the system. Does KOHA & DSPACE are installed & implemented separately? I have the same requirements of ILS & DL system but I dont know how it works together? Thank you Regards, Ateeq

1 0

what barcode system to use
by Klaas Chielens 11 Mar '11

11 Mar '11

Dear all, We have decided upon ordering barcodes to mark our books. Do you have suggestions as to where the best deals can be found for custom barcodes as well as what system of barcodes to use? I found a supplier ("The Library Store") which offers code 39 codabar follett style "interleaved 2 of 5" mod-43 mod-10 as we don't have any previous barcodes to deal with, could you suggest me what works well (and more or less why?) thanks! Klaas Klaas Chielens | Electronic Communication __________________________________ Institute for European Studies Vrije Universiteit Brussel Pleinlaan 2 (office: Pleinlaan 15, 5th floor) 1050 Brussels Belgium T: +32 2 6291563 F: +32 2 6291809 E: klaas.chielens(a)vub.ac.be

2 1

Group multiple items in a "box" for easy circulation
by Jason O'Neil 11 Mar '11

11 Mar '11

Hi List I'm helping a high school library upgrade to koha, and they have a few unusual requests I'm trying to help with. They keep "boxes", collections of about 20 books relevant to specific topics that are loaned out to teachers. In circulation, they use a single barcode on the front of the box to check out, and all of the items will now be checked out to that patron. Similarly for checking in the items, using the barcode on the box will check in all the contained items. I'm wondering if Koha currently has any similar functionality? If not, I'll move to the devel list and talk about implementing it myself :) Thanks Jason O'Neil

1 0

Is KOHA suitable for Digital Library?
by mohan pradhan 10 Mar '11

10 Mar '11

On 03/09/2011 01:13 AM, atiqse wrote: > I am new to KOHA ILS Solution, Can any body guide me that whether or not to > use the KOHA ILS in place of digital library requirements? > > To what extend can KOHA cater to manage digital contents (PDF and TIFF and > etc)? For Digital Library, you can use GSDL. We i.e. DlnetSA have developed Koha GSDL Live CD, this can be downloaded from the url: http://sourceforge.net/projects/gsdlkohalive/ Mohan Raj Pradhan General Secretary DlnetSA e-mail: mpradhan(a)healthnet.org.np

1 0