Hi Zachary: you have some problems with you migration<br>1) NML.mrc is not a MARC file. You must convert this file (that should be renamed as NML.mrk) with marcmaker of MarcEdit<br>2) Field 100. It is a no repetible field. It seems that you split the name of the authors in 2 fields,<br>
=100 0$a"Jeanne".<br>=100 1$a"Titherington".<br>should be<br>=100 1\$aTitherington, Jeanne<br>(without ", without points)<br>3) Field 020. You must put "\\" as indicators and it is better to eliminate the dashs<br>
=020 $a"0-688-09930-0"<br>should be<br>=020 \\$a0688099300<br>4) The title must be in the field 245, not in 130. <br>=130 $a"Pumpkin Pumpkin".<br>must be<br>=245 1\$aPumpkin Pumpkin.<br>(with point at the end).<br>
5) Apparenlty the date that you put in the field of publication data is not the <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-style-span" style="">date of publication. The CVS file have a field ("published") that is the date of publication</span></span>. For example the first register<br>
=LDR 00000nam 2200000Ia 45e0<br>=008 090314s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=020 $a"0-439-06073-7"<br>=100 0$a"Katherine".<br>=100 1$a"Paterson".<br>=130 $a"Jip".<br>=260 $b"Scholastic".$c"1/14/2009".<br>
should be<br>=LDR 00000nam 2200000Ia 45e0<br>=008 090314s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=020 \\$a0439060737<br>=100 1\$aPaterson, Katherine<br>=245 1\$aJip.<br>=260 \\$bScholastic, $c1996<br>=300 \\$a180 p.<br>
<br>
I add \\ indicators in field 260 and I add also field 300 with number of pages. <br><br>5) Convert your mrk file to a UTF8 file before the conversion<br><br>These suggestions (I think) only help to you to import the generated MARC file in Koha. A much better conversion could be do with the help of a librarian with MARC expertise.<br>
<br>In your CVS there is no way (I think) to get the data of the physical items, because there are not barcodes. So, when you import the generated MARC file you would not have items to borrow. <br><br>Regards, <br>Alejandro Tiraboschi<br>
FaMAF-UNC<br><br><div class="gmail_quote">2009/9/19 Zachary Tucker <span dir="ltr"><<a href="mailto:zbtucker@gmail.com">zbtucker@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello all!<div><br></div><div>This is my first post to the Koha list, and I am glad to see there is such an active community around the product. I've only used it for a few days, but I am already very happy with my decision to use Koha over Evergreen, OpenBiblio, etc.</div>
<div><br></div><div>My question pertains to importing existing book records. I have a listing of all our records in a CSV file... which contains info such as title, author, etc. The file is attached for reference. In an attempt to import that data, I converted that CSV information to MARC records. the converted file is attached for reference also. But, when I try to import the MARC file, I get an error that the staging was not completed because there are MARC errors.</div>
<div><br></div><div>So, I suppose my question has a lot mini questions... did I go about importing the wrong way? Did I convert the CSV file incorrectly? Did I map the data to the wrong MARC fields? I followed the LOC's MARC guide when doing the conversion, but apparently I did something wrong. </div>
<div><br></div><div>Any help would be greatly appreciated!</div><div><br></div><div>Thanks,<br>Zach Tucker</div><div><br></div><div>IT Director, Nelson Memorial Library</div>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>