https://docs.moodle.org/502/en/api.php?action=feedcontributions&feedformat=atom&user=ValeryfMoodleDocs - User contributions [en]2026-05-15T17:33:32ZUser contributionsMediaWiki 1.43.5https://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122957Dashboard Block2016-04-17T10:34:05Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query. When used in a paged format such as Flexipage or Page, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard. the new [https://moodle.org/plugins/mod_poster | Poster] module is also a good candidate to organize and render dashboard elements into a single screen.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Literal===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122956Dashboard Block2016-04-17T10:33:00Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query. When used in a paged format such as Flexipage or Page, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard. the new [https://moodle.org/plugins/mod_poster| Poster] module is also a good candidate to organize and render dashboard elements into a single screen.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Literal===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122955Dashboard Block2016-04-17T10:32:46Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query. When used in a paged format such as Flexipage or Page, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard. the new [https://moodle.org/plugins/mod_poster | Poster] module is also a good candidate to organize and render dashboard elements into a single screen.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Literal===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122954Dashboard Block2016-04-17T10:32:27Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query. When used in a paged format such as Flexipage or Page, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard. the new [[https://moodle.org/plugins/mod_poster|Poster]] module is also a good candidate to organize and render dashboard elements into a single screen.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Literal===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122953Dashboard Block2016-04-17T10:32:06Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query. When used in a paged format such as Flexipage or Page, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard. the new [https://moodle.org/plugins/mod_poster|Poster] module is also a good candidate to organize and render dashboard elements into a single screen.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Literal===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122952Dashboard Block2016-04-17T10:28:47Z<p>Valeryf: /* Litteral */</p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query.<br />
<br />
When used in a paged format such as Flexipage, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Literal===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122951Dashboard Block2016-04-17T10:28:32Z<p>Valeryf: /* Instance Configuration */</p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query.<br />
<br />
When used in a paged format such as Flexipage, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Litteral===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is split into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (literal) rendering | Configuration: Raw data (literal) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output coloring of data | Additional parameters for output coloring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122950Dashboard Block2016-04-17T10:27:50Z<p>Valeryf: /* Reference, information, development and support */</p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query.<br />
<br />
When used in a paged format such as Flexipage, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Litteral===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is splitted into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (litteral) rendering | Configuration: Raw data (litteral) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output colouring of data | Additional parameters for output colouring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
This module is now maintained at Edunao.com (French Moodle Partner)<br />
<br />
Master documentation (FR) location is ar http://docs.edunao.com/doku.php?id=blockdashboard<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122949Dashboard Block2016-04-17T09:58:58Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query.<br />
<br />
When used in a paged format such as Flexipage, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 and upper starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Litteral===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is splitted into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (litteral) rendering | Configuration: Raw data (litteral) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output colouring of data | Additional parameters for output colouring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122948Dashboard Block2016-04-17T09:57:58Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query.<br />
<br />
When used in a paged format such as Flexipage, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [http://github.com/vfremaux/moodle-local_vflibs | this location on github], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a block in a course.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Litteral===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with color value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic development<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is splitted into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (litteral) rendering | Configuration: Raw data (litteral) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output colouring of data | Additional parameters for output colouring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Dashboard_Block&diff=122947Dashboard Block2016-04-17T09:56:19Z<p>Valeryf: </p>
<hr />
<div><br />
The "Dashboard Block" (more accurately Dashboard Element Block) allows displaying graphically or litterally the result of any query made in Moodle.<br />
<br />
When used in standard course formats, the block gives access to an extra page displaying the data redering for the specified query.<br />
<br />
When used in a paged format such as Flexipage, or any format allowing blocks to layout freely over the page, the block may display directly the graph rendering and be combined to other blocks to fgorm a complex, highly customizable dashboard.<br />
<br />
This blocks uses state-of-the art GPL libraries such as MIT JQplot and some other integrations. It has provision for powerfull data filtering and for using results for automatically generated exports.<br />
<br />
==Installation==<br />
<br />
From version 2.7 starting at April 16 2016, the graphic libraries have been deffered to a central custom local component. <br />
<br />
You'ill find an adequate package at [[http://github.com/vfremaux/moodle-local_vflibs | this location on github]], on the corresponding branch.<br />
<br />
Provided libraries are :<br />
<br />
JQplot : MIT Graph plotting library in HTML5<br />
TimeLine : A smart time line (still to develop)<br />
GoogleMapAPI : A wrapper to google map plotting of geolocated information<br />
<br />
<br />
==Capabilities and security advice==<br />
<br />
This block allows very deep data reading in Moodle database and powerfull data display. As the query can be written by power users with configuraiton capability, the block could be misused by unauthorised people and produce unwanted access to critical information.<br />
<br />
To reduce such risks, a couple of capabilities has been added to control precisely :<br />
<br />
who is allowed to add such a blcok in a coutse.<br />
who is allowed to access the block configuration.<br />
<br />
==Major rendering features==<br />
<br />
===Litteral===<br />
<br />
*Linear table raw<br />
*Linear table cleaned<br />
*Linear table with subtotals<br />
*Linear table with colour value coding (one column)<br />
<br />
* Tabular table Nx1 dimension<br />
* Tree shaped hierarchic developement<br />
<br />
===Graphical===<br />
<br />
*Bars<br />
*Lines<br />
*Pies<br />
*Donuts<br />
*Timeline (expérimental)<br />
*GoogleMap<br />
<br />
===File export generation===<br />
<br />
*CSV export (all data)<br />
*CSV export (filtered data)<br />
<br />
==Data Filtering==<br />
<br />
*Multidimensional filtering<br />
*Blocks filtering binding to the whole page for syncing several blocks to identical filtering values.<br />
<br />
==Global behaviour of the block==<br />
<br />
The key point of the block is its confguration form that will define all information needed to get data, filter it, choose what should be output in each rendering method, and finally individual parameters for each rendering method.<br />
<br />
Additional configuration allows to add dynamic filtering proposed to end users to filter dynamically the output.<br />
<br />
Althoug the setup form and rules are quite complex, we tried to implement a very lot of possibilities so this bloc becomes some kind of "swiss-knife" for Moodle smart reporting.<br />
<br />
==Global Settings==<br />
<br />
Some global settings allow derivated operation, such as querying an external (PostGre) database, or changing some technical performance features.<br />
<br />
[[Dashboard Block Global Settings | Global Settings]]<br />
<br />
==Instance Configuration==<br />
<br />
The configuration documentation is splitted into sections, each addressing a key feature of the dashboard.<br />
<br />
* [[Dashboard Configuration: Rendering location | Configuration: Rendering location]]<br />
* [[Dashboard Configuration: Rendering channels | Configuration: Rendering channels]]<br />
* [[Dashboard Configuration: Writing Query | Configuration: Writing Query]]<br />
* [[Dashboard Configuration: Raw data (litteral) rendering | Configuration: Raw data (litteral) rendering]]<br />
* [[Dashboard Configuration: Graph rendering settings | Configuration: Graph rendering settings]]<br />
* [[Dashboard Configuration: Configuring summarizers | Configuration: Configuring summarizers]]<br />
* [[Dashboard Configuration: Cache options and setting up exports | Configuration: Cache options and setting up exports]] <br />
<br />
Some extra configuration can improve data display<br />
<br />
* [[Dashboard Configuration: Additional settings for crosstable and tree-shaped display | Additional settings for crosstable and tree-shaped data display]]<br />
* [[Dashboard Configuration: Additional parameters for output colouring of data | Additional parameters for output colouring of data]]<br />
* [[Dashboard Configuration: Plotting geographic information | Additional parameters for geographic plotting (experimental)]]<br />
* [[Dashboard Configuration: Special Features on Columns for Output | Additional special settings when choosing output columns]]<br />
<br />
==Tips==<br />
<br />
===Exporting/importing the Block Configuration===<br />
<br />
This tip is usefull as the configuration of this bloc is huge and uses a lot of variables. The configuration export/import utility allows you to export an encoded configuration string as a text file, store it to your local system, then import it again in, say, a new unconfigured block instance. Configuraiton export contains all the dashboard configuration including the whole query, so it is easy to make several dashboard elements as a variant from a stored one.<br />
<br />
* [[Dashboard Configuration: Exporting/Importing Configuration | How to export/import configuration]]<br />
<br />
==Development Road Map==<br />
<br />
These are future features that are foreseen in the next road map for Dashboard Block.<br />
<br />
* Query parametrization with user filled variables<br />
* PDF generators<br />
* Crosstable Excel exports<br />
* Filtering values pre-fetch caching to improve performance<br />
* Accessory database extension to MySQL schemes<br />
<br />
=== Reference, information, development and support ===<br />
<br />
valery.fremaux-AT-gmail.com<br />
[[Category:Contributed code]]<br />
<br />
[[fr:Bloc Tableau de bord]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Badges&diff=119298Badges2015-07-21T14:18:22Z<p>Valeryf: </p>
<hr />
<div>{{Tracking progress}}<br />
Badges are a good way of celebrating achievement and showing progress. Badges may be awarded based on a variety of chosen criteria and are fully compatible with [http://openbadges.org/ Mozilla Open Badges]. Badges created in Moodle may be displayed on a user's profile or pushed to their [https://backpack.openbadges.org/ Open Badges backpack] and public badge collections in their backpack will display in their Moodle profile.<br />
<br />
There are two categories of badges:<br />
* Site badges - available to users site-wide and related to the site wide activities, like finishing a set of courses.<br />
* Course badges - available to users enrolled in the course and related to the activities that happen inside the course.<br />
<br />
[[File:badgesintro.png]]<br />
<br />
*[[Managing badges]]<br />
*[[Badges settings]]<br />
*[[Using badges]]<br />
*[[Badges FAQ]]<br />
<br />
[[Category:Badges]]<br />
<br />
[[de:Auszeichnungen]]<br />
[[es:Insignias]]<br />
[[ja:バッジ]]<br />
[[fr:Badges]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Customlabel_module_(Course_elements)&diff=117249Customlabel module (Course elements)2015-03-01T09:42:57Z<p>Valeryf: </p>
<hr />
<div>This plugin is documented on the [[https://docs.moodle.org/26/en/Customlabel_module_(Course_elements) | Moodle 2.6 documentation]] site :</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Block_settings&diff=102771Block settings2013-01-16T00:14:01Z<p>Valeryf: </p>
<hr />
<div>{{Blocks}}<br />
==Adding a block to a page==<br />
<br />
Blocks can be added to a page by turning editing on then using the 'Add a block' drop-down menu.<br />
<br />
Please see [[Blocks]] for a list of all the blocks in a standard Moodle install. Your site may have added contributed blocks and or your site administrator has disabled specific blocks on your site.<br />
<br />
{{New features}}Note: The ability to add a particular block to a page is controlled by an ''addinstance'' capability (e.g. [[Capabilities/block/comments:addinstance|block/comments:addinstance]]), which is allowed for the default role of teacher.<br />
<br />
==Block configuration==<br />
<br />
After adding a block, click the edit icon in the block header to configure it.<br />
[[Image:blocks03.png |thumb|right|Example of 2 blocks with editing turned on]]<br />
<br />
===Block settings===<br />
<br />
Certain blocks, such as the HTML block, allow a block title and more to be set.<br />
<br />
[[File:Block configuration block setting area.png]]<br />
<br />
===Where this block appears===<br />
Depending upon the context and users permissions, this area determines where this block will appear.<br />
*Original block location: provides information about where the block was initially created.<br />
*Display on page types: allows the user to set the context that the block can appear in. These options will vary depending upon the permissions of the user. For example a site administrator might see a setting that will allow the block to appear on Any page, or any type of course main page, while a teacher may only see the option to place it on every page in the course. <br />
*Default region: Usually a right column or left column option<br />
*Default weight: Where in the column do you want it to appear if there are other blocks in that column. -10 will put it at the top, 10 will put it at the bottom. A zero is neutral. <br />
[[File: Block configuration where appears.png]] <br />
<br />
See [[User profiles]] for instructions on how to make a block appear on all user profile pages.<br />
<br />
===On this page===<br />
*Visible - Yes or No. <br />
*Region - Here you can override the column preference on this page.<br />
*Weight - Here you can override the default setting on this page.<br />
[[File:Block configuration on this page.png]]<br />
<br />
=='Sticky blocks'==<br />
The term 'sticky' block was used in older versions of Moodle to mean blocks which the admin added either sitewide or to the [[My home]] page and which could not be deleted by regular users. Although the term is no longer used, it is still possible to make blocks 'sticky' and in a wider variety of locations. Here are a few examples:<br />
<br />
===Making a block sticky throughout the whole site===<br />
The Moodle administrator might wish for example to display support contact details sitewide using an [[HTML block]] called 'Helpdesk':<br />
<br />
#As an administrator, turn on the editing on the front page and add the block you wish to make sticky.<br />
#For ''Where this block appears>Page contexts'', choose 'Display throughout the entire site'.<br />
#Decide other settings according to your preference and save.<br />
#The block will now appear on all pages of your Moodle.<br />
<br />
{|<br />
| [[File:sitewidestickyblock.png|thumb|Making a block sticky throughout the site]]<br />
<br />
|}<br />
<br />
===Making a block sticky throughout a course===<br />
The teacher might wish for example to display the [[Messages block]] everywhere in the course. This would allow students easily to message each other and their tutors not only on the course from the main page but also on individual activities. The block would be available on admin pages too.<br />
<br />
#As a teacher in the course, turn on the editing on the course main page and add the block you wish to make sticky.<br />
#For ''Display on page types'', choose 'Any page'<br />
#Decide other settings according to your preferences and save.<br />
#The block will now appear on all pages of the course.<br />
<br />
{|<br />
|[[File:coursestickyblock.png|thumb|Making a block sticky throughout a course]]<br />
|}<br />
<br />
===Making a block sticky in a category===<br />
A user with category rights might for instance wish to display a [[Remote RSS feeds block]] in all of the courses within a particular category, such as a Head of Science adding Science news feeds to the Physics, Biology and Chemistry courses. While this should be possible, there are currently problems with blocks on category pages not saving the required page context. See MDL-31616<br />
===Making a block sticky in a resource or an activity===<br />
A teacher might wish to display a block in one particular resource or activity, for example a Head of Faculty might make create a [[Book]] for departmental policies and wish to add the comments block to every chapter/page of a book so colleagues can give quick feedback. (Note that such a comments block would be the ''same'' block on each chapter/page)<br />
#As a teacher in the course, turn on the editing and click into the resource/activity -in this case a Book and add the block.<br />
#For ''Display on page types'', you will see (for example) 'mod-book*' <br />
#Decide other settings according to your preferences and save.<br />
#The block will now appear on all related screens.<br />
<br />
{|<br />
|[[File:bookstickyblock.png|thumb|Making a block sticky throughout a book]]<br />
|}<br />
<br />
===Adding a block to all user profile pages===<br />
See [[User profiles]]<br />
<br />
===Adding a block to My home page for all users===<br />
See [[My home]] Note that such a block would not be truly 'sticky', in that users can customise their My home page and could, if wished, delete the block.<br />
<br />
==Block permissions==<br />
<br />
Role permissions for a block can be changed by clicking the Assign roles icon (a face and mask) in the header of the block then via ''Settings > Block administration > Permissions''.<br />
{|<br />
|[[File:Blockassign.png|thumb|Changing permissions in a block]]<br />
|}<br />
<br />
See [[Blocks FAQ]] for details of how to hide front page blocks from non-logged-in users.<br />
<br />
[[de:Blockeinstellungen]]<br />
[[fr:Paramétrage des blocs]]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Customlabel_module_(Course_elements)&diff=102748Customlabel module (Course elements)2013-01-14T08:56:31Z<p>Valeryf: </p>
<hr />
<div>This plugin is documented on the [[https://docs.moodle.org/23/en/Customlabel_module_(Course_elements) | Moodle 2.3 documentation]] site :</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Profile_field_enrolment&diff=102737Profile field enrolment2013-01-12T13:54:46Z<p>Valeryf: Created page with "{{Enrolment}} Location: External database edit settings link in ''Settings > Site administration > Plugins > Enrolments > Manage enrol plugins'' (once installed) ==Plugin availa..."</p>
<hr />
<div>{{Enrolment}}<br />
Location: External database edit settings link in ''Settings > Site administration > Plugins > Enrolments > Manage enrol plugins'' (once installed)<br />
<br />
==Plugin availability==<br />
<br />
Get the plugin archive in the [https://moodle.org/plugins/view.php?plugin=mod_customlabel | Moodle PLugin Database].<br />
<br />
==Documentation Location==<br />
<br />
The full documentation of this enrolment contributive plugin is in the [https://docs.moodle.org/22/en/Profile_field_enrolment | Moodle Documentation 2.2 volume ]</div>Valeryfhttps://docs.moodle.org/502/en/index.php?title=Customlabel_module_(Course_elements)&diff=102451Customlabel module (Course elements)2012-12-14T22:30:44Z<p>Valeryf: Created page with "This plugin is documented on the Moodle 2.3 documentation site :"</p>
<hr />
<div>This plugin is documented on the [[https://docs.moodle.org/23/en/Customlabel_module_(Course_elements)| Moodle 2.3 documentation]] site :</div>Valeryf