[Koha] CDS/ISIS to Marc conversion issue

[Ata ur Rehman]

On Thu, Sep 4, 2008 at 8:28 PM, <d.saibhalaji at gmail.com> wrote:

> Thanks Fredric,
>
> I tried using the file after replacing the 45e0 with 4500 and running the
> load but that did not help.

What is the meaning of "that did not help"?, please tell us about the exact
error you are getting here

>
> 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'.

In my point of view you need not to change anything in
marc_subfield_structure

>
> Please let me know if there is something else i need to do about this
> issue.
>
> Thanks,
> Sai Bhalaji
>
>
>
> Frederic Demians <frederic at tamil.fr> to d.saibhalaji at gmail.com,
> koha at lists.katipo.co.nz
> 1 Sep
>
> 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.
>
>
>
> Please send a dump of your import file to get help. Few biblio records in
> text version generated with yaz-marcdump for example.
> - Show quoted text -
> --
> Frédéric
> Ata ur Rehman <ata.rehman at gmail.com> to d.saibhalaji at gmail.com,
> koha at lists.katipo.co.nz
> 2 Sep
>
>
>
> There are few issues with your data. plz see my inline reply
>
> On Tue, Sep 2, 2008 at 9:35 AM, <d.saibhalaji at gmail.com> wrote:
>
> Thanks Frederic,
>
> Here are a set of 10 records from the marc import file.
>
> The barcode/accession number is the one corresponding to 950 (for example
> in record 1: "=950 \\$a21193" and =950 \\$a4813)
>
> Corresponding to 950a in the database i added the items.barcode field in
> the "marc_subfield_structure" table.
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00333nam 2200169Ia 45e0
>
>
> replace all 45e0 with 4500
>
>
>
> =005 120604
>
> =004 D
>
> =005 M
>
> =010 65-16401
>
> =100 \\$aAndrews$bDonald H.
>
> =100 \\$aKokes$bRichard J.
>
> =245 \\$aFundamental <Chemistry>
>
> =250 2nd ed.
>
> =260 \\$aNew York$bJohn Wiley$c1965
>
> =950 \\$a21193
>
> all barcodes must be under 952 $p
>
>
>
> =950 \\$a4813
>
> =952 \\$a540ANDK
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00268nam 2200121Ia 45e0
>
> =020 0-06-040805-7
>
> =952 \\$a540BOIE
>
> =100 \\$aBoikess$bRobert S.
>
> =100 \\$aEdelson$bEdward
>
> =245 \\$a<Chemical Principles>
>
> =250 3rd Ed.
>
> =260 \\$aNew York$bHarper & Row$c1985
>
> =950 \\$a30262
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00311nam 2200145Ia 45e0
>
> =010 84-10798
>
> =020 0-06-040805-7
>
> =100 \\$aBoikess$bRobert S.
>
> =100 \\$aEdelson$bEdward
>
> =245 \\$a<Chemical principles>
>
> =250 2nd Ed.
>
> =260 \\$aNew York$bHarper & Row$c1982
>
> =950 \\$a28407
>
> =950 \\$a29531
>
> =952 \\$a540BOIE
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00347nam 2200169Ia 45e0
>
> =010 74-10192
>
> =020 0-12-132372-2
>
> =100 \\$aBrescia
>
> =100 \\$aArents
>
> =100 \\$aMeislich
>
> =100 \\$aTurk
>
> =245 \\$aFundamentals Of <Chemistry>
>
> =250 3rd Ed.
>
> =260 \\$aNew York$bAcademic Press$c1975
>
> =650 \\$aChemistry
>
> =950 \\$a8567
>
> =952 \\$a540BRE
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00278nam 2200121Ia 45e0
>
> =020 0-333-444-97-3
>
> =020 0-333-37310-3
>
> =100 \\$aFreemantle$bMichael
>
> =245 \\$a<Chemistry> in Action
>
> =260 \\$aLondon$bMacmillan Education Ltd$c1987
>
> =650 \\$aChemistry
>
> =950 \\$a34810
>
> =952 \\$a540FRE
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00192nam 2200085Ia 45e0
>
> =100 \\$aAndrews$bDonald H.
>
> =245 \\$a<Chemistry> - Humanistic view
>
> =260 \\$aTokyo$bMcGrawHill$c1974
>
> =950 \\$a20610
>
> =952 \\$a540AND
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00220nam 2200097Ia 45e0
>
> =100 \\$aBabor$bJoseph A.
>
> =100 \\$aLehrman$bAlexander
>
> =245 \\$aGeneral <College Chemistry>
>
> =260 \\$bThomas Crowell$c1947
>
> =950 \\$a3260
>
> =952 \\$a540BABL
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00233nam 2200097Ia 45e0
>
> =100 \\$aBarton$bL.
>
> =245 \\$aNew trends in Chemistry
>
> =260 \\$aBerlin$bSpringer-verlag$c1982
>
> =440 \\$aTopics in current Chemistry$v100
>
> =950 \\$a24630
>
> =952 \\$a540BAR
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00241nam 2200109Ia 45e0
>
> =100 \\$aBaum$bStuart J.
>
> =100 \\$aScaife$bCharles W.
>
> =245 \\$aChemistry, <Life Science> Approach
>
> =250 2nd Ed.
>
> =260 \\$bMacMillan$c1980
>
> =950 \\$a8335
>
> =952 \\$a540BAUS
>
>
> ----------------------------------------------------------------------------------------
>
> =LDR 00217nam 2200097Ia 45e0
>
> =100 \\$aBresica
>
> =245 \\$a<Students Guide> To <Fundamentals> Of <Chemistry>
>
> =250 3rd Ed.
>
> =260 \\$bAcademic Press$c1975
>
> =950 \\$a8568
>
> =952 \\$a540BRA
>
>
> ----------------------------------------------------------------------------------------
>
>
>
> Please let me know if some more details would me needed.
>
>
> Thanks,
>
> Sai Bhalaji
>
> Sri Sathya Sai University
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080905/08c613c8/attachment.htm