[Koha] Export/Import question from Alice 5.0

[Richard Eibrand]

Hi Seth,

Many thanks for your email. I spent some time at this yesterday and figured out what the problem was.

Even though I was choosing marc21 as the import character encoding on the Stage marc for input, it was not until I set marc21 in the system preferences  that the records were being imported with the correct field mappings.

Thanks for your suggestions all the same.

Regards,

Richard

From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Seth Mayo
Sent: 22 March 2011 03:49
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Export/Import question from Alice 5.0

Sounds like the MARCEdit changes to field haven't aligned with Koha fields correctly.  When we changed from Alice to Koha, many fields needed to be re-mapped in MARC prior to import because Alice uses a completely different MARC tag structure for various areas.  It is a mix of standard and non-standard.

Seth Mayo
IT Technical Manager
Email:  smayo at stpeters.nsw.edu.au<mailto:smayo at stpeters.nsw.edu.au>
-------------------------------------------------------
St Peter's Anglican Primary School
Howe Street
Campbelltown NSW 2560
PH: 02 4627 2990
DID:  02 8203 1368
Website:  http://www.stpeters.nsw.edu.au



On 22 March 2011 05:25, Richard Eibrand <RichardEibrand at rcpi.ie<mailto:RichardEibrand at rcpi.ie>> wrote:
Hi there,

We are looking to moving from Alice 5.0 to Koha. To that end, I have been playing around with getting our data exported from Alice and imported into Koha.

The guts of the problem are this:
-  After exporting a MARC variant file from Alice, and importing it into Alice, the MAIN ENTRY--PERSONAL NAME field is populated with what appears to be todays date, with frey 50 after it, e.g. Personal name    20110321 frey50 - instead of Personal name Koha_author as it was entered in Alice.
- I used MARCedit to have a look at my export files, and this is what I am getting:

=LDR  00354nam  22001451a 4500
=020  \\$c0.00
=040  \\$aRoyal College of Physicians of Ireland
=082  \\$bKOH
=100  \\$aKoha_Author
=245  \\$aKoha_Title$h[Text]
=250  \\$aKoha_Edition
=260  \\$bKoha_Publisher$cKoha_Year
=300  \\$aKoha_Physical Description
=500  \\$aKoha_Notes
=600  \\$aKoha_Subject

But this is what I am getting back once the import has completed and the index re-indexed, which is all correct except for the MAIN ENTRY LINE

000 -LEADER
  fixed length control field    00404nam a22001571a 4500
INTERNATIONAL STANDARD BOOK NUMBER
  Terms of availability    0.00
CATALOGING SOURCE
  Original cataloging agency    Royal College of Physicians of Ireland
DEWEY DECIMAL CLASSIFICATION NUMBER
  Item number    KOH
MAIN ENTRY--PERSONAL NAME
  Personal name    20110321 frey50
TITLE STATEMENT
  Title    Koha_Title
  Medium    [Text]
EDITION STATEMENT
  Edition statement    Koha_Edition
PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
  Name of publisher, distributor, etc    Koha_Publisher
  Date of publication, distribution, etc    Koha_Year
PHYSICAL DESCRIPTION
  Extent    Koha_Physical Description
GENERAL NOTE
  General note    Koha_Notes

I have tried with all the export formats available to me, namely, 02USMARC, 04USMARC with Copy information and 50 USMARC (Containing TLC Compulsory tags) from Alice.
I have also imported them as both UNIMARC or MARC21 - but to no avail.

Would anyone have any suggestions?

Many thanks,

Richard

------------------------------------------------------------
Richard Eibrand
ICT Manager
Royal College of Physicians of Ireland
Frederick House
19 South Frederick Street<x-apple-data-detectors://4>
Dublin<x-apple-data-detectors://4> 2
Telephone:01- 8639700<tel:01-%208639700>
Fax:01-6724707<tel:01-6724707>
_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
http://lists.katipo.co.nz/mailman/listinfo/koha

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110323/1aaf15c0/attachment.htm