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@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@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@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: bob@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