[Bug 6828] New: Add Admin Dashboard for staff users.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Bug #: 6828 Summary: Add Admin Dashboard for staff users. Classification: Unclassified Change sponsored?: --- Product: Koha Version: unspecified Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: System Administration AssignedTo: paul.poulain@biblibre.com ReportedBy: barry@oslo.ie QAContact: koha-bugs@lists.koha-community.org CC: gmcharlt@gmail.com The Admin main page has a lot of empty space that could be utilised for library wide information. Other ILS show local and global information on various pages e.g. - Number of currently checked out items - Number of items in my branch - Number of overdues - Total Bibs catalogued in last 7 days. How about the addition of a Koha dashboard page to use this space and present local and global library information within the users context? -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #1 from Barry Cannon <barry@oslo.ie> 2011-09-01 10:56:52 UTC --- Created attachment 5249 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5249 Mock up of Admin Dashboard Mock up screen of Admin Dashboard. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Barry Cannon <barry@oslo.ie> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|paul.poulain@biblibre.com |barry@oslo.ie -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Barry Cannon <barry@oslo.ie> changed: What |Removed |Added ---------------------------------------------------------------------------- Change sponsored?|--- |Sponsored -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |paul.poulain@biblibre.com --- Comment #2 from Paul Poulain <paul.poulain@biblibre.com> 2011-09-01 12:59:00 UTC --- In your idea/plans, can the list of what is in the dashboard be edited by the library ? will it be hardcoded ? modular system ? Libraries will be highly interested by this feature, for sure. But i'm also sure that each of them will ask for different views A suggestion: we (well, you, if you code it ;-) ) : dashboard could retrieve datas to display from saved reports. Something like : table dashboard = dashboardid report_id position (the position in dashboard) Then you run the results, and display them in the dashboard. Managing the dashboard will mean for the libraries defining reports to run, and attaching them to the dashboard. We could provide some standard/basic/usual reports during installation. Other suggestion : this kind of dashboard, appearing on homepage, can be highly CPU consuming for large databases. I strongly suggest to cache the result in a file and update the dashboard only once every night. Or remove it from the homepage to have a dashboard specific one, but that's not your goal, and I agree the dashboard on homepage is an amazing idea) HTH -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #3 from Barry Cannon <barry@oslo.ie> 2011-09-01 13:42:33 UTC --- (In reply to comment #2)
In your idea/plans, can the list of what is in the dashboard be edited by the library ? will it be hardcoded ? modular system ? Libraries will be highly interested by this feature, for sure. But i'm also sure that each of them will ask for different views
In this release the data will be hard coded. If accepted I will certainly add the ability to show/hide details under the SysPref submenus of DashBoardDisplayed.
A suggestion: we (well, you, if you code it ;-) ) : dashboard could retrieve datas to display from saved reports. Something like : table dashboard = dashboardid report_id position (the position in dashboard)
Then you run the results, and display them in the dashboard. Managing the dashboard will mean for the libraries defining reports to run, and attaching them to the dashboard. We could provide some standard/basic/usual reports during installation.
Sounds great. However, if everyone agreed, I would like to get a limited release up and integrated first, if possible and then add features as patches etc.
Other suggestion : this kind of dashboard, appearing on homepage, can be highly CPU consuming for large databases. I strongly suggest to cache the result in a file and update the dashboard only once every night.
Yes, we have been toying with this idea too. At the moment, the number of selects is increasing and although they are only counts* it isn't ideal to have those queries running directly with every main page load. The only downside we had to this is that it introduces another cron job and makes the data somewhat stale (until updated at night). Is this the general consensus? Generate a static page nightly?
Or remove it from the homepage to have a dashboard specific one, but that's not your goal, and I agree the dashboard on homepage is an amazing idea)
HTH
-- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #4 from Paul Poulain <paul.poulain@biblibre.com> 2011-09-01 15:11:55 UTC ---
Other suggestion : this kind of dashboard, appearing on homepage, can be highly CPU consuming for large databases. I strongly suggest to cache the result in a file and update the dashboard only once every night.
Yes, we have been toying with this idea too. At the moment, the number of selects is increasing and although they are only counts* it isn't ideal to have those queries running directly with every main page load. The only downside we had to this is that it introduces another cron job and makes the data somewhat stale (until updated at night). Is this the general consensus? Generate a static page nightly?
Well, the static is definetly better if you want it on homepage ! But, depending on how deep you want to go, you can also : * have a button "update" available only for patrons with a (newly created) permission. That would result in semi-static stats : the boss can update, it's not updated everytime the page is loaded * you could use memcache for results also : if memcache is set, the retrieve the result from memcache. If it's not set, calculate everytime In fact, there are many possibilities ;-) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Robin Sheat <robin@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |robin@catalyst.net.nz --- Comment #5 from Robin Sheat <robin@catalyst.net.nz> 2011-09-01 23:44:33 UTC --- Chris and I were discussing the possibility of adding a charting reporting interface to koha. This would also be able to make something like this look nice. For example, a graph that showed issues per hour for the past 12 hours, or something like that. Just giving you more stuff to think about ;) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz --- Comment #6 from Chris Cormack <chris@bigballofwax.co.nz> 2011-09-01 23:50:49 UTC --- And my 2cents, if you could make it hand back json, then we could do graphs like http://stats.workbuffer.org/graph.html Really easily, all client side. All these comments mean one thing though, its a good idea, and I agree your approach to get something out there and refine is a good approach. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #7 from Paul Poulain <paul.poulain@biblibre.com> 2011-09-02 07:24:14 UTC --- BibLibre is investigating using a tool like Jasper Reports for graphical displays. I think that a dedicated tool will be easier/give a better result than developing something new. Stay concentrated on the core of Koha. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #8 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-09-02 09:10:21 UTC --- Hi Barry, first of all - I think the dashboard is a great idea! I also think the numbers in the mock up are a great start and I will be happy to test once your patches arrive on the list. I have only a small design suggestion to make: Perhaps it could be placed in a column on the right or left, so it stays on top and is always visible when you go to the start page. I think a reporting tool will probably provide more flexibility to people who know how to use it and how to make it work with Koha - it will always require a certain amount of database knowledge and such. That said I think some build in graps and pies in Koha would be a very nice addition and will make a lot of libraries really happy. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #9 from Barry Cannon <barry@oslo.ie> 2011-11-16 14:00:40 UTC --- Created attachment 6317 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6317 Patch implement enhancement First run of enhancement patch. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Barry Cannon <barry@oslo.ie> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |barry@oslo.ie -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |PATCH-Sent Status|NEW |ASSIGNED Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Barry Cannon <barry@oslo.ie> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6317|0 |1 is obsolete| | --- Comment #10 from Barry Cannon <barry@oslo.ie> 2011-11-24 12:00:32 UTC --- Created attachment 6389 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6389 New Amended patch This patch should be the final patch needed to implement this feature. I had omitted a file in the last upload and have added that now. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Needs Signoff |Does not apply --- Comment #11 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-21 06:44:31 UTC --- Hi Barry, I am sorry, your patch does not apply on master. Could you please fix and resubmit? Apply? [y]es/[n]o/[e]dit/[v]iew patch/[a]ccept all y Applying: Bug 6828[ENH] - Add basic Dashboard for staff users. /home/katrin/kohaclone/.git/rebase-apply/patch:61: trailing whitespace. BEGIN { /home/katrin/kohaclone/.git/rebase-apply/patch:62: trailing whitespace. $VERSION = 3.01; /home/katrin/kohaclone/.git/rebase-apply/patch:64: trailing whitespace. @EXPORT = qw(&number_of_items_library_xml &number_of_borrowers_library_xml &number_of_issues_library_xml &number_of_biblios_xml &number_of_loan_history_system_xml /home/katrin/kohaclone/.git/rebase-apply/patch:85: trailing whitespace. /home/katrin/kohaclone/.git/rebase-apply/patch:93: trailing whitespace. warning: squelched 50 whitespace errors warning: 55 lines add whitespace errors. Using index info to reconstruct a base tree... <stdin>:61: trailing whitespace. BEGIN { <stdin>:62: trailing whitespace. $VERSION = 3.01; <stdin>:64: trailing whitespace. @EXPORT = qw(&number_of_items_library_xml &number_of_borrowers_library_xml &number_of_issues_library_xml &number_of_biblios_xml &number_of_loan_history_system_xml <stdin>:85: trailing whitespace. <stdin>:93: trailing whitespace. warning: squelched 51 whitespace errors warning: 55 lines applied after fixing whitespace errors. Falling back to patching base and 3-way merge... Auto-merging installer/data/mysql/sysprefs.sql Auto-merging installer/data/mysql/updatedatabase.pl CONFLICT (content): Merge conflict in installer/data/mysql/updatedatabase.pl Auto-merging koha-tmpl/intranet-tmpl/prog/en/modules/intranet-main.tt CONFLICT (content): Merge conflict in koha-tmpl/intranet-tmpl/prog/en/modules/intranet-main.tt Auto-merging mainpage.pl CONFLICT (content): Merge conflict in mainpage.pl Failed to merge in the changes. Patch failed at 0001 Bug 6828[ENH] - Add basic Dashboard for staff users. When you have resolved this problem run "git am --resolved". If you would prefer to skip this patch, instead run "git am --skip". To restore the original branch and stop patching run "git am --abort". -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6389|0 |1 is obsolete| | --- Comment #12 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- Created attachment 10058 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10058&action=edit Bug 6828 - Add basic Dashboard for staff users. This enhancement adds the option of switching on/off a Dashboard on the Staff users mainpage. The information displayed is specific to the users logged in branch but will also show a system wide overview. Its visibility is controlled by a new SysPref. This first revision takes its data from an XML file which needs to be populated on a cronjob. The file to run is in misc/migration_tools/dashboard_xml.pl. The usual Koha env will need to be set for the user running the script. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 --- Comment #13 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- Created attachment 10059 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10059&action=edit Bug 6828 follow-up: adapt dashboard to new staff client theme This follow-up makes a few cosmetic changes: * Moves the dashboard to underneath the "pending" panel * Switches the layout to CSS-based instead of table-based * Makes the error message translatable * Reindents some sections of the added code to make things more readable -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Patch doesn't apply |Needs Signoff -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Marc Véron <veron@veron.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |veron@veron.ch --- Comment #14 from Marc Véron <veron@veron.ch> --- Installed patch yesterday, looked great, but in the meantime I get "Does not apply" error, sorry. Applying: Bug 6828 follow-up: adapt dashboard to new staff client theme error: patch failed: koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css:2274 error: koha-tmpl/intranet-tmpl/prog/en/css/staff-global.css: patch does not apply Additionally, it would be nice to have a span around the line "last updated..." to make it possible to format or to hide it with CSS. Marc -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #10058|0 |1 is obsolete| | --- Comment #15 from Kyle M Hall <kyle.m.hall@gmail.com> --- Created attachment 10217 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10217&action=edit [SIGNED-OFF] Bug 6828[ENH] - Add basic Dashboard for staff users. This enhancement adds the option of switching on/off a Dashboard on the Staff users mainpage. The information displayed is specific to the users logged in branch but will also show a system wide overview. Its visibility is controlled by a new SysPref. This first revision takes its data from an XML file which needs to be populated on a cronjob. The file to run is in misc/migration_tools/dashboard_xml.pl. The usual Koha env will need to be set for the user running the script. Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #10059|0 |1 is obsolete| | --- Comment #16 from Kyle M Hall <kyle.m.hall@gmail.com> --- Created attachment 10218 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10218&action=edit [SIGNED-OFF] Bug 6828 follow-up: adapt dashboard to new staff client theme This follow-up makes a few cosmetic changes: * Moves the dashboard to underneath the "pending" panel * Switches the layout to CSS-based instead of table-based * Makes the error message translatable * Reindents some sections of the added code to make things more readable Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Kyle M Hall <kyle.m.hall@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off CC| |kyle.m.hall@gmail.com -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA CC| |jonathan.druart@biblibre.co | |m --- Comment #17 from Jonathan Druart <jonathan.druart@biblibre.com> --- QA Comments: 1/ I think the Copyright is not the good one :) (+# Copyright 2000-2002 Katipo Communications) 2/ SQL reserved words must be uppercased 3/ all files are not pertidied (indentation, etc.) 4/ intranet-main.tt > Tables does not contain a body tag. However, its contain style (width="400") whitch can be set into the css file. 5/ The first table (Overview) contains an empty row (the last one). 6/ The value of the syspref DashBoardDisplayed is send to the template from C4/Auth.pm. I think it can be sent from the mainpage.pl 7/ Why the default value for DashBoardDisplayed is "show" ? We have to launch the dashboard_xml.pl script then I think the default value could be "Don't show" Marking as Failed QA -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Tom Misilo <misilot@fit.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |misilot@fit.edu -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |josef.moravec@gmail.com -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6828 Marjorie Barry-Vila <marjorie.barry-vila@ccsr.qc.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |marjorie.barry-vila@ccsr.qc | |.ca -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org