[Bug 16122] New: Item record needs to keep Local Use count

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] New: Item record needs to keep Local Use count

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

            Bug ID: 16122
           Summary: Item record needs to keep Local Use count
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Circulation
          Assignee: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]
                CC: [hidden email], [hidden email]

Like the "issues" field in the items table, there should be a field for
"local_use" to keep the count of local uses.  While this information is kept in
the statistics table, it is a task to acquire, and if a library wants to keep
bloat down on their tables, the statistics are pruned on a regular schedule,
which means loss of valuable data.  This counter would keep that valuable
information in one field in each item record, rather than having a separate
field for each instance in the statistics table.

Unless it is vital to someone to know the exact moment a local use occurred, I
am suggesting that this piece of information not be recorded in the statistics
table any longer.  This would significantly reduce the growth of the statistics
table in general.

Christopher

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

Katrin Fischer <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from Katrin Fischer <[hidden email]> ---
I think an option would be ok, but I am against removing it - the local use
information in statistics will allow to look up the timeframe (local uses in
the last x months, years...) which is useful information.

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

--- Comment #2 from Christopher Brannon <[hidden email]> ---
Perhaps a switch to turn the statistic on/off?  But add the counter to the
record.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

--- Comment #3 from Katrin Fischer <[hidden email]> ---
Could work :)

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

Andrew <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #4 from Andrew <[hidden email]> ---
I absolutely agree if would be handy to have a local use number in the record
-- and then to show that number on moredetail.pl.

But I also agree with Katrin that I don't see why we would remove those
transactions from the statistics table.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

--- Comment #5 from Christopher Brannon <[hidden email]> ---
Read the second paragraph.  It addresses this question.

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

--- Comment #6 from Katrin Fischer <[hidden email]> ---

My feeling is that a simple counter loses meaning the longer you keep the data.

What's better? 5 local uses in 10 years or 5 in one? With a simple counter,
there is no way to tell. I think issues might give an indicator about 'use' of
the book (when you might want to replace it), but not sure the local_use is
interesting in the same way.

That said, we could split the circulation log preference to not record.

Is the size of the data in statistics really that much of an issue? I seem to
remember that some libraries have kept their data without pruning ever and have
to say we don't prune either and have some systems running for almost 10 years
now. It's only used for statistics, so it doesn't slow anything down.

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 16122] Item record needs to keep Local Use count

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16122

--- Comment #7 from Christopher Brannon <[hidden email]> ---
The bigger the system, the more data you have to sift through, and it can make
reports very sluggish.

I'd be fine if it were kept in the logs, if there were some mechanism that
could prune the logs of items that are deleted, and the pruning could be fine
tuned as needed.

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/