This package adds the ability to store inputs of a form (or other input) into database and export the stored data as xlsx.
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)
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'