Hi If you do a Marc import through the koha importing tool, you can remove the records through the same process. You just need to check which import process you want to remove and that's it. Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le mar. 25 juin 2019 à 15:44, Andy Boze <boze.1@nd.edu> a écrit :
Dear all,
I'm hoping someone can give me a bit of direction. We have a large number of deleted biblio records (due to a failed MARC records import). We'd like to remove the deleted records from the database as there are somewhat more deleted records (401,000) than active records.
Is there a script than can clean up deleted records? I've seen this "Clean up database" script <
https://koha-community.org/manual/18.11/en/html/cron_jobs.html#clean-up-data...
, but it's not what we're looking for.
If there's no script, can we safely use the MySQL TRUNCATE command on the deletedbiblio, deletedbiblio_metadata, deletedbiblioitems and deleteditems tables? This is a non-circulating library, so I don't think the biblionumber would be tied to any other tables.
I'll appreciate any guidance. We're using Koha 18.11 and MariaDB 5.5.60.
-- Andy Boze, Associate Librarian University of Notre Dame 271H Hesburgh Library (574) 631-8708 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha