[Koha] KOHA instalation on Cent OS 6.8

Hi, I am trying to install KOHA ( latest stable version ) in Cantos 6.8 . I have a dedicated server with three website running successfully in it . I need to park my KOHA along with these website . CentOS.6.3 is that latest official documentation published on KOHA (

Re: [Koha] Order PDF report

Hi, the PDFs created from the basket group page can't be customized without changing files in Koha at the moment. See: Bug 10135 -Adding the ability to define customised basketgroups pdf layouts https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10135 And also: Bug 10746 -Improving

Re: [Koha] problem Installing koha on ubuntu 12.04

If you are using Ubuntu 16.04 you can configure your MySQL to be less strict or use MariaDB. Instructions can be found on the wiki: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 Hope this helps, Katrin On 20.02.2017 02:21, Paul A wrote: On

Re: [Koha] Having two servers for Koha - Database and Application server

Hello Admire, the only difference is in koha-create step: https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-create use request-db and populate-db parameters regards Josef čt 23. 2. 2017 v 7:52 odesílatel Admire Mutsikiwa napsal: >

[Koha] Having two servers for Koha - Database and Application server

Hi I would like to enquire if it is possible to implement Koha on two servers , with one server as the Database server running Mysql Database and another as the application server running Koha. I will appreciate any pointers on how to have such a setup/ Kind Regards, Admire Mutsikiwa

Re: [Koha] SQL Report-Circulation-- Help

Hi Pandu Rangaswamy, hope this sql helps your requirements - SELECT DISTINCT b.biblionumber, b.title, b.author, t.publishercode AS

Re: [Koha] Difference between 3.22 and 16.11

Thanks Doug, Katrin and all, I'm new to this KOHA community but I'm already impressed by the level of cooperation and support provided. I'm very grateful. We are indeed opting for 16.11 and we are then working to a minimum upgrade approach of n+3. Dan Dan Walsh | Programme Manager,

Re: [Koha] Koha History (was Difference between 3.22 and 16.11)

On 23/02/17 06:38, King, Fred wrote: Which brings me to something that I've been wondering for a while. Version 3.x was substantially different from Version 2.x. Is there a way that the new numbering system will reflect a similar extensive change, or will Koha continue to become more awesome

Re: [Koha] Koha MARC Tag - Table of Contents

Hi You should ask Insead how they set that up, there is no way for us to know how they are doing full text searching. To me it doesn't look like they are, they just have a pdf attached. But they will be able to tell you A very quick look would appear to suggest that they have a full 505$a

Re: [Koha] Difference between 3.22 and 16.11

Thanks Katrin, that clears it up. Dan - your implied question of which version to go to in your update, sounds like it should be the latest 16.x. Doug -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Katrin Sent: Wednesday, February 22, 2017 12:30

Re: [Koha] Difference between 3.22 and 16.11

Which brings me to something that I've been wondering for a while. Version 3.x was substantially different from Version 2.x. Is there a way that the new numbering system will reflect a similar extensive change, or will Koha continue to become more awesome bit-by-bit? No, I'm not going to ask

Re: [Koha] Difference between 3.22 and 16.11

Hi Doug, the last 3.xx version was 3.22, after that, we switched. So after 3.22 was 16.05, then 16.11. We currently actively maintain the last 3 versions, so 3.22 - 16.05. In May, when 17.05 is released, it's like that 3.22 will see its 'end of life'. Hope that clears it up, Katrin On

Re: [Koha] Difference between 3.22 and 16.11

Hi Doug Dan, I am confused also. I thought we moved to the YY.xx.xx convention. > I'm not sure why we are still maintaining the 3.xx convention. What am > I missing? Dan asked for the technical differences between Koha 3.22 an 16.11. Koha 3.22 was released in November 2015 *

Re: [Koha] Difference between 3.22 and 16.11

Dan, I am confused also. I thought we moved to the YY.xx.xx convention. I'm not sure why we are still maintaining the 3.xx convention. What am I missing? Thanks, Doug -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Barton Chittenden Sent:

Re: [Koha] Publisher Authority Type

Hi, Krishna! The data in the 260 field (or the 264) is transcribed data--it should be transcribed from the item, and may not be the same as the authorized form of the publisher's name in the authority file. For example, a book may have on the title page (made up example): "Oxford at the

Re: [Koha] Search not working

Katrin, This was my problem. Search wasn't working because there was some confusion between UNIMARC & MARC21 during the installation. The option to choose the flavour is presented with the koha-create $instance & koha 1st time web installation. Regards, Ian On 19/02/2017 22:08, Katrin

Re: [Koha] Koha MARC Tag - Table of Contents

On 2017-02-21 11:52 PM, Chris Cormack wrote: Hi Dr Bhavsar You should ask Insead how they set that up, there is no way for us to know how they are doing full text searching. To me it doesn't look like they are, they just have a pdf attached. But they will be able to tell you A very quick

[Koha] Summary: Koha Devel Meeting, 22 Februrary 2017

Hi All, We had a productive dev meeting today, just wanted to highlight some of our discussions for the general list readers. If this seems useful I will try to send these updates after each dev meeting: The Onboarding tool still

Re: [Koha] Difference between 3.22 and 16.11

I think you'd want to look at the 16-11 release notes (posted by Amit Gupta) as well as the 16.05 release notes: https://koha-community.org/koha-16-05-released/ On Wed, Feb 22, 2017 at 3:44 AM, Amit Gupta wrote: > Hi Daniel, > > There are lot of new features in 16.11.x.

Re: [Koha] SQL Report-Circulation-- Help

Dear All, Currently i am using Koha version 3.12.10.000. and i am having two branch libraries. I am looking in SQL report to generate the books details with the following details. 1. Title of the book 2. Author 3. Publisher 4. Place of Publication and year 5. Name of the vendor 6. Invoice No

Re: [Koha] SQL Report-Circulation-- Help

Hi Jonathan, I did a mistake with WHERE Coditions, like; p.categorycode=<> INSTEAD OF borrowers.categorycode (http://schema.koha-community.org/16_05/tables/old_issues.html ) and this was throwing error : Unknown column 'p.categorycode' in 'where clause' Now, I have

Re: [Koha] SQL Report-Circulation-- Help

What is the error you get? Please answer to the list. On Wed, 22 Feb 2017 at 12:12 SATISH wrote: > thank you Jonathan for correcting sql syntax. > but after corrections,it is still showing error! > > with thanks > satish > > On 22 February 2017 at 15:57, Jonathan Druart <

Re: [Koha] SQL Report-Circulation-- Help

Hello Satish, To add conditions to a SQL query you just need to separate them with the "AND" keyword, do not repeat "WHERE". So it's: SELECT fields FROM TABLE WHERE condition_a AND condition_b AND condition_c Regards, Jonathan On Wed, 22 Feb 2017 at 11:05 SATISH

[Koha] SQL Report-Circulation-- Help

Hi, With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / I looking for Borrower's complete transactions report between "date range" and "by patron category" and "by itemtype". I reason for the report is: to keep the record in hard copy for entire semester's transactions. I am trying

Re: [Koha] Difference between 3.22 and 16.11

Hi Daniel, There are lot of new features in 16.11.x. Please see the below link Koha 3.22 release notes https://koha-community.org/koha-3-22-released/ Koha 16.11 release notes https://koha-community.org/koha-16-11-released-2/ On 22 Feb 2017 11:43 am, "Walsh, Daniel (British Council)" <