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. CLICK HERE.  



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
  • Back
-------------------------------------

It will be highly appreciated if anyone resolve this issue

Best regards
Syed


--
-:.:IMAGEOLOGIST:.:-