[Koha] Cleaning up lots of duplicates

Frédéric Demians frederic at tamil.fr
Thu Aug 4 18:29:45 NZST 2016


> If I could construct an SQL query to identify the duplicate biblionumbers
> (excluding an original record for each item), would it be enough to delete
> database records from the items, biblioitems, and biblios tables, and then
> fully re-index Zebra to clean these up?

Yes, it would be enough, if you don't have subscriptions or holdings linked to
the deleted biblio records. Alternatively, you can build a query which
produces a list of biblionumber, then use this list in Tools > Batch record
deletion (no reindexing required).

Kind regards,
-- 
Frédéric DEMIANS
http://www.tamil.fr/fdemians


More information about the Koha mailing list