- Koha - lists.katipo.co.nz

Re: [Koha] search problem in koha 3.10.4
by Peter Zhao 20 Apr '13

20 Apr '13

Hi, Greetings. sudo gedit /etc/cron.d/koha # The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set when this process runs as a user (koha). */5 * * * * koha $KOHA_PATH/bin/migration_tools/rebuild_zebra.pl -b -a -z &> /dev/null This file needs put "koha" (user) in it. Try it. And change KOHA_PATH with your actual directory would be better. Peter Zhao At 2013-04-18 08:00:02,koha-request@lists.katipo.co.nz wrote: >Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > >To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha >or, via email, send a message with subject or body 'help' to > koha-request(a)lists.katipo.co.nz > >You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of Koha digest..." > > >Today's Topics: > > 1. Re: search problem in koha 3.10.4 (Mark Tompsett) > 2. Re: search problem in koha 3.10.4 (Bernardo Gonzalez Kriegel) > 3. Help With Preferences & Manual (Nicole Engard) > 4. Re: search problem in koha 3.10.4 (Paul) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Wed, 17 Apr 2013 07:42:21 -0400 >From: "Mark Tompsett" <mtompset(a)hotmail.com> >To: "Mohamed Megahed" <mr_megahed(a)hotmail.com> >Cc: koha(a)lists.katipo.co.nz >Subject: Re: [Koha] search problem in koha 3.10.4 >Message-ID: <BLU172-DS24BCBDC6636BFD919F02FCC6CE0(a)phx.gbl> >Content-Type: text/plain; format=flowed; charset="iso-8859-1"; > reply-type=original > >Greetings, > >This is clearly a development install, otherwise you wouldn't have touched >the cron jobs at all. >I am assuming you followed >http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_git >which is not intended for a production system, but rather a development >system. > >So my first suggestion is to follow >http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages >instead. It does a good job of hiding complexities from the user. Including >a whole set of nice commands: >http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages > >However, I could be wrong and you actually are trying to join the bug patch >submitting side of things. >In which case: > >--- BEGIN Your example --- ># The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set >when $ >*/1 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z &> >/d$ >--- END Your example --- > >--- BEGIN actual --- ># The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set >when this process runs. >*/5 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z &> >/dev/null >--- END actual --- > >I think you may have a problem using "/d$". Also, after your install did you >run a full reindex? > /home/{user name}/{koha >directory}/misc/migration_tools/rebuild_zebra.pl -b -a -r -v >Where {user name} and {koha directory} are your user name and most likely >"kohaclone"? > >And to finish off, the most likely cause of everything: > $ sudo service koha-zebra-daemon start >It doesn't start automatically on reboot for me, so this may be your problem >too. I've been meaning to improve the instructions that way. You can confirm >it is running with: > $ ps aux | grep zebra >You should see more than just your grep line. > >GPML, >Mark Tompsett > > > >------------------------------ > >Message: 2 >Date: Wed, 17 Apr 2013 12:23:01 -0300 >From: Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> >To: Mark Tompsett <mtompset(a)hotmail.com> >Cc: koha <koha(a)lists.katipo.co.nz>, Mohamed Megahed > <mr_megahed(a)hotmail.com> >Subject: Re: [Koha] search problem in koha 3.10.4 >Message-ID: > <CADF4kvR-tVkghK2pjf=pd8FOhkESg8XWr1Cca43-3G2oH_Qn4A(a)mail.gmail.com> >Content-Type: text/plain; charset=UTF-8 > >On Wed, Apr 17, 2013 at 8:42 AM, Mark Tompsett <mtompset(a)hotmail.com> wrote: > >> Greetings, >> >> This is clearly a development install, otherwise you wouldn't have touched >> the cron jobs at all. >> > >Mark, >why you always suppose that everybody do packages installs? > >In my opinion most of current installs were done using tar.gz > >So the question of how to correctly setup cron jobs is a valid one. > >Regards, >Bernardo > > >------------------------------ > >Message: 3 >Date: Wed, 17 Apr 2013 15:26:25 -0400 >From: Nicole Engard <nengard(a)gmail.com> >To: Koha <Koha(a)lists.katipo.co.nz> >Subject: [Koha] Help With Preferences & Manual >Message-ID: > <CAC0K6VEqgK-mOJkDMB95YDxLn+Y0iUHUYgBkKt_VSN_=DpMxDA(a)mail.gmail.com> >Content-Type: text/plain; charset=UTF-8 > >Hi all, > >I got this question today and I realized that the manual is not clear and >now I am second guessing myself - can someone help me out with updating the >manual and answering this question? > >----- > > >What we want to have happen is that if an item is returned to the checkout >library (which is not the owning library for the item) then we want the >checkout library to be able to fill a hold on that item by a patron of the >checkout library without having to send the item back to the owning >library, have the owning library ship it back and then check it out to the >patron with the hold. That seems to be what the description in Section >1.1.5.2.11 of the manual ( >http://manual.koha-community.org/3.10/en/administration.html#HomeOrHoldingB…) >is describing. However the manual states that this setting "Asks: Use the >checkout and fine rules of_____" and That does not seem to make sense in >relation to the description. > >Since there is such a caution against changing this setting after the >initial setup, we want to get it right. > >Also, I believe that we concluded during training that we would have the >IndependentBranches preferences set to prevent so this setting would apply. >However I am now confused about the IndependentBranches settings which I >thought only applied to what staff can do. When I get to the part of the >description in section .1.2.3.2 of the manual ( >http://manual.koha-community.org/3.10/en/administration.html#IndependantBra…) >that says Prevent will, "preventing users from other branch locations from >placing holds or checking out materials from library branches other than >their own" I am left wondering if this will stop all holds by patrons of >one library from placing holds on items for other libraries. Or is it just >that staff of one library cannot place a hold on another libraries items.... > > >------------------------------ > >Message: 4 >Date: Wed, 17 Apr 2013 10:02:41 -0400 >From: Paul <paul.(a)aandc.org> >To: Karam Qubsi <karamqubsi(a)gmail.com>, Mohamed Megahed > <mr_megahed(a)hotmail.com> >Cc: koha staff <koha(a)lists.katipo.co.nz> >Subject: Re: [Koha] search problem in koha 3.10.4 >Message-ID: <5.2.1.1.2.20130417094506.058c7678@localhost> >Content-Type: text/plain; charset="us-ascii"; format=flowed > >At 04:25 PM 4/17/2013 +0300, Karam Qubsi wrote: >>Hi Mohamed , >>try to rebuild your zebra index manually . >>cd $KOHA_PATH/misc/migration_tools/ >>then : >>perl rebuild_zebra.pl -b -a -z > >Unless 3.10 has changed radically from 3.8, an incremental -z might not be >sufficient. > >As user koha (or whichever user has the rights): > >koha:/$ cd /usr/share/koha >koha:/usr/share/koha$ ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x >koha:/usr/share/koha$ ./bin/migration_tools/rebuild_zebra.pl -a -r -v > >Maybe the path has changed from /usr/share/koha/bin to ?/?/?/misc? Please >adjust accordingly. > >We run this every 15 minutes while our cataloguers are working, otherwise >duplicate/unwanted biblios creep in and can get very confusing for non-techies. > >Best - Paul > > > > > > >>On Wed, Apr 17, 2013 at 10:36 AM, Mohamed Megahed >><mr_megahed(a)hotmail.com>wrote: >> >> > Hi all >> > I have installed koha 3.10.4 on ubuntu 12.04 and all ok. but i have faced >> > problem search record, after cataloging record, try to search it ... no >> > result i use zebra indexing and cronjob. >> > in crontab i had add this lines >> > >> > # The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set >> > when $ >> > */1 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z >> > &> /d$ >> > >> > after that no result in search both biblio and authority. >> > >> > any sugg. >> > thnks >> > >> > >> > MOHAMED MEGAHED Chief Library at Ahram Canadian University >> > Tel : +2 0100 22 97 96 2 >> > Tel : +2 011 23 502 505 >> > >> > >> > >> > >> > _______________________________________________ >> > Koha mailing list http://koha-community.org >> > Koha(a)lists.katipo.co.nz >> > http://lists.katipo.co.nz/mailman/listinfo/koha >> > >> >> >> >>-- >>*Karam Qubsi* >>_______________________________________________ >>Koha mailing list http://koha-community.org >>Koha(a)lists.katipo.co.nz >>http://lists.katipo.co.nz/mailman/listinfo/koha > >--- >Maritime heritage and history, preservation and conservation, >research and education through the written word and the arts. ><http://NavalMarineArchive.com> and <http://UltraMarine.ca> > > > >------------------------------ > >_______________________________________________ >Koha mailing list >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha > > >End of Koha Digest, Vol 90, Issue 25 >************************************

2 1

Making a list from Reading History
by Marie Wardall 19 Apr '13

19 Apr '13

Just wondering if you can make a saved Public or Private list from your Reading history easily. I have a few teachers who have checked out a number of books over the year and would like to use their reading history to create saved lists to use next year. We are using Koha version 3.6 TIA Marie Marie J. Wardall Library Media Specialist Weston Elementary School 5200 Camp Phillips Rd. Schofield, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-359-4181 ext. 5624 Change Today, Change Tomorrow, Keep Changing

2 1

Need some SQL help
by Doug Dearden 19 Apr '13

19 Apr '13

Hello all, I find myself once again confounded by an SQL problem. I am trying to extract the value from field 245, ind2 . I have used a variety of select statements without success, i.e. SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"][ind2]') as "SkipArticle" or SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="ind2"]') as "SkipArticle" Those are two of the variations I have tried. There are probably another 20 along the way. When I look at the marcxml field I see that ind1 and ind2 are on the same line as the 245 identifier, and not in a subfield line. For instance: <datafield tag="245" ind1="1" ind2="0"> <subfield code="a">Biology unmoored :</subfield> <subfield code="b">Melanesian reflections on life and biotechnology /</subfield> A number of my attempts have not returned a syntax error, they just never return a value. So what would the SQL/Xpath syntax be to get the info out of ind2 ? Thanks in advance for your help, Doug Dearden Director, IT School for Advanced Research (505)954-7220 sarweb.org

2 2

KohaCon 13 IRC Planning Meeting for April Announcement and Agenda
by Keener, Nancy 19 Apr '13

19 Apr '13

Hello everyone, please join us next week. KohaCon 13 IRC planning meeting April 23rd 21 UTC. Find your time here: http://www.timeanddate.com/worldclock/fixedtime.html?msg=KohaCon+13+IRC+Pla… Join the IRC for KohaCon13 Planning here: http://koha-community.org/get-involved/irc Agenda: * Registration and program update. * Programs group needs to meet. * Opening speaker. * Mistress of Ceremonies ..... Megan Conelly * Donations and Sponsorships. * Road Trip. * Vendor requests. * What have we forgotten? Hey, it's all coming together! Nancy Keener Systems Librarian I.T.O.S.C. Chair KohaCon 13 Chair Washoe County Library System Reno, Nevada 775 327-8347 nkeener(a)washoecounty.us

1 0

Mysql query
by Paul 18 Apr '13

18 Apr '13

I'm looking, please, for some expertise in writing MySQL queries (Koha "reports".) I have a good "report" for listing high value items in our collections (a requirement for our insurers), but need to add the "special case" of multi volume biblios. Example: a set of Britannicas (14th ed.) is a single biblio with 24 "items" at $25 each for a total of $600, above our declared insurance threshold (we price items individually to cover incomplete sets.) Question: How can I "SUM" all items under a single biblio in a manner that will allow inclusion on the "HAVING" line below? SELECT items.price,biblio.author,biblio.title,ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS subtitle FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) HAVING items.price >= <<Value more than>> ORDER BY items.price DESC; I *suspect* it's something along the lines of: SET @price1=0; SELECT items.price, (@price1:=SUM(items.price)) as FullValue, @price1 as returned_val but cannot get this to function properly (it returns the value of the whole catalogue) -- the following: SET @price1=0; SELECT items.price, (@price1:=SUM(items.price)) as FullValue, @price1 as returned_val, biblio.author,biblio.title,ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS subtitle FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) HAVING FullValue >= 500 ORDER BY FullValue DESC; does *not* even save in Koha (Error 1 "see logs", but I can't find anything - suspect it's the ; on line 1.) But on the command line, it runs without syntactical error, but lists only biblionumber=1 and the total value of everything we have ever catalogued ;={ Maybe it's not possible and a Perl script is required? Many thanks for any suggestions. Paul

2 1

planning categories in acquisitions
by Henry Rowsell 18 Apr '13

18 Apr '13

Hi Koha Community First time on here, but hope you can help out. I'm an acquisitions librarian wanting to make best use of the statistical options available in the Acquisitions module for tracking spending, but I am unable to fully understand from the example in the documentation how to make this work. I'd like some advice on using the statistics 1 and 2 fields (also referred to as planning values or planning categories) on the order form within Acquisitions. When I have tried to set values for these when creating or editing a fund, it presents various other values available to other admin functions in Koha, but cannot then see such values when back on the order form. How (and where in the system) can one set these values or add more variables? and then how does one use them for reporting? What I am hoping is that I can set values such as the names of courses or groups at my institute that I could apply as an extra level of statistical detail to funds or sub-funds within my acquisitions budgets. We are currently using version 3.06.02.003. Many thanks! Henry Henry Rowsell Acquisitions Librarian BLDS (British Library for Development Studies) Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel. +44 (0)1273 915661 email: h.rowsell(a)ids.ac.uk website: www.blds.ids.ac.uk BLDS is funded by DFID (through the Mobilising Knowledge for Development Programme) and IDS. Join our Publications Exchange programme, to have your material made available in BLDS, and to receive the IDS Bulletin in return! If your organisation produces publications that could be supplied to us on this exchange basis, please email k.butcher(a)ids.ac.uk. We particularly welcome requests from developing country organizations. This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914

1 0

Help With Preferences & Manual
by Nicole Engard 17 Apr '13

17 Apr '13

Hi all, I got this question today and I realized that the manual is not clear and now I am second guessing myself - can someone help me out with updating the manual and answering this question? ----- What we want to have happen is that if an item is returned to the checkout library (which is not the owning library for the item) then we want the checkout library to be able to fill a hold on that item by a patron of the checkout library without having to send the item back to the owning library, have the owning library ship it back and then check it out to the patron with the hold. That seems to be what the description in Section 1.1.5.2.11 of the manual ( http://manual.koha-community.org/3.10/en/administration.html#HomeOrHoldingB…) is describing. However the manual states that this setting "Asks: Use the checkout and fine rules of_____" and That does not seem to make sense in relation to the description. Since there is such a caution against changing this setting after the initial setup, we want to get it right. Also, I believe that we concluded during training that we would have the IndependentBranches preferences set to prevent so this setting would apply. However I am now confused about the IndependentBranches settings which I thought only applied to what staff can do. When I get to the part of the description in section .1.2.3.2 of the manual ( http://manual.koha-community.org/3.10/en/administration.html#IndependantBra…) that says Prevent will, "preventing users from other branch locations from placing holds or checking out materials from library branches other than their own" I am left wondering if this will stop all holds by patrons of one library from placing holds on items for other libraries. Or is it just that staff of one library cannot place a hold on another libraries items....

1 0

search problem in koha 3.10.4
by Mohamed Megahed 17 Apr '13

17 Apr '13

Hi all I have installed koha 3.10.4 on ubuntu 12.04 and all ok. but i have faced problem search record, after cataloging record, try to search it ... no result i use zebra indexing and cronjob. in crontab i had add this lines # The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set when $ */1 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z &> /d$ after that no result in search both biblio and authority. any sugg. thnks MOHAMED MEGAHED Chief Library at Ahram Canadian University Tel : +2 0100 22 97 96 2 Tel : +2 011 23 502 505

4 3

Re: [Koha] search problem in koha 3.10.4
by Paul 17 Apr '13

17 Apr '13

At 04:25 PM 4/17/2013 +0300, Karam Qubsi wrote: >Hi Mohamed , >try to rebuild your zebra index manually . >cd $KOHA_PATH/misc/migration_tools/ >then : >perl rebuild_zebra.pl -b -a -z Unless 3.10 has changed radically from 3.8, an incremental -z might not be sufficient. As user koha (or whichever user has the rights): koha:/$ cd /usr/share/koha koha:/usr/share/koha$ ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x koha:/usr/share/koha$ ./bin/migration_tools/rebuild_zebra.pl -a -r -v Maybe the path has changed from /usr/share/koha/bin to ?/?/?/misc? Please adjust accordingly. We run this every 15 minutes while our cataloguers are working, otherwise duplicate/unwanted biblios creep in and can get very confusing for non-techies. Best - Paul >On Wed, Apr 17, 2013 at 10:36 AM, Mohamed Megahed ><mr_megahed(a)hotmail.com>wrote: > > > Hi all > > I have installed koha 3.10.4 on ubuntu 12.04 and all ok. but i have faced > > problem search record, after cataloging record, try to search it ... no > > result i use zebra indexing and cronjob. > > in crontab i had add this lines > > > > # The cronjobs -- $KOHA_PATH is defined in /etc/environment, and gets set > > when $ > > */1 * * * * $KOHA_PATH/misc/migration_tools/rebuild_zebra.pl -b -a -z > > &> /d$ > > > > after that no result in search both biblio and authority. > > > > any sugg. > > thnks > > > > > > MOHAMED MEGAHED Chief Library at Ahram Canadian University > > Tel : +2 0100 22 97 96 2 > > Tel : +2 011 23 502 505 > > > > > > > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > >-- >*Karam Qubsi* >_______________________________________________ >Koha mailing list http://koha-community.org >Koha(a)lists.katipo.co.nz >http://lists.katipo.co.nz/mailman/listinfo/koha --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

1 0

queries in koha
by Dennis Njuguna 17 Apr '13

17 Apr '13

Hi all I need some help here, Im am supposed to link koha and the main financial system of our school, i.e patrons who are students I need to either rename a field in koha called Admission Number and have it mandatory, I was thinking of using the field "Sort1" or "Initials" and have it mandatory like field "Surname" or "Zip/Postal" I have renamed it in mysql but its not renamed in koha. is this even possible in the first place? -- Dennis K. Njuguna

3 6