LIS Links Becoming More Social

Birthdays

Birthdays Today

Latest Activity

Bidyut Bikash Kalita was featured
Congratulate them!
6 hours ago
Profile IconMumtaz Nazir, Kamalesh Dinda, Dr. Shivaganga and 1 more joined LIS Links
7 hours ago
Dr. Chhavi Jain and Shadiya are now friends
16 hours ago
Reeti Brar is attending Sunita Pareek's event
Thumbnail

Webinar on AI for Libraries at https://meet.google.com/fey-fjee-mdr

December 12, 2025 from 12pm to 2pm
yesterday
0 Comments
Samidha Sandeep Yadav might attend Gopal Pandey's event
Thumbnail

National Conference on "Bharatiya Knowledge System: Bridging Traditional Wisdom and Modern Challenges for Viksit Bharat at Jhunsi,

October 10, 2026 all day
yesterday
0 Comments
shankar das updated their profile
yesterday
Namita Bayan is attending Dr. Divyanshu Gupta's event
Thumbnail

National Conference on "Transforming Libraries from Knowledge Repositories to Intelligent Information Ecosystems: Emerging Trends, Innovation, Social Responsibility and Sustainability" (TLibRIIE-2027) at Mizoram University, Aizawl, India

February 17, 2027 at 10am to February 18, 2027 at 5pm
Monday
0 Comments
Namita Bayan might attend Rabishankar Giri's event

ICSSR-Sponsored Three-Day International Seminar on “Archives as Living Memory in the Indian Knowledge Ecosystem” at Presidency University, Kolkata

February 3, 2027 at 10am to February 5, 2027 at 5pm
Monday
0 Comments
Rabishankar Giri posted an event

ICSSR-Sponsored Three-Day International Seminar on “Archives as Living Memory in the Indian Knowledge Ecosystem” at Presidency University, Kolkata

February 3, 2027 at 10am to February 5, 2027 at 5pm
Monday
0 Comments
Dr Praggya Pandey posted a blog post

Library Trainee at PRL Ahmedabad

Monday
0 Comments
Profile IconVANPARIYA ROHITKUMAR VALLABHBHAI, Bapan Chandra Das, Archana S. Mangave and 2 more joined LIS Links
Monday
Dr. Divyanshu Gupta posted an event
Thumbnail

National Conference on "Transforming Libraries from Knowledge Repositories to Intelligent Information Ecosystems: Emerging Trends, Innovation, Social Responsibility and Sustainability" (TLibRIIE-2027) at Mizoram University, Aizawl, India

February 17, 2027 at 10am to February 18, 2027 at 5pm
Monday
0 Comments

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: 898

▶ Reply to This

Replies to This Forum

Permalink Reply by Mahipal Sharma on November 24, 2020 at 17:36

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 November 30, 2020 at 23:42

Thank you Sir.

Permalink Reply by Vijender Kumar on December 5, 2020 at 22:54

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.

Permalink Reply by Mukhedkar M. V. on December 7, 2020 at 22:52

Thank you sir.

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp