- Koha - lists.katipo.co.nz

SQL report help
by Kerrie Stevens 10 Mar '16

10 Mar '16

I'm trying to get a report to show the number of items in each collection code according to the branch selected. I've looked in the reports library but can't find anything that is exactly right. I've tried to mix'n'match bits from a few reports but I keep getting an error message about syntax. This is what I have so far: SELECT items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title, biblio.copyrightdate COUNT( i.barcode ) AS "Count" FROM items LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.dateaccessioned DESC Any help, much appreciated. Thank you Kerrie Harvest Bible College

2 1

Koha 3.18 Manual in Chinese has been translated completely
by Anthony Mao 10 Mar '16

10 Mar '16

Hi all, It is my honor to announce that Koha 3.18 Manual in Chinese has been translated completely. http://translate.koha-community.org/manual/3.18/zh-TW/ Could web master help add a link on https://koha-community.org/documentation/, looks like Koha 3.18 ·3.18 Manual (English) [PDF] ·3.18 Manual (Chinese[Taiwan]) [PDF] Thanks for your attentation! Anthony Mao

4 5

Help in koha 3.22.04
by Arshad Iqbal 09 Mar '16

09 Mar '16

Hi On the 3rd step of koha web installer i am facing this error please help me. Can't use an undefined value as an ARRAY reference at /usr/lib/i386-linux-gnu/perl5/5.20/DBI.pm line 2064. Muhammad Arshad Iqbal

2 1

UK Further Education college exploring Koha
by Colin Sawers 09 Mar '16

09 Mar '16

Hi I have just joined this list we are a UK Further Education college currently exploring whether Koha would be a viable option for us. If there are any other FE colleges in the UK on the list I would be particularly to interested to hear from you, especially if you have migrated from Heritage to Koha. Thanks for your help. Best Regards Colin Colin Sawers BA(Hons) MCLIP MInstLM Team Leader: Learning Resources Vision West Nottinghamshire College Derby Road, Mansfield, Nottinghamshire, NG18 5BH T: +44 1623 627191 ex 8417 F: +44 1623 623063 M: +44 7816 585924 E: colin.sawers(a)wnc.ac.uk<mailto:colin.sawers@wnc.ac.uk> Web: www.wnc.ac.uk<http://www.wnc.ac.uk/> Facebook: Vision West Notts<http://www.facebook.com/visionwestnotts> Twitter: @westnotts<http://twitter.com/#!/WestNotts> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ National Beacon College, IiP Gold Standard and 14th best place to work in the public sector To view our disclaimer please follow this link http://www.wnc.ac.uk/emaildisclaimer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2 1

Question about embedded "live search" links
by Delawska-Elliott, Basia 09 Mar '16

09 Mar '16

Hello All, Greetings from Portland! This is my first time posting to the list and we don't have Koha yet. We are looking at Koha functionality and it seems very impressive. Here is a quick question (apologies if it had been asked and answered before. The archives are blocked from my site.) -- is it possible to create a link to a live search on a specific topic in Koha that could be posted on a library website and that would automatically execute when a user clicks on it? Thank you in advance for your help! Basia Basia Delawska-Elliott | Medical Librarian | 503.216.4064 | basia.delawska-elliott(a)providence.org Providence Health & Services System Library Services | Providence St. Vincent Medical Center, 9205 SW Barnes Rd., Portland, OR 97225 ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.

3 5

Report includes renewals?
by Christopher Davis 09 Mar '16

09 Mar '16

Dear Colleagues, I need to know whether or not the "Circulation numbers in a time frame for all itemtypes, per branch" report found at <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Circulation_number…> includes renewals. Will someone please confirm this either way for me? TIA, Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgdavis(a)uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary

2 2

International Koha Fund - Grants Committee Draft Rules
by Bob Birchall 09 Mar '16

09 Mar '16

International Koha Fund - Grants Committee Draft Rules Te Horowhenua Trust (THT) in New Zealand has established a Fund for the ongoing development and dissemination of Koha as free software. In May 2015 THT entered into a Memorandum of Understanding (MOU) with representatives of the Koha community regarding the operation of the Fund. Pursuant to the MOU, the Koha community has established a Fundraising Committee to, amongst other purposes, promote contributions to the Fund. The Fundraising Committee is now assisting THT to make rules for the establishment and operation of a Grants Committee to administer the disbursement of grants from the Fund. It is important to understand that whilst the Fundraising Committee is established by the Koha community, the Grants Committee will be a committee of the Trust. The Trust is seeking the advice of the community on the making of the Grants Committee rules. A draft of the rules has now been added to the wiki: https://wiki.koha-community.org/wiki/Fundraising This will be considered at the next couple of meetings of the community. Turn up and have your say: https://wiki.koha-community.org/wiki/IRC_Meetings https://wiki.koha-community.org/wiki/General_IRC_meeting_9_March_2016 Bob Birchall Calyx

1 0

Help, Web Installer
by Arshad Iqbal 09 Mar '16

09 Mar '16

Hi On the 3rd step of koha web installer i am facing this error please help me. Can't use an undefined value as an ARRAY reference at /usr/lib/i386-linux-gnu/perl5/5.20/DBI.pm line 2064. Muhammad Arshad Iqbal

1 0

General IRC meeting 9 March 2016 at 20:00 UTC
by Brendan Gallagher 08 Mar '16

08 Mar '16

Hello - Just a reminder that there is a General IRC Meeting tomorrow. Here is the link to the agenda. https://wiki.koha-community.org/wiki/General_IRC_meeting_9_March_2016 You'll also find a time converter in the wiki link so you can adjust to your local time. Thanks, Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO

1 0

opac reading history
by Celtic Studies Library 08 Mar '16

08 Mar '16

Hi We are unable to see parton's reading history. We can only see what they currently have on loan. opac privacy and opac reading history are set to ALLOW. Is there something we are missing? Many thanks Margaret -- School of Celtic Studies Dublin Institute for Advanced Studies 10 Burlington Road Dublin 4 +353 1 6140182 www.celt.dias.ie/library @SCSLIbrary

2 1