Re: [Koha] delete content of a biblio instance
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 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 > > > > > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] delete content of a biblio instance
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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 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 > a > > > > écrit : > > > Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.ha...@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 < > > > > > > lmoisesro...@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.oer...@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 > > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] delete content of a biblio instance
Those are commands to run from a MySQL command prompt. SET FOREIGN_KEY_CHECKS = 0; basically turns off FK integrity so it should always be used carefully and on a live system only as a last resort. The truncates cleanout tables and the last one turns the FK checks back on. Every rare now and then in a migration, I may use this if I've loaded bibs and items and want to reload them before other loading is done. On Tue, Jul 7, 2020 at 1:32 PM Heinz-Jürgen Oertel wrote: > Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.ha...@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 < > lmoisesro...@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.oer...@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
Re: [Koha] delete content of a biblio instance
Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.ha...@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 > > 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.oer...@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
Re: [Koha] delete content of a biblio instance
Well, it depends. 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; 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 On Tue, Jul 7, 2020 at 11:17 AM Luis Moises Rojas 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.oer...@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 > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] delete content of a biblio instance
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.oer...@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
Re: [Koha] delete content of a biblio instance
So, just to make sure I understand, deleting all the bibs and associated items but leaving everything else, right? On Tue, Jul 7, 2020 at 9:40 AM Heinz-Jürgen Oertel wrote: > 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
[Koha] delete content of a biblio instance
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