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, <[email protected]> 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 > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
