[Koha] Fwd: subject Shelflist card

[Nalisha Tamang]

-- Forwarded message -
From: Nalisha Tamang 
Date: Mon, Mar 15, 2021 at 12:19 PM
Subject: subject Shelflist card
To: , Koha 


dear all,
please help me to create subject shelflist card, the following things must
be included callnumber, barcode, author, title, place,publisher,date,
pages,subjects
eg.

Callnumber  Author
Barcode  Title, sub-title. Publication place:
   Publisher, year.
   page no.


1.subjects 2. Subjects



with thanks
Nalisha Tamang
___

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

[Koha] Time to translate: string freeze to prepare Koha 19.11.16 has begun

[Victor Grousset/tuxayo]

Hi, saluton, hola, bonjour,

String freeze is into effect as of now for the 19.11.x maintenance 
branch. The release is scheduled for around the 23th.


This means it's the right time to head over to the translation platform:
https://translate.koha-community.org/projects/

Reminder: if you add or change a translation in version 19.11,
then you must also copy it to 20.05 and 20.11. Otherwise your work will
be lost for future versions.


Happy translating,

--
Victor Grousset/tuxayo
___

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

[Koha] Koha service provider in Germany

[Anne Christensen]

Hello, Koha-Community,

I would like to introduce my company, effective WEBWORK, as a service
provider for Koha. We are a 12 enthusiastic software developers and
librarians with lots of experience working with open source software such as
VuFind, DSpace, Kitodo and others. We have recently started to provide
services for Koha – covering consultation work, implementation support, data
migration, customization and hosting. Among our first clients is the
European Institute for Gender Equality in Vilnius (Lithuania).

We are based in Hamburg, Germany and provide support in both German and
English.

Here are our contact details:

Company Name: effective WEBWORK GmbH
Location: Hamburg, Germany
Contact person: Ms Anne Christensen
Contact email: mailto:christen...@effective-webwork.de
Website: https://www.effective-webwork.de/loesungen-tools/koha/
Phone: +49 40 6094085794

We would very much like to added to the list of providers for paid support.

Kind regards
Anne

--
Anne Christensen
Gesellschafterin, Projektmanagement & Beratung
 
effective WEBWORK GmbH
Neuer Wall 18
20354 Hamburg
 
Telefon: +49 40 60940857-94
Telefax: +49 40 60940857- 1
 
E-Mail: christen...@effective-webwork.de
Blog: https://www.effective-webwork.de/blog/
ORCID: https://orcid.org/-0001-7753-1078
 
Handelsregister: HRB 101108 (Hamburg)
UStId: DE254169943


___

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

Re: [Koha] Koha 20.11 - RabbitMQ and lock_dir

[Tom Hanstra]

Thanks for the response, Johathan.

I figured out the lockdir issue. There was an ownership problem that I
could address.

For the RabbitMQ piece, I have a separate RabbitMQ server which I would
like to use. Where in the configuration files would I address setting this
to be a separate RabbitMQ server?  And then, something has to create the
initial setup on that server. What sets that all up? I am not finding that
documentation.

Thanks,
Tom

On Mon, Mar 15, 2021 at 4:49 AM Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> Hello Tom,
>
> - Which error do you have on the about page? Did you create the
> directory? Are the permissions correct?
> Did you restart memcached?
>
> - About RabbitMQ, it's not mandatory so far, there is a fallback to
> run the jobs when they are "enqueued".
> In 20.05 it's only used for the batch record modification tool, but it
> will be used for other background jobs in the upcoming versions.
> Its main goal is to avoid the different problems we have with the way
> we fork background jobs in the current implementation (see 22417
> related bug reports) and have them executed by a worker script.
> To have RabbitMQ works it should be as easy as
> rabbitmq-plugins enable rabbitmq_stomp
> service rabbitmq-server restart
>
>
> Let me know if you have additional questions.
>
> Regards,
> Jonathan
>
> Le ven. 12 mars 2021 à 20:51, Tom Hanstra  a écrit :
> >
> > After our upgrade to Koha 20.11, we have noticed a couple of errors. I'm
> > trying to track them down and understand the changes.
> >
> > - lockdir in XML configuration file
> >
> > I get a warning about lockdir missing from the XML file, even after
> adding
> > the line. I added:
> >
> >  /var/lock/koha
> >
> > to my /etc/koha-conf.xml file but the error is still showing up in the
> > About Koha screen. Do I have to do something to clear it? Or did I
> > miss something?
> >
> > - RabbitMQ as message broker
> >
> > Reading the documentation, the addition of RabbitMQ as a message broker
> is
> > specifically done for PLACK. Do I really have to set up a local RabbitMQ
> or
> > is there another workaround? What am I gaining that did not work before?
> > Because adding another little piece of software is a bit of hassle.
> >
> > If it is needed, where do I find documentation on setup?  The Wiki has
> > nothing that I found to be worthwhile. And if it is not (yet) needed,
> then
> > how do I remove the error?
> >
> > Thanks,
> > Tom
> > --
> > *Tom Hanstra*
> > *Sr. Systems Administrator*
> > hans...@nd.edu
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
*Tom Hanstra*
*Sr. Systems Administrator*
hans...@nd.edu
___

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

Re: [Koha] Regarding query output from sql reports -

[Suresh Kumar Tejomurtula]

Dear Katrin,

Iam using 16.05 version. Let me know if any correction is required any
settings if I change this issue can be resolved.

I have same issue on another test database with 18.11 too.

Regards
Suresh Kumar


On Sat, Mar 13, 2021, 17:57 Katrin Fischer  wrote:

> Hi Suresh,
>
> which Koha version are you seeing this in?
>
> Katrin
>
> On 12.03.21 14:03, Suresh Kumar Tejomurtula wrote:
> > Dear all,
> >
> > When I download a report from koha reports, if any title or any other
> > field having "&" in the field, the CSV will have "" in the output
> > instead of "&".
> > I generally manually edit the exported data and correct "" to "&".
> >
> > Is there any way to overcome this issue automatically?
> >
> > -
> > Regards
> > T. Suresh Kumar
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha 20.11 - RabbitMQ and lock_dir

[Jonathan Druart]

Hello Tom,

- Which error do you have on the about page? Did you create the
directory? Are the permissions correct?
Did you restart memcached?

- About RabbitMQ, it's not mandatory so far, there is a fallback to
run the jobs when they are "enqueued".
In 20.05 it's only used for the batch record modification tool, but it
will be used for other background jobs in the upcoming versions.
Its main goal is to avoid the different problems we have with the way
we fork background jobs in the current implementation (see 22417
related bug reports) and have them executed by a worker script.
To have RabbitMQ works it should be as easy as
rabbitmq-plugins enable rabbitmq_stomp
service rabbitmq-server restart


Let me know if you have additional questions.

Regards,
Jonathan

Le ven. 12 mars 2021 à 20:51, Tom Hanstra  a écrit :
>
> After our upgrade to Koha 20.11, we have noticed a couple of errors. I'm
> trying to track them down and understand the changes.
>
> - lockdir in XML configuration file
>
> I get a warning about lockdir missing from the XML file, even after adding
> the line. I added:
>
>  /var/lock/koha
>
> to my /etc/koha-conf.xml file but the error is still showing up in the
> About Koha screen. Do I have to do something to clear it? Or did I
> miss something?
>
> - RabbitMQ as message broker
>
> Reading the documentation, the addition of RabbitMQ as a message broker is
> specifically done for PLACK. Do I really have to set up a local RabbitMQ or
> is there another workaround? What am I gaining that did not work before?
> Because adding another little piece of software is a bit of hassle.
>
> If it is needed, where do I find documentation on setup?  The Wiki has
> nothing that I found to be worthwhile. And if it is not (yet) needed, then
> how do I remove the error?
>
> Thanks,
> Tom
> --
> *Tom Hanstra*
> *Sr. Systems Administrator*
> hans...@nd.edu
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Problem with some SQL

[Sebastian Krieg]

Hello,

Try this to combine the query and exp2 and exp3:

SELECT []
FROM []
WHERE
exp1 
AND
(exp2 OR exp3)
ORDER by []
;

I hope this works, I got no error executing this query in my database...

Thanks

Sebastian


> Carlos Lopez  hat am 15.03.2021 06:33 geschrieben:
> 
>  
> Hi everyone
> 
> I have the following reports that I would like to combine into one:
> 
> SELECT categories.description, COUNT(borrowers.borrowernumber)
> FROM borrowers, categories
> WHERE borrowers.categorycode = categories.categorycode
> AND borrowers.date_renewed BETWEEN <> 
> AND <>
> GROUP BY borrowers.categorycode
> 
> (count the number of borrower renewals between 2 given dates and provide a 
> breakdown by borrower category)
> 
> And
> 
> SELECT categories.description, COUNT(borrowers.borrowernumber)
> FROM borrowers, categories
> WHERE borrowers.categorycode = categories.categorycode
> AND borrowers.dateenrolled BETWEEN <> 
> AND <>
> GROUP BY borrowers.categorycode
> 
> (same thing but for new enrolments rather than renewals)
> 
> What I would like is a report that will give me 3 columns: Borrower category 
> (from categories.description), a count of newly-enrolled borrowers, and a 
> count of renewed borrowers, with a breakdown by borrower category, but I only 
> want the user to have to enter a single starting date and a single end date 
> (not 2 identical date ranges).
> 
> I tried to run this one but it looks as though we're not allowed to set 
> variables before the SELECT statement:
> 
> SET @start_date = <>
> SET @end_date = <>
> SELECT categories.description AS "BORROWER CATEGORY",
> SUM(CASE WHEN borrowers.dateenrolled BETWEEN @start_date AND @end_date THEN 1 
> ELSE 0) NewBorrowers,
> SUM(CASE WHEN borrowers.date_renewed BETWEEN @start_date AND @end_date THEN 1 
> ELSE 0) RenewedBorrowers
> FROM borrowers, categories
> WHERE borrowers.categorycode = categories.categorycode
> GROUP BY borrowers.categorycode
> 
> Is something like what I'm trying to do even possible on Koha, or should I be 
> happy with my 2 reports?
> 
> With kind regards from the Dalton McCaughey Library Team
> 
> Carlos Lopez
> 
> Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052
> Ph: 03 9340  ext.1 | 
> libr...@dml.vic.edu.au | 
> library.dmlibrary.org.au
> 
> ___
> 
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

___ 
mailto:sebastian.kr...@tuz-eisenach.de
___

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

[Koha] subject Shelflist card

[Nalisha Tamang]

dear all,
please help me to create subject shelflist card, the following things must
be included callnumber, barcode, author, title, place,publisher,date,
pages,subjects
eg.

Callnumber  Author
Barcode  Title, sub-title. Publication place:
   Publisher, year.
   page no.


1.subjects 2. Subjects



with thanks
Nalisha Tamang
___

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