Dear colleagues,
I updated the barcodes field directly from the koha_library items table in 
mysql successfully. From the browser, searching the barcodes from the catalogue 
is successful but the batch item modification gives the barcodes not found 
result. Barcodes edited through the browser are however found using the batch 
modification.
How do I resolve this?
This is the query I used:
CREATE TEMPORARY TABLE temp_koha_imports(call_number VARCHAR(40) NOT NULL, 
barcode VARCHAR(40) NOT NULL UNIQUE,
new_barcode VARCHAR(40) NOT NULL PRIMARY KEY;

LOAD DATA LOCAL INFILE '/tmp/koha_update_weeded.csv' INTO TABLE 
temp_koha_imports FIELDS TERMINATED BY ',';


UPDATE items i INNER JOIN temp_koha_imports t ON t.barcode=i.barcode SET 
i.barcode=new_barcode;

Someone please help


_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to