LIS Links

First and Largest Academic Social Network of LIS Professionals in India

LIS Links Becoming More Social

LIS Links whatsApp

LIS Links Mailing List (Broadcast Message)

Birthdays

Birthdays Today

Latest Activity

Dr. O Seshaiaih and Arun kumar Sirla are now friends
6 hours ago
Dr. Vijayakumar M and VISHNU K. GUPTA are now friends
10 hours ago
PRAKASH posted a status
"I applied for a Bihar Library job, so I need some study material. Please help me out"
yesterday
0 Comments
Rikki Singh Cintury joined Dr. Badan Barman's group
Thumbnail

Circular in Library and Information Science

yesterday
6 Comments
CHIPPA ANJANEYULU updated their profile
Tuesday
allauddin updated their profile
Tuesday
Pramod S. Kerkar replied to Dr. Anoop Kumar Bajpai's discussion Librarian is the teachers of teacher. How you can prove it?
Sep 3
Deepak Singh posted an event

Two-Day International Conference on Application of Modern Technologies in Libraries at Mandsaur University

September 26, 2026 at 6pm to September 27, 2026 at 7pm
Sep 3
0 Comments
KESHAVA updated their profile
Sep 2
M.MANI posted an event
Thumbnail

International Seminar on Redefining Research Excellence: Data to Discovery at Chennai, Tamil Nadu, India

September 11, 2026 from 8:30am to 6:30pm
Sep 1
0 Comments
Sumedha Singh posted events
Sep 1
Profile IconAamir Khan, Anil Kumar Usendi, Narendra Lahkar and 2 more joined LIS Links
Sep 1
M.MANI updated their profile
Sep 1
Reeti Brar is attending Nagappa Veerappa Bakkannanavar's event

Invitation to Present | SoFerence 2026: A Global Platform to Showcase AI Use Cases in Libraries at Virtual

September 10, 2026 from 9:30am to 5pm
Sep 1
0 Comments
Profile IconRATNAM INSTITUTE OF PHARMACY, Nandani kumari, Jenny Prisca Barla and 2 more joined LIS Links
Aug 31
Priyatama Sharma updated their profile
Aug 30
Rituraj Borkakoti updated their profile
Aug 30
Rainika sharma is now friends with Mr. S Kumar UGC-NET and prasidh kumar mishra
Aug 29
Joydip Barman shared a profile on Facebook
Thumbnail

Joydip Barman

Aug 29
Prangyasini Nayak is attending SHEIK MAIDEEN's event

Webinar on DELNET: Resources and Services at Online

September 9, 2026 from 3pm to 4pm
Aug 28
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: 884

▶ 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