[Koha] Help to assign one barcode each to 10000+ records in mrc file

[King, Fred]

When I added our e-book collections to Koha, I didn't create item records--just bib records. As long as you have the link to the book in the 856u field, items and barcodes aren't needed.

Fred King
Medical Librarian, MedStar Washington Hospital Center
fred.king at medstar.net
202-877-6670
ORCID 0000-0001-5266-0279

I'm fifty one years old and I sort of think that the thing I'm supposed to do hasn't happened yet.
--Sandi Toksvig


-----Original Message-----
From: Koha [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Mrs. Chitralekha M. Chitale 
Sent: Monday, October 26, 2015 4:35 AM
To: koha at lists.katipo.co.nz
Subject: [Koha] Help to assign one barcode each to 10000+ records in mrc file

Sir, 

For the first time I purchased e-books from a publisher. They provided me a marc file (.mrc) for all the ebook titles (10000+). 
I can upload it directly to my Koha after adding and editing certain fields in records and add items with subfields having same description. 
I can do so using marcedit 5.2 as far as all records have same description to be added in that tag / copying from another field. 

But my problem is adding barcode (accession number in 952$p) to these records as each record will have different barcode. 

I tried converting marc file in excel. There is one marc tag per column but some of the columns have multiple subfields. 
I inserted barcode column, item type column, location column, Now I need to convert this excel to .mrc. 
The issue is I am not able to map them while converting to mrk file as each tag (above 010) must have subfield. 
I cannot map columns with multiple subfields eg. subject headings. 

Help me to assign one barcode each to these 10000+ records. 


Mrs. Chitralekha M. Chitale 
Librarian, Lokmanya Tilak College of Engineering, 
Navi Mumbai, India 

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
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, orthopaedics, 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.