Hello pls i need ur help, can anyone help me out, i want an sql query for
report to generate the number of books calalogued by all librarians, but i am
finding it difficult becos acquisition librarian is always the one entering the
biblio in our case since all materials must pass through acquisitions.
I am using Koha 18.11 on Debian 9
thanks
On Thursday, April 25, 2019, 1:14:24 AM GMT+1,
koha-requ...@lists.katipo.co.nz <koha-requ...@lists.katipo.co.nz> wrote:
This message is eligible for Automatic Cleanup!
(koha-requ...@lists.katipo.co.nz) Add cleanup rule | More info
Send Koha mailing list submissions to
koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz
You can reach the person managing the list at
koha-ow...@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."
Today's Topics:
1. Clear Holiday Calendar (Charles Kelley)
2. Re: Clear Holiday Calendar (Owen Leonard)
3. Re: Clear Holiday Calendar (Alvaro Cornejo)
4. Re: Koha 17.05 randomly repeating an earlier transaction.
(Jonathan Druart)
----------------------------------------------------------------------
Message: 1
Date: Wed, 24 Apr 2019 22:27:53 +0900
From: Charles Kelley <cmkelley...@gmail.com>
To: Discussion Group Koha <koha@lists.katipo.co.nz>
Subject: [Koha] Clear Holiday Calendar
Message-ID:
<CAM8F7wrYBRiSk=gvlcpjlgguopheqt0o_-vkceqzntdj5ah...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Hello, all
I made an irrecoverable error when I made a holiday for U.S. Memorial
Day: I made the holiday perpetual on everyday. Now I cannot delete the
holiday. How do I clear this? It's a demo, so no great harm has been done.
But I don't want to reload the demo from scratch.
If there is no way to clear the holiday calendar, then I have a feature
request into Koha developers.
Thank you for your help in this matter.
--
-- Charles.
Charles Kelley, MLS
PSC 704 Box 1029
APO AP 96338
1-301-741-7122 [US cell]
011-80-81-4714-5490 [JPN cell]
mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
Meeting Your Information Needs. Virtually.
------------------------------
Message: 2
Date: Wed, 24 Apr 2019 09:46:16 -0400
From: Owen Leonard <oleon...@myacpl.org>
To: Discussion Group Koha <koha@lists.katipo.co.nz>
Subject: Re: [Koha] Clear Holiday Calendar
Message-ID:
<CAO4qe2N71Uc49WrE9-fQuOZWnHfLhWrGRO44qj-R_vuwdZ8F=w...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
> Now I cannot delete the holiday.
Do you not see how to delete the holiday or are you trying to delete
and it isn't working? If it is the latter, is there some error message
associated with the failure?
-- Owen
--
Web Developer
Athens County Public Libraries
https://www.myacpl.org
------------------------------
Message: 3
Date: Wed, 24 Apr 2019 08:55:11 -0500
From: Alvaro Cornejo <cornejo.alv...@gmail.com>
To: Charles Kelley <cmkelley...@gmail.com>
Cc: Discussion Group Koha <koha@lists.katipo.co.nz>
Subject: Re: [Koha] Clear Holiday Calendar
Message-ID:
<CAO55aG8jotaYqteLaXQb31-uagD1g1-v3R4DT4Oi3woXSB==d...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Hi Charles
If the holiiday editor does not work you can manually edit the database.
There are two holliday related tables: special_holidays
<http://schema.koha-community.org/18_11/tables/special_holidays.html> and
repeatable_holidays
<http://schema.koha-community.org/18_11/tables/repeatable_holidays.html> you
can access them an delete the faulty record manually.
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 mer. 24 avr. 2019 à 08:29, Charles Kelley <cmkelley...@gmail.com> a
écrit :
> Hello, all
>
> I made an irrecoverable error when I made a holiday for U.S. Memorial
> Day: I made the holiday perpetual on everyday. Now I cannot delete the
> holiday. How do I clear this? It's a demo, so no great harm has been done.
> But I don't want to reload the demo from scratch.
>
> If there is no way to clear the holiday calendar, then I have a feature
> request into Koha developers.
>
> Thank you for your help in this matter.
>
> --
> -- Charles.
>
> Charles Kelley, MLS
> PSC 704 Box 1029
> APO AP 96338
>
> 1-301-741-7122 [US cell]
> 011-80-81-4714-5490 [JPN cell]
>
> mnogoja...@aol.com [h]
> cmkelley...@gmail.com [p]
>
> linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls>
> Meeting Your Information Needs. Virtually.
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
------------------------------
Message: 4
Date: Wed, 24 Apr 2019 19:04:39 -0400
From: Jonathan Druart <jonathan.dru...@bugs.koha-community.org>
To: Raymund Delahunty <r.delahu...@arts.ac.uk>
Cc: koha <koha@lists.katipo.co.nz>
Subject: Re: [Koha] Koha 17.05 randomly repeating an earlier
transaction.
Message-ID:
<CAJzKNY4G4EbipzBHX=d-johfjh6_yuvcws4ze1fr0eayu-w...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Hi Raymund,
I would also check the access logs around this timestamp.
Regards,
Jonathan
Le ven. 12 avr. 2019 à 03:29, Raymund Delahunty
<r.delahu...@arts.ac.uk> a écrit :
>
> We have recently had two examples of what appears to be Koha issuing an item
> to a reader “by itself” without any staff member doing the operation. Both
> took place at the same library site, and same issue desk, but different staff
> users logged on. We are multi-site, multi-issue desk, with heavy use of
> self-issue, but the problem is only reported (so far) using Circulation (so
> no SIP2 traffic), and at the one location. Yesterday we received this:
> “This morning Koha decided to randomly issue an item to a student. The
> student wasn't present- she only emailed us once she had automatic
> notification of her borrowing the item. The item was issued at 10:13 today.
> This never happened. We still have the item in our cupboard. It looks like
> Koha duplicated the student's previous transaction that had taken place a
> couple of days earlier. Neither of us on the desk issued the item, or
> remember anything unusual. Could it be that when we logged into Koha, it had
> that transaction still in its memory somehow????”)
> Our support company have advised: “We have investigated this transaction in
> the logs but there isn't anything to indicate what might have happened. It
> is recorded as a checkout in the standard way.
> | 29319123 | 2019-04-09 10:13:04 | 341304 | CIRCULATION | ISSUE | 370312 |
> 1407873
> I'm afraid there isn't very much more we can do regarding this […]”
> The previous example was sort-of similar- a laptop was returned by a user and
> it was *immediately* issued to a staff member who had borrowed (and returned)
> the item *the previous day*. She immediately complained that she was at her
> office, and away from the library, and had NOT borrowed the laptop.
> Has anyone experience this? Any ideas what we should look for? Thanks for any
> suggestions.
> Ray Delahunty
> University of the Arts London
> This email and any attachments are intended solely for the addressee and may
> contain confidential information. If you are not the intended recipient of
> this email and/or its attachments you must not take any action based upon
> them and you must not copy or show them to anyone. Please send the email back
> to us and immediately and permanently delete it and its attachments. Where
> this email is unrelated to the business of University of the Arts London or
> of any of its group companies the opinions expressed in it are the opinions
> of the sender and do not necessarily constitute those of University of the
> Arts London (or the relevant group company). Where the sender's signature
> indicates that the email is sent on behalf of UAL Short Courses Limited the
> following also applies: UAL Short Courses Limited is a company registered in
> England and Wales under company number 02361261. Registered Office:
> University of the Arts London, 272 High Holborn, London WC1V 7EY
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Subject: Digest Footer
_______________________________________________
Koha mailing list
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 162, Issue 21
*************************************
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
