Hello everyone!
I wrote an SQL command to generate barcodes for all items in Koha.
I did not find a command like this that was already written so I thought I
might publish it on this list in case anyone else might find it useful.
You will need to find your mysql username and password in your
/etc/koha/sites/library/koha-conf.xml ("library" is your Koha instance name).
In the commands below replace username with your username, of course, and
koha_library with your database name. (You can show all databases in msql by
entering: show databases; )
msql -u username -p
use koha_library;
set @bnum = 524580000000;update items set barcode=(@bnum:=@bnum+1) where
barcode is not null;
This will set a barcode of 524580000001 for the first book and each subsequent
book will be assigned a number that is one higher than the last so the second
will be 524580000002 and so on.
I am not sure it is necessary but I also did a zebra reindex afterwards. (Again
"library" is your Koha instance name.)
sudo koha-rebuild-zebra -f -v library
Thank you,
Father Vlasie
IT Director
St. Photios Orthodox Theological Seminary
510 Collier Way, Etna, CA 96027, U.S.A.
Website: www.spots.school
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
