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
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@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@lists.katipo.co.nz] On Behalf Of Mrs. Chitralekha M. Chitale Sent: Monday, October 26, 2015 4:35 AM To: koha@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@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.
Thank you Fred King. I need to assign barcodes as I want these to be counted (item wise) through a report showing my library collection. Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ----- Original Message ----- From: "Fred King" <Fred.King@Medstar.net> To: "Mrs. Chitralekha M. Chitale " <library.ltce@ltjss.net>, koha@lists.katipo.co.nz Sent: Tuesday, October 27, 2015 8:13:01 PM Subject: RE: Help to assign one barcode each to 10000+ records in mrc file 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@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@lists.katipo.co.nz] On Behalf Of Mrs. Chitralekha M. Chitale Sent: Monday, October 26, 2015 4:35 AM To: koha@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@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.
I need to assign barcodes as I want these to be counted (item wise) through a report showing my library collection.
Is it necessary to have a unique barcode for each item, or just to have an item for each record? We add "dummy" item records to e-book records when we import, but we don't bother with a barcode since the item will never get checked out. If all require is an item for each record, this can be done without having to use MarcEdit if you use a MARC modification template: http://manual.koha-community.org/3.20/en/catalogtools.html#marcmodtemplates I can elaborate on our process if that sounds like it would accomplish what you want. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Hi! Since you are usin marcedit, you can actually do this through merging provided you have 001 field or control number for your records. You can edit the records in csv/excel and then add/edit the barcodes. Convert this csv to mrk then merge the records using the 001 field as the field to use for matching. -- View this message in context: http://koha.1045719.n5.nabble.com/Help-to-assign-one-barcode-each-to-10000-r... Sent from the Koha-general mailing list archive at Nabble.com.
participants (4)
-
King, Fred -
Mrs. Chitralekha M. Chitale -
Owen Leonard -
schnydszch