Re: [Koha] subscription delete

[vikram zadgaonkar]

Hello,
What error your getting?
Vikram Zadgaonkar


On Thu, Sep 5, 2019 at 9:55 AM Nalisha Tamang  wrote:

> Dear all,
> Please help me to delete the serial subscription, i tried to delete the
> subscription but it didn't work, it is still there.
> Thanks
> with regards
> Nalisha Tamang Rai
> ___
> 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] subscription delete

[Nalisha Tamang]

Dear all,
Please help me to delete the serial subscription, i tried to delete the
subscription but it didn't work, it is still there.
Thanks
with regards
Nalisha Tamang Rai
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Deleted biblio still appearing in search results staff interface

[Elaine Bradtke]

We're running 19:05.02

The problem is with Biblio 13267   A selection of some less known folk
songs, vol. 2

and related name authority record 1493 Winn, Cyril

In the staff interface, if Winn, Cyril is used as a search term, the
results include  A selection of some less known folk songs, vol. 2

-
biblio 13267. It shouldn't be there, it's been deleted.
When the title is clicked on, the answer is: The record you requested does
not exist (13267).

In the OPAC (https://catalogue.efdss.org) when we search on the title, A
selection of some less known folk songs, vol. 2

or
the name Winn, Cyril, or the biblio number the answer that comes up is:

Internal Server Error

We've run a zebra index and it didn't make any difference.
Any ideas on what's causing the problem? Where we should look?
I just did a couple batch edits and uploads, but this particular record was
not in either of those batches.

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha Items Not Displayed in Intranet Search (Not Zebra?)

[JStall]

I am running version 17.11.01.000, Jessie, with no warnings displayed. I have
made no recent changes to the system other than regular cataloging.

For the past two days I have been unable to search our records.

Zebra index seems to be working, since the record data is populating facets
(see https://pasteboard.co/IvUAC17.png), even for newly cataloged items, but
searches will not return a list of records. Searching for a specific title
should return the individual record page, but instead it fails to add the
bibnumber to the individual record URL. This leads to "The record you
requested does not exist ()." If I enter a bibnumber manually, the item page
loads normally.

Clip of opac-error.log: https://pastebin.com/cQyY7WGf.

Also, main section of OPAC gives 403 error, no search results returned at
all from the public side.

All xlst is disabled.

Any suggestions about where to look are greatly appreciated!



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] how to enable elasticsearch koha library 19.05 in Ubuntu?

[Victor Barroso Oliveira]

Good night
how to enable elasticsearch koha library 19.05 in Ubuntu?

thank you

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

Re: [Koha] Top 10 Circulating Books

[Cab Vinton]

Try this --

SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode
FROM statistics s
JOIN items i ON (i.itemnumber=s.itemnumber)
LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber)
WHERE s.datetime BETWEEN <> AND <>
AND s.itemnumber IS NOT NULL AND s.type IN ('issue','renew') AND
i.homebranch=<>
GROUP BY b.biblionumber
ORDER BY circs DESC LIMIT 10

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH

On Fri, Aug 30, 2019 at 4:26 AM Ma. Victoria H. Silva-Manuel
 wrote:
>
> HI.
>
> I got the SQL report below to generate the top 10 circulating books from
> koha-community.
>
> SELECT count(s.datetime) AS circs, b.title, b.author,
>i.ccode FROM statistics sJOIN items i ON
> (i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON
> (b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) >
> DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH)
>   AND DATE(s.datetime)<=CURRENT_DATE() AND
>   s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY
> b.biblionumber ORDER BY circs DESC LIMIT 10
>
>
> How can we add date range and branch filter?
>
> Thank you.
>
> --
> Ma. Victoria H. Silva-Manuel
> Registered Librarian, 3892
> ___
> 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] Koha calculating but not showing overdue fines

[muirunyeri]

Hi,
I thank you Katrin for your advise on my problem.
Koha was installed online following the installation procedure availed in 
kohageek blog.
How or where do I set the holdingbranch? 
Kindly give me more guidance on this please.
Thanks for your forbearance.
Regards.


Sent from my Samsung Galaxy smartphone. Original message From: 
Katrin Fischer  Date: 01/09/2019  21:36  (GMT+03:00) 
To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha calculating but not 
showing overdue fines 
Hi,

just in case: you should also set the holdingbranch of your items.

if the fine is calculated on return, but not appearing overnight on the
patron account, the next thing you need to check is that the fines.pl
cronjob is scheduled and running.

How to do that depends a bit on how you installed Koha.

Hope this helps,

Katrin

On 25.08.19 07:24, muiru james wrote:
> Hi,
>
> My system is now calculating overdue fines after setting the homelibrary
> field but its only after checking in the overdue item that you can see the
> amount of fine. On the patrons account, its only showing the user as having
> overdue items but not showing what amount of fine has accrued. What can I
> do for  the amount accrued to be shown even while the item is still checked
> out?
>
> Someone please help
>
> Thank you
>
> Best Regards
>
> On Wed, 21 Aug 2019 10:59 muirunyeri 
>> Hi,
>>
>> While Koha is now calculating fines, its only possible to see the fine
>> after item checkin. Its only showing a user as having overdue items but no
>> amount of fine accrued before checkin. What can be done to show on the
>> screen the amount accrued even while the item is still checked out?
>>
>> Best Regards
>>
>>
>>
>> Sent from my Samsung Galaxy smartphone.
>>  Original message 
>> From: muirunyeri 
>> Date: 16/08/2019 14:12 (GMT+03:00)
>> To: Alvaro Cornejo , koha@lists.katipo.co.nz
>> Subject: Re: [Koha] Koha Not calculating and charging overdue fines
>>
>> Hi,
>>
>> Thanks Alvaro. The code worked and now overdue is calculating
>>
>> Best regards
>>
>>
>>
>> Sent from my Samsung Galaxy smartphone.
>>  Original message 
>> From: Alvaro Cornejo 
>> Date: 15/08/2019 16:42 (GMT+03:00)
>> To: muirunyeri 
>> Cc: Carlos Lopez , koha@lists.katipo.co.nz
>> Subject: Re: [Koha] Koha Not calculating and charging overdue fines
>>
>> Hi Muirunyeri
>>
>> You can access mysql and run a command like:
>>
>>
>> UPDATE `items` SET `homebranch` = `YourHomeBranchID' [WHERE homebranch is 
>> NULL];
>>
>> As you will be editing your database directly, you should backup your
>> system before.
>>
>> Regards,
>>
>> Alvaro
>>
>>
>> |-|
>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
>> celular y Nextel
>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
>> y GPRS online
>>    Visitenos en www.perusms.com
>>
>>
>> Le jeu. 15 août 2019 à 01:54, muirunyeri  a écrit :
>>
>>> Hi Carlos,
>>> I ran the report which returns a single column with item numbers. It
>>> indeed confirms all items are without home branch. However, no batch
>>> editing option.
>>> Any assistance to solve this is highly appreciated.
>>> Thanks
>>>
>>> Sent from my Samsung Galaxy smartphone. Original message
>>> From: Carlos Lopez  Date: 15/08/2019
>>> 02:02  (GMT+03:00) To: muirunyeri ,
>>> koha@lists.katipo.co.nz Subject: RE: [Koha] Fwd:Re:  Koha Not
>>> calculating and charging overdue fines
>>> Hi Muirunyeri
>>> If the homebranch field is empty, you could run a report from this query:
>>>  SELECT itemnumber
>>>  FROM items
>>>  WHERE homebranch is NULL
>>>
>>> You should even get a little "Batch modify" button at the top of your
>>> results.
>>>
>>> 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
>>>
>>> -Original Message-
>>> From: Koha  On Behalf Of muirunyeri
>>> Sent: Thursday, 15 August 2019 5:56 AM
>>> To: koha@lists.katipo.co.nz
>>> Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines
>>>
>>>
>>>
>>>
>>>
>>> Sent from my Samsung Galaxy smartphone. Original message
>>> From: muirunyeri  Date: 14/08/2019  22:54
>>> (GMT+03:00) To: katrin.fischer...@web.de Subject: Re: Re: [Koha] Koha
>>> Not calculating and charging overdue fines
>>> Hi,
>>>
>>> I have around 44,000 items that were imported from excel. The homebranch
>>> field is blank and this might be the cause if the non-calculating overdue
>>> fines. How can i edit items to fill this field (batch)? The homebranch
>>> field is not available on the items form. If its hidden, how can I unhide
>>> it?
>>>
>>> You could also give me an SQL code if it'll get the
>>
>>>