Re: [Koha] delete content of a biblio instance
Hi, Sorry, yes, that was it. It has been a long time since I did that import. I think it was a two step process... Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mer. 8 juil. 2020 à 16:40, Heinz-Jürgen Oertel <hj.oertel@t-online.de> a écrit :
Am Dienstag, 7. Juli 2020, 20:22:07 CEST schrieb Alvaro Cornejo:
Hi,
If you have imported the records through the upload tool of koha, you can remove those same records through the same tool.
Regards,
Alvaro
Hi Alvaro,
do you mean via Tools-> Staged MARC record management
==> Managed staged MARC records, including completing and reversing imports
to reverse the import?
for some unknown reasons, this did not work
Heinz
Le mar. 7 juil. 2020 à 12:32, Heinz-Jürgen Oertel <hj.oertel@t-online.de> a
écrit :
Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.hamby@gmail.com :
Well, it depends.
to your first question. It is not a used running system yet. I just used it to get familiar with it. The first import in a new biblio was not successful, not the correct import data used. Now I like to empty it and import a new export from another system.
If you only have bibs and items loaded this should work:
SET FOREIGN_KEY_CHECKS = 0; truncate biblio; truncate biblioitems;
truncate items; truncate auth_header; truncate sessions; truncate zebraqueue; truncate biblio_metadata; SET FOREIGN_KEY_CHECKS = 1;
I assume that are all data base commands to the biblio data base?
However, if you've had this as a living system with transactions you will also need to look at cleaning out a lot of other tables such as
statistics,
issues, etc....
see above.
Thanks and Greetings
Heinz
On Tue, Jul 7, 2020 at 11:17 AM Luis Moises Rojas <
lmoisesrojas@gmail.com>
wrote:
Hi, That was my question a few days ago, and there is no way.
I don't know if there is any answer now
El mar., 7 de jul. de 2020 9:40 AM, Heinz-Jürgen Oertel <
hj.oertel@t-online.de> escribió:
Hello
I'm looking for a way to delete the complete content of a biblio
instance,
not the instance itself in order to keep "Item types", "Patron
categories"
etc.
Any hint is very welcome. After deleting the content,, I want to
import
new data via marcxml import.
Greetings
Heinz
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- mit freundlichen Grüßen aus Halle (Saale)
Heinz-Jürgen Oertel
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- mit freundlichen Grüßen aus Halle (Saale) Heinz-Jürgen Oertel
Am Donnerstag, 9. Juli 2020, 00:18:01 CEST schrieb Alvaro Cornejo:
Hi,
Sorry, yes, that was it.
It has been a long time since I did that import. I think it was a two step process...
Regards Alvaro
Alvaro or may be I have to correct me. Could it be that still the search index data base is the old one, this mysterious Zebra thing? Because there is another strange thing. After deleting the biblio data base using a lot of SQL delete commands, still a search delivers content. Than I was able to delete also this using sudo zebraidx -c /etc/koha/sites/bibliothek/zebra-biblios.cfg drop biblios sudo zebraidx -c /etc/koha/sites/bibliothek/zebra-biblios.cfg commit koha-rebuild-zebra -b -r -v mylibrary (I found these commands somewhere) And now after an MARCXML file, the im port lists all the entries but an OPAC search delivers nothing. What I now have to do that the (zebra?) index is build again ?? There is a big missing issue for me, What did I overlook? Does someone have a introduction not only to set up Koha bot ALSO import data into it? Regards Heinz
Hi Have you cleared your browser cache? Also, if you have plack and/or memcached enabled, you might want to restart them. You can also try a full index rebuild with koha-rebuild-zebra -b -r -v -a Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le jeu. 9 juil. 2020 à 05:36, Heinz-Jürgen Oertel <hj.oertel@t-online.de> a écrit :
Am Donnerstag, 9. Juli 2020, 00:18:01 CEST schrieb Alvaro Cornejo:
Hi,
Sorry, yes, that was it.
It has been a long time since I did that import. I think it was a two step process...
Regards Alvaro
Alvaro or may be I have to correct me. Could it be that still the search index data base is the old one, this mysterious Zebra thing?
Because there is another strange thing. After deleting the biblio data base using a lot of SQL delete commands, still a search delivers content. Than I was able to delete also this using
sudo zebraidx -c /etc/koha/sites/bibliothek/zebra-biblios.cfg drop biblios sudo zebraidx -c /etc/koha/sites/bibliothek/zebra-biblios.cfg commit koha-rebuild-zebra -b -r -v mylibrary
(I found these commands somewhere)
And now after an MARCXML file, the im port lists all the entries but an OPAC search delivers nothing. What I now have to do that the (zebra?) index is build again ??
There is a big missing issue for me, What did I overlook? Does someone have a introduction not only to set up Koha bot ALSO import data into it?
Regards Heinz
participants (2)
-
Alvaro Cornejo -
Heinz-Jürgen Oertel