[Koha] CDS/ISIS to Marc conversion issue

Sat Sep 6 14:24:14 NZST 2008

On Fri, Sep 5, 2008 at 9:20 AM, Ata ur Rehman <ata.rehman at gmail.com> wrote:

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

After replacing 45e0 with 4500 also, the barcode field does not get
populated or loaded.

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

In the marc_edit tool, the field mapping for CDS/ISIS to MARC conversion
does not support for subfield since I tried mapping 460=>952p which did not
change in the output, i.e our source file for importing. Please let me know
if there is any other way of doing this.

>
>
>> 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/20080906/8c6d32c2/attachment.htm 