[Koha] Koha reports wiki

Discussion:

Cab Vinton

2018-07-19 12:01:01 UTC

Hi, All --

Apologies for the cross-posting.

The clean up of the Reports wiki page appears to have got stalled out:
https://wiki.koha-community.org/wiki/SQL_Reports_Library

(Large no. of duplicate listings of reports for holds, patrons, &
circulation (HPC), which also appear on corresponding pages --
https://wiki.koha-community.org/wiki/SQL_Reports_Holds, etc.)

I've identified the reports on the main page that aren't cross-listed
(19 in total). I'd like to relocate these & then delete all the
listings under the HPC categories on the main page.

I suspect these pages see a lot of use, however, so I don't want to
barge in and inadvertently make things worse.

Anything I should be aware of before jumping in?

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https:/

Barton Chittenden

2018-07-19 13:56:43 UTC

Permalink

Cab,

the reports wiki is in a state of benign neglect, because of development of
_mana_, which will create a way for reports to be shared to and imported
from a central server.

See

https://wiki.koha-community.org/wiki/Recommendation_engine_integrated_with_Mana_project_RFC

https://wiki.koha-community.org/wiki/Mana_central_database

Bug 17047 - Mana Knowledge Base : share data (
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047).

We're still adding queries to the report library and fixing reports as we
find out that they're broken, but we haven't bulk updated the reports to
reflect the biblioitems.marcxml -> biblio_metadata.metadata move in 17.05
for instance.

Bug 17047 is currently signed off; if you logged in and added a comment to
the QA team that this was a priority (and possibly also added a vote (next
to 'importance' on the bug page), that would help move things along. :-)

--Barton

Post by Cab Vinton
Hi, All --
Apologies for the cross-posting.
https://wiki.koha-community.org/wiki/SQL_Reports_Library
(Large no. of duplicate listings of reports for holds, patrons, &
circulation (HPC), which also appear on corresponding pages --
https://wiki.koha-community.org/wiki/SQL_Reports_Holds, etc.)
I've identified the reports on the main page that aren't cross-listed
(19 in total). I'd like to relocate these & then delete all the
listings under the HPC categories on the main page.
I suspect these pages see a lot of use, however, so I don't want to
barge in and inadvertently make things worse.
Anything I should be aware of before jumping in?
All best,
Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
_______________________________________________
Koha-devel mailing list
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katipo.co.nz/mai

Cab Vinton

2018-07-19 15:43:14 UTC

Permalink

Thank you, Barton.

I'm not totally clear on the future status of the Reports wiki. Is the
idea that it would be completely replaced by the Mana KB?

The wiki is very easy to use & I suspect a resource that many
librarians besides myself find very valuable (including librarians
using non-standard versions of Koha).

Mana may prove to be the same, but I don't think I have an easy way to
review what it will look like, or what it looks like in its current
state ...

So my initial thought is to just proceed w/ these relatively trivial
edits to the wiki. Will certainly hold off, though, if there's
consensus that it's a waste of time :-)

Cheers,

Cab

On Thu, Jul 19, 2018 at 9:56 AM, Barton Chittenden

Post by Barton Chittenden
Cab,
the reports wiki is in a state of benign neglect, because of development of
_mana_, which will create a way for reports to be shared to and imported
from a central server.
See
https://wiki.koha-community.org/wiki/Recommendation_engine_integrated_with_Mana_project_RFC
https://wiki.koha-community.org/wiki/Mana_central_database
Bug 17047 - Mana Knowledge Base : share data
(https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047).
We're still adding queries to the report library and fixing reports as we
find out that they're broken, but we haven't bulk updated the reports to
reflect the biblioitems.marcxml -> biblio_metadata.metadata move in 17.05
for instance.
Bug 17047 is currently signed off; if you logged in and added a comment to
the QA team that this was a priority (and possibly also added a vote (next
to 'importance' on the bug page), that would help move things along. :-)
--Barton

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://

Cab Vinton

2018-07-20 20:21:34 UTC

Permalink

Hi, All --

All Holds, Patrons, & Circulation reports have been copied over from
the main wiki reports page to the appropriate dedicated page.

I believe it should now be safe to delete these sections from the main
page (sections 2, 3, & 4, respectively). This should free up quite a
bit of space.

The links to the Holds, Patrons, & Circulation Reports pages will of
course remain at the top of the main page.

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katipo.co.nz/ma

Barton Chittenden

2018-07-21 17:52:41 UTC

Permalink

Post by Cab Vinton
Hi, All --
All Holds, Patrons, & Circulation reports have been copied over from
the main wiki reports page to the appropriate dedicated page.
I believe it should now be safe to delete these sections from the main
page (sections 2, 3, & 4, respectively). This should free up quite a
bit of space.

If you click into those sections, You'll see that each query has been
replaced by a link to the respective query on the Holds, Patrons and
Circulation page -- this means that if people have links bookmarked,
they'll get people to a link to the right page, but the queries are no
longer duplicated -- we may want to change the page so that we use anchors
rather than headers so that the individual queries don't show up in the
table of contents on the main page.

I think that we should also put a "Works in version" row in the template.
That will help some just to show the marcxml -> metadata queries. (there
was also a change in 17.11 -- statistics now has a location field, this
breaks queries that use location but don't specify the table).
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
http

Cab Vinton

2018-07-21 18:19:15 UTC

Permalink

Post by Barton Chittenden
If you click into those sections, You'll see that each query has been
replaced by a link to the respective query on the Holds, Patrons and
Circulation page -- this means that if people have links bookmarked, they'll
get people to a link to the right page, but the queries are no longer
duplicated -- we may want to change the page so that we use anchors rather
than headers so that the individual queries don't show up in the table of
contents on the main page.

The new Holds/ Patrons/ Circ pages have a number of queries not on the
main page, & until I moved them over, there were 20 or so queries on
the main page that weren't on the HPC pages.

In other words, it was a mess. I think it's a bad idea to continue to
have 2 locations for the same queries. Actually, it seems rather
pointless. The Note at the top of the main page asks folks to add new
queries to the appropriate HPC page, but that clearly was not
happening consistently. Bookmarks can & should be updated, & I think
most users would prefer to have a single site to search.

If the HPC sections are not deleted from the main page, within a few
months there'll just be another mess, w/ queries on one page, but not
the other. In addition, if the queries are on a dedicated page there's
one fewer outline level to deal with.

Post by Barton Chittenden
I think that we should also put a "Works in version" row in the template.
That will help some just to show the marcxml -> metadata queries. (there was
also a change in 17.11 -- statistics now has a location field, this breaks
queries that use location but don't specify the table).

Sounds good. Not sure where the template lives, however.

Cab Vinton, Director
Plaistow Public Library
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https:/

Barton Chittenden

2018-07-21 21:42:16 UTC

Permalink

I agree entirely about the duplication, I'm not a fan.

I think that someone had filled in the template with a real report; I
edited it and made it generic:

https://wiki.koha-community.org/wiki/SQL_Reports_Library#SQL_Report_Template

Post by Barton Chittenden

they'll

Post by Barton Chittenden
get people to a link to the right page, but the queries are no longer
duplicated -- we may want to change the page so that we use anchors

rather

Post by Barton Chittenden
than headers so that the individual queries don't show up in the table of
contents on the main page.

The new Holds/ Patrons/ Circ pages have a number of queries not on the
main page, & until I moved them over, there were 20 or so queries on
the main page that weren't on the HPC pages.
In other words, it was a mess. I think it's a bad idea to continue to
have 2 locations for the same queries. Actually, it seems rather
pointless. The Note at the top of the main page asks folks to add new
queries to the appropriate HPC page, but that clearly was not
happening consistently. Bookmarks can & should be updated, & I think
most users would prefer to have a single site to search.
If the HPC sections are not deleted from the main page, within a few
months there'll just be another mess, w/ queries on one page, but not
the other. In addition, if the queries are on a dedicated page there's
one fewer outline level to deal with.

Post by Barton Chittenden
I think that we should also put a "Works in version" row in the template.
That will help some just to show the marcxml -> metadata queries. (there

was

Post by Barton Chittenden
also a change in 17.11 -- statistics now has a location field, this

breaks

Post by Barton Chittenden
queries that use location but don't specify the table).

Sounds good. Not sure where the template lives, however.
Cab Vinton, Director
Plaistow Public Library
_______________________________________________
Koha-devel mailing list
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https

Cab Vinton

2018-07-22 18:53:06 UTC

Permalink

All Holds, Patrons, and Circulation queries are now on their
respective dedicated pages.

I've also made a first attempt at adding subheadings to the Catalog/
Bibliographic Reports.

There are 140 of these, so a separate page may make sense for these
queries as well. (By way of comparison, there are only 29 Holds and 50
Patrons queries.)

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH

Barton Chittenden

2018-07-21 17:39:24 UTC

Permalink

I spoke briefly with Katrin (cait) in IRC, she's of the opinion that there
will be a number of libraries that won't be able to use mana -- either for
policy or technical reasons. I think she has a good point, and I expect
that even after mana is operational, the SQL Reports Library on the Koha
wiki will continue to live on. These are definitely valid points.

At the same time, mana may also be useful in the cleanup process. My
general feeling is that we should keep cleaning up the reports library as
we find broken queries and such, but maybe wait on a full-bore cleanup
until mana is in place.

Post by Cab Vinton
Thank you, Barton.
I'm not totally clear on the future status of the Reports wiki. Is the
idea that it would be completely replaced by the Mana KB?
The wiki is very easy to use & I suspect a resource that many
librarians besides myself find very valuable (including librarians
using non-standard versions of Koha).
Mana may prove to be the same, but I don't think I have an easy way to
review what it will look like, or what it looks like in its current
state ...
So my initial thought is to just proceed w/ these relatively trivial
edits to the wiki. Will certainly hold off, though, if there's
consensus that it's a waste of time :-)
Cheers,
Cab
On Thu, Jul 19, 2018 at 9:56 AM, Barton Chittenden

Post by Barton Chittenden
Cab,
the reports wiki is in a state of benign neglect, because of development

Post by Barton Chittenden
_mana_, which will create a way for reports to be shared to and imported
from a central server.
See
https://wiki.koha-community.org/wiki/Recommendation_

engine_integrated_with_Mana_project_RFC

Post by Barton Chittenden
https://wiki.koha-community.org/wiki/Mana_central_database
Bug 17047 - Mana Knowledge Base : share data
(https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047).
We're still adding queries to the report library and fixing reports as we
find out that they're broken, but we haven't bulk updated the reports to
reflect the biblioitems.marcxml -> biblio_metadata.metadata move in 17.05
for instance.
Bug 17047 is currently signed off; if you logged in and added a comment

Post by Barton Chittenden
the QA team that this was a priority (and possibly also added a vote

(next

Post by Barton Chittenden
to 'importance' on the bug page), that would help move things along. :-)
--Barton

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.kat