LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

sukham romen singh left a comment for Khundrakpam Premoda Devi
8 hours ago
Prakhar Dixit updated their profile
yesterday
Mr. K. Kanipriyan and Kannan G are now friends
yesterday
Rohan Gupta updated their profile
yesterday
Profile IconN.KAPILESH, Bhamare Rhishikesh Suresh, piyush dhekale and 26 more joined LIS Links
yesterday
Madhu E S posted a blog post

Library Trainee - Indian Institute of Technology Dharwad

yesterday
0 Comments
Shompa Das (Chaudhury) posted a blog post

Library Assistant - IITM Pune Library (Government Research Institute in Pune under MoES)

yesterday
0 Comments
Shaheen Momin posted a discussion

Standard Procedure for Writing Off Unreturned Books by Departed Faculty Members

yesterday
0 Comments
MD KAIYUM SHAIKH posted an event

International Conference on “Transforming Libraries through AI for a Smarter Knowledge Future” (ICTL–2026) at Kalinga University, Naya Raipur, Mode: Hybrid (Online & Offline)

June 19, 2026 at 9am to June 20, 2026 at 5pm
yesterday
0 Comments
Nagappa Veerappa Bakkannanavar posted an event

60th Anniversary (Diamond Jubilee) of the Department of Studies in Library and Information Science (MyDLIS) at the University of Mysore at University of Mysore

May 29, 2026 at 9am to May 30, 2026 at 5pm
yesterday
0 Comments
Dr. SUDHI S VIJAYAN posted a discussion

Internatisonal Conference and Awards - Prof. K A Isaac Society for Library and Information Science

yesterday
0 Comments
Oriental Library Association posted a discussion

Call for Articles: GRANTHENDRIYA (ISSN: 3107-8192) | Volume 2, Issue 1

yesterday
0 Comments
Dr. Chittaranjan Nayak posted a discussion

Admission Open for the Session 2026-2027

yesterday
0 Comments
Suresh Vyas posted a discussion

Pay Anomaly regarding Entry Pay of Departmental Librarians in MoD (Level 6 vs Level 7) – Seeking Guidance and CAT Precedents

yesterday
0 Comments
Krishna kumar yadav is attending Dr. Sandip Pathak's event
Thumbnail

13th Convention Planner 2026 at Gauhati University,  Guwahati, Assam.

September 18, 2026 at 9am to September 20, 2026 at 7pm
yesterday
0 Comments
Anil Singh Yadav left a comment for Krishna kumar yadav
Saturday
Krishna kumar yadav left a comment for Anil Singh Yadav
May 20
Dr Rajiv Vij updated their profile
May 19
Mr. K. Kanipriyan is attending MD KAIYUM SHAIKH's event

An Invitation to the International Conference on “Transforming Libraries through AI for a Smarter Knowledge Future (ICTL–2026)” | 19th–20th June 2026 | Kalinga University, Naya Raipur (Hybrid Mode) at Kalinga University, Naya Raipur, Mode: Hybrid (Online & Offline)

June 19, 2026 at 9am to June 20, 2026 at 5pm
May 19
0 Comments
Vikash Kumar Dwivedi updated their profile
May 13

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

▶ 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