- Koha - lists.katipo.co.nz

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

re-labeling fields
by Dennis Njuguna 17 Apr '13

17 Apr '13

I need to give a new caption "label" to the field "initials" in the patrons using intranetuserjs or any other viable way kindly help -- Dennis K. Njuguna

2 1

(no subject)
by Dennis Njuguna 17 Apr '13

17 Apr '13

Thanks alot people for assistance, then my best option would be the *IntranetUserJS way*, I wonder what I'm not doing right: 1. I go to *IntranetUserJS using the administration, global system perferences * *2. then I try * $("#memberentry_contact label[for='phone']").html("my primary phone :"); but I see no change once I save and open the patrons' page is it something im missing? -- Dennis K. Njuguna

1 0

Zebra update not picking New records
by amutsikiwa 17 Apr '13

17 Apr '13

Hi All I have a problem with my zebra update. It is not picking new bib records and new biblioitems. When I add a new title record and then run command /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -a -z -v Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 Records exported: 0 ==================== REINDEXING zebra ==================== ==================== exporting biblio ==================== Records exported: 0 Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING Regards, Admire

1 0