Automate Joomla Database Operations
With TF Tools extension, you can automate Joomla database operations. Save time and get more done by setting workflows.
The component has three types of database operations for automation:
- Update: Updates column in any Joomla database table.
- Delete: Deletes records in any Joomla database table.
- Replace: Replaces text in any Joomla database table.
From the dashboard, navigate to ''Auto Tasks".
Task Type: Choose the type of task you want to set.
Database Table: Enter the name of the database table without prefix. For example: content
After saving, you can set Task specific options.
Please note that these operations cannot be undone.
1. Update Record
The first step in updating records is to get IDs. You can either directly enter the IDs of records or get through query.
Conditions
ID Type: Choose how you want to get the IDs of records to update.
Item IDs: Enter comma separated list of record IDs.
Where Conditions: Add one or more conditions to select records for updating.
Order By: Enter the ordering. For example: id DESC
Limit: Specify the number of records to update at a time.
Actions
Column Name: Enter the name of 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.
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.
Testing and Automating
After setting up the Auto Task, 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 in article titles