Template-Generator for Moodle Database Activity

Excel file that generates html and css templates for a Bootstrap database activity in Moodle.

Download: Template-Generator_for_Moodle_Databases.xlsx

Description

The "generator" is an Excel (.xlsx) file which combines input variables with html and css code. Simply add your database fields to the excel file and copy pre-formatted templates for your database. The list view is a bootstrap table with one field in each column and might be the base for custom formatting.

How To

• Create a database in Moodle or use an existing one
• Create input fields or use existing ones
• Copy all field names in the excel sheet "Fields"
• Optional: change setting in excel sheet "Settings"
• Copy templates from excel sheet "Template"

Dependencies

• A bootstrap based Moodle Theme (like the standard themes Boost and Classic)
• Microsoft Excel (Libre Office might work as well, not tested)
• Optional: Source-code editor to make adjustments

Features

• English and German
• Uses Bootstrap Grid
  • Modern Design
  • Responsive
• Easily adjustable colors
• Optional: DataTables for a mobile friendly list view
  • Assign priorities to fields/columns. Priority 1 will always be shown on narrow screens while higher priorities will collapse.

Help

• Set language by choosing "EN" or "DE" on sheet "Settings"
• Moodle fields must have a unique name (no duplicates)
• Activate DataTables by selecting "Yes / Ja" on sheet "Settings"
• DataTable priorities: n columns can have priority 1,...,n
  • Not all columns need priorities. No priority = column will collapse first on narrow screens

Version History

• 1.4
  • advanced search preset added
  • added quick search for list view again (caused an issue)
• 1.3
  • not approved entries are highlighted now
  • removed quick search for list view when dataTables is activated
  • minor design fixes
• 1.2
  • fixed some CSS causing styling issues outside of the database (buttons, moodle chat)
  • fixed text-wrapping issue of dropdown items on some moodle versions
• 1.1
  • Added support for tags like ##user##, ##timeadded## etc.
  • New layout for sheet "fields"
  • Translation for export buttons
• 1.0
  • Initial Release

Acknowledgments

Inspiration, code snippets, etc.

• Florian Dagner: Dropdown-Menü für Datenbanken
• Florian Dagner: Tabellen-Generator für die Moodle-Datenbank
• DataTables

Screenshots

View List

View Single

DataTables on mobile (collapsed and expanded)