Re: [Koha] CDS/ISIS to Marc conversion issue
Thanks Fredric, I tried using the file after replacing the 45e0 with 4500 and running the load but that did not help. 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'. Please let me know if there is something else i need to do about this issue. Thanks, Sai Bhalaji Frederic Demians <frederic@tamil.fr> to d.saibhalaji@gmail.com, koha@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@gmail.com> to d.saibhalaji@gmail.com, koha@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Thu, Sep 4, 2008 at 8:28 PM, <d.saibhalaji@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@tamil.fr> to d.saibhalaji@gmail.com, koha@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@gmail.com> to d.saibhalaji@gmail.com, koha@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Fri, Sep 5, 2008 at 9:20 AM, Ata ur Rehman <ata.rehman@gmail.com> wrote:
On Thu, Sep 4, 2008 at 8:28 PM, <d.saibhalaji@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@tamil.fr> to d.saibhalaji@gmail.com, koha@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@gmail.com> to d.saibhalaji@gmail.com, koha@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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.
Forget it. Your item barcode issue doesn't come from that.
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.
If CDS/ISIS doesn't allow you to export MARC records in the appropriate format, you need to : 1. export you records from CDS/ISIS 2. convert them from CDS/ISIS format to Koha format 3. import the previous records into Koha Depending on your skills, step 2 can be accomplished by several means: * A Perl script using MARC library: http://marcpm.sourceforge.net/ * using MarcEdit: http://oregonstate.edu/~reeset/marcedit/ -- Frédéric
participants (4)
-
Ata ur Rehman -
d.saibhalaji＠gmail.com -
Frederic Demians -
Sai Bhalaji D.