[Koha] Batch update of bib records - non-public note

[King, Fred]

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 at 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 at lists.katipo.co.nz> On Behalf Of Ravinder Pallikonda
Sent: Tuesday, December 6, 2022 7:07 PM
To: Koha <koha at 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 at 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.