[Koha] NULL items

[Rachel Hollis]

Thanks Chris, I meant to also state that our Koha was recently updated to 3.01.00.145. I verified that item-level_itypes is set to Use the item type of the Specific Item. I couldn't find biblioitems.itemtype in Systems Preferences but under Koha to MARC Mapping > biblioitems itemtype is mapped to 942c. I'm assuming that these are as they should be.

Since I'm just a librarian ;-) I asked my geek to walk me through the Update and Script recommendations you make; she'll be in this afternoon.

Rachel Hollis, librarian

-----Original Message-----
From: Chris Cormack [mailto:chris at bigballofwax.co.nz]
Sent: Tuesday, September 21, 2010 2:49 PM
To: Rachel Hollis
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] NULL items

On 22 September 2010 07:29, Rachel Hollis
<Rachel.Hollis at stevenshenager.edu> wrote:
> Greetings colleagues, I have tried to get our Circulation And Fines Rules preferences to work to no avail.
> Recently I ran a Catalog Statistics report and discovered that 6251 out of 6386 items.itype are NULL which probably explains why the Circ Rules aren't working.
>
> Is there a way to assign or fill the NULL items.itype values with one of our itype values? Even better would be to assign a specific value for each shelving location.
>
> As far as I can see in the staff interface, the item types (942c & 952y) are filled in. Changing the 942c and 952y does not seem to alter the NULL; the Catalog Statistics report result number does not change. Additionally, any idea how I managed to have so many NULL items.itypes; could it be my adding a space prefix to Description when in Modify Item Type so that alphabetically the most used itype is the first choice?
>
Hi Rachel

There are 2 things you can check here, do you have item-level_itypes set?
And is biblioitems.itemtype set?

You probably want to item-level_itypes switched on, then to populate them
If so, a good start would be to run
UPDATE items,biblioitems SET items.itype=biblioitems.itemtype WHERE
items.biblioitemnumber=biblioitems.biblioitemnumber

That will fix the items table, there is then a script in
misc/maintenance called sync_items_in_marc.pl which when run will fix
the MARC to match what you have in the items table.

Hope this helps

Chris

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.