[Koha] Fwd: Data Imports form Excel > How copies of a book ?

[HRS]

Dear Community please  help  me to solve data import matter from excel.

After importing  data from Excel I have noticed that  copies of an item is
display separately. Example if a book has 4 copies, it displays as separate
items now. I need one bib. record and under that 4 items.

I use merge record function but it take time for 100000 records- it would
difficult task.

The  MarcEdit template is like this

0 \\ 020$a 0 0
1 \\0 82$a 0 0
2 \\ 082$b 0 0
3 \\ 100$a 0 0
4 \\ 245$a 0 0
5 \\ 250$a 0 0
6 \\ 260$b 0 0
7 \\ 260$c 0 0
8 \\ 650$a 0 0
9 \\ 942$c 0 0
10 \\ 952$a 0 0
11 \\ 952$b 0 0
12 \\ 952$i 0 0
13 \\ 952$o 0 0
14 \\ 952$p 0 0
15 \\ 952$l 0 0
16 \\ 952$z 0 0

Any one can solve the matter ? please

Harsha Balasooriya
Senior Assistant Librarian
The Open University of Sri Lanka