- Koha - lists.katipo.co.nz

999 $c and $d, and limits on nu
by Stacy Pober 19 Apr '10

19 Apr '10

In a Koha item record, should the 999$c (BIBLIONUMBER) and 999$d (BIBLIOITEMNUMBER) fields always be identical? We've had some issue show up with the newest LLEK testing where the 999$c and 999$d fields don't match in some records and it causes a situation where users may see a summary record for one item, but clicking on the title link leads to an entirely different item. Why there are even two different fields for biblionumber and biblioitemnumber if the field data is always supposed to be identical for those fields? -- Stacy Pober Information Alchemist Manhattan College Library Riverdale, NY 10471 stacy.pober(a)manhattan.edu

2 1

Wanted KOHA support expert/s
by Sudhir Gandotra 19 Apr '10

19 Apr '10

Hello List, We at OpenLX are looking out for 1 or 2 experts who have experience of implementing and customizing KOHA and can undertake work on assignment/basis with us. Those with proven ability, please get in touch with me, directly on my email -ID : sudhir(a)openlx.com Peace, Force & Joy! Sudhir Gandotra. 98-101-20918 / 93-124-65666 OpenLX Linux OS, Linux Training, Support, Services, Product Development Legal.Software @ Fractional Cost : http://kalculate.com http://openlx.com - International Alliance of LINUX companies You don't need violence to shake the world Treat Others As You Would Have Them Treat You www.humanistmovement.org

1 0

Migrating data from 2.2.9 to 3.00.X: item problems
by Magdalena Söderqvist 19 Apr '10

19 Apr '10

Hi, SIPRI library is attempting to migrate catalogue records from 2.2.9 to 3.00.06.008. I know the latest stable release is 3.00.05, but our IT-guy got a little carried away (and then he went on vacation)! The upgrade however solved a major problem with blank record pages in the opac, but we still have some remaining problems we need help solving. Others have reported similar problems but I haven't been able to figure out how their problems were actually solved, hence this appeal. Problem 1: When importing a normal biblio with only one item to the new version, the one item is split up in two, with Shelf location on one row and Barcode on another. The rest of the item specific information is hidden. If I edit the record and delete one of the items and move the barcode to the remaining item, all the hidden information shows up. So the question is, what is wrong? We use 952c for Shelving location and 952p for Barcode. Also, we don't use actual barcodes, but instead use the barcode field for our accession numbers, for example G10/123 or 10/124. Problem 2: We occasionally catalogue chapters as separate biblios, and when doing so, we have used the same barcode/accession no. for each chapter belonging to the same book. It worked fine in 2.2.9, but since 3.0.x does not seem to accept duplicate barcodes this has now become a problem. Would it be possible/complicated/stupid? to alter the bulcmarcimport.pl to make it allow import of biblios with duplicate barcodes? Is there a better solution? Any help you can offer is much appreciated. Sincerely, Magdalena Söderqvist, Librarian SIPRI Library (Stockholm, Sweden) ******************************************* System details: New Koha version: 3.00.06.008 Apache Server version: Apache/2.2.3 Server built: Mar 27 2010 13:52:09 MySQL mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1 OS Linux db1.sipri.org 2.6.18-164.15.1.el5xen #1 SMP Wed Mar 17 12:04:23 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux Perl 5.008008 ************** Old Koha version: 2.2.9 OS version ('uname -a') Linux koha.sipri.org 2.6.18-8.el5xen #1 SMP Fri Jan 26 14:29:35 EST 2007 x86_64 x86_64 x86_64 GNU/Linux Perl version 5.008008 MySQL version mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3 Apache version Server version: Apache/2.2.3 Server built: Nov 29 2006 06:33:27

3 2

Re: [Koha] Koha as a federated library
by Vimal Kumar 19 Apr '10

19 Apr '10

Congrats Anselm. You are integrated Koha well into Joomla. Can you share with community members about how Koha integrate with Koha? Anybody integrated Koha into Drupal? Regards, -- 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

3 2

[KohaCon10] Volunteers Meeting Postponed till May
by Russel Garlick 19 Apr '10

19 Apr '10

Hi all, Apologies for the late notification. We will be postponing the KohaCon10 Volunteers meeting a month. Next meeting will be UTC (GMT) Monday, 10 May 2010 at 22:00:00 That is Wellington (New Zealand) Tuesday, 11 May 2010 at 10:00:00 a.m I will do a call for Agenda items before that meeting, but if you have anything, please send it to me off list. Cheers, -- Russel Garlick Catalyst IT Ltd. +64 4 803 2237 +64 27 537 1377 PO Box 11-053, Manners St, Wellington 6142, New Zealand

1 0

Moving an item to a different biblio
by Steven Vincent - TechnologyWise 18 Apr '10

18 Apr '10

Hi all We have a need to shift a number of items from one biblio to another, and have searched for an option to do this, but can't find anything. Other than edit the records in MySQL, is there something we are missing that can be used for this? -- Regards Steven Steven Vincent Director TechnologyWise Ltd

2 2

"No Items Available" incorrectly showing in search
by Steven Vincent - TechnologyWise 18 Apr '10

18 Apr '10

Hi We have a strange issue with a new installation where certain items are showing as "No items available" in the search, but in the detail screen, the status is blank, and the checkout history shows "has never been checked out". The database shows fields "notforloan, damaged, itemlost, wthdrawn, onloan" as "0, 0, 0, 0, 0000-00-00" respectively. I've included some actual results below. Can anyone point me in the right direction as to where the search is picking this up from? And is it related to the detail Status showing as blank, rather than "Available". Is there another data field used in the calculation of 'available'? (Although other items have a blank 'detail' status yet their 'search' status is 'available') Regards Steven Steven Vincent Director TechnologyWise Ltd *=== As per the search result === * 1. Railways / Griffiths, Rose. A & C Black, Description: ; London : , 1992 : 25 p. : ; 20 cm. ISBN: 0713636297 : Books 1 item No items available 1 on loan: * [Books] Tauriko School [G] (B001481) (1) === As per the detail screen: === *Railways /(Griffiths, Rose.)* has never been checked out. And: Checkout Status: Not Checked out

1 0

Location of the code that searches and retrieves results, using zebra.
by arun j 18 Apr '10

18 Apr '10

Hello, koha newbie here, can somebody tell the location of code that searches and retrieves results, using zebra in koha. plz help me. thanks a lot.

2 1

Clearing off server
by Nicole Engard 18 Apr '10

18 Apr '10

Hi all, A month or so ago I had a chat on IRC with some of you about an error I was having where mysql couldn't start on my demo system. http://stats.workbuffer.org/irclog/koha/2010-03-08#i_407411 I am having that issue again. I know I need to do a new install and alot more space, but I don't have time right now because I have a lot of travel coming up. So what I'm wondering is what files I can delete in the log folder - which logs can I get rid of? I have already done as jdavidb said last time and purged the *.gz files. I have a few others files that are pretty darn big. I just need to know what's safe to get rid of. Thanks in advance! Nicole ------------------ My Files ------------------ nengard@debian:/var/log$ ls -la total 886332 drwxr-xr-x 9 root root 4096 2010-04-16 23:27 . drwxr-xr-x 15 root root 4096 2009-08-06 19:28 .. drwxr-x--- 2 root adm 4096 2010-04-16 23:27 apache2 drwxr-xr-x 2 root root 4096 2010-03-08 06:36 apt -rw-r--r-- 1 root root 0 2009-09-05 06:25 aptitude -rw-r----- 1 root adm 203448 2010-04-16 23:28 auth.log -rw-r----- 1 root adm 82589 2010-04-07 06:25 auth.log.1 -rw-r----- 1 root adm 31 2009-08-06 19:16 boot -rw-rw---- 1 root utmp 0 2010-04-07 06:25 btmp -rw-rw---- 1 root utmp 0 2010-03-16 06:25 btmp.1 -rw-r----- 1 root adm 3903 2010-04-16 23:28 daemon.log -rw-r----- 1 root adm 5588 2010-04-07 03:24 daemon.log.1 -rw-r----- 1 root adm 5704 2010-04-16 16:54 debug -rw-r----- 1 root adm 8468 2010-04-07 03:24 debug.1 -rw-r----- 1 root adm 16754 2010-04-16 16:54 dmesg -rw-r----- 1 root adm 16957 2010-04-07 14:30 dmesg.0 -rw-r----- 1 root adm 0 2010-03-02 06:25 dpkg.log -rw-r----- 1 root adm 29757 2010-02-03 06:16 dpkg.log.1 drwxr-s--- 2 Debian-exim adm 4096 2010-03-08 06:36 exim4 -rw-r--r-- 1 root root 24048 2010-01-26 12:27 faillog -rw-r--r-- 1 root root 856 2010-02-03 06:16 fontconfig.log drwxr-xr-x 2 root root 4096 2009-08-06 19:16 fsck drwxr-xr-x 3 root root 4096 2009-08-06 19:30 installer -rw-r----- 1 root adm 52636 2010-04-16 16:54 kern.log -rw-r----- 1 root adm 79068 2010-04-07 06:25 kern.log.1 -rw-rw-r-- 1 root utmp 292584 2010-04-16 23:17 lastlog -rw-r----- 1 root adm 0 2009-08-06 19:31 lpr.log -rw-r----- 1 root adm 2142208 2010-04-16 23:22 mail.err -rw-r----- 1 root adm 55169 2010-04-07 06:20 mail.err.1 -rw-r----- 1 root adm 222056448 2010-04-16 23:22 mail.info -rw-r----- 1 root adm 168584062 2010-04-07 06:20 mail.info.1 -rw-r----- 1 root adm 253272064 2010-04-16 23:22 mail.log -rw-r----- 1 root adm 168596040 2010-04-07 06:20 mail.log.1 -rw-r----- 1 root adm 2543616 2010-04-16 23:22 mail.warn -rw-r----- 1 root adm 55169 2010-04-07 06:20 mail.warn.1 -rw-r----- 1 root adm 47381 2010-04-16 16:54 messages -rw-r----- 1 root adm 70611 2010-04-07 06:25 messages.1 drwxr-s--- 2 mysql adm 4096 2009-08-15 15:11 mysql -rw-r----- 1 mysql adm 0 2009-08-15 15:11 mysql.err -rw-r----- 1 mysql adm 0 2010-04-10 06:25 mysql.log drwxr-xr-x 2 root root 4096 2009-08-06 19:31 news -rw-r--r-- 1 root root 0 2009-08-06 19:28 pycentral.log -rw-r----- 1 root adm 52297830 2010-04-16 23:28 syslog -rw-r----- 1 root adm 36197221 2010-04-10 06:25 syslog.1 -rw-r----- 1 root adm 139 2010-04-10 11:11 user.log -rw-r----- 1 root adm 207 2010-04-05 19:34 user.log.1 -rw-rw-r-- 1 root utmp 28416 2010-04-16 23:17 wtmp -rw-rw-r-- 1 root utmp 64896 2010-04-07 05:27 wtmp.1

2 1

Re: [Koha] Journal articles and analytical records
by Elaine Bradtke 17 Apr '10

17 Apr '10

Regarding the subfields in 773, I'm using $x ISSN and $z ISBN when we have this information, plus $o for the accession number of the item. A lot of what we have doesn't have International Standard numbers for one reason or another, but it all has an accession number. I haven't worried too much about the display at the moment, it seemed to look ok in the test runs. The one thing I couldn't get to function was a link between the 773 field and the parent item, but we're a bit behind in installing Koha releases*, and this may work better in the newer ones. Perhaps we should form a group on analytics and pool our information and techniques? With an idea of putting together a little wiki? Thanks Elaine (*I work 2 days a week on this project, and my IT guru is a volunteer. . . ) > Message: 3 > Date: Fri, 26 Mar 2010 08:15:06 -0500 > From: Linda Culberson <lculber(a)mdah.state.ms.us> > Subject: [Koha] Journal articles and analytical records > To: koha <koha(a)lists.katipo.co.nz> > Message-ID: <4BACB35A.6060505(a)mdah.state.ms.us> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > All, > We are just now loading our records, but have thousands of analytic > records that we will be experimenting with. Like Elaine and Beda, we are > looking at using the 773. I was thinking about putting the host item > system number in the subfield $w and maybe using the subfield $o for > something to tie directly to the individual item. In our current system > we are using the item part, and I was thinking of either trying that or > using the barcode or itemnumber in the $o. What subfields have been used > in your testing, Elaine? > > I am relieved to know we are not alone in looking at this and look > forward to working with everyone. We have absolutely no funds to > contribute but sweat equity works, I hope. > > Thanks! > > Linda > > Message: 5 > Date: Fri, 26 Mar 2010 10:50:53 -0400 > From: Jared Camins-Esakov <camins(a)numismatics.org> > Subject: Re: [Koha] Journal articles and analytical records > To: Linda Culberson <lculber(a)mdah.state.ms.us> > Cc: koha <koha(a)lists.katipo.co.nz> > Message-ID: <4BACC9CD.8050608(a)numismatics.org> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Good morning, list, > > I replied off-list to Andrew yesterday, assuming that no one else was > crazy enough to create analytics, but it looks like I was wrong. > > In our database of ~175,000 bibliographic records, we have ~120,000 > analytic records, created over the last 50 years (our card catalog was > digitized in the 90s). Our old system did not link analytics, but we > very much want to provide linking in the new Koha catalog. I added > ISBNs, ISSNs, LCCNs, and local control numbers to ~91,000 of those > analytic records, but for everything except for the ISBN, that only > identifies the bibliographic record and not the actual item. We don't > currently do anything with the links, although it seems like it > shouldn't be too problematic to add them, at least on a bib record level > (50 years of catalogers have resulted in exceedingly inconsistent 773$g > formatting). > > It's very good to know that we're not going it alone with regards to > analytic records in Koha. How are those of you with analytics displaying > host publication information in the OPAC? > > Unfortunately, we probably don't have any money for sponsoring these > features, either. > > Regards, > Jared > -- Elaine

6 8