Hi Carlos, Thanks for your sharing. I'll try. 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

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