Hi Steve (and Jerwyn), You might have a look through https://gitorious.org/koha-migration-toolbox and see if there are any tools there that will help.
Cheers, Liz Rea On 04/04/14 05:56, Steven Nickerson wrote: > 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 <[email protected]> > To: Bob Birchall <[email protected]> > Cc: koha list <[email protected]> > 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 <[email protected]> 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 < >>> [email protected]> 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 < >>>> [email protected]> 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 >>>>> [email protected] >>>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>>>> >>>>> >>>>> >>> >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> [email protected] >>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> >> -- >> Bob Birchall >> Director >> Calyx Group Pty Limited >> >> Mob: 0414 796 988 >> Email: [email protected] >> Web: www.calyx.net.au >> >> Participating in the Koha Open ILS project: >> http://koha-community.org >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
