Dear Linda, Thanks for your guidance, I am using MARC21... I have converted "Text(Tab delimited).txt" file to .mrk and then .mrc using MarcEdit (followed the steps from http://lists.katipo.co.nz/public/koha/2010-December/026750.html) ... As far as 952 and 260 field concern I have no idea how I can convert my data in single field trough MarcEdit (like your example: =082 \\$a917.6703/G925a/2000). Please guide me from where I get together my 952 and 260 fields in single line
Regards, Syed On Thu, Nov 17, 2011 at 3:22 AM, Linda Culberson <lcul...@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 <imageolog...@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<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 lcul...@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:.:-
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha