[Koha] ATHENA to KOHA Migration.

Liz Rea liz at catalyst.net.nz
Fri Apr 4 09:37:34 NZDT 2014


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 at southville.edu.ph>
> To: Bob Birchall <bob at calyx.net.au>
> Cc: koha list <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] ATHENA to KOHA Migration.
> Message-ID:
> 	<CAOxu5LyHj6UL+BfmkYAduWvmVnYHeSsQyutGPTuKJXxt6PbPSA at 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 at 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 at 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 at 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 at lists.katipo.co.nz
>>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>
>>>>>
>>>>>
>>>
>>> _______________________________________________
>>> Koha mailing list  http://koha-community.org
>>> Koha at 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 at 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 at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>



More information about the Koha mailing list