LIS Links
First and Largest Academic Social Network of LIS Professionals in India
Top Content
Birthdays
Birthdays Today
Latest Activity
Mastering Scholarly Literature Discovery: Indexing, Open Access & Full Text Databases at Online
November 13, 2026 at 7:30pm to November 15, 2026 at 8:30pm
Two-Day National Seminar on “Smart Libraries: Integrating AI, IoT, and Intelligent Systems for Next-Generation Knowledge Services at Chitkara University, Himachal Pradesh (Pinjore-Nalagarh National Highway (NH-21A), kalujhinda, Baddi, Himachal Pradesh
February 19, 2027 to February 20, 2027
29th National Convention on Knowledge, Library and Information Networking (NACLIN 2026) at Hotel The Park Hyderabad, Raj Bhavan Road, Somajiguda, Hyderabad*
November 26, 2026 at 9pm to November 27, 2026 at 4pm
AI-Powered Koha in Practice: Metadata, SQL Reports and OPAC Customisation
November 22, 2026 from 1pm to 3pm🚀 AI-Powered Librarianship: 5-Day Hands-on Skill Development Bootcamp
November 26, 2026 at 7:30pm to November 30, 2026 at 9pm
Conference on Bhartiya Knowledge System: Traditional Wisdom and Modern Challenges for Viksit Bharat (BKS-2027) at Malwanchal University
January 16, 2027 all day
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: 911
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
