Re: [Koha] Replacement of information in an item field by batch
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, AE1131 REF AE5 E363 2010 guide AE1132 REF AE5 E363 2010 index A-K AE1133 REF AE5 E363 2010 index L-Z It has the following error message: Barcodes not found AE1131 REF AE5 E363 2010 guide AE1132 REF AE5 E363 2010 index A-K AE1133 REF AE5 E363 2010 index L-Z Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: peter@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:clo...@dml.vic.edu.au] Sent: Thursday, 14 February 2019 8:02 AM To: Peter Lau ; Koha 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 <>/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 clo...@dml.vic.edu.au -Original Message- From: Koha On Behalf Of Peter Lau Sent: Thursday, 14 February 2019 10:11 AM To: Koha 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@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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Replacement of information in an item field by batch
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, AE1131 REF AE5 E363 2010 guide AE1132 REF AE5 E363 2010 index A-K AE1133 REF AE5 E363 2010 index L-Z It has the following error message: Barcodes not found AE1131 REF AE5 E363 2010 guide AE1132 REF AE5 E363 2010 index A-K AE1133 REF AE5 E363 2010 index L-Z Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: peter@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:clo...@dml.vic.edu.au] Sent: Thursday, 14 February 2019 8:02 AM To: Peter Lau ; Koha 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 <>/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 clo...@dml.vic.edu.au -Original Message- From: Koha On Behalf Of Peter Lau Sent: Thursday, 14 February 2019 10:11 AM To: Koha 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@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
Re: [Koha] Replacement of information in an item field by batch
Hi Carlos, Thanks for your sharing. I'll try. Thanks & regards, Peter Lau Librarian Tel: (852) 3977 9868 | Email: peter@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:clo...@dml.vic.edu.au] Sent: Thursday, 14 February 2019 8:02 AM To: Peter Lau ; Koha 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 <>/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 clo...@dml.vic.edu.au -Original Message- From: Koha On Behalf Of Peter Lau Sent: Thursday, 14 February 2019 10:11 AM To: Koha 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@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
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 <>/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 clo...@dml.vic.edu.au -Original Message- From: Koha On Behalf Of Peter Lau Sent: Thursday, 14 February 2019 10:11 AM To: Koha 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@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
[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@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
