[Koha] ATHENA to KOHA Migration.

Mon Mar 31 14:43:02 NZDT 2014

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
>
>