Configuration
The plugin Form requires 2 new configuration parameters:
- Antivirus enabled: to enable or disable antivirus scanning of files that can be uploaded from a form.
- Command: command to be run for antivirus scanning
Go to the application configuration interface to enter these 2 parameters
Application parameters are documented on the general administration manual page: Application configuration CMS
Rights
This extension brings 4 new rights.
Content rights" category
| Right title | Role |
|---|---|
| Forms edition | Add and edit forms in the online editor (add fields, modify...) |
Forms" category
| Right title | Role |
|---|---|
| Delete entries | Allows form entries entered by visitors to be deleted |
| Export forms | Export and view data sent by visitors on forms |
| See the request | Allows you to view the SQL query used to obtain form data |
Operation
Form data is stored in SQL databases.
A table is created for each of your forms.
Its name is prefixed by"PluginForms-". Table and column names are generated from their respective IDs.
When a contributor deletes a field, the column remains in the SQL table, but is no longer used by the application. As a result, you will still be able to access all the data if you wish.
Similarly, when a form (or its content) is deleted, the entire SQL table (data and structure) is preserved.
For the moment, there is no way of determining :
- which tables are used and which are not.
- which tables are associated with a given content.
- which column is associated with which field (except when querying the Repository JCR).
Orphan form data
This tool in the administrator interface allows you to view forms stored in the database but no longer referenced in CMS. It can also be used to permanently delete the corresponding SQL tables.
The tool lists :
- table name SQL
- number of table entries
- the name of the content referencing the table
- the name of the site that carried the content
- the contributor who last modified the content
- the existence of the content (for example, a form may have been deleted from the content)
Back to top