[Koha] Type vs. Item Type

Gay Richards g.richards at auckland.ac.nz
Thu Aug 8 08:07:43 NZST 2013

I'm glad I was able to point you in the right direction, thanks to our IT whizz figuring this out for us a while ago.

Your list of suggested codes for various formats is great. I will keep it for future reference (saves having to think about it each time a different format appears. 

Regards, Gay

Gay Richards
Information Specialist
New Zealand Family Violence Clearinghouse
Tāmaki Innovation Campus
The University of Auckland
Ph: (09) 923 4640 

   09 923 4640 | www.nzfvc.org.nz | info at nzfvc.org.nz

-----Original Message-----
From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Steven Nickerson
Sent: Thursday, 8 August 2013 6:39 a.m.
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Type vs. Item Type

I had asked about this a couple of weeks ago and I thought I'd follow-up in case this helps anyone else.  I got responses from David Cook and Gay Richards (THANKS!!!) that led me to the "LEADER" field in the
biblioitems.marcxml DB column.   This is a "coded" field that determines the
TYPE for that particular bibliographic record.  In my case I had my items.itype field correct but not the data inside of this biblioitems.marcxml column, so I used something similar to the following SQL statement to update the biblioitems.marcxml field to set it correctly (replacing string "nam" with some other appropriate string):


update biblioitems as i1 inner join (select biblioitemnumber from items where itype="DVD") as i2 on i2.biblioitemnumber=i1.biblioitemnumber set i1.marcxml=replace(i1.marcxml, 'nam ', 'ngm ');


I also ran similar SQL update statements for VHS tapes, Music CDs, etc.


In case anyone wants to learn more about this MARC field and the coding, you can find information about it at http://www.loc.gov/marc/formatintegration.html

Here's a summary of what I used for codes and their meanings:

nam = books

ngm = DVDs, VHS tapes, etc. (i.e. video movies)

nim = non-musical audio (i.e. audiobooks on both cassettes and CDs)

njm = music audio (cassettes and CDs)

nab = periodicals and magazines

nrm = 3-dimensional items such as games, puzzles, etc.

nem = maps


And finally, as David Cook pointed out to me, here are the options for dealing with this issue in case anyone else sees similar results in their OPAC search:

1) Turn off the "DisplayOPACiconsXSLT" system preference. This will remove the "Type", "Format", etc. information from the OPAC search results (although it will still display in the intranet, if you've enabled XSLT there).

2) Fix the Leader in your catalogue records so that they are properly coded (the path I went down above)

3) Turn off XSLT for search results


Good luck!


Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list