[Koha] ATHENA to KOHA Migration.
Steven Nickerson
snicker1 at maine.rr.com
Fri Apr 4 05:56:06 NZDT 2014
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
>
--
Jerwyn G. Fernadez
Basic Education Librarian
Southville International School and Colleges
------------------------------
Message: 3
Date: Sun, 30 Mar 2014 22:43:02 -0300
From: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
To: Jerwyn Fernandez <jerwyn_fernandez at southville.edu.ph>
Cc: koha list <koha at lists.katipo.co.nz>
Subject: Re: [Koha] ATHENA to KOHA Migration.
Message-ID:
<CADF4kvRTQHw3atxpzgoe6RgxUiYi16_Yceq2SF=Ro0nf5UJw7g at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
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
>
>
------------------------------
Message: 4
Date: Sun, 30 Mar 2014 18:54:04 -0700
From: Jerwyn Fernandez <jerwyn_fernandez at southville.edu.ph>
To: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
Cc: koha list <koha at lists.katipo.co.nz>
Subject: Re: [Koha] ATHENA to KOHA Migration.
Message-ID:
<CAOxu5LwLkHKhWbDTt4MC2Mpcok0ye_NzqTe3W_iGwBugVPUA5Q at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
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
------------------------------
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 101, Issue 62
*************************************
More information about the Koha
mailing list