Re: [Koha] Getting error on Data Migration (Excel>MarcEdit>Koha)
Dear Syed / All Thanks for your email. I have seen your MARC data. I converted it into .mrk file to make it human readable. It 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 =LDR 00423nam a2200193Ia 45e0 = 08 2$a001-BES =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =082 \\$219TH ED. =100 \\$aBESTERMAN THEODORE =245 \\$aBRITISH SOURCES OF REFERENCE AND INFORMATION. =260 \\$aLONDON =260 \\$bBRITISH COUNCIL =260 \\$c1947 =300 \\$a56 =440 \\$nv. 1 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p13523 =LDR 00416nam a2200193Ia 45e0 = 08 2$a001-BHA =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =082 \\$219TH ED. =100 \\$aBHATTI IQBAL A. =245 \\$aEVERLATEST GENERAL KNOWLEDGE. =260 \\$aJEHELUM =260 \\$bBHATTI PUBLISHERS =260 \\$c1985 =300 \\$a392+112+104 =440 \\$nv. 1 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p68273 =LDR 00463nam a2200205Ia 45e0 = 08 2$a001-BOL =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a9780511583735 =082 \\$219TH ED. =100 \\$aBOLGAR R. R. =245 \\$aTHE CLASSICAL HERITAGE AND ITS BENEFICARIES. =260 \\$aLONDON =260 \\$bCAMBRIDGE UNIVERSITY PRESS =260 \\$c1954 =300 \\$aVII 591 =440 \\$nv. 1 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p14915 =LDR 00384nam a2200145Ia 45e0 = 08 2$a001-BOO =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =245 \\$aTHE BOOK OF KNOWLEDGE; AN ENSICLOPEDIA FOR READERS OF ALL AGES. EDITED BY HAROLD F.B. WHEELER =260 \\$aLONDON =260 \\$bTHE WAVERLEY BOOK COMP. (N.D) =440 \\$nv. 8 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p2333 =LDR 00384nam a2200145Ia 45e0 = 08 2$a001-BOO =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =245 \\$aTHE BOOK OF KNOWLEDGE; AN ENSICLOPEDIA FOR READERS OF ALL AGES. EDITED BY HAROLD F.B. WHEELER =260 \\$aLONDON =260 \\$bTHE WAVERLEY BOOK COMP. (N.D) =440 \\$nv. 9 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p2340 =LDR 00434nam a2200181Ia 45e0 = 08 2$a001-CLA =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a9780415050364 =100 \\$aCLAYTON PETER A. =245 \\$aTHE SEVEN WONDERS OF THE ANCIENT WORLD BY PETER A. CLAY TON & MARTIN J. =260 \\$aNEW YORK =260 \\$bDORSET PRESS =260 \\$c1988 =300 \\$aXV 176 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p61661 =LDR 00354nam a2200157Ia 45e0 = 08 2$a001-CON =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =245 \\$aCONTEMPORARY AFFAIRS. EDITED BY ABBAS SARWAR QURESHI. =260 \\$aLAHORE =260 \\$bCARAVAN BOOK HOUSE =260 \\$c2005 =300 \\$a548 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p74631 =LDR 00371nam a2200169Ia 45e0 = 08 2$a001-COV =008 111116s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$aCOVEY STEPHEN R. =245 \\$aTHE 7 HABITS OF HIGHLY EFFECTIVE PEOPLE =260 \\$aLONDON =260 \\$bSIMON & SCHUSTER =260 \\$c2004 =300 \\$a372 =942 \\$cBK =952 \\$aMAIN =952 \\$bMAIN =952 \\$p76772 Please correct the following: 1- Change 45e0 into 4500 in LDR tag of all records 2- In the above records, 08 tag is not according to MARC standard 3- Combine all 952 tag data under one tag like: =952 \\$aMAIN$bMAIN$p76772 Then convert it into .mrc file and import into koha I hope it will work. Thanks for using TLS (http://www.lisolutions.org/tls) Regards, Ata ur Rehman ------------------------------ Coordinator, LISolutions® info@lisolutions.org http://www.lisolutions.org Get a signature like this. <http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19> CLICK HERE.<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19> On Mon, Nov 21, 2011 at 7:41 PM, imageologist <imageologist@gmail.com>wrote:
Asalam o Alekum
Dear Mr Ata,
I'm using TLS 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<http://192.168.2.6:8000/cgi-bin/koha/tools/manage-marc-import.pl?import_batch_id=11> - Back <http://192.168.2.6:8000/cgi-bin/koha/tools/tools-home.pl>
-------------------------------------
It will be highly appreciated if anyone resolve this issue
Best regards Syed
-- -:.:IMAGEOLOGIST:.:-
participants (1)
-
Ata ur Rehman