[Koha] KOHA instalation on Cent OS 6.8

[paulson kf]

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
( https://wiki.koha-community.org/wiki/Koha_3.10_on_Centos_6.3_x86_64_en )
. I have tried this but not getting succeeded . Any one have any
information about this.




Best Regards,
Paulson k  f
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Order PDF report

[Katrin]

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 PDF printing of baskets - Omnibus
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10746

I've added a German translation of the PDF a while ago, that you can 
switch to using the OrderPdfFormat system preference. It's a 2-page 
version, in the 3-page version an additional summary page of all 
included baskets is printed as the second page.


In 16.11 we've added a feature to send out orders by e-mail that is 
based on the ACQORDER notice template and can be changed easily:


Bug 5260 - Add option to send an order by e-mail to the acquisition module
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5260

Hope this helps,

Katrin

On 21.02.2017 12:17, Andreas Wolf wrote:

Dear all,

  


just wondering how I can customize the basket group order PDF report (found
in

Acquisitions as ,Print this basket group in PDF')?

  


Thanks for your assistance.

  


Kind regards,

  


Andreas

  

  


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] problem Installing koha on ubuntu 12.04

[Katrin]

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 2017-02-19 01:44 AM, Mark Tompsett wrote:

Greetings,

The newer versions of Koha are not supported on Ubuntu 12.04. Use a 
newer

version Ubuntu, though Debian is the primary recommended OS.
https://wiki.koha-community.org/w/index.php?title=Koha_on_Debian


Ubuntu 12.04LTS is getting "older" but is still [at least partially] 
supported until 2019. My experience is that Ubuntu 16.04LTS needs 
"downgrading" of MySQL (to 5.6 from 5.7) for Koha. The Wiki reference 
you cite is not very clear on all this.


Given the statistics for usage of Ubuntu servers (anecdotally "quite 
prevalent", no proof) I would suggest that it behooves our Koha 
community to be clearer on what exactly is involved -- it's not 
"rocket science", but it obviously could be a "good thing (tm)" to 
have a write-up available on the reasons why, and what is involved.


I get the impression, perhaps incorrectly, that the difficulties 
described in this query involve a 32-bit system. If this is not 
possible, shouldn't we say from which version forward 32-bit packages 
are no longer suitable for Koha installation?


Respectfully -- P.


GPML,
Mark Tompsett

-Original Message-
From: Subhranil Bhattacharyya
Sent: Sunday, February 19, 2017 1:32 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] problem Installing koha on ubuntu 12.04

Dear sir,


I have some problem during KOHA installation, i am using Ubuntu 12.04
desktop-i386, when i am writing the terminal, sudo apt-get install koha
common, its shows following error messege


root@koha-H81M-WW:/home/koha# sudo apt-get install koha-common

Reading package lists... Done

Building dependency tree

Reading state information... Done

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:


The following packages have unmet dependencies:

koha-common : Depends: libarchive-extract-perl but it is not installable

Depends: libgd-perl but it is not installable

Depends: libsereal-decoder-perl but it is not installable

Depends: libsereal-encoder-perl but it is not installable

E: Unable to correct problems, you have held broken packages.


root@koha-H81M-WW:/home/koha# sudo apt-get install -f

Reading package lists... Done

Building dependency tree

Reading state information... Done

0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

root@koha-H81M-WW:/home/koha# sudo apt-get install koha common

Reading package lists... Done

Building dependency tree

Reading state information... Done

E: Unable to locate package koha

E: Unable to locate package common

root@koha-H81M-WW:/home/koha#


please give my suggesion, what can I do
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha




___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Josef Moravec]

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:

> 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 (Mr)
>
> ICT Manager
>
> Libraries
>
> University of Zimbabwe
>
> Tel:+263-4-303276 <+263%204%20303%20276>
>
> Mob:+26377111 <+263%2077%20111%20>
>
>
>
> "It is easy to dodge our responsibilities, but we cannot dodge the
> consequences of dodging our responsibilities."  Josiah Charles Stamp
> 
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Admire Mutsikiwa]

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 (Mr)

ICT Manager

Libraries

University of Zimbabwe

Tel:+263-4-303276

Mob:+26377111

 

"It is easy to dodge our responsibilities, but we cannot dodge the
consequences of dodging our responsibilities."  Josiah Charles Stamp
 

 

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[SATISH]

Hi Pandu Rangaswamy,

hope this sql helps your requirements

-

SELECT DISTINCT b.biblionumber, b.title, b.author, t.publishercode AS
publisher, t.place AS 'place of publication', t.editionstatement AS
'edition', b.copyrightdate AS 'copyright year',
i.booksellerid AS 'vendor', i.stocknumber AS 'invoice number',
i.price, i.withdrawn AS 'withdrawn stuatus'
FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN
items i USING(biblionumber) GROUP BY b.biblionumber



with thanks

Satish MV
Librarian
Govt. Engineering College, Hassan
Karnataka


> 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 and Date
> 7. Price
> 8. Withdrawn status
>
>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Walsh, Daniel (British Council)]

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, Libraries Revolution and Digital Services, South 
Asia | British Council
T: +94 (0) 114 752 1521 | M:  + 94 (76) 638 8840 | BCTN 8 500 6490
daniel.wal...@britishcouncil.org | www.britishcouncil.org 
Creating opportunity for people worldwide 
The British Council is committed to a policy of equal opportunity and diversity


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: 23 February 2017 02:37
To: 'Katrin'; koha@lists.katipo.co.nz
Subject: 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 PM
To: koha@lists.katipo.co.nz
Subject: 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 22.02.2017 19:56, Doug Dearden wrote:
> 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: Wednesday, February 22, 2017 5:55 AM
> To: Amit Gupta 
> Cc: Koha-List 
> Subject: 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. 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)" < 
>> daniel.wal...@britishcouncil.org> wrote:
>>
>> Dear Colleagues,
>>
>> We are currently upgrading KOHA across our libraries.  Other than a 
>> change in naming convention, are there any technical differences 
>> between 3.22 and 16.11?
>>
>> Dan Walsh
>>
>>
>>
>> The British Council is the United Kingdom's international 
>> organisation for cultural relations and educational opportunities. A 
>> registered charity:
>> 209131 (England and Wales) SC037733 (Scotland).
>> This message is for the use of the intended recipient(s) only and may 
>> contain confidential information. If you have received this message 
>> in error, please notify the sender and delete it.
>> The British Council accepts no liability for loss or damage caused by 
>> viruses and other malware and you are advised to carry out a virus 
>> and malware check on any attachments contained in this message.
>> ___
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
> https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha

The British Council is the United Kingdom's international organisation for 
cultural relations and educational opportunities. A registered charity: 209131 
(England and Wales) SC037733 (Scotland).
This message is for the use of the intended recipient(s) only and may contain 
confidential information. If you have received this message in error, please 
notify the sender and delete it.
The British Council accepts no liability for loss or damage 

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

[Bob Birchall]

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 bit-by-bit?




The trigger for the change from Koha 2.x to Koha 3.x was the 
introduction of Zebra and a new presentation theme.  Nothing quite so 
revolutionary occurred to trigger a change from 3.x to 4.x. 
Additionally, a move to 4.x might have caused some confusion for victims 
of a particular fork.  As we have time-based releases in May and 
November each year, the 'yy.mm' pattern makes a lot of sense.


What triggered the change from 1.x to 2.x?  From the 'Timeline', it 
looks like MARC support was added at v1.3.  Was it just that we'd 
reached 1.9 and 2.0 was logically the next place to go?


I think the Timeline on the About page is an awesome community asset.  
Thanks to those who maintain it!


Bob Birchall
Calyx
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Michael Kuhn]

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
(that is "hidden" from the client browser, but is present in the "page
source"), and then an 856 $u and $z for the .pdf.

Perhaps guesswork on my behalf, and I have no idea what "alchemy" (css?,
js?) might be in the background, but from a MARC point of view appears
fairly straightforward.


When looking at the given URL:

http://librarycatalogue.insead.edu/cgi-bin/koha/opac-detail.pl?biblionumber=83836_desc=kw%2Cwrdl%3A%20marketing

I see the following:

1. Instead of showing the actual URL (MARC 856 $u) or the link text ($y) 
they just show a PDF image - this can be coded in the original XSL file 
(I've done something similar with Antolin images, look here: 
https://opac.treuchtlingen.de/cgi-bin/koha/opac-detail.pl?biblionumber=13327 
) - the image then links to the actual PDF file ( 
http://librarycatalogue.insead.edu/pdf/83836.pdf ) which is better 
readable than the content of MARC 590 $a


My own code in "MARC21slim2OPACDetail.xsl" looked like this, just as an 
example:



  Antolin 
  
/opac-tmpl/select="$theme"/>/images/antolinrabe.jpg

vertical-align:middle
25
25
  


2. To me it seems in fact not the PDF file is indexed but they just 
extracted (maybe even by copy & paste) the content and inserted it into 
MARC 590 $a as you can see here: 
http://librarycatalogue.insead.edu/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=83836 
- of course like this MARC 590 would just be indexed like any other MARC 
field, so there is no need to find a way to index the PDF file. (Well, 
I'm not sure if MARC 590 is indexed by default, but this can be 
configured in Zebra)


Maybe this helps?

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Doug Dearden]

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 PM
To: koha@lists.katipo.co.nz
Subject: 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 22.02.2017 19:56, Doug Dearden wrote:
> 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: Wednesday, February 22, 2017 5:55 AM
> To: Amit Gupta 
> Cc: Koha-List 
> Subject: 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. 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)" <
>> daniel.wal...@britishcouncil.org> wrote:
>>
>> Dear Colleagues,
>>
>> We are currently upgrading KOHA across our libraries.  Other than a change
>> in naming convention, are there any technical differences between 3.22 and
>> 16.11?
>>
>> Dan Walsh
>>
>>
>>
>> The British Council is the United Kingdom's international organisation for
>> cultural relations and educational opportunities. A registered charity:
>> 209131 (England and Wales) SC037733 (Scotland).
>> This message is for the use of the intended recipient(s) only and may
>> contain confidential information. If you have received this message in
>> error, please notify the sender and delete it.
>> The British Council accepts no liability for loss or damage caused by
>> viruses and other malware and you are advised to carry out a virus and
>> malware check on any attachments contained in this message.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[King, Fred]

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 what's going to happen to the numbering system in 
about 83 years. :-)

Fred King
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279

After disassembling and inspecting the humidifier, I've determined that the 
main problem with it is that someone took it apart.
--XKCD


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Katrin
Sent: Wednesday, February 22, 2017 2:30 PM
To: koha@lists.katipo.co.nz
Subject: 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 22.02.2017 19:56, Doug Dearden wrote:
> 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: Wednesday, February 22, 2017 5:55 AM
> To: Amit Gupta 
> Cc: Koha-List 
> Subject: 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://urldefense.proofpoint.com/v2/url?u=https-3A__koha-2Dcommunity.
> org_koha-2D16-2D05-2Dreleased_=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4w
> hPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=3QDjUn
> WEzwyxfYPkPY5s-2dP9nel7roh0H_5ZvARtd8=eUFkWXRsEAuMag_kz38VWlyyI_mjWv
> hUX9YaNcKZzkU=
>
> On Wed, Feb 22, 2017 at 3:44 AM, Amit Gupta  wrote:
>
>> Hi Daniel,
>>
>> There are lot of new features in 16.11.x. Please see the below link
>>
>> Koha 3.22 release notes
>>
>> https://urldefense.proofpoint.com/v2/url?u=https-3A__koha-2Dcommunity
>> .org_koha-2D3-2D22-2Dreleased_=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4
>> whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=3QDj
>> UnWEzwyxfYPkPY5s-2dP9nel7roh0H_5ZvARtd8=ubShkjzKDCYpkbcm3EotnSxwFVY
>> feit9PIlxOOvYh-0=
>>
>> Koha 16.11 release  notes
>>
>> https://urldefense.proofpoint.com/v2/url?u=https-3A__koha-2Dcommunity
>> .org_koha-2D16-2D11-2Dreleased-2D2_=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0Q
>> K_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI
>> =3QDjUnWEzwyxfYPkPY5s-2dP9nel7roh0H_5ZvARtd8=hwu8BSGcSX1qw8C0T40DB_
>> O0WQ4YfgPl75KzoYy09kc=
>>
>>
>> On 22 Feb 2017 11:43 am, "Walsh, Daniel (British Council)" < 
>> daniel.wal...@britishcouncil.org> wrote:
>>
>> Dear Colleagues,
>>
>> We are currently upgrading KOHA across our libraries.  Other than a 
>> change in naming convention, are there any technical differences 
>> between 3.22 and 16.11?
>>
>> Dan Walsh
>>
>>
>>
>> The British Council is the United Kingdom's international 
>> organisation for cultural relations and educational opportunities. A 
>> registered charity:
>> 209131 (England and Wales) SC037733 (Scotland).
>> This message is for the use of the intended recipient(s) only and may 
>> contain confidential information. If you have received this message 
>> in error, please notify the sender and delete it.
>> The British Council accepts no liability for loss or damage caused by 
>> viruses and other malware and you are advised to carry out a virus 
>> and malware check on any attachments contained in this message.
>> ___
>> Koha mailing list  
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.
>> org=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOm
>> jyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=3QDjUnWEzwyxfYPkPY5s-2dP9nel7ro
>> h0H_5ZvARtd8=4IfG7RvN8OrInJwnSZLgk34r6WtqjYUP1proT7RVses=
>> Koha@lists.katipo.co.nz
>> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.
>> nz_mailman_listinfo_koha=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpnd
>> Vxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=3QDjUnWEzw
>> yxfYPkPY5s-2dP9nel7roh0H_5ZvARtd8=0yhF6IsY3rVAeYCjTsvO6sUkt9ILtLGVy
>> AAQwBuH8LQ= ___
>> Koha mailing list  
>> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.
>> org=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOm
>> jyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=3QDjUnWEzwyxfYPkPY5s-2dP9nel7ro
>> h0H_5ZvARtd8=4IfG7RvN8OrInJwnSZLgk34r6WtqjYUP1proT7RVses=
>> Koha@lists.katipo.co.nz
>> 

Re: [Koha] Difference between 3.22 and 16.11

[Katrin]

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 22.02.2017 19:56, Doug Dearden wrote:

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: Wednesday, February 22, 2017 5:55 AM
To: Amit Gupta 
Cc: Koha-List 
Subject: 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. 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)" <
daniel.wal...@britishcouncil.org> wrote:

Dear Colleagues,

We are currently upgrading KOHA across our libraries.  Other than a change
in naming convention, are there any technical differences between 3.22 and
16.11?

Dan Walsh



The British Council is the United Kingdom's international organisation for
cultural relations and educational opportunities. A registered charity:
209131 (England and Wales) SC037733 (Scotland).
This message is for the use of the intended recipient(s) only and may
contain confidential information. If you have received this message in
error, please notify the sender and delete it.
The British Council accepts no liability for loss or damage caused by
viruses and other malware and you are advised to carry out a virus and
malware check on any attachments contained in this message.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Michael Kuhn]

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
* https://koha-community.org/koha-3-22-released/

Koha 16.05 was released in May 2016 (instead of Koha 3.24)
* https://koha-community.org/koha-16-05-released/

Koha 16.11 was released in November 2016
* https://koha-community.org/koha-16-11-released-2/

Koha 16.11 was in fact 16.11.0, but since we're already at 16.11.4 also 
the following release notes have to be studied to really know about all 
the differences between Koha 3.22 and 16.11.4:


* https://koha-community.org/koha-16-11-01-released
* https://koha-community.org/koha-16-11-02-released
* https://koha-community.org/koha-16-11-03-security-release
* https://koha-community.org/koha-16-11-04-release

Hope this helps.

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Doug Dearden]

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: Wednesday, February 22, 2017 5:55 AM
To: Amit Gupta 
Cc: Koha-List 
Subject: 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. 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)" <
> daniel.wal...@britishcouncil.org> wrote:
>
> Dear Colleagues,
>
> We are currently upgrading KOHA across our libraries.  Other than a change
> in naming convention, are there any technical differences between 3.22 and
> 16.11?
>
> Dan Walsh
>
>
>
> The British Council is the United Kingdom's international organisation for
> cultural relations and educational opportunities. A registered charity:
> 209131 (England and Wales) SC037733 (Scotland).
> This message is for the use of the intended recipient(s) only and may
> contain confidential information. If you have received this message in
> error, please notify the sender and delete it.
> The British Council accepts no liability for loss or damage caused by
> viruses and other malware and you are advised to carry out a virus and
> malware check on any attachments contained in this message.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Publisher Authority Type

[Hernandez, Heather]

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 University Press 2016."

This could be transcribed as:

260 _ _ $a Oxford : $b University Press, $c 2016.

But the authorized form of the name of this publisher in the authority file
in OCLC & the Library of Congress is:

110 2_ Oxford University Press.

So the record would have a 710 field with the authorized form of the name
for searching, access, etc.:

710 2_ Oxford University Press.

The 260 $b and the 710 may be identical, but not necessarily.  The
transcription becomes important when trying to identify particular
editions, printings, etc., especially in special collections, with rare
materials, etc.

I hope this helps clarify!  Cheers,
h2
~~
Heather Hernandez
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
415-561-7032, heather_hernan...@nps.gov
http://www.nps.gov/safr/learn/historyculture/museum-collections.htm

"The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Search not working

[i.pr...@zigzagee.com]

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 wrote:

Hi Vanda,

when using UNIMARC you will have to choose it in 2 places, maybe one 
was missed?


Before the instance is created, you need to tell Koha that it will be 
using UNIMARC. You can do so by changing ZEBRA_MARC_FORMAT="marc21" in 
/etc/koha/koha-sites.conf to "unimarc". This will affect the indexing 
configuration and can be the cause of why your search might not work, 
when the records itself look correct.


Then, when running the web installer, you also need to make sure 
UNIMARC is selected there. This will affect which cataloguing 
frameworks (MARC field and subfield definitions) are installed.


Hope this helps,

Katrin

On 17.02.2017 13:19, vanda koha wrote:

Hello Ian,

We are still unable to solve our problem. We have done everything we 
were

told to do, including what you mention in your message. Unfortunately
nothing worked.

And yes, we chose UNIMARC when the package installation was 
performed. My

computer collegues say that we also have some references to MARC21 in
the  the koha-conf.xml file and apparently it is supposed to be that 
way.

Still loking for an answer...

Regrads

Vanda

2017-02-16 19:13 GMT+00:00 i.pr...@zigzagee.com :


Vanda,

Just out of interest, did you choose UNIMARC when the package 
installation

was performed ?

I did and I'm facing the same search problems as you. I note the
koha-conf.xml file seems to
  have a lot of MARC21 references. Not sure if this needs to change to
UNIMARC. This was just the template file that was generated through the
installation.

I tried the koha-rebuild-zebra -f -a -b -v $instance approach 
recommended

but that didn't
  fix the search problems. if you want to know where it is just use 
>which

koha-rebuild-zebra

Regards,
Ian

--


Dr. Ian Pratt B.Eng Ph.D C.Eng MIET MIEEE
Director - ZigZagee Ltd.
Email: i.pr...@zigzagee.com
Landline: + 44 (0) 1509 276251
Mobile: + 44 (0) 7796331815
Web: www.zigzagee.com




___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha



--


Dr. Ian Pratt B.Eng Ph.D C.Eng MIET MIEEE
Director - ZigZagee Ltd.
Email: i.pr...@zigzagee.com
Landline: + 44 (0) 1509 276251
Mobile: + 44 (0) 7796331815
Web: www.zigzagee.com


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Paul A]

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 look would appear to suggest that they have a full 505$a 
(that is "hidden" from the client browser, but is present in the "page 
source"), and then an 856 $u and $z for the .pdf.


Perhaps guesswork on my behalf, and I have no idea what "alchemy" (css?, 
js?) might be in the background, but from a MARC point of view appears 
fairly straightforward.


Best -- Paul


Chris

On 22 February 2017 10:19:14 AM GMT+05:30, "Dr. Sandeep Bhavsar" 
 wrote:

Dear All

I request all of you to please see the INSEAD OPAC, They have uploaded
the
pdf file which has fulltext indexing search and even pdf logo is seen
on
the OPAC display

http://librarycatalogue.insead.edu/cgi-bin/koha/opac-detail.pl?biblionumber=83836_desc=kw%2Cwrdl%3A%20marketing

Please guide me about how can upload the pdf file and I want fulltext
indexing search.

On Tue, Feb 21, 2017 at 1:43 AM, Katrin 
wrote:


Hi,

these instructions might be helpful:
http://kohageek.blogspot.de/2015/12/attaching-files-to-catal
og-records.html

But keep in mind that the content of the files won't be

indexed/searchable.


Hope this helps,

Katrin

On 20.02.2017 08:09, Dr. Sandeep Bhavsar wrote:


Right now I am using  3.22.02.002 version., will you please guide me

about

how can I upload the pdf file. Insead library OPAC show the pdf

icon.



On Mon, Feb 20, 2017 at 12:36 PM, Bob Birchall 

wrote:


Yes, check the manual for your version of Koha.

Bob

On 20/02/17 18:01, Dr. Sandeep Bhavsar wrote:

Thanks for your instant reply. Can we upload the pdf file also.

On Mon, Feb 20, 2017 at 12:20 PM, Bob Birchall 

wrote:


505 Formatted Contents Note?

https://www.loc.gov/marc/bibliographic/concise/bd505.html

Bob Birchall
Calyx

On 20/02/17 17:38, Dr. Sandeep Bhavsar wrote:

Dear All


Greetings !!!

I have gone through the Koha OPAC of INSEAD Library, I notice

that they

have uploaded the Table of Contents (TOC) of the book which has
fulltext
indexing search.

I would like to  know about the exact MARC tag number for

uploading

TOC,





___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha





--
Warm Regards

Dr. Sandeep Bhavsar
Librarian


*Prin. L. N. Welingkar Institute of Management Development & Research
(AUTONOMOUS)*
L Napoo Road | Matunga (CR) | Mumbai- 400 019.
Tel: 022-2419 8377  |  Mob:  9870 18 
Library Portal*: http://elearn.welingkar.org/infowe
*


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Nick Clemens]

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
needs more testing (see Jonathan's email here:
http://lists.koha-community.org/pipermail/koha-devel/2017-February/043481.html)


This tool will make it easier for those setting up a new instance to enable
necessary settings and configuration and generally make Koha setup more
friendly.

It was proposed as a possibility to roll the tool out in English first, and
add other languages as they are tested. Ideally we would have as much
testing as possible now. We will discuss and vote on how to move ahead at
the next Developers meeting (8 March 2017, 19UTC)

The ru-RU and uk-UA languages were discussed for possible removal as there
has been no maintenance, if you are using these or interested in helping
maintain (or have strong opinion) please let us know.

Testing and QA teams can always use more help so let us know if you are
interested.

Other interesting notes:
ElasticSearch dependencies are being packaged by Mirko
Jonathan continues work on refactoring and moving things to the Koha
namespace (see here

for Koha::Patron status)
OverDrive integration has been pushed to master

The next meeting will be 8 March 2017, 19UTC
,
I hope to see you there.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Barton Chittenden]

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. 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)" <
> daniel.wal...@britishcouncil.org> wrote:
>
> Dear Colleagues,
>
> We are currently upgrading KOHA across our libraries.  Other than a change
> in naming convention, are there any technical differences between 3.22 and
> 16.11?
>
> Dan Walsh
>
>
>
> The British Council is the United Kingdom's international organisation for
> cultural relations and educational opportunities. A registered charity:
> 209131 (England and Wales) SC037733 (Scotland).
> This message is for the use of the intended recipient(s) only and may
> contain confidential information. If you have received this message in
> error, please notify the sender and delete it.
> The British Council accepts no liability for loss or damage caused by
> viruses and other malware and you are advised to carry out a virus and
> malware check on any attachments contained in this message.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[pandu rangaswamy]

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 and Date
7. Price
8. Withdrawn status

Kindly guide to get the report.

Thanks
Pandu.
+91-8978002982

On Wed, Feb 22, 2017 at 3:35 PM, SATISH  wrote:

> 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 following report, with date range, am successful but when added
> patron category and itemtype (last two line in WHERE section), it's
> failing.
>
> Can someone help me to get this report or please correct me, if I am wrong
> in the query??
>
> 
> --
> SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname,
> borrowers.streetnumber, borrowers.categorycode,items.barcode,
> DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate,
> DATE_FORMAT(old_issues.date_due,  "%d %b %Y %h:%i %p") As date_due,
> DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As
> lastreneweddate,
> DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate,
> EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' )
> AS TITLE,
> items.itype, items.location, items.ccode,items.itemcallnumber, items.price
> FROM old_issues
> LEFT JOIN borrowers ON ( borrowers.borrowernumber =
> old_issues.borrowernumber )
> LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber )
> LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber =
> b.biblioitemnumber)
> WHERE p.categorycode=<> AND
> WHERE items.itype=<> AND
> WHERE old_issues.issuedate BETWEEN <> and
> <> ORDER BY old_issues.issuedate
> 
> 
>
> With Thanks
> Satish MV
> Librarian
> Govt. Engineering College, Hassan
> Karnataka.
> www.gechassan.ac.in
> --
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
M.Pandu Rangaswamy
H.T.Parekh Library
Institute For Financial Management and Research (IFMR)
24, Kothari Road, Chennai - 600 034
INDIA
Tel - 91-44-2830 3498
Mobile: 08978002982
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[SATISH]

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 corrected my query with the syntax you had mentioned, as It
works now!  Thank you, here is the corrected SQL Query.


Title: Borrower's complete transactions report between "date range" + "by
patron category" + "by item type
--
SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname,
borrowers.streetnumber, borrowers.categorycode,items.barcode,
DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate,
DATE_FORMAT(old_issues.date_due,  "%d %b %Y %h:%i %p") As date_due,
DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As
lastreneweddate,
DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate,
EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' )
AS TITLE,
items.itype, items.location, items.ccode,items.itemcallnumber, items.price
FROM old_issues
LEFT JOIN borrowers ON ( borrowers.borrowernumber =
old_issues.borrowernumber )
LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber )
LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = b.biblioitemnumber)
WHERE borrowers.categorycode=<> AND
items.itype=<> AND
old_issues.issuedate BETWEEN <> and <> ORDER BY old_issues.issuedate
-

With Thanks
Satish MV
Librarian
Govt. Engineering College, Hassan
Karnataka.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Jonathan Druart]

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 <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
> 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  wrote:
>
> > 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 following report, with date range, am successful but when
> added
> > patron category and itemtype (last two line in WHERE section), it's
> > failing.
> >
> > Can someone help me to get this report or please correct me, if I am
> wrong
> > in the query??
> >
> >
> >
> --
> > SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname,
> > borrowers.streetnumber, borrowers.categorycode,items.barcode,
> > DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate,
> > DATE_FORMAT(old_issues.date_due,  "%d %b %Y %h:%i %p") As date_due,
> > DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As
> > lastreneweddate,
> > DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate,
> > EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' )
> > AS TITLE,
> > items.itype, items.location, items.ccode,items.itemcallnumber,
> items.price
> > FROM old_issues
> > LEFT JOIN borrowers ON ( borrowers.borrowernumber =
> > old_issues.borrowernumber )
> > LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber )
> > LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber =
> > b.biblioitemnumber)
> > WHERE p.categorycode=<> AND
> > WHERE items.itype=<> AND
> > WHERE old_issues.issuedate BETWEEN <> and
> > <> ORDER BY old_issues.issuedate
> >
> >
> 
> >
> > With Thanks
> > Satish MV
> > Librarian
> > Govt. Engineering College, Hassan
> > Karnataka.
> > www.gechassan.ac.in
> > --
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
>
> --
>
>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Jonathan Druart]

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  wrote:

> 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 following report, with date range, am successful but when added
> patron category and itemtype (last two line in WHERE section), it's
> failing.
>
> Can someone help me to get this report or please correct me, if I am wrong
> in the query??
>
>
> --
> SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname,
> borrowers.streetnumber, borrowers.categorycode,items.barcode,
> DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate,
> DATE_FORMAT(old_issues.date_due,  "%d %b %Y %h:%i %p") As date_due,
> DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As
> lastreneweddate,
> DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate,
> EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' )
> AS TITLE,
> items.itype, items.location, items.ccode,items.itemcallnumber, items.price
> FROM old_issues
> LEFT JOIN borrowers ON ( borrowers.borrowernumber =
> old_issues.borrowernumber )
> LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber )
> LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber =
> b.biblioitemnumber)
> WHERE p.categorycode=<> AND
> WHERE items.itype=<> AND
> WHERE old_issues.issuedate BETWEEN <> and
> <> ORDER BY old_issues.issuedate
>
> 
>
> With Thanks
> Satish MV
> Librarian
> Govt. Engineering College, Hassan
> Karnataka.
> www.gechassan.ac.in
> --
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] SQL Report-Circulation-- Help

[SATISH]

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 following report, with date range, am successful but when added
patron category and itemtype (last two line in WHERE section), it's failing.

Can someone help me to get this report or please correct me, if I am wrong
in the query??

--
SELECT borrowers.cardnumber, borrowers.surname,borrowers.firstname,
borrowers.streetnumber, borrowers.categorycode,items.barcode,
DATE_FORMAT(old_issues.issuedate, "%d %b %Y %h:%i %p") As issuedate,
DATE_FORMAT(old_issues.date_due,  "%d %b %Y %h:%i %p") As date_due,
DATE_FORMAT(old_issues.lastreneweddate, "%d %b %Y %h:%i %p") As
lastreneweddate,
DATE_FORMAT(old_issues.returndate, "%d %b %Y %h:%i %p") As returndate,
EXTRACTVALUE( b.marcxml, '//datafield[@tag="245"]/subfield[@code>="a"]' )
AS TITLE,
items.itype, items.location, items.ccode,items.itemcallnumber, items.price
FROM old_issues
LEFT JOIN borrowers ON ( borrowers.borrowernumber =
old_issues.borrowernumber )
LEFT JOIN items ON ( items.itemnumber = old_issues.itemnumber )
LEFT JOIN biblioitems AS b ON ( items.biblioitemnumber = b.biblioitemnumber)
WHERE p.categorycode=<> AND
WHERE items.itype=<> AND
WHERE old_issues.issuedate BETWEEN <> and
<> ORDER BY old_issues.issuedate


With Thanks
Satish MV
Librarian
Govt. Engineering College, Hassan
Karnataka.
www.gechassan.ac.in
--
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Amit Gupta]

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)" <
daniel.wal...@britishcouncil.org> wrote:

Dear Colleagues,

We are currently upgrading KOHA across our libraries.  Other than a change
in naming convention, are there any technical differences between 3.22 and
16.11?

Dan Walsh



The British Council is the United Kingdom's international organisation for
cultural relations and educational opportunities. A registered charity:
209131 (England and Wales) SC037733 (Scotland).
This message is for the use of the intended recipient(s) only and may
contain confidential information. If you have received this message in
error, please notify the sender and delete it.
The British Council accepts no liability for loss or damage caused by
viruses and other malware and you are advised to carry out a virus and
malware check on any attachments contained in this message.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha