Hi Steve (and Jerwyn), You might have a look through https://gitorious.org/koha-migration-toolbox and see if there are any tools there that will help. Cheers, Liz Rea On 04/04/14 05:56, Steven Nickerson wrote:
Hi Jerwyn. Although the link I find in a Google search is now "broken" (http://contribs.koha.org/extension_view.php?eid=15) there is/was a Perl script already written that converts the MARC records exported from Athena into ones that you can simply import into Koha, without having to manipulate them in MarcEdit. The script is named "athenamarc2koha.pl" and did the 852->952 conversion for you. Maybe someone else can comment on a location that you can get the athenamarc2koha.pl script from, and if not I can probably find a copy of it from similar migrations I've done in the past.
Steve ------------------------------ Date: Sun, 30 Mar 2014 18:15:08 -0700 From: Jerwyn Fernandez <jerwyn_fernandez@southville.edu.ph> To: Bob Birchall <bob@calyx.net.au> Cc: koha list <koha@lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <CAOxu5LyHj6UL+BfmkYAduWvmVnYHeSsQyutGPTuKJXxt6PbPSA@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1"
Hi Bob,
I'll be attaching the files again.
*Any way if you still can't view the attached files I'll be pasting here the data.*
*This are the data that I exported in ATHENA:*
=LDR 00485nam 2200145 a 4500 =005 20110303132525.0 =008 100603s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d =020 \\$a81-7301--211-3 =100 \\$aMadaan, Anil =245 \\$aLearn about computers part 1. =260 \\$aNew Delhi, India :$bDreamland Pub,$c1997. =300 \\$a80 =440 \\$aDreamland's Learn About Computers =650 \\$aComputer. =852 \\$p0001$kM$h004$iM26$m1997$bMunich Library Main Collection$6Books$924950.00Php$7Lib. Fund$820100603$zAGL
=LDR 00451nam 2200121 a 4500 =005 20101103145955.0 =008 100524s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d =100 \\$aBryant-Mole, Karen =245 \\$aI'm happy. =260 \\$c1998. =650 \\$aHappy$xJuvenile literature =852 \\$p0025$kM$h155.4$iB84$m1998$bMunich Library Main Collection$6Books$7Sch. Fund$820100524$zjmls =852 \\$p3250$kM$h155.4$iB84$m1998$bMunich Library Main Collection$6Books$7Sch. Fund$820101103$zjmls
=LDR 00407nam 2200121 a 4500 =005 20110303132719.0 =008 100520s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d =100 \\$aBenito, Patricia Pe =245 \\$aLearning basic programming :$bFor elementary schools. =260 \\$bPhoenix,$c1994. =650 \\$aProgramming =650 \\$aComputer =852 \\$bMunich Library Main Collection$h005.1$iB43$m1994$p0007$zjmls$6Books$7Sch. Fund$820100520$kM
And this are the data when I edited in through MARCedit tool:
=LDR 00485nam 2200145 a 4500 =005 20110303132525.0 =008 100603s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d =020 \\$a81-7301--211-3 =050 \\$aM 004$bM26 1997 =100 \\$aMadaan, Anil =245 \\$aLearn about computers part 1. =260 \\$aNew Delhi, India :$aDreamland Pub,$c1997. =300 \\$a80 =440 \\$aDreamland's Learn About Computers =541 \\$eE0001 =650 \\$aComputer. =952 \\$pE0001$aMU$yBK$g24950.00Php$eLib. Fund$d20100603$xAGL$oM 004 M26 1997$bMU
=LDR 00451nam 2200121 a 4500 =005 20101103145955.0 =008 100524s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d =050 \\$aM 155.4$bB84 1998 B84 1998 =050 \\$aM 155.4$bB84 1998 B84 1998 =100 \\$aBryant-Mole, Karen =245 \\$aI'm happy. =260 \\$c1998. =541 \\$eE0025 =541 \\$eE3250 =650 \\$aHappy$xJuvenile literature =952 \\$pE0025$aMU$yBK$eSch. Fund$d20100524$xjmls$oM 155.4 B84 1998 M 155.4 B84 1998$bMU =952 \\$pE3250$aMU$yBK$eSch. Fund$d20101103$xjmls$oM 155.4 B84 1998 M 155.4 B84 1998$bMU
=LDR 00407nam 2200121 a 4500 =005 20110303132719.0 =008 100520s19uu\\\\xx\\\\\\\\\\\\00\\\\eng\d =050 \\$a005.1 M$bB43 1994 =100 \\$aBenito, Patricia Pe =245 \\$aLearning basic programming :$aFor elementary schools. =260 \\$aPhoenix,$c1994. =541 \\$eE0007 =650 \\$aProgramming =650 \\$aComputer =952 \\$aMU$pE0007$xjmls$yBK$eSch. Fund$d20100520$o005.1 B43 1994 M$bMU
**note that I just selected 3 records due to we have thousands of records.*
Take a look of the data that I edited; as you can see there is no problem in the 1st record. However on the 2nd and 3rd record there are problems in callnumbers take a look with the filed of 050$b and 952$o you will see the problem.
Thanks,
- Jerwyn
On Sat, Mar 29, 2014 at 5:35 PM, Bob Birchall <bob@calyx.net.au> wrote:
Hi Jerwyn, The list does not support attachments. Describe the problem verbally or provide a click-able link.
Regarding your original problem, using regular expressions to construct your 952$o is probably the best way to proceed. At least, it is what we do. The alternative is to import the data and manipulate the other sub-fields into 952$o afterwards, probably with a small script you would develop.
Best wishes, Bob Birchall Calyx
On 29/03/14 23:13, Jerwyn Fernandez wrote:
Hi Vikram,
I wonder why you can't still see the attached files.
Thank you for your respond, please see attached files.
Please let me know if you still can't view the files.
Regards,
- Jerwyn
On Sat, Mar 29, 2014 at 1:23 PM, vikram zadgaonkar < vikramczadgaonkar@gmail.com> wrote:
Hi,
No attachment in your mail . In which format do you get data out put from ATHENA? If you can send sample data to me , I can try and mail you back. BTW which koha ver you are using?
Vikram Zadgaonkar
On Fri, Mar 28, 2014 at 7:12 AM, Jerwyn Fernandez < jerwyn_fernandez@southville.edu.ph> wrote:
Good day!
We are currently migrating our system ATHENA to KOHA.
ATHENA holds data in 852 and on the other part KOHA holds data in 952.
I
used MarcEdit tool to edit the data. I was able to edit it somehow however; when I upload the data to KOHA I notice there are problems in callnumber.
ATHENA holds the data of callnumber in 852 $kPrefix $hMain $iCutter $mSuffix a
KOHA holds the data of callnumber in 952 $ofull callnumber
I do have a problem for those data that I exported in ATHENA that has *"multiple
items on a single record and to those subfileds that are not properly arranged".*
One of the attached file is the data that I exported to ATHENA, I just selected 3 records due to we have thousands of records.
And the other attached file is the data that I was able to edit please check it.
Is there anyone can help me with my problem? I heard that several libraries was successfully done this, some used regular expression and to be honest I'm not very particular with it.
Hopefully I came in to the right place to answer my query.
Thank you and best regards,
-- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Bob Birchall Director Calyx Group Pty Limited
Mob: 0414 796 988 Email: bob@calyx.net.au Web: www.calyx.net.au
Participating in the Koha Open ILS project: http://koha-community.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha