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
