"What are you up to?"
LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
AI-Powered Bibliometric Analysis:10-Day Hands-on Research-to-Publication Programme at Online
December 1, 2026 at 7:30pm to December 10, 2026 at 9pm
Two-Day National Level Workshop on "Gateways to Global Visibility: Publishing in Scopus and WoS Journals" at Dnyanprassarak Mandal’s College and Research Centre
December 1, 2026 to December 2, 2026
International Conference on Re-engineering and Transforming Libraries for Research and Development at Keralam
February 11, 2027 at 10am to February 13, 2027 at 5pm
Top Content
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: 910
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
