README

This extension adds an additional finisher to the TYPO3 Form (tx_form) to save the results into the database

• Gitlab Repository: gitlab.com/lavitto/typo3-form-to-database
• TYPO3 Extension Repository: extensions.typo3.org/extension/form_to_database
• Found an issue?: gitlab.com/lavitto/typo3-form-to-database/issues

Compatibility

Introduction

Features

• No configuration needed
• No database-changes per form required
• Shows all results per form in a separate backend module
• Provides a CSV-download of all results
• Preview & PDF download of individual form results
• Automatic deletion of results after a specified number of days (GDPR)

Screenshots

Backend Overview

• Full Size Screenshot

Backend Results

• Full Size Screenshot

Installation & setup

1. composer req lavitto/typo3-form-to-database (or download from the TYPO3 Extension Repository)
2. Add the extension as a dependency in your site as a site set
3. Edit the form you wish to store results for
4. Add the finisher ("Save the mail to the Database") to your form - it is recommended you place this finisher first

Usage

Command / Scheduler

It's possible to delete the form results by the command line or scheduler (Execute console commands).

Usage:
  form_to_database:deleteFormResults [<maxAge>]

Arguments:
  maxAge                Maximum age of form results in days [default: 90]

Options

There are several options available for customisation. To change these, go to Settings -> Configure Extensions -> form_to_database

• General
  • hideLocationInList - Should the location of the form be hidden on the Form results overview module? (Default: No)
  • displayActiveFieldsOnly - If true will only output active renderables in backendModule and CSV (will not display deleted renderables stored in the formDefinition) (Default: false)
• CSV Settings
  • csvDelimiter - What character should separate fields in the CSV export (Default: ,)
  • csvOnlyFilenameOfUploadFields - Should the CSV list the whole path or just the file name?
  • csvHtmlSpecialChars - If true will encode special chars (' => ", < => <) (Default: true)

Additional Feature configuration

PDF download of a single result

Contribute

We welcome issues and merge/pull requests. Please don't let conventions or failing tests put you off - we can always fix them once a request is submitted.

Please follow the TYPO3 Commit conventions if you can when committing.

Please use GitLab only for bug-reporting or feature-requests. For support use the TYPO3 community channels

To run tests & linting

The extension uses a modified version of runTests.sh from the TYPO3 core.

You need Podman installed and running to run the tests.

• Install dependencies with TYPO3 13 and php 8.2:
  • Build/Scripts/runTests.sh -t 13 -p 8.2 -s composer install (-t is currently obsolete, as only v13 is supported and set as default)
• Run linter:
  • Build/Scripts/runTests.sh -p 8.2 -s lintPhp
  • Build/Scripts/runTests.sh -t 13 -p 8.2 -s lintTypoScript
• Execute functional tests:
  • Build/Scripts/runTests.sh -p 8.2 -s functional

See help menu for all options: Build/Scripts/runTests.sh --help

Commits should follow TYPO3 Commit Guidelines.

Releasing

The package is released automatically to Packagist when tagged, however TER requires a manual upload

1. git archive -o "form_to_database_[tag].zip" [tag] where [tag] is the version just created
2. Upload the zip file created to the TER - use the changelog for the entry

Support

If you need private or personal support, try the TYPO3 Slack channel - #ext-form-to-database or reach out to Mike directly