Updated: Excel to Koha Data Import via MarcEdit

[Mukhedkar M. V.]

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

[Mahipal Sharma]

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. 

[Mukhedkar M. V.]

Thank you Sir.

[Vijender Kumar]

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.

[Mukhedkar M. V.]

Thank you sir.