Dashboard Block Global Settings

PostGre Accessory Connexion Scheme

These connection settings allow providing an accessory external connection to graph data from. This feature might be extended to MySQL scheme if LMS administrator uses accessory platforms in complement with LMS that do not support high-level data reports.

Extra database hostname

The hostname for an accessory extra database the dashboard block can choose to query rather than internal LMS db.

Extra database port

Accessory database port

Extra database name

Name of the database to connect to

Extra database login

Login of a user having read access to the accessory database

Extra database password

Password for a user having read access to the accessory database

Performance and breakdown experience helpers

“Big Result” security trap threshold (experimental)

When processing a very lot of data, you may stuck your db connection and faildown your db server on low powered hostings. If this case occurs, it might be difficult to fix the query as having no more access to the configuration panel of the Dashboard block. If you are not an LMS database expert and knows how to rip off the damaged block instance configuration, this setting could prevent big results from being output without paging.

F.e, setting 300 as threshold will force any query outputting more than 300 lines of a result to enter the paged display mode.

Activates the editing secured mode

You may even try more control for bad or strangling queries by avoiding the block to shoot the query while the course is still in editing mode. Set 1 as value for this option to secure the editing mode. Cron is also responsible for delayed cache refresh.

Cron global settings

These settings will define when the dashboard global cron handling is enabled.

Cron activation

If this is set to “no”, absolutely no automated export can run, including those block instances that choose their own scheduling settings.

Hour

Choose the hour all defaults cron enabled blocks will be processed.

Weekly frequency

Here you can choose which day the dashboard will be cron processed. You can choose one day in the week or on a daily basis.