How to delete library data in koha using the command line Sometimes you need to empty the all data (e.g. bibliographic, borrowers, and transaction details) from your Koha LMS without losing the configuration settings and authorized values, e.g. libraries, item types, patron categories, locations, etc. Let us know how to delete data from the Koha instance/library. Delete Koha's bibliographic data NB: I would recommend taking a backup of the database before applying the following commands. Login as a root user sudo su Log into MySQL database mysql -uroot -p Enter MySQL root password use koha_library; Disable foreign key constraints when you truncate the tables SET FOREIGN_KEY_CHECKS=0; Delete all bibliographic details TRUNCATE items; TRUNCATE biblioitems; TRUNCATE biblio; TRUNCATE deletedbiblioitems; TRUNCATE deletedbiblio; TRUNCATE biblio_metadata; Delete all transactions TRUNCATE old_issues; TRUNCATE issues; Delete borrowers details ...
Koha INSTALLATION After installation of ubuntu 20.4 (Focal Fossa), right click on the mouse choose open terminal. past the following comments in terminal. Update Ubuntu using apt sudo apt update sudo apt upgrade -y if the system asks for update make it "Remind me later" it may confuse the process Clear the apt-get packager manager cache sudo apt clean Install MariaDB-server dependence sudo apt install -y mariadb-server Provide MySQL/MariaDB root password (If the password asks during the installation process, enter the password in the window. Apply the following command, if the password window did not appear during the installation secure it) Securing MariaDB Run this command to improve the security of the MariaDB installation: sudo mysql_secure_installation (The script will prompt you to set up the root user password, remove the anonymous user, restrict root user access to the local machine and remove the te...
Create Barcode Labels in Koha Here we will create the barcode which can be printed on the A4 size ordinary bond paper or A4 size sheet with 65 (5x13) self-adhesive labels. Create a Label Layout First, we need to create a layout for the barcode label. A layout is used to define the fields that you want to print on the label. To create the layout go to:- Koha Home➤ Tools➤Label creater➤New➤ Layout Enter the following details 1. Layout name :- Enter the Name (I have just entered MANC Final) 2. Choose Barcode type :- Code 39 (commonly used) 3. Choose Layout Type :- Bibliographic data proceeds barcode (Library Name on the top and barcode would be below) 4. Bibliographic data :- Here we want to print the library name above the barcode, So I choose order number 1 for the homebranch_description remaining fields left blank. 5. Text Justificatification :- Center 6. Font:- Times-Roman (You can choose other fonts also) 7. Font Size :- 8 Now save the layout Create a Label Template Koha H...
Comments
Post a Comment