Greetings friends, according to the report on item types, there are 25 total biblios in my catalog. They are Books, CD-ROMs, Reference, Periodicals and Visuals. When I try to delete Audio under Item Types and Circulation Codes, it tell me that it is in use 2 times; when I try to delete Books, it tells me that it in use 32 times. How do I access these phantom Audio biblios so that I can delete them and then delete the item type? What we've got: Koha version: 3.01.00.001 OS version: Linux library 2.6.18-6-686 #1 SMP Fri Jun 6 22:22:11 UTC 2008 i686 GNU/Linux Zebra version: Zebra 2.0.32 Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus ________________________________ 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.
When the item types interface says that the type is in use X number of times, it means that there are X records in biblioitems with that itemtype, not items w/ the itype. I'm not sure whether this is helpful or not. When I try to delete my BKS item type, it says: "*This record is used 219 times*." Compare from the following queries: mysql> select itemtype, count(*) from biblioitems group by 1; +----------+----------+ | itemtype | count(*) | +----------+----------+ | NULL | 10 | | AR | 5 | | *BKS * | *219* | | CF | 176 | | SER | 202 | | SR | 216 | | VR | 195 | +----------+----------+ 7 rows in set (0.00 sec) mysql> select itype, count(*) from items group by 1; +-------+----------+ | itype | count(*) | +-------+----------+ | NULL | 4 | | *BKS * | *555* | | CF | 480 | | SER | 480 | | SR | 537 | | VR | 450 | +-------+----------+ 6 rows in set (0.01 sec) So the result message is clearly from biblioitems count. Shouldn't it be from items table? I know how to delete items. Not sure about biblioitems though. --Joe On Wed, Jan 7, 2009 at 11:49 AM, Rachel Hollis < Rachel.Hollis@stevenshenager.edu> wrote:
Greetings friends, according to the report on item types, there are 25 total biblios in my catalog. They are Books, CD-ROMs, Reference, Periodicals and Visuals. When I try to delete Audio under Item Types and Circulation Codes, it tell me that it is in use 2 times; when I try to delete Books, it tells me that it in use 32 times. How do I access these phantom Audio biblios so that I can delete them and then delete the item type?
What we've got: Koha version: 3.01.00.001 OS version: Linux library 2.6.18-6-686 #1 SMP Fri Jun 6 22:22:11 UTC 2008 i686 GNU/Linux Zebra version: Zebra 2.0.32
Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus
Thanks for the heads up regarding the items and biblioitems. Investigating further, I found that the Koha to MARC Mapping is set up such that under biblioitems, itemtype maps to 942$c (the Koha [default] item type) and that under items, itype maps to 952$y (the Koha item type). Further, I found that changing the biblio framework also affects 942$c (Koha [default] item type). I suspect that two of my records have a 942$c for the item type I’d like to delete. Tomorrow I’ll look into mapping the 942$c and 952$y to see if it is possible to align biblio frameworks with item types. Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus ________________________________ 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.
participants (2)
-
Joe Atzberger -
Rachel Hollis