LIS Links
First and Largest Academic Social Network of LIS Professionals in India
LIS Links Becoming More Social
Birthdays
Birthdays Today
Latest Activity
Invitation to Present | SoFerence 2026: A Global Platform to Showcase AI Use Cases in Libraries at Virtual
The Fr. Arrupe Central Library, St. Xavier's University, Kolkata, is organizing a Two-Day National Conference on “Bridging Knowledge, Technology, and Society through Libraries” at Fr. Albert Huart Hall (Auditorium), St. Xavier's University, Kolkata.
International Conference on “Transforming Libraries through AI for a Smarter Knowledge Future” (ICTL–2026) at Kalinga University, Naya Raipur, Mode: Hybrid (Online & Offline)
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: 852
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
