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

Mail

exec a SH script (with mail report)

Configuration

Mail

exec a SQL query (with mail report and old templating)

Configuration

Mail

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

See CHANGELOG.md

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