Hello! How to create a user after (TRUNCATE borrowers) delete all records and keep settings? https://wiki.koha-community.org/wiki/How_to_delete_all_records_and_keep_sett... Koha 23.05 Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru
Hi, I'd suggest exporting the super user first from the borrowers table, then truncate the table, then import the super user back into the now empty table so you don't shut yourself out of the Koha admin interface. Best regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von ????? ????? ?????????? Gesendet: Donnerstag, 22. Juni 2023 11:43 An: koha@lists.katipo.co.nz Betreff: [Koha] TRUNCATE borrowers
Hello!
How to create a user after (TRUNCATE borrowers) delete all records and keep settings?
https://wiki.koha- community.org/wiki/How_to_delete_all_records_and_keep_settings
Koha 23.05 Good Luck!
Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for the reply. -----Original Message----- From: Bruns, Anke <Anke.Bruns@gwdg.de> Sent: Thursday, June 22, 2023 5:26 PM To: Сычев Игорь Алексеевич <ias@tpu.ru>; koha@lists.katipo.co.nz Subject: AW: TRUNCATE borrowers Hi, I'd suggest exporting the super user first from the borrowers table, then truncate the table, then import the super user back into the now empty table so you don't shut yourself out of the Koha admin interface. Best regards, Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns@gwdg.de ------------------------------------------------- Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg@gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 ------------------------------------------------- Zertifiziert nach ISO 9001 und ISO 27001 -------------------------------------------------
-----Ursprüngliche Nachricht----- Von: Koha <koha-bounces@lists.katipo.co.nz> Im Auftrag von ????? ????? ?????????? Gesendet: Donnerstag, 22. Juni 2023 11:43 An: koha@lists.katipo.co.nz Betreff: [Koha] TRUNCATE borrowers
Hello!
How to create a user after (TRUNCATE borrowers) delete all records and keep settings?
https://wiki.koha- community.org/wiki/How_to_delete_all_records_and_keep_settings
Koha 23.05 Good Luck!
Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Igor, if it's alrady too late and you have deleted your superlibrarian patron, there is a script to create a new account: http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.... Hope this helps, Katrin On 22.06.23 11:42, Сычев Игорь Алексеевич wrote:
Hello!
How to create a user after (TRUNCATE borrowers) delete all records and keep settings?
https://wiki.koha-community.org/wiki/How_to_delete_all_records_and_keep_sett...
Koha 23.05 Good Luck!
Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for the reply. -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Katrin Fischer Sent: Saturday, June 24, 2023 2:33 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] TRUNCATE borrowers Hi Igor, if it's alrady too late and you have deleted your superlibrarian patron, there is a script to create a new account: http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line.... Hope this helps, Katrin On 22.06.23 11:42, Сычев Игорь Алексеевич wrote:
Hello!
How to create a user after (TRUNCATE borrowers) delete all records and keep settings?
https://wiki.koha-community.org/wiki/How_to_delete_all_records_and_kee p_settings
Koha 23.05 Good Luck!
Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru _______________________________________________
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
participants (3)
-
Bruns, Anke -
Katrin Fischer -
Сычев Игорь Алексеевич