[Koha] Deleting items...

[Katrin Fischer]

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 at orex.es]
> Sent: Thursday, May 07, 2015 5:11 PM
> To: Layale Bassil
> Cc: koha at 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 at aub.edu.lb<mailto:lb26 at 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 at lists.katipo.co.nz<mailto:Koha at 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 at orex.es<mailto:hagud at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>