- Koha - lists.katipo.co.nz

Re: [Koha] After upgrade to 16.5.00.000 - OPAC/Staff Client not showing results
by SATISH 28 Jun '16

28 Jun '16

Hi Mark, cat /var/log/koha/{instance name}/zebra-error.log shows; 20160625 17:29:34 gechlibrary-koha-zebra: client (pid 4329) killed by signal 15, stopping koha-start-zebra {instance name} shows; Zebra already running for instance gechlibrary. I am still not getting search results in opac/staff client eventhough I have 1000+ records. Previously, Koha 3.16 was installed from packages method on ubuntu 12.4 LTS Desktop and was working very fine and problem started after uprade to 16.5.00.000. I am not sure, how to proceed further, and community's help is requested. -satish On Sun, Jun 26, 2016 at 9:22 PM, Mark Tompsett <mtompset(a)hotmail.com> wrote: > Greetings, > > Could you please post to the list the results of: > cat /var/log/koha/{instance name}/zebra-error.log > > My guess is it will be something like: > YYYYMMDD 07:35:XX {instance name}-koha-zebra: client (pid #####) killed by > signal 15, stopping > > If so: > $ sudo koha-start-zebra {instance name} > > Will temporarily fix it, until the zebra dies again. Granted, this is a > problem being encountered on a fresh install for us. > > GPML, > Mark Tompsett > > --

2 2

Koha-16.05.01 installation
by vijay kumar 28 Jun '16

28 Jun '16

Dear all, I have installed koha-16.05.01 on Ubuntu 16.04 with all required perl modules having no error by using old stable koha repository echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d/koha.list Earlier getting errors, using koha-repository for stable version mention below echo deb http://debian.koha-community.org/koha squeeze main | sudo tee /etc/apt/sources.list.d/koha.list With regards, Vijay Kumar

1 0

OCLC Connexion users on Mac OS
by Eric Phetteplace 27 Jun '16

27 Jun '16

Hello Collective Wisdom, Is anyone an OCLC Connexion user that also happens to use Mac OS X? We're a Mac school (♥︎) and the desktop client only runs on Windows. But we learned today that the website's export function, which worked fine with our prior ILS Millennium, only exports records in MARC8 encoding and not UTF-8, so Koha doesn't work with it. All our work around options look bleak: using something like WINE to run the client on a Mac, asking our staff to dual boot or run a VM, exporting to a file instead & importing that into Koha. They'll work but they're much more inconvenient than the web client. If anyone has a better idea I'd be grateful. Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

2 2

Round the World Koha Speaking Tour
by Esmael Wan 27 Jun '16

27 Jun '16

Hi Joann, I'm from malaysia and on behalf Koha Community of Malaysia we are very pleased to receive you as a guest to convey information on Koha. We have several sites Koha in academic and public libraries around kuala lumpur and georgetown & we can prepare meeting/presenting/talking to the koha's libraries. As our guest we would like to provide accommodation, travel costs and daily remuneration during their stay. Please let know more details about planning. Regards Esmael

2 1

Round the World Koha Speaking Tour
by Joann Ransom 27 Jun '16

27 Jun '16

Hi everyone, I have a few months available and am planning a round the world speaking tour starting late August this year – so really soon! I would love to visit as many countries as I can with strong Koha presences and I am looking for partners to help make this a viable proposition. What I am seeking your help with is libraries, vendors or individuals who would be willing to ‘host’ me ie accommodation, domestic travel, a bit of hospitality. I don’t need posh – happy to homestay J In exchange I would love to speak on Koha origins, Koha community or Te Takere (which is a truly awesome public library / community centre I have developed over the last 4 years) and / or mix and mingle in gatherings. I’m basically happy to sing for my supper in any way that is required J. My draft itinerary is set out below and if anyone is able to help make this happen personally or by passing this email on to someone who can help that would be awesome. I’m so excited at the thought of meeting many of you in this great global Koha family that we have created. Many thanks Jo. Draft itinerary: (I need to travel in one direction around the globe) Philippines, Malaysia, India, Turkey, Greece, France, Germany, Austria, Czech Republic, Sweden, Norway, UK, Ireland, USA, Colombia, Chile, Argentina. *Joann Ransom* *Chief Executive Officer* *DDI* 06 366 0841 | *Mobile* 027 320 6923 jransom(a)tetakere.org.nz *Ph.* 06 368 1953 *www.tetakere.org.nz* <http://www.tetakere.org.nz/> Chief Executive Te Horowhenua Trust.

7 6

SQL problem- showing results when they are zero.
by Raymund Delahunty 27 Jun '16

27 Jun '16

We have a quite complex budget and funds structure which is making writing reports somewhat challenging. For example, we have struggled at modify the report below, to have it show lines when both Expenditure AND Commitments are zero. When both are zero, the line is simply omitted from the result. We have not seen any results where Expenditure is zero, but where Commitments is not (a possible scenario, of course), so we are not sure if it is the Expenditures being zero that is the underlying problem. For example running the query of the CSM College library shows only 36 lines of results rather than the expected 44. So 8 have zero in both Exp / Comms. Can someone suggest how we might add in the missing 8 lines. SELECT budget_name AS 'Fund Name', sort1 as 'Subject Fund', FORMAT(sum(valSpent),2) AS 'Expenditure', FORMAT(sum(valOnOrder),2) AS 'Commitments' FROM (SELECT b.budget_name, o.sort1, sum(o.unitprice*o.quantity) AS valSpent, 0 AS valOnOrder FROM aqorders o LEFT JOIN aqbudgets b USING (budget_id) WHERE o.datereceived IS NOT NULL AND o.sort1 IN ('CSM Act & Direct','CSM Animation','CSM Architecture','CSM CCC','CSM Ceramic Design','CSM Charges','CSM Collab Perf','CSM Enterprise','CSM Fashion','CSM Film','CSM Fine Art','CSM Foundation','CSM Graphic Design','CSM Innov & Imagin','CSM Jewellery','CSM PDP','CSM Photography','CSM Pro & Indu Des','CSM Qref & General','CSM Replacements','CSM Samples','CSM Textiles','CSM Journals','CSM e-Act & Direct','CSM e-Animation','CSM e-Architecture','CSM e-CCC','CSM e-Ceramic Design','CSM e-Charges','CSM e-Collab Perf','CSM e-Enterprise','CSM e-Fashion','CSM e-Film','CSM e-Fine Art','CSM e-Foundation','CSM e-Graphic Design','CSM e-Innov & Imagin','CSM e-Jewellery','CSM e-PDP','CSM e-Photography','CSM e-Pro & Indu Des','CSM e-Qref & General','CSM e-Replacements','CSM e-Samples','CSM e-Textiles','CSM e-Journals') GROUP BY o.sort1 UNION ALL SELECT b.budget_name, o.sort1, 0 AS valSpent, sum(o.listprice*o.quantity) AS valOnOrder FROM aqorders o LEFT JOIN aqbudgets b USING (budget_id) WHERE o.sort1 IN ('CSM Act & Direct','CSM Animation','CSM Architecture','CSM CCC','CSM Ceramic Design','CSM Charges','CSM Collab Perf','CSM Enterprise','CSM Fashion','CSM Film','CSM Fine Art','CSM Foundation','CSM Graphic Design','CSM Innov & Imagin','CSM Jewellery','CSM PDP','CSM Photography','CSM Pro & Indu Des','CSM Qref & General','CSM Replacements','CSM Samples','CSM Textiles','CSM Journals','CSM e-Act & Direct','CSM e-Animation','CSM e-Architecture','CSM e-CCC','CSM e-Ceramic Design','CSM e-Charges','CSM e-Collab Perf','CSM e-Enterprise','CSM e-Fashion','CSM e-Film','CSM e-Fine Art','CSM e-Foundation','CSM e-Graphic Design','CSM e-Innov & Imagin','CSM e-Jewellery','CSM e-PDP','CSM e-Photography','CSM e-Pro & Indu Des','CSM e-Qref & General','CSM e-Replacements','CSM e-Samples','CSM e-Textiles','CSM e-Journals') and o.datereceived IS NULL and o.orderstatus<>'cancelled' GROUP BY o.sort1) AS CSMorders GROUP BY sort1 ORDER BY budget_name ASC Many thanks. Ray Delahunty r.delahunty(a)arts.ac.uk<mailto:r.delahunty@arts.ac.uk> University of the Arts London . This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of London Artscom Limited the following also applies: London Artscom Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

1 0

Koha 16.05.01 released
by Frédéric Demians 26 Jun '16

26 Jun '16

It is with great pleasure that we announce the release of Koha 16.05.01, a maintenance release of the Koha open source integrated library system. See the full release notes here: https://koha-community.org/koha-16-05-01-released/ Download: http://koha-community.org/download-koha/ Stay tuned for Debian/Ubuntu package availability. -- Frédéric DEMIANS http://www.tamil.fr/fdemians

2 2

Re: [Koha] Can the OPAC home page be configured to display News without logging in?
by Tim Auld 26 Jun '16

26 Jun '16

Thanks Katrin, Using All-Libraries did the trick. The News displays successfully on the home page. Regards ... Tim.

1 0

Can the OPAC home page be configured to display News without logging in?
by Tim Auld 26 Jun '16

26 Jun '16

If you want to display news items on the OPAC home page, can it be configured to do so without the user having to login to see it? Regards, Tim Auld Minnesota

2 1

OCLC Connexion users on Mac OS
by Eric Phetteplace 26 Jun '16

26 Jun '16

Hello Collective Wisdom, Is anyone an OCLC Connexion user that also happens to use Mac OS X? We're a Mac school and the desktop client only runs on Windows. But we learned today that the website's export function, which worked fine with our prior ILS Millennium, only exports records in MARC8 encoding and not UTF-8, so Koha doesn't work with it. All our work around options look bleak: using something like WINE to run the client on a Mac, asking our staff to dual boot or run a VM, exporting to a file instead & importing that into Koha. They'll work but they're much more inconvenient than the web client. If anyone has a better idea I'd be grateful. Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

1 0