You can only do it from the command line. I would back up your database and then to delete the bibs without items run these three commands in MySQL: INSERT into deletedbiblio (SELECT * FROM biblio where biblionumber NOT IN (SELECT biblionumber from items)); INSERT into deletedbiblioitems (SELECT * FROM biblioitems where biblionumber NOT IN (SELECT biblionumber from items)); DELETE FROM biblio where biblionumber NOT IN (SELECT biblionumber from items); For duplicates, there are reports to help you find duplicates but not to delete them: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Duplicate_titles Nicole On Tue, Feb 28, 2012 at 9:02 AM, <makekee@msu.ac.zw> wrote:
We have a number of duplicate entries in our database and also biblios without items. I would like to know how how one can bulk delete duplicate records and all the biblios with no items attached. Thanks in advance
Ephraim Makeke
---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha