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 http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha