Latest Activity

Karandeep Singh and Gurpreet Kaur are now friends
3 hours ago
Karandeep Singh replied to Karandeep Singh's discussion Web OPAC in E-granthalaya 3.0 Software
6 hours ago
Dr.Stephen.G posted blog posts
15 hours ago
Dr.Stephen.G and Madhavan Kolayamparampath are now friends
16 hours ago
Dr. Ujjal Marjit posted a status
"7 Useful Researcher Profiles Every Researcher Must Know"
17 hours ago
Profile IconAshish Kumar Shukla, Chencheti Balu, Arpita Mehta and 9 more joined LIS Links
17 hours ago
Dr. Subhash Chandra posted a blog post
17 hours ago
Dr.P.MUTHU MARI posted a discussion
17 hours ago
Nitish Kumar posted a discussion
17 hours ago
SHRIKANT KUMAR replied to Karandeep Singh's discussion Web OPAC in E-granthalaya 3.0 Software
18 hours ago
Ashoka R updated their profile
22 hours ago
Dr.Ghule Pravin Keruji updated their profile
Dr.Ghule Pravin Keruji and Sameer More are now friends
Anuj Jindal replied to MRS.PRITEE CHAK's discussion UGC NET study material
shilpa deshpande replied to Badan Barman's discussion PIL on Neglect of Library and Appointment of Library Staff all over India
SANTOSH KUMAR updated their profile
Badan Barman and Rahul Anand are now friends
Karandeep Singh posted a discussion
prabhu.c posted a discussion
Madhavan Kolayamparampath posted an event

Challenges of Academic Librarians in the Digital Landscape at Zoom/ YouTube

August 12, 2021 from 3:30pm to 7pm

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.



Views: 321

Reply to This

Replies to This Forum

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. 

Thank you Sir.

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.

Thank you sir.


© 2021   Created by Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Koha Workshop