Dashboard

Blocks ::: block_dashboard
Maintained by Valery Fremaux
Graphic, one query dashboard element using MIT library JQplot and other libraries
Latest release:
86 sites
49 downloads
33 fans
Current versions available: 8

IMPORTANT NOTE FOR PLUGIN ARCHIVE AVAILABILITY : due to the large amount of plugins supported, it is NOT affordable for us to update moodle.org packages. Please use the Source Control urls to our github to get plugins archives

The dashboard element bloc is of use with flexible Moodle
page formats allowing free setup of the dashboard page layout using blocks.

It implements a "dashboard element" capable to plot and render in
many graphic output formats any result of a complex query presented
to the Moodle database (or an eventual external PostGre schema).

Given a full query, the dashboard block mashes up :

- Data table output
   + Linear (records) data table
   + Tabular (cross dimension) tables
   + Treeview (on hierarchical mapped results)
   
- Graphic plotting using JQPlot
   + Line graphs
   + Bar graphs
   + Pie graphs
   + Donuts graphs
   
- Geographic plotting (using GoogleMaps API)
   + Google Maps + query data plotting
   + Possibility to change icons and plor mutiple class data using course files
   + Geocoding requests to Google handled (up to 2500 per day) with static long term caching
   => Will evolve

- Time special plotting : Integrating SIMILE Timeline plugin
   + Plot on a timeline plugin of "instant" and "time duration" events
   + possibility of setting up color classes for events
   + possibility to customize "instant" pin icons from course files
   => Will evolve

- Data output additional features
  + Data output formatting (using sprintf formatting)
  + Filters (selecting output or query fields for filtering)
  + Summators : displaying computed sums of output fields
  + Cumulative mode : Produces cumulative sum of a field without extra query
  + Data colouring and marking (on tables) using comparison formulas (ex: %% == 0 )
  + Mappable Labels for ALL query field names

- Performance features
  + Result caching (programmable retension delay)
  + Croned refresh of cache
  + Instance adjustable refresh mode or global cron settings

Dependancies :

You will need to add the custom extra libraries additions from https://github.com/vfremaux/moodle-local_vflibs to get the plotter libraries.

Get the adequate branch for your major Moodle version and install the libraries as a moodle/local component.

Screenshots

Screenshot #0
Screenshot #1
Screenshot #2

Contributors

Valery Fremaux (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Comments

  • Alan Hare
    Wed, 27 Mar 2013, 4:41 AM
    Hey Valery, your block sounds nice but doe not wortk with 2.4 (latest). Are there plans to fix to work with 2.4, currently there are errors.

    Coding error detected, it must be fixed by a programmer: You must set the text for the node when you create it.
  • Valery Fremaux
    Wed, 27 Mar 2013, 6:11 AM
    yes sure there are... actually last evolution was asked y some customers for 1.9, but we are in migration pre-schedule for them, so it will be fixed in a little delay.....

    I'm adding two key features : authro defined parameters to enhance end user experience in querying himself part of data, and filter caching to improve really "read again" queries.

    Cheers
    Valery
  • Alan Hare
    Thu, 28 Mar 2013, 12:10 AM
    Thank you for the update! smile
  • Trevor Wilson
    Wed, 17 Apr 2013, 3:35 AM
    Anyone have success with this on Moodle/Oracle setup? I get it installed fine and then run into a whack of trouble.
  • Valery Fremaux
    Wed, 17 Apr 2013, 3:29 PM
    Hi Trevor,, i'mterribly sorry about that, but i have absoloutely no experimenting nor test facility (nor budget allocation wink ) to check and ensure Oracle compatibility. Dashboarding faces lot of performance issues that often needs using some optimized SQL tricks that may affect portability. May you possibly address me some typical issue reports i can check some unportable writings could be avoided.

    Also dashboard is being revised as oportunistic quick drawn design is reaching its limits. So some new version may arrive soon...
  • Syed Iqbal
    Sun, 16 June 2013, 2:02 PM
    Hey Valery ,
    I am using moodle 2.2 after installing dashboard this error occurs when i view the dashboard

    Coding error detected, it must be fixed by a programmer: You must set the text for the node when you create it.
    .
    .
    .
    what do i do??
  • Valery Fremaux
    Sun, 16 June 2013, 7:18 PM
    seems you need to add a name to the block to avoid this error comming. Not yet analized....
  • haythem haythem
    Thu, 20 June 2013, 12:52 AM
    please help!!!

    Debug info: Missing version value in version.php
    Error code: detectedbrokenplugin
    Stack trace:

    line 548 of /lib/upgradelib.php: plugin_defective_exception thrown
    line 360 of /lib/upgradelib.php: call to upgrade_plugins_modules()
    line 1544 of /lib/upgradelib.php: call to upgrade_plugins()
    line 349 of /admin/index.php: call to upgrade_noncore()
  • Valery Fremaux
    Thu, 20 June 2013, 4:01 AM
    please check the last published version for Moodle 2.3/2.4, maybe runs on 2.5 without update..
  • 昇文 涂
    Thu, 6 Mar 2014, 10:00 PM
    Excuse me, my moodle is 2.4.1, currently there are errors.

    Coding error detected, it must be fixed by a programmer: You must set the text for the node when you create it.

    By the way, how can I input the data to database?

    thank for you
  • rashmi kapure
    Tue, 6 May 2014, 8:05 PM
    hello valery ,
    I have problem in configuring the dashboard report block.I have run the query in phpmyadmin database in cpanel , it works properly but when i put query in query settings and then run the dashboard it shows error.Kindly guide me regarding this settings.
  • Valery Fremaux
    Tue, 6 May 2014, 9:22 PM
    can u send me your query at valery.fremaux-at-gmail.com ? tell me your Moodle version and the block's version also
  • rashmi kapure
    Thu, 8 May 2014, 5:48 PM
    hello valery,

    I have sent you mail on your mentioned id.Please troubleshoot my problem.
  • Inês Couto
    Tue, 18 Nov 2014, 11:56 PM
    Hi there,
    I'm trying to make a filter in the query I'm using in the dashboard block.
    The thing is: I want the user to see it's own grades from all over de site moodle.
    I already have the query saying everbodys graduates and now I would like to filter it only to the user.
    How can I do that?
    Thank you!!!
  • Sawan Dhanotiya
    Mon, 16 Mar 2015, 7:38 PM
    Hi Valery,

    I have install Dashboard block. I am unable to setup the DB settings.
Please login to post comments