[Koha] Getting error on Data Migration

imageologist imageologist at gmail.com
Tue Nov 22 21:13:56 NZDT 2011 

Dear Linda & Ata,

Thanks for your kind support and step by step guidance, I have successfully
resolved my data-migration problem I have combined 082 & 952 field and
sub-fields in single line with MarcEdit field mapping "join items" find
attached for reference.

Thanks & regards
Syed



On Thu, Nov 17, 2011 at 3:22 AM, Linda Culberson
<lculber at mdah.state.ms.us>wrote:

> Sved,
> I've never used Excel to migrate MARC but have used MarcEdit and the
> Import Tool.  I can tell you that your first record in MarcEdit looks like:
>
> =LDR  00422nam a2200205Ia 45e0
> = 08  2$a001-AYE
> =008  111116s9999\\\\xx\\\\\\\\\\\\**000\0\und\d
> =020  \\$a140135472
> =082  \\$219TH ED.
> =100  \\$aAYER A. J.
> =245  \\$aTHE PROBLEM  OF KNOWLEDGE.
> =260  \\$aENGLAND
> =260  \\$bPENGUIN BOOKS
> =260  \\$c1986
> =300  \\$a223
> =440  \\$nv. 1
> =942  \\$cBK
> =952  \\$aMAIN
> =952  \\$bMAIN
> =952  \\$p45594
>
> Everything in a field or tag should be on a single line
> The 260 should be like
> =260 \\$aEngland$bPenguinBooks$**c1986.
>
> The 952 fields should be all one one line like
> =952 \\$aMAIN$bMAIN$p45594
>
> There are some other problems with the record not having the correct
> indicators for MARC21, but I don't know UNIMARC, which I'm assuming you are
> using, so I can't help you there at all, I'm afraid.
>
>
> Here is one of ours in MARC21 in MarcEdit for you to look at
> =LDR  01667pam  2200385 a 4500
> =001  3
> =003  Ms-Ar
> =005  20110528131125.0
> =008  000608s2000\\\\aruab\\\\b\\\**s001\0\eng\\
> =010  \\$a00009893
> =020  \\$a1563490889 (alk. paper)
> =082  \\$a917.6703/G925a/2000
> =100  1\$aGuendling, Randall L.
> =245  13$aAn Archaic campsite in the Ozarks :$btest excavations at the
> Ryan Site (3MA233) /$cby Randall L. Guendling ; with contributions by
> Sandra L. Dunavan.
> =260  \\$aFayetteville :$bArkansas Archeological Survey,$c2000.
> =300  \\$aiv, 52 p. :$bill., maps ;$c29 x 22 cm.
> =440  \0$aArkansas Archeological Survey research report ;$vno. 30
> =504  \\$aIncludes bibliographical references (p. 45-51) and index.
> =505  0\$aProject background and environmental parameters -- Cultural
> history and previous investigations -- Archeology of the Ryan Site --
> Analysis of the artifact collections -- Archeobotanical remains from the
> Ryan Site -- Ryan Site prehistory and recommendations.
> =650  \0$aRyan Site (Ark.)
> =650  \0$aPaleo-Indians$zArkansas$**zMadison County.
> =650  \0$aStone implements$zArkansas$zMadison County.
> =650  \0$aSalvage archaeology$zArkansas$zMadison County.
> =651  \0$aMadison County (Ark.)$xAntiquities.
> =700  1\$aDunavan, Sandra L.
> =952   \\$aDAH$bDAH$cARCH$8GEN$o917.**6703/G925a/2000$p17
>
>  Subject:
>> [Koha] Getting error on Data Migration (Excel>MarcEdit>Koha)
>> From:
>> imageologist <imageologist at gmail.com>
>> Date:
>> Wed, 16 Nov 2011 17:45:46 +0500
>> To:
>> koha at lists.katipo.co.nz
>>
>>
>> Greetings!
>>
>> I'm using Koha 3.04.02, please find attached my library data-migration
>> process files I have followed http://lists.katipo.co.nz/**
>> public/koha/2010-December/**026750.html<http://lists.katipo.co.nz/public/koha/2010-December/026750.html>steps with MarcEdit 5.6. During import process I am getting following error
>> "9 records not staged because of MARC error". at this stage I am in testing
>> process I have more than 10,000 books records in Excel format to migrate in
>> Koha. Please guide me am I missing some where or I have missed/conflict on
>> mapping fields?
>>
>>
>> ------------------------------**-------
>>
>> Error:
>> Stage MARC Records For Import
>>
>> MARC Staging results :
>>
>>    * 9 records in file
>>    * 9 records not staged because of MARC error
>>    * 0 records staged
>>    * Did not check for matches with existing records in catalog
>>    * 0 item records found and staged
>>    * Manage staged records
>>    * Back
>>
>> ------------------------------**-------
>>
>> It will be highly appreciated if anyone resolve this issue
>>
>>
>> Best regards
>> Syed
>>
>>
>> LibraryData-16Nov2011-2 Text (Tab delimited).txt
>>
>> 001-AYE      AYER A. J.      THE PROBLEM  OF KNOWLEDGE.      ENGLAND
>> PENGUIN BOOKS   1986    223     v. 1    19TH ED.        45594   140135472
>>     MAIN    MAIN    BK
>> 001-BES BESTERMAN THEODORE      BRITISH SOURCES OF REFERENCE AND
>> INFORMATION.   LONDON  BRITISH COUNCIL 1947    56      v. 1    19TH ED.
>>    13523           MAIN    MAIN    BK
>> 001-BHA BHATTI IQBAL A. EVERLATEST GENERAL KNOWLEDGE.   JEHELUM BHATTI
>> PUBLISHERS       1985    392+112+104     v. 1    19TH ED.        68273
>>       MAIN    MAIN    BK
>> 001-BOL BOLGAR R. R.    THE CLASSICAL HERITAGE AND ITS BENEFICARIES.
>>  LONDON  CAMBRIDGE UNIVERSITY PRESS      1954    VII 591 v. 1    19TH ED.
>>      14915   9780511583735   MAIN    MAIN    BK
>> 001-BOO         THE BOOK OF KNOWLEDGE; AN ENSICLOPEDIA FOR READERS OF ALL
>> AGES. EDITED BY HAROLD F.B. WHEELER   LONDON  THE WAVERLEY BOOK COMP. (N.D)
>>                   v. 8            2333            MAIN    MAIN    BK
>> 001-BOO         THE BOOK OF KNOWLEDGE; AN ENSICLOPEDIA FOR READERS OF ALL
>> AGES. EDITED BY HAROLD F.B. WHEELER   LONDON  THE WAVERLEY BOOK COMP. (N.D)
>>                   v. 9            2340            MAIN    MAIN    BK
>> 001-CLA CLAYTON PETER A.        THE SEVEN WONDERS OF THE ANCIENT WORLD BY
>> PETER A. CLAY TON & MARTIN J. NEW YORK        DORSET PRESS    1988    XV
>> 176                  61661   9780415050364   MAIN    MAIN    BK
>> 001-CON         CONTEMPORARY AFFAIRS. EDITED BY ABBAS SARWAR QURESHI.
>> LAHORE  CARAVAN BOOK HOUSE      2005    548                     74631
>>     MAIN    MAIN    BK
>> 001-COV COVEY STEPHEN R.        THE 7 HABITS OF HIGHLY EFFECTIVE PEOPLE
>> LONDON  SIMON & SCHUSTER        2004    372                     76772
>>     MAIN    MAIN    BK
>>
>
>
>
>
>
> --
> Linda Culberson      lculber at mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873   Fax:  601/576-6824
>
>
>


-- 
-:.:IMAGEOLOGIST:.:-
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111122/5e03ecfb/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: MarcEdit Join Items in single line.JPG
Type: image/jpeg
Size: 45019 bytes
Desc: not available
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111122/5e03ecfb/attachment-0001.jpe>

More information about the Koha mailing list