Automate Joomla Database Operations
With TF Tools extension, you can automate Joomla database operations. Save time and get more done by setting up automation workflows.
The component has three types of database operations for automation:
- Update Records: Updates column in any Joomla database table.
- Delete Records: Deletes records in any Joomla database table.
- Replace Records: Replaces text in any Joomla database table.
Please note that these operations cannot be undone.
From the dashboard, navigate to the ''Channels". Create a new Channel with type as "Joomla DB". After saving, you will see the Options tab.
Options Tab
Task Type: Choose the type of task you want to automate.
Database Table: Enter the name of the database table without the prefix. For example: content
1. Update Record
Where Conditions: Add one or more conditions for updating. This is required field.
Column Name: Enter the name of the column to update.
Column Type: Choose the type of database column.
Column Value: Enter the new value to update.
2. Replace Records
You can perform find and replace on any column.
Where Conditions: Add one or more conditions to select records for replacing. This is required field.
Column Name: Enter the name of column to update.
Replace: Enter the old or existing string or value to replace.
Replace With: Enter the new value to replace with.
3. Delete Records
Where Conditions: Add one or more conditions to delete records. This is required field.
Testing and Automating
After setting, click "Process" button to run and check the task manually. To automate, set the frequency under the Auto Options tab.
Use Cases
- Republish Joomla articles
- Reset article hits
- Replace previous year to current year in article titles
- Delete old records from other extensions