This package adds the ability to store values of a form (or other input) into database and export the stored data as xlsx, xls, ods, csv or html.
To install the package simply run
composer require wegmeister/databasestorage
❗ The DatabaseStorage stores your data as JSON. Therefore only the Labels of the first entry can be used for the headline/export. Keep that in mind and try to avoid changing your forms later on. Whenever you add a now field after someone already entered some data, the new field would not exist in the headline row of the exported table ❗
You can add the DatabaseStorage Finisher in two ways:
Add the DatabaseStorage a finisher in your form definition/yaml file:
type: 'Neos.Form:Form'
identifier: 'some-identifier'
label: 'My form'
renderables:
# Your renderables / form fields go here
finishers:
-
identifier: 'Wegmeister.Database:DatabaseStorageFinisher'
options:
# The identifier is used to group your data in the database.
# You should avoid using the same identifier twice or your data could become a little messed up.
identifier: 'my-form-data'
You can also use the DatabseStorage with the new Neos.Form.Builder. You should be able to simply add DatabaseStorage as a finisher to your formular.
Don't forget to set an (unique) identifier
!
The following settings are available and can be overridden by your Settings.yaml:
Wegmeister:
DatabaseStorage:
# Creator name of the exported files
creator: 'die wegmeister gmbh'
# Title for the exported files
title: 'Database Export'
# Subject for the exported files
subject: 'Database Export'
# DateTime format if the datetime is included in the export
datetimeFormat: 'Y-m-d H:i:s'