Useful tasks in the scheduler module : full backup, send query result in mail as HTML or CSV, exec SH script with reports...
This extension add new process in your scheduler module, for example you can :
- backup your entire TYPO3 website (with mail report)
- exec a SH script (with mail report)
- exec a SQL query with data put into a HTML table in an email
- exec a SQL query with CSV as mail attachment (with options for separator, escaping, etc.)
- exec a SQL query with XLSX as mail attachment (requires phpoffice/phpspreadsheet library)
- clear caches
- clear files in typo3temp older than x days
Do not hesitate to contact me if you have any good ideas.
This extension work with TYPO3 11.5.x-13.4.x.
This task allows you to execute a SQL query and receive the results as an XLSX file attached to an email.
Prerequisites:
This feature requires the phpoffice/phpspreadsheet library. If you haven't installed it yet, you can add it to your TYPO3 project using Composer:
composer require phpoffice/phpspreadsheetConfiguration Options:
- Filename: The desired name for the XLSX file (e.g.,
export_data.xlsx). - No Datetime Suffix: If checked, the current date and time will not be appended to the filename.
- No Header Row: If checked, the first row of the XLSX file will not contain the column names (headers).
- SQL Query: The SQL query to execute.
- Email: The recipient email address.
- Subject: The subject of the email.
- Body: The body content of the email.
(TODO: Add a screenshot of the configuration for Query2xlsxTask once available/created)
Download and install as TYPO3 extension.
- Composer : composer require apen/additional_scheduler
- TER url : https://extensions.typo3.org/extension/additional_scheduler/
- Releases : https://github.com/Apen/additional_scheduler/releases
Go to the scheduler module and enjoy it.
I was in an interior version of 1.4 and all my tasks are broken, how can i do?
Run the dedicated migration command : typo3/sysext/core/bin/typo3 additionalscheduler:fixupdateto14