==== Dashboard Block ====
===== File Output Configuration =====


{{ :blocks:dashboard:sortie-sur-fichier.png?nolink |}}


  * **Generate output:** No / Yes
  * **File output fields:** The file output can be fed with fields other than those used for display. 
  * **Data formatting:** These fields let you reformat the output data according to masks compatible with the "sprintf" function. For a list of reference fields, the format list must contain the same number of formatting expressions separated by semicolons. An empty expression means "no formatting".

<html><!-- nomoodle --></html>
[[http://php.net/manual/en/function.sprintf.php|Learn more about formatted strings]]
<html><!-- /nomoodle --></html>

  * **Output file type:** CSV record / CSV record without header line / SQL INSERT statement
  * **SQL table name (SQL output):** If you choose to output SQL statements, you must specify the target table name for the insertions. 
  * **File location (in moodledata):** Data can be generated from a scheduled refresh (deferred refresh). This setting determines the path within the course files where the file will be generated.
:!: Warning: This path must exist in the course files. The generator will not create the directory if it does not exist.

  * **Timestamp files:** If enabled, each generated file will be completed with a timestamp.
  * **Special location:** Administrators may need to generate output files in paths that are not controlled by Moodle.
 

<html><!-- nomoodle --></html>
-----

==== Credits ====

  * Valéry Frémaux (valery@activeprolearn.com)- Development and documentation
  * Florence Labord (florence@activeprolearn.com) - documentation



[[:blocks:dashboard:userguide|Back to the configuration guide index]] - [[:Blocks:Dashboard|Back to the component index]] - [[:Blocks:Dashboard:QueryCatalogue|Go to the generic query catalog]] - [[:Plugins|Back to the plugin index]] - [[:start|Back to the catalog]]

<html><!-- /nomoodle --></html>