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

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

imageologist

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

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha

LibraryData-16Nov2011-2 Text (Tab delimited).txt (69K) Download Attachment
LibraryData-16Nov2011-2.xls (260K) Download Attachment
LibraryData-16Nov2011-2.mrc (4K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

imageologist

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



--
-:.:IMAGEOLOGIST:.:-

_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha

LibraryData-16Nov2011-2.xls (260K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

imageologist
In reply to this post by imageologist

Greetings!

I'm using Koha 3.04.02, please have a look following fields for my library data-migration process 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?


Class No.-------------------------- 082$a   
Author Name--------------------- 100$a
Book Title-------------------------- 245$a
Place-------------------------------- 260$a
Publisher--------------------------- 260$b
Year---------------------------------- 260$c
Pages------------------------------- 300$a
Vol.---------------------------------- 440$n
DDC Ed.--------------------------- 082$2                       
Accession No. (Barcode)--- 952$p 
ISBN-------------------------------- 020$a 
Home Location------------------ 952$a
Holding Branch------------------ 952$b  
Item Type-------------------------- 942$c

######

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




_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Getting error on Data Migration (Excel>MarcEdit>Koha)

Adalid Ortiz
In reply to this post by imageologist
I recomend that convert groups of 1,000 records using Marcedit and import into koha using the webtool "Stage MARC Records For Import" to get more control and identify errors. Verify the info about ITEMS (tag 952 and subfields).

Saludos,


Felipe Adalid Ortiz Anzaldo
Bibliotecario de sistemas
Universidad Iberoamericana Tijuana
Biblioteca Loyola
http://clavius.tij.uia.mx
Ave. Centro Universitario 2501
Playas de Tijuana
22200, Tijuana, B.C.
0 664 630-1577 Ext. 623
[hidden email]
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Getting error on Data Migration (Excel>MarcEdit>Koha)

Ata ur Rehman
In reply to this post by imageologist
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,




On Mon, Nov 21, 2011 at 7:41 PM, imageologist <[hidden email]> 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:.:-


_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
http://lists.katipo.co.nz/mailman/listinfo/koha