Hi Rajesh,
it is possible with SQL, but you will want to do a full reindex after so
you can search for your new barcodes.
I think something like this could work:
UPDATE items SET barcode = CONCAT('000',barcode) where barcode between
10 and 99;
UPDATE items SET barcode = CONCAT('00',barcode) where barcode between
100 and 999;
...
I'd also recommend doing a backup for doing any changes with SQL and
testing your new barcodes well in circulation.
Hope this helps,
Katrin
On 12.04.19 10:55, takan bhatt wrote:
Dear Sir / madam
My current Barcode is XXXXXX but I want to add zero as prefix in all the
items, Is is possible in Bulk ?
Pls any SQL command is there ?
pls guide me
Rajesh Bhatt
GRIMS LIbrary
Vapi India
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
