[Koha] SQL problem- showing results when they are zero.

2016-06-27 Thread Raymund Delahunty
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

Re: [Koha] Round the World Koha Speaking Tour

2016-06-27 Thread Christopher Davis
Jo, When do you plan on traveling in the U.S.A.? There are a number of Koha libraries (both community Koha, and LibLime Koha) around my region who probably would be interested in a little conference like this. Thank you, Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library

[Koha] Round the World Koha Speaking Tour

2016-06-27 Thread Esmael Wan
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 ko

Re: [Koha] OCLC Connexion users on Mac OS

2016-06-27 Thread MJ Ray
On 24 June 2016 00:00:19 CEST, Eric Phetteplace wrote: >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. It's been a while since I supported Mac OS X but I'm p

Re: [Koha] Round the World Koha Speaking Tour

2016-06-27 Thread Eric Bégin
Hi Joann, I feel like you'll have to add a few weeks to your trip :) Let me know if (and when) you could pass by Montréal, Canada before going south in the US, we'll be happy to set something up. Cheers, Eric Begin Solutions inLibro inc. On 2016-06-27 13:36, Esmael Wan wrote: Hi Joann, I'

Re: [Koha] OCLC Connexion users on Mac OS

2016-06-27 Thread Eric Phetteplace
Thanks, MJ. I tried converting an OCLC export to MARCXML using both marc2xml and a custom pymarc script, both imports choked and failed in Koha. I'm not sure where the issue lies, if it was just an artifact of one of the records I chose in testing. For the list's benefit, we're trying out a workfl

[Koha] Need help to open a staff patron

2016-06-27 Thread Mahmudul Hasan
Dear All I am new here. So, I have read the manual and seen nothing to solve this problem. According to manuual whenever i am going to add a new patron. It can not. At the first time when i was logged in following warning message shows and that is "You are logged in as the database administrativ

[Koha] Koha-16.05.01 installation

2016-06-27 Thread vijay kumar
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 s