LIS Links Becoming More Social

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Profile IconSanjeev Kumar, shaista khanam, Keshav D Vala and 1 more joined LIS Links
18 hours ago
Bidyut Bikash Kalita posted a blog post

Librarian - NPS International school, Lokhra, Guwahati

yesterday
0 Comments
Dr. U. PRAMANATHAN posted a blog post

The Coast Guard Public School, Daman(U.T) invites applications for the Librarian Post to be filled up for the Academic Year 2026-27.

yesterday
0 Comments
Dr. U. PRAMANATHAN posted a discussion

British Council’s physical library in Chennai turns its last page.

yesterday
0 Comments
Dr. U. PRAMANATHAN posted an event

User Awareness Programme on IRINS and INFLIBNET Services at Darshan University, Rajkot, Gujarat on February 21, 2026. at Darshan University, Rajkot, Gujarat.

February 21, 2026 from 8:30am to 5:30pm
yesterday
0 Comments
Profile IconMOHANA K and vandita sharma joined LIS Links
Sunday
Dr. U. PRAMANATHAN posted blog posts
Saturday
Bidyut Bikash Kalita posted blog posts
5 more…
Saturday
Profile IconBidyut Bikash Kalita, SANTHOSHA M, Pooja devi and 7 more joined LIS Links
Friday
Dr. Badan Barman posted a blog post

Library and Information Officer in NITI Aayog

Friday
0 Comments
Praveen Kumar and Dr. Badan Barman are now friends
Thursday
Praveen Kumar updated their profile
Thursday
Anandanayaka S G updated their profile
Jan 28
Dr.W.Vijaya Shoba shared their event on Facebook
Thumbnail

Stress and Stress Management for College Students

Jan 24
Dr.W.Vijaya Shoba posted an event
Thumbnail

Stress and Stress Management for College Students at Kaliakkavilai

January 30, 2026 from 3pm to 4pm
Jan 22
0 Comments
Dr. U. PRAMANATHAN posted a discussion

Call for Book Chapters: Digital Leadership in Library & Information Centers (Innovative Strategies in Library Management) by Ess Ess Publications.

Jan 22
0 Comments
Sachin Chourasia updated their profile
Jan 20
Dr. U. PRAMANATHAN posted an event

RRRLF-sponsored National Conference on Information Landscape: Trends and Innovations in Public and Academic Libraries (NCILTIPAL 2026) at Kasthurba Kalaiarangam, Vellalar College for Women (Autonomous), Thindal, Erode.

February 13, 2026 at 9am to February 14, 2026 at 5pm
Jan 20
0 Comments
Profile Iconsanthosh kumar, D.Seshu Kumari, Shruthi and 4 more joined LIS Links
Jan 20
Dr.W.Vijaya Shoba shared a profile on Facebook
Thumbnail

Devika Nath

Jan 12

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

▶ 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