On Thu, Nov 17, 2011 at 3:22 AM, Linda Culberson
<lculber@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@gmail.com>
Date:
Wed, 16 Nov 2011 17:45:46 +0500
To:
koha@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 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@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