[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