Thank you Fred and Heather for your reply and suggestions. I knew the Batch Item Modification tool but I have unique text for each record to be added to 952X. There are hundreds of records and their unique text. Ok, I will try to use MarcEdit. Regards Ravi -----Original Message----- From: King, Fred <Fred.King@Medstar.net> Sent: Friday, 9 December 2022 9:13 am To: Ravinder Pallikonda <Ravinder.Pallikonda@education.govt.nz>; Koha <koha@lists.katipo.co.nz> Subject: RE: Batch update of bib records - non-public note I haven't seen an answer to this yet, so let me give it a try. Bear in mind, however, that earlier this week I tried to answer something that turned out to be completely different from what the questioner wanted because it involved a tab that I didn't know about. I may be wrong. I frequently am. So on to my answer: This may be far easier than you think it will be. What I think you want to do is add a 952$x to every record, but not the same text to every record. Do your items have barcodes? If so, put the barcodes of the items into lists according to which text you want to add, one barcode per line. Next, go to Tools > Batch Item Modification. If your instance is set up like mine (22.05) there will be a button to upload a barcode file and a box to paste barcodes into. Choose one or the other as your whimsey takes you. Click Next, which will take you to a screen with all your 952 fields. Type the text you want for your non-public note for this particular set into the x field. Click Save. Repeat with all your barcode lists. If you can export your records to MarcEdit, you can use the Marc Modification Tools (F7) to do something similar. I think you'd have to export different batches, then add the relevant text to the 952$x per batch. You can also convert the records to a spreadsheet, but this is going to take more steps than either of the two above. I've also had problems re-uploading records I've modified with MarcEdit or spreadsheets using 999$c as the match point--some item records wouldn't replace so I ended up with two. I never did figure out the problem, I just gave up, deleted the old records, uploaded the new records. No matter what you end up doing, I'd highly recommend doing it on a test system first. Trust me, I know what I'm talking about here. Good luck! --Fred Fred King, MSLS, AHIP Medical Librarian, MedStar Washington Hospital Center fred.king@medstar.net 202-877-6670 ORCID 0000-0001-5266-0279 MedStar Authors Catalog: http://medstarauthors.org I have learned from my mistakes, and I am sure I can repeat them exactly. --Peter Cook -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Ravinder Pallikonda Sent: Tuesday, December 6, 2022 7:07 PM To: Koha <koha@lists.katipo.co.nz> Subject: [EXTERNAL] [Koha] Batch update of bib records - non-public note **ATTENTION: This email originated from outside the MedStar Health network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. Hi All I would like to add unique note (note would be different to many records) to all the bibliographic records of Koha in non-public note field - 952x. What is the best way to add the non-public note. I got following option in mind. Export Marc records from koha -->convert them to excel using MARC Edit -->add unique note in excel sheet to all the records in non-public note-->convert excel to MARC-->upload them back to Koha Please let me know is there any better way or any other ways to do this task? Any suggestions please. Best regards Ravi ________________________________ DISCLAIMER: This email and any attachments may contain information that is confidential and subject to legal privilege. If you are not the intended recipient, any use, dissemination, distribution or duplication of this email and attachments is prohibited. If you have received this email in error please notify the author immediately and erase all copies of the email and attachments. The Ministry of Education accepts no responsibility for changes made to this message or attachments after transmission from the Ministry. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ---------------------------------------------------------------------- MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopedics, cancer and GI. IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. Help conserve valuable resources - only print this email if necessary. ________________________________ DISCLAIMER: This email and any attachments may contain information that is confidential and subject to legal privilege. If you are not the intended recipient, any use, dissemination, distribution or duplication of this email and attachments is prohibited. If you have received this email in error please notify the author immediately and erase all copies of the email and attachments. The Ministry of Education accepts no responsibility for changes made to this message or attachments after transmission from the Ministry.