Send Koha-devel mailing list submissions to
    koha-devel@lists.koha-community.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
    koha-devel-request@lists.koha-community.org

You can reach the person managing the list at
    koha-devel-owner@lists.koha-community.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."


Today's Topics:

1. Adding recent (current/past year) statistics to the items
table (Nick Clemens)
2. Re: Adding recent (current/past year) statistics to the items
table (Michael Hafen (TECH))


----------------------------------------------------------------------

Message: 1
Date: Fri, 22 Apr 2022 14:51:56 -0400
From: Nick Clemens <nick@bywatersolutions.com>
To: Koha Devel <koha-devel@lists.koha-community.org>, Koha
    <koha@lists.katipo.co.nz>
Subject: [Koha-devel] Adding recent (current/past year) statistics to
    the items table
Message-ID:
    <CAA_eX3NMs0Gx+2z_xYWvmy_3zq_5vJsnkmTS5RG68LCNxmNDmg@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Hi All,

We have had several requests recently for an easy way to access
current/last year's circulation stats for items, without having to create
reports totalling these numbers. The numbers here are used for weeding,
state reporting, etc.

Other systems have fields: 'Year to date circ' and 'last year circ'

We have discussed several possible developments:
- a new table to track these
- adding a new field, or altering 'issues' to use JSON and storing
circ/renewal counts by year
- adding two new fields to the items table and use a cronjob to move
'current year' circ to 'last years circ' at the end of the year.

We wanted to check in with the community to see if this is a request that
others have or have seen, and how they handle these.

Thanks for any info.
Nick (kidclamp)

--
Nick Clemens
ByWater Solutions
bywatersolutions.com
Phone: (888) 900-8944
Pronouns: (he/him/his)
Timezone: Eastern
Follow us:
<https://www.facebook.com/ByWaterSolutions/>
<https://www.instagram.com/bywatersolutions/>
<https://www.youtube.com/user/bywatersolutions>
<https://twitter.com/ByWaterSolution>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220422/b17c6437/attachment-0001.htm>

------------------------------

Message: 2
Date: Fri, 22 Apr 2022 13:32:33 -0600
From: "Michael Hafen (TECH)" <michael.hafen@washk12.org>
To: Nick Clemens <nick@bywatersolutions.com>
Cc: Koha Devel <koha-devel@lists.koha-community.org>, Koha
    <koha@lists.katipo.co.nz>
Subject: Re: [Koha-devel] Adding recent (current/past year) statistics
    to the items table
Message-ID:
    <CAAh7Ud=He2POBaBaULMF7OwGsM5v6n7H7-cK86fxFnZSmiK-fQ@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

I have schools using Koha here, and those are reports that my schools asked
for. I built reports for them, but Guided Reports could probably take care
of them too.

On Fri, Apr 22, 2022 at 12:52 PM Nick Clemens <nick@bywatersolutions.com>
wrote:

> Hi All,
>
> We have had several requests recently for an easy way to access
> current/last year's circulation stats for items, without having to create
> reports totalling these numbers. The numbers here are used for weeding,
> state reporting, etc.
>
> Other systems have fields: 'Year to date circ' and 'last year circ'
>
> We have discussed several possible developments:
> - a new table to track these
> - adding a new field, or altering 'issues' to use JSON and storing
> circ/renewal counts by year
> - adding two new fields to the items table and use a cronjob to move
> 'current year' circ to 'last years circ' at the end of the year.
>
> We wanted to check in with the community to see if this is a request that
> others have or have seen, and how they handle these.
>
> Thanks for any info.
> Nick (kidclamp)
>
> --
> Nick Clemens
> ByWater Solutions
> bywatersolutions.com
> Phone: (888) 900-8944
> Pronouns: (he/him/his)
> Timezone: Eastern
> Follow us:
> <https://www.facebook.com/ByWaterSolutions/>
> <https://www.instagram.com/bywatersolutions/>
> <https://www.youtube.com/user/bywatersolutions>
> <https://twitter.com/ByWaterSolution>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>


--
Michael Hafen
Washington County School District Technology Department
Systems Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220422/4cad254f/attachment-0001.htm>

------------------------------

Subject: Digest Footer

_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/


------------------------------

End of Koha-devel Digest, Vol 197, Issue 12
*******************************************