[Koha] ATHENA to KOHA Migration.

Mon Mar 31 14:54:04 NZDT 2014

Hi Bob,

Yes that's my problem, if there 2 items what more if there are 10 items.

And the other problem is I am not familiar with Notepad++ or Perl.

- Jerwyn

On Sun, Mar 30, 2014 at 6:43 PM, Bernardo Gonzalez Kriegel <
bgkriegel at gmail.com> wrote:

> Jerwyn,
> your example shows a duplicated callnumber when you have 2 items
>
> It's multiplied by the number of items when you have more than 2?
>
> If not, it have always the same structure (4 strings).
> In that case a clever search and replace using Notepad++ could help you
> (or Perl)
>
> Regards,
> Bernardo
>
>
>
>
> --
> Bernardo Gonzalez Kriegel
> bgkriegel at gmail.com
>
>
> On Sun, Mar 30, 2014 at 10:15 PM, Jerwyn Fernandez <
> jerwyn_fernandez at southville.edu.ph> wrote:
>
>> 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
>>
>> _______________________________________________
>> 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