Delete no item from koha
*Hi to all* *currently facing a problem. I am working on koha 18.11.02. And** in my koha there are a lot of record entry in which there are no item** added. And I want to remove all of them in one go because there are a lot** of such entries in my database where no item is added in my framework** records. So anyone suggest me in this regard is helpful to me.* * Thanks in advance,* -- Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809*
I'm a beginner with koha (and more used to koha 17.11) but I would do this way: as admin: Home > Tools > Export data AFAIK by default only records with items are exported (this default behaviour can be changed in the Export page if needed). Keep the default behaviour and do the export. You obtain a backup file. To check that the backup contains items only, you might create a new instance of koha, populate it with the backup, and see the records (maybe there is some other way to check this but I don't know). When sure that the backup really contains only records with items, go back to the original library, delete every record, then import the backup. Or, more safely, keep apart the original library unmodified and use the new one. Giuseppe On Tue, 19 Feb 2019, Arshad Iqbal wrote:
*Hi to all*
*currently facing a problem. I am working on koha 18.11.02. And** in my koha there are a lot of record entry in which there are no item** added. And I want to remove all of them in one go because there are a lot** of such entries in my database where no item is added in my framework** records. So anyone suggest me in this regard is helpful to me.*
* Thanks in advance,*
--
Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for the tip! but looking tricky On Tue, Feb 19, 2019 at 6:49 PM Giuseppe Ciaccio <giuseppe.ciaccio@unige.it> wrote:
I'm a beginner with koha (and more used to koha 17.11) but I would do this way:
as admin: Home > Tools > Export data AFAIK by default only records with items are exported (this default behaviour can be changed in the Export page if needed). Keep the default behaviour and do the export. You obtain a backup file.
To check that the backup contains items only, you might create a new instance of koha, populate it with the backup, and see the records (maybe there is some other way to check this but I don't know).
When sure that the backup really contains only records with items, go back to the original library, delete every record, then import the backup. Or, more safely, keep apart the original library unmodified and use the new one.
Giuseppe
On Tue, 19 Feb 2019, Arshad Iqbal wrote:
*Hi to all*
*currently facing a problem. I am working on koha 18.11.02. And** in my koha there are a lot of record entry in which there are no item** added. And I want to remove all of them in one go because there are a lot** of such entries in my database where no item is added in my framework** records. So anyone suggest me in this regard is helpful to me.*
* Thanks in advance,*
--
Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Best Regards *Muhammad Arshad Iqbal* *Assistant Librarian* *NUST Central Library * *National University of Science and Technology (NUST)* *Sector H-12, Islamabad, Pakistan* *Tel. Office:051-90851087* *Cell no.+923444900809*
Hi Muhammad
*currently facing a problem. I am working on koha 18.11.02. And** in my koha there are a lot of record entry in which there are no item** added. And I want to remove all of them in one go because there are a lot** of such entries in my database where no item is added in my framework** records. So anyone suggest me in this regard is helpful to me.*
If you have a list with the numbers of the bibliographic records that do not contain an item, you could use the batch record deletion. You will find it in Koha menu "Tools > Catalog > Batch record deletion". For example the following query should give you such a list (found at https://wiki.koha-community.org/wiki/SQL_Reports_Library#All_bibs_where_last... ) SELECT b.biblionumber, b.title, b.author FROM biblio b LEFT JOIN items i USING (biblionumber) WHERE i.itemnumber IS NULL AND b.biblionumber IN (SELECT biblionumber FROM deleteditems) GROUP BY b.biblionumber Hope this helps. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
participants (3)
-
Arshad Iqbal -
Giuseppe Ciaccio -
Michael Kuhn