Delete all the books record
Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be. Now I want to delete all the records. I tried using an old blog. However, it is showing in catalogue search. I want to completely remove all the records I uploaded. Kindly help me. Rajesh Bhatt GRIMS Vapi
Most of the time it is easier to "just undo the import" which is possible on the import page. Since it sounds that you have already messed with the database you have to redo the zebra index: https://stackoverflow.com/questions/26925152/reindexing-zebra-because-there-... If that did not help please elaborate and tell what you did already Am 09.11.19 um 13:02 schrieb takan bhatt:
Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be. Now I want to delete all the records. I tried using an old blog. However, it is showing in catalogue search. I want to completely remove all the records I uploaded.
Kindly help me.
Rajesh Bhatt GRIMS Vapi _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
What I does is *sudo su* *mysql -uroot -p* *use koha_library;* Then applied *SET FOREIGN_KEY_CHECKS=0;* *TRUNCATE items; * *TRUNCATE deleteditems;* *TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio; * *SET FOREIGN_KEY_CHECKS=1;* *Quit* *However, I think I have not reindexed zebra.* *Kindly di help* *Rajesh Bhatt* On Sat, Nov 9, 2019, 18:53 Franz Dietrich <dietrich@teilgedanken.de> wrote:
Most of the time it is easier to "just undo the import" which is possible on the import page. Since it sounds that you have already messed with the database you have to redo the zebra index:
https://stackoverflow.com/questions/26925152/reindexing-zebra-because-there-...
If that did not help please elaborate and tell what you did already
Am 09.11.19 um 13:02 schrieb takan bhatt:
Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be. Now I want to delete all the records. I tried using an old blog. However, it is showing in catalogue search. I want to completely remove all the records I uploaded.
Kindly help me.
Rajesh Bhatt GRIMS Vapi _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Franz Dietrich -
takan bhatt