apen / additional_scheduler
Useful tasks in the scheduler module : full backup, send query result in mail, exec SH script with reports...
Fund package maintenance!
paypal.me/cerdanyohann
Installs: 68 264
Dependents: 0
Suggesters: 0
Security: 0
Stars: 8
Watchers: 4
Forks: 11
Open Issues: 1
Type:typo3-cms-extension
Requires
- php: ^7.4||^8.0||^8.1
- typo3/cms-core: ^11||^12||^13
- typo3/cms-scheduler: ^11||^12||^13
Requires (Dev)
README
Useful tasks in the scheduler module : full backup, send query result in mail as HTML or CSV, exec SH script with reports...
What does it do?
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.
Screenshots
List of all the tasks
backup your entire TYPO3 website (with mail report)
Configuration
exec a SH script (with mail report)
Configuration
exec a SQL query (with mail report and old templating)
Configuration
exec a SQL query with XLSX as mail attachment
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/phpspreadsheet
Configuration 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)
clear files in typo3temp older than x days
Installation
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.
Changelog
FAQ
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