Hi, the bibliographic data in Koha is split between the tables biblio and biblioitems - biblioitems being even a little more important as it holds the full MARC record. If you want to delete items, you want to delete from the items table. And if you don't use Koha's built in tools, but SQL, you will also have to rebuild your index to update the item information in Zebra to match your database after. I think you probably messed up the record by only deleting biblioitems - I'd check if there is still an entry in biblio for it. Hope this helps, Katrin Am 08.05.2015 um 15:23 schrieb Layale Bassil:
Thank you so much Hugo.
One question, I was trying to delete one item manually from the database, I deleted the item from the biblioitems table but now Koha is messed up I don’t know why. I can’t import data or use Delete Batch item… this is because the item was not deleted properly or all its related data.
Any suggestion here?
Thanks.
From: Hugo Agud [mailto:hagud@orex.es] Sent: Thursday, May 07, 2015 5:11 PM To: Layale Bassil Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Deleting items...
Hi Layale Koha has it own module of delete items in batch , please take a look on http://manual.koha-community.org/3.18/en/batchdeleteitems.html
2015-05-07 16:04 GMT+02:00 Layale Bassil <lb26@aub.edu.lb<mailto:lb26@aub.edu.lb>>: Hello,
I would like to know how can I delete the items/holdings (keeping bib records) of a certain library in Koha 3.14? Is there any interface for it? Can you help write a script for it if need be?
Thank you.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
--
Hugo Agud - Orex Digital
www.orex.es<http://www.orex.es>
Director
Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70 hagud@orex.es<mailto:hagud@orex.es> · http://www.orex.es/
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifÃquenoslo inmediatamente y bórrelo de su sistema.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha