LIS Links Becoming More Social

Birthdays

Birthdays Today

Latest Activity

Bidyut Bikash Kalita posted a blog post

Assistant Library and Information Officer - Department of Economic Affairs

5 hours ago
0 Comments
Pallavi lamba updated their profile
8 hours ago
Profile IconShalini Singh, Pratima S. Pandey, Gobinda Patel and 1 more joined LIS Links
19 hours ago
Rahul Devkant updated their profile
yesterday
ASHOK KUMAR MISHRA posted a blog post

Library Trainee at School of Planning and Architecture Bhopal

yesterday
0 Comments
nidhi singh updated their profile
yesterday
Profile IconLIS Links now has leaderboards
Thursday
Profile IconRaj Stephan Murmu, Jyoti Amit kumar Solanki, Mumtaz Nazir and 3 more joined LIS Links
Thursday
Anant Kulkarni updated their profile
Thursday
Bidyut Bikash Kalita was featured
Congratulate them!
Thursday
Dr. Chhavi Jain and Shadiya are now friends
Wednesday
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
Tuesday
0 Comments

Top Content 

1 Assistant Library and Information Officer - Department of Economic Affairs

Assistant Library and Information Officer - Department of Economic Affairs
2 Library Trainee at School of Planning and Architecture Bhopal

Library Trainee at School of Planning and Architecture Bhopal
3 Welcome Address by Dr. Kankana Baishya

Welcome Address by Dr. Kankana Baishya
4 Vote of Thanks by Dr. Badan Barman

Vote of Thanks by Dr. Badan Barman
5 National Conference on "Transforming Libraries from Knowledge Repositories to Intelligent Information Ecosystems: Emerging Trends, Innovation, Social Responsibility and Sustainability" (TLibRIIE-2027)

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

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