<div dir="ltr"><br><div class="gmail_quote">On Thu, Sep 4, 2008 at 8:28 PM, <span dir="ltr"><<a href="mailto:d.saibhalaji@gmail.com">d.saibhalaji@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Thanks Fredric,<br><br>I tried using the file after replacing the 45e0 with 4500 and running the load but that did not help.</blockquote><div><span style="color: rgb(0, 0, 153);">What is the meaning of "that did not help"?, please tell us about the exact error you are getting here</span> <br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>I use 'marc edit' tool for converting the CDS/ISIS file into marc and when i map 950=>952p, it does not do any conversion on the identifier. Hence I made the change in the database table 'marc_subfield_structure'.</blockquote>
<div><span style="color: rgb(0, 0, 153);">In my point of view you need not to change anything in marc_subfield_structure</span> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Please let me know if there is something else i need to do about this issue.<br><br>Thanks,<br>Sai Bhalaji<br><br><br><br>Frederic Demians <<a href="mailto:frederic@tamil.fr" target="_blank">frederic@tamil.fr</a>> to <a href="mailto:d.saibhalaji@gmail.com" target="_blank">d.saibhalaji@gmail.com</a>, <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><br>
1 Sep<div class="Ih2E3d"><br><br> We have our library running on CDS/ISIS database. I use the bulkimport.pl script for loading into the mysql. Most of the fields get loaded into the database except for the barcode (accession #). Can someone let me know the possible reason for it. Can it be due to multiple values for the field? If so, please let me know how to resolve it since I've tried most of the attempts in the marc_subfield_structure table.<br>
<br><br><br>Please send a dump of your import file to get help. Few biblio records in text version generated with yaz-marcdump for example.<br></div>- Show quoted text -<br><font color="#888888">--<br>Frédéric<br>Ata ur Rehman <<a href="mailto:ata.rehman@gmail.com" target="_blank">ata.rehman@gmail.com</a>> to <a href="mailto:d.saibhalaji@gmail.com" target="_blank">d.saibhalaji@gmail.com</a>, <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><br>
2 Sep</font><div><div></div><div class="Wj3C7c"><br><br><br>There are few issues with your data. plz see my inline reply<br><br>On Tue, Sep 2, 2008 at 9:35 AM, <<a href="mailto:d.saibhalaji@gmail.com" target="_blank">d.saibhalaji@gmail.com</a>> wrote:<br>
<br> Thanks Frederic,<br><br> Here are a set of 10 records from the marc import file.<br><br> The barcode/accession number is the one corresponding to 950 (for example in record 1: "=950 \\$a21193" and =950 \\$a4813)<br>
<br> Corresponding to 950a in the database i added the items.barcode field in the "marc_subfield_structure" table.<br><br> ----------------------------------------------------------------------------------------<br>
<br> =LDR 00333nam 2200169Ia 45e0<br><br><br>replace all 45e0 with 4500<br><br><br><br> =005 120604<br><br> =004 D<br><br> =005 M<br><br> =010 65-16401<br><br> =100 \\$aAndrews$bDonald H.<br><br> =100 \\$aKokes$bRichard J.<br>
<br> =245 \\$aFundamental <Chemistry><br><br> =250 2nd ed.<br><br> =260 \\$aNew York$bJohn Wiley$c1965<br><br> =950 \\$a21193<br><br>all barcodes must be under 952 $p <br><br><br><br> =950 \\$a4813<br>
<br> =952 \\$a540ANDK<br><br> ----------------------------------------------------------------------------------------<br><br> =LDR 00268nam 2200121Ia 45e0<br><br> =020 0-06-040805-7<br><br> =952 \\$a540BOIE<br>
<br> =100 \\$aBoikess$bRobert S.<br><br> =100 \\$aEdelson$bEdward<br><br> =245 \\$a<Chemical Principles><br><br> =250 3rd Ed.<br><br> =260 \\$aNew York$bHarper & Row$c1985<br><br> =950 \\$a30262<br>
<br> ----------------------------------------------------------------------------------------<br><br> =LDR 00311nam 2200145Ia 45e0<br><br> =010 84-10798<br><br> =020 0-06-040805-7<br><br> =100 \\$aBoikess$bRobert S.<br>
<br> =100 \\$aEdelson$bEdward<br><br> =245 \\$a<Chemical principles><br><br> =250 2nd Ed.<br><br> =260 \\$aNew York$bHarper & Row$c1982<br><br> =950 \\$a28407<br><br> =950 \\$a29531<br><br> =952 \\$a540BOIE<br>
<br> ----------------------------------------------------------------------------------------<br><br> =LDR 00347nam 2200169Ia 45e0<br><br> =010 74-10192<br><br> =020 0-12-132372-2<br><br> =100 \\$aBrescia<br>
<br> =100 \\$aArents<br><br> =100 \\$aMeislich<br><br> =100 \\$aTurk<br><br> =245 \\$aFundamentals Of <Chemistry><br><br> =250 3rd Ed.<br><br> =260 \\$aNew York$bAcademic Press$c1975<br><br> =650 \\$aChemistry<br>
<br> =950 \\$a8567<br><br> =952 \\$a540BRE<br><br> ----------------------------------------------------------------------------------------<br><br> =LDR 00278nam 2200121Ia 45e0<br><br> =020 0-333-444-97-3<br>
<br> =020 0-333-37310-3<br><br> =100 \\$aFreemantle$bMichael<br><br> =245 \\$a<Chemistry> in Action<br><br> =260 \\$aLondon$bMacmillan Education Ltd$c1987<br><br> =650 \\$aChemistry<br><br> =950 \\$a34810<br>
<br> =952 \\$a540FRE<br><br> ----------------------------------------------------------------------------------------<br><br> =LDR 00192nam 2200085Ia 45e0<br><br> =100 \\$aAndrews$bDonald H.<br><br> =245 \\$a<Chemistry> - Humanistic view<br>
<br> =260 \\$aTokyo$bMcGrawHill$c1974<br><br> =950 \\$a20610<br><br> =952 \\$a540AND<br><br> ----------------------------------------------------------------------------------------<br><br> =LDR 00220nam 2200097Ia 45e0<br>
<br> =100 \\$aBabor$bJoseph A.<br><br> =100 \\$aLehrman$bAlexander<br><br> =245 \\$aGeneral <College Chemistry><br><br> =260 \\$bThomas Crowell$c1947<br><br> =950 \\$a3260<br><br> =952 \\$a540BABL<br>
<br> ----------------------------------------------------------------------------------------<br><br> =LDR 00233nam 2200097Ia 45e0<br><br> =100 \\$aBarton$bL.<br><br> =245 \\$aNew trends in Chemistry<br><br> =260 \\$aBerlin$bSpringer-verlag$c1982<br>
<br> =440 \\$aTopics in current Chemistry$v100<br><br> =950 \\$a24630<br><br> =952 \\$a540BAR<br><br> ----------------------------------------------------------------------------------------<br><br> =LDR 00241nam 2200109Ia 45e0<br>
<br> =100 \\$aBaum$bStuart J.<br><br> =100 \\$aScaife$bCharles W.<br><br> =245 \\$aChemistry, <Life Science> Approach<br><br> =250 2nd Ed.<br><br> =260 \\$bMacMillan$c1980<br><br> =950 \\$a8335<br>
<br> =952 \\$a540BAUS<br><br> ----------------------------------------------------------------------------------------<br><br> =LDR 00217nam 2200097Ia 45e0<br><br> =100 \\$aBresica<br><br> =245 \\$a<Students Guide> To <Fundamentals> Of <Chemistry><br>
<br> =250 3rd Ed.<br><br> =260 \\$bAcademic Press$c1975<br><br> =950 \\$a8568<br><br> =952 \\$a540BRA<br><br> ----------------------------------------------------------------------------------------<br><br>
<br><br> Please let me know if some more details would me needed.<br><br><br> Thanks,<br><br> Sai Bhalaji<br><br> Sri Sathya Sai University<br><br> _______________________________________________<br> Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">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></div>
</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></div>