Koha reports wiki

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

Koha reports wiki

Cab Vinton
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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

barton
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



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

On Thu, Jul 19, 2018 at 8:01 AM, Cab Vinton <[hidden email]> wrote:
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-devel mailing list
[hidden email]
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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

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
<[hidden email]> wrote:

> 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
>
> On Thu, Jul 19, 2018 at 8:01 AM, Cab Vinton <[hidden email]> wrote:
>>
>> 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-devel mailing list
>> [hidden email]
>> 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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

Bob Birchall @ Calyx
I visit the wiki page frequently. I've never used Mana.
Fwiw,
Bob

On 20/07/18 01:43, Cab Vinton wrote:

> 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
> <[hidden email]> wrote:
>> 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
>>
>> On Thu, Jul 19, 2018 at 8:01 AM, Cab Vinton <[hidden email]> wrote:
>>> 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-devel mailing list
>>> [hidden email]
>>> 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-devel mailing list
> [hidden email]
> 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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

Cab Vinton
In reply to this 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.

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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

barton
In reply to this post by Cab Vinton
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.

On Thu, Jul 19, 2018 at 11:43 AM, Cab Vinton <[hidden email]> wrote:
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
<[hidden email]> wrote:
> 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
>
> On Thu, Jul 19, 2018 at 8:01 AM, Cab Vinton <[hidden email]> wrote:
>>
>> 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-devel mailing list
>> [hidden email]
>> 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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

barton
In reply to this post by Cab Vinton


On Fri, Jul 20, 2018 at 4:21 PM, Cab Vinton <[hidden email]> wrote:
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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

Cab Vinton
> 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.

> 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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

barton
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:


On Sat, Jul 21, 2018 at 2:19 PM, Cab Vinton <[hidden email]> wrote:
> 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.

> 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-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

Cab Vinton
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
_______________________________________________
Koha-devel mailing list
[hidden email]
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/
Reply | Threaded
Open this post in threaded view
|

Re: Koha reports wiki

Katrin Fischer-2
Cab++

Thx for your work on this!


On 22.07.2018 20:53, Cab Vinton wrote:

> 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
> _______________________________________________
> Koha-devel mailing list
> [hidden email]
> 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-devel mailing list
[hidden email]
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/