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_fernan...@southville.edu.ph> To: Bob Birchall <b...@calyx.net.au> Cc: koha list <koha@lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <caoxu5lyhj6ul+bfmkyaduwvmvnyhessqyutgptukjxxt6pb...@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 <b...@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 < >> vikramczadgaon...@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_fernan...@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@lists.katipo.co.nz >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>>> >>>> >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > -- > Bob Birchall > Director > Calyx Group Pty Limited > > Mob: 0414 796 988 > Email: b...@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@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 <bgkrie...@gmail.com> To: Jerwyn Fernandez <jerwyn_fernan...@southville.edu.ph> Cc: koha list <koha@lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <CADF4kvRTQHw3atxpzgoe6RgxUiYi16_Yceq2SF=ro0nf5uj...@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 bgkrie...@gmail.com On Sun, Mar 30, 2014 at 10:15 PM, Jerwyn Fernandez < jerwyn_fernan...@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 <b...@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 < > >> vikramczadgaon...@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_fernan...@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@lists.katipo.co.nz > >>>> http://lists.katipo.co.nz/mailman/listinfo/koha > >>>> > >>>> > >>>> > >> > >> > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha@lists.katipo.co.nz > >> http://lists.katipo.co.nz/mailman/listinfo/koha > >> > > > > -- > > Bob Birchall > > Director > > Calyx Group Pty Limited > > > > Mob: 0414 796 988 > > Email: b...@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@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@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_fernan...@southville.edu.ph> To: Bernardo Gonzalez Kriegel <bgkrie...@gmail.com> Cc: koha list <koha@lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <caoxu5lwlkhkhwbdtt4mc2mpcok0ye_nzqte3w_igwbugvpu...@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 < bgkrie...@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 > bgkrie...@gmail.com > > > On Sun, Mar 30, 2014 at 10:15 PM, Jerwyn Fernandez < > jerwyn_fernan...@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 <b...@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 < >> >> vikramczadgaon...@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_fernan...@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@lists.katipo.co.nz >> >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >>>> >> >>>> >> >>>> >> >> >> >> >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha@lists.katipo.co.nz >> >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > >> > -- >> > Bob Birchall >> > Director >> > Calyx Group Pty Limited >> > >> > Mob: 0414 796 988 >> > Email: b...@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@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 101, Issue 62 ************************************* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha