- Koha - lists.katipo.co.nz

Message preference issue
by vikram zadgaonkar 05 Apr '14

05 Apr '14

Hi, I am facing problem in default Patron messaging preferences. I am attaching following screen shots: Option 1 is which I am getting and option 2 is what I want. Vikram Zadgaonkar

1 0

Re: [Koha] How to clean Koha imported records?
by Arslan Farooq 05 Apr '14

05 Apr '14

Hi Layale, [...] > On another hand, I read in the wiki that I need to truncate the following tables: > * bibio > * biblioitems > * items > * auth_header > * sessions > * zebraqueue As a help to truncate these table, you may use phpMyAdmin. And this may be of help too: http://stackoverflow.com/questions/8641703/how-do-i-truncate-tables-properl… Arslan

1 0

Making Koha a Z39.50 server
by sheldon_tappin 04 Apr '14

04 Apr '14

Hi All, I am trying to make my Koha installation act as a Z39.50 server. We are currently using version 3.12.11.000. Based on a tutorial I followed, I uncommented the following lines: 1. *<listen id="publicserver" >tcp:@:68</listen> * I used 68 as my port 2. <server id="publicserver" listenref="publicserver"> to <serverinfo id="publicserver"> <ccl2rpn>/etc/koha/zebradb/ccl.properties</ccl2rpn> <user></user> <password></password> </serverinfo> 3. I removed the default username and password that was there for the public server then, I saved the file. I checked to see if the zebra process was running, all indications showed that it is active. To test the server I added a Z39.50 target using the following parameters but it didn't work: Target: LOCAL Hostname/Port: 127.0.0.1:68 Database: biblios Userid: Password: Checked: Yes Rank: 0 Syntax: USMARC Encoding: MARC-8 Timeout: 0 *Please inform me on what I am doing wrong so that I can correct the issue.* Best Regards, Sheldon Tappin /University of Guyana Library/ -- View this message in context: http://koha.1045719.n5.nabble.com/Making-Koha-a-Z39-50-server-tp5793133.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Merging duplicate authorities - line missing
by Chitralekha 04 Apr '14

04 Apr '14

I am using 3.14.00.000 Koha version. While trying to merge duplicate authority entries as per 3.14 manual I encountered that one line is missing in output. When I searched for the term "Highway Engineering" the result was -- Authority search results Results 1 to 3 of 3 As per manual there should be one line between above two lines giving options of cancel and merge i.e. -- Authority search results Merging with authority: Highway Engineering (205) Cancel merge Results 1 to 3 of 3 Please fix this. Chitralekha M. Chitale -- View this message in context: http://koha.1045719.n5.nabble.com/Merging-duplicate-authorities-line-missin… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Basket Number(Acquisition Module)
by Madhura Deodhar IES Library 04 Apr '14

04 Apr '14

Dear All, Basket numbers are generated automatically by the system. Since we are using acquisition module and generating Purchase orders from 3 years; It becomes difficult for us to sort out them according to particular year. Therefore, If I want to set the Basket number for new financial year, what i supposed to do? Thanking you in anticipation. -- *Regards,* *Madhura M.Deodhar* *Librarian*IES Management College and Research Centre VMD Lotlikar Vidya Sankul Opp.Lilavati Hospital, Bandra Reclamation Bandra (West) Mumbai - 50 61378327(direct) 9869385665/9167004647 http://iesmglib.blogspot.com *P **Please consider the environment before printing this e-mail.*

1 0

patron alphabetical list
by Sandeep Bhavsar 04 Apr '14

04 Apr '14

Respected All I am using koha 3.14.04.000 , and having two categories of patron Staff and Student. In patrons option 'browse by last name' only staff category data is visible and we want the data of student also. Please guide. -- *Regards * *Sandeep Bhavsar* B.com, M.Lib.I.Sc SET, M.Phil, American Library Association - FERA 2011 fellow Librarian Dr. V N Bedekar Institute of Management Studies Thane (W) 400601 Mumbai INDIA Mobile : 9987049099 www.vpmthane.org

1 0

Where to put item information
by Darla Grediagin 04 Apr '14

04 Apr '14

Good morning, I have just gotten a new install of koha 3.0 Everything was going great until I went to look at the Koha Field for Items. Instead of being mapped to 952, every item is mapped to 995. I have tried to edit these to 952, but I couldn't do this. I can edit my Marc records so the information matches being on the 995 fields, but I wasn't sure if this would make a difference to having it in 952. I am using MARC21 as the flavor of MARC. Any suggestions would be appreciated. Darla -- Darla Grediagin District Librarian Bering Strait School District Unalakleet, Alaska Web Address :http://bssdonline.org/course/view.php?id=51 Blog:http://aklibrarian1.edublogs.org/ OPAC:http://opac.bssd.org:8181/cgi-bin/koha/opac-search.pl

4 4

SIP2 to koha 3.14.05.000
by Pankaj 04 Apr '14

04 Apr '14

I want to integrate koha 3.14.05.000 to RFID tool using SIP2 protocols .How can installed SIP2 server on Ubuntu please give me suggestion . -- *Thanks & Regards PANKAJ KUMAR MAURYAGreat Eastern Impex Pvt. Ltd.Plot no. : 285, Udyog Vihar,Phase - II, Gurgaon - 122016(HARYANA), IndiaPhone No. : +91-124-2347431, 2347432Fax No. : +91-124-2348432Vodafone No. : 9953938077Toll Free :-18002004015Visit us at www.geipl.com <http://www.geipl.com> An ISO 9001:2008 Certified Company*

2 1

Framework Question
by Nicole Engard 04 Apr '14

04 Apr '14

If I delete a framework that is being used what will happen if I go to edit one of those bib records? Will it just use Default? Nicole

3 2

Re: [Koha] ATHENA to KOHA Migration.
by Steven Nickerson 03 Apr '14

03 Apr '14

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_fernandez(a)southville.edu.ph> To: Bob Birchall <bob(a)calyx.net.au> Cc: koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <CAOxu5LyHj6UL+BfmkYAduWvmVnYHeSsQyutGPTuKJXxt6PbPSA(a)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 <bob(a)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(a)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(a)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(a)lists.katipo.co.nz >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>>> >>>> >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)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(a)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(a)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 <bgkriegel(a)gmail.com> To: Jerwyn Fernandez <jerwyn_fernandez(a)southville.edu.ph> Cc: koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <CADF4kvRTQHw3atxpzgoe6RgxUiYi16_Yceq2SF=Ro0nf5UJw7g(a)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 bgkriegel(a)gmail.com On Sun, Mar 30, 2014 at 10:15 PM, Jerwyn Fernandez < jerwyn_fernandez(a)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 <bob(a)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(a)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(a)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(a)lists.katipo.co.nz > >>>> http://lists.katipo.co.nz/mailman/listinfo/koha > >>>> > >>>> > >>>> > >> > >> > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha(a)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(a)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(a)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(a)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_fernandez(a)southville.edu.ph> To: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> Cc: koha list <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] ATHENA to KOHA Migration. Message-ID: <CAOxu5LwLkHKhWbDTt4MC2Mpcok0ye_NzqTe3W_iGwBugVPUA5Q(a)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 < bgkriegel(a)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 > bgkriegel(a)gmail.com > > > On Sun, Mar 30, 2014 at 10:15 PM, Jerwyn Fernandez < > jerwyn_fernandez(a)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 <bob(a)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(a)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(a)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(a)lists.katipo.co.nz >> >>>> http://lists.katipo.co.nz/mailman/listinfo/koha >> >>>> >> >>>> >> >>>> >> >> >> >> >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha(a)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(a)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(a)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(a)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(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 101, Issue 62 *************************************

2 1