[Koha] ATHENA to KOHA Migration.

Jerwyn Fernandez jerwyn_fernandez at southville.edu.ph
Mon Mar 31 14:15:08 NZDT 2014 

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
>



-- 
Jerwyn G. Fernadez
Basic Education Librarian
Southville International School and Colleges

More information about the Koha mailing list