UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI
August 31, 2026 at 10:30am to September 14, 2026 at 5:30pm
LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
National Conference on "Bharatiya Knowledge System: Bridging Traditional Wisdom and Modern Challenges for Viksit Bharat at Jhunsi,
October 10, 2026 all day
Webinar on DELNET: Resources and Services at Online
September 9, 2026 from 3pm to 4pm
UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI
August 31, 2026 at 10:30pm to September 14, 2026 at 5:30pm
72nd ILA Annual Conference – International Conference on “Future Libraries: Advancing Research and Excellence (FLARE 2027)” at Indira Gandhi Memorial Library, University of Hyderabad, Gachibowli
January 7, 2027 to January 9, 2027
*International Conference on Transformative Libraries and the Digital Future – ICTLDF 2026* at ONLINE
August 20, 2026 at 10pm to August 21, 2026 at 7pm
Updated: Excel to Koha Data Import via MarcEdit
Greetings of the day.
Please let me know the Excel sheet bibliographic record entries for multiple items of a record. i.e. Multiple copies of a book. e.g., Accession number 480 to 484 (5 copies) of the book, "Food flavours technology handbook".
I am using MarcEdit to convert .xls to .mrk and .mrc. Then Koha - Tools - Sage MARC records & Manage Staged MARC records.
At present, there are 5 rows with all fields same, except Accession Number field.
But MarcEdit creates one record for each row, with one item associated with each record.
Instead I want One record with 5 items associated with it.
Please help, what should be the Excel sheet format, and other care to be taken.
Thanks in advance.
Regards
Mataprasad
Views: 873
Replies to This Forum
-
Permalink Reply by Mahipal Sharma on
-
First create one record with only one barcode.
When imported, import other records with matching rules set to author and title matches.
It will create one record and 5 items after that.
-
Permalink Reply by Mukhedkar M. V. on
-
Thank you Sir.
-
Permalink Reply by Vijender Kumar on
-
Put all barcode of multiple copy horizontal instead of vertical in the tag of 952p.then merge all tag of 952 which are same data of multiple copies.
-
-
Thank you sir.
© 2026 Created by Dr. Badan Barman.
Powered by
