Hi Peter, the batch item edit tool exects a .txt file with only the barcodes. Every barcode needs to be on a separate line. Hope this helps, Katrin On 15.02.19 07:40, Peter Lau wrote:
Hi Carlos,
I have an Excel file with the following information that I would like to update the 3 existing records based on the item barcodes including Collection Type and Call Number,
AE00001131
REF
AE5 E363 2010 guide
AE00001132
REF
AE5 E363 2010 index A-K
AE00001133
REF
AE5 E363 2010 index L-Z
It has the following error message:
Barcodes not found
AE00001131 REF AE5 E363 2010 guide
AE00001132 REF AE5 E363 2010 index A-K
AE00001133 REF AE5 E363 2010 index L-Z
Thanks & regards,
Peter Lau
Librarian
Tel: (852) 3977 9868 | Email: Peter.Lau@yccece.edu.hk | Fax: (852) 23384320
2 Tin Wan Hill Road, Tin Wan, Aberdeen
YCCECE, Here We Grow Our Future | www.yccece.edu.hk
-----Original Message----- From: Carlos Lopez [mailto:clopez@dml.vic.edu.au] Sent: Thursday, 14 February 2019 8:02 AM To: Peter Lau <peter.lau@yccece.edu.hk>; Koha <koha@lists.katipo.co.nz> Subject: RE: [Koha] Replacement of information in an item field by batch
Hi Peter
Koha is very good at this sort of batch processing. If you select the records you want to edit (from a file of itemnumbers or barcodes, or by scanning a barcode at a time) you can use the Batch Item Modification tool (Koha > Tools > Batch item modification, or <<your Koha instance>>/cgi-bin/koha/tools/batchMod.pl
Regards,
Carlos.
Carlos Lopez
Cataloguer
Dalton McCaughey Library
29 College Crescent
Parkville, VIC 3052
AUSTRALIA
Ph: +61 3 93408885
Fax: +61 3 86694418
clopez@dml.vic.edu.au
-----Original Message-----
From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Peter Lau
Sent: Thursday, 14 February 2019 10:11 AM
To: Koha <koha@lists.katipo.co.nz>
Subject: [Koha] Replacement of information in an item field by batch
How can I replace the item collection code or call number in item by batch?
Thanks & regards,
Peter Lau
Librarian
Tel: (852) 3977 9868 | Email: Peter.Lau@yccece.edu.hk | Fax: (852) 23384320
2 Tin Wan Hill Road, Tin Wan, Aberdeen
YCCECE, Here We Grow Our Future | www.yccece.edu.hk _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
--
Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.http://www.mailguard.com.au/mg
Click here to report this message as spam:
https://console.mailguard.com.au/ras/1V6MsDH8Ro/6PPHtcJtolVYpyf47LxKsK/-0.6 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha