Fwd: Data Imports form Excel > How copies of a book ?
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
Greetings, I am no expert in the matter, but one thing cries out to me: [SNIP AND EDIT] \\ 952$a 0 0 \\ 952$b 0 0 \\ 952$i 0 0 \\ 952$o 0 0 \\ 952$p 0 0 \\ 952$l 0 0 \\ 952$z 0 0 [SNIP AND EDIT] I would expect something closer to: \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0 Of course, all those 0's bug me too, but I'm assuming you are just putting some sort of placeholder there. And if you had multiple items: \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0 \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0 \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0 Hope this helps. GPML, Mark Tompsett
That's my experience, too. Four lines of 952 tags = four items. When I put them on the same line, I got only one item. Fred King kohauser@phred.us
Greetings,
I am no expert in the matter, but one thing cries out to me:
[SNIP AND EDIT] \\ 952$a 0 0 \\ 952$b 0 0 \\ 952$i 0 0 \\ 952$o 0 0 \\ 952$p 0 0 \\ 952$l 0 0 \\ 952$z 0 0 [SNIP AND EDIT]
I would expect something closer to: \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0
Of course, all those 0's bug me too, but I'm assuming you are just putting some sort of placeholder there. And if you had multiple items: \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0 \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0 \\ 952$a 0 0$b 0 0$i 0 0$o 0 0$p 0 0$l 0 0$z 0 0
Hope this helps.
GPML, Mark Tompsett
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Fred King -
HRS -
Mark Tompsett