[Koha] Getting error on Data Migration (Excel>MarcEdit>Koha)

[Ata ur Rehman]

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 at 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 at 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:.:-
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111121/df7f6494/attachment-0001.html>