If you have Joomla articles mixed in a category where they don't belong along with articles that do belong, batch moving them to the proper location can be a slow, tedious task using the core Joomla method. Join us as we look at how to streamline using DB Replacer from Regular Labs.
00:00:00 โ Intro & Sponsors
00:01:38 โ DB Replacer Basics & Backup Precautions
00:06:45 โ Finding Category IDs & Configuration
00:10:36 โ Tag Filtering & Category Replacement
00:16:25 โ Advanced Filtering & Verification
00:22:10 โ Creating a Christmas Sermons Category
00:28:00 โ Finding & Moving Additional Sermons
00:32:00 โ Avoiding Common DB Replacer Mistakes
00:38:30 โ Fixing SEF URL Issues with sh404SEF
00:44:00 โ Rebuilding Christmas Sermons URLs
00:48:10 โ Repairing Audio Tags in Joomla Data
01:03:30 โ Regex Capture Groups for Audio Fixes
01:19:15 โ Version Table Repairs & Data Export
01:29:30 โ Batch Tagging & Alias Management
01:43:00 โ Auto-Redirects & URL Regeneration
01:58:00 โ Fixing MP3 & Favicon URL Issues
02:10:00 โ Wrap-Up & Upcoming Guests
Summay
1. Recategorizing Joomla Articles with DB Replacer
Tim demonstrates how to use DB Replacer to quickly move large groups of articles from one category to another without manually editing each article.
2. Planning Safely Before Database Changes
Before making any replacements, he stresses the importance of creating backups and understanding exactly how DB Replacer modifies database records.
3. Finding Category IDs and Building Accurate Filters
The process begins by identifying category IDs and creating targeted filters to ensure only the intended articles are affected.
4. Using Tags to Bulk-Move Content
Tim uses article tags to locate specific sermon content and perform bulk category changes, making large-scale content organization much faster.
5. Verifying Results and Refining Searches
After running replacements, additional filtering and validation steps are used to confirm articles were moved correctly and no content was missed.
6. Creating and Organizing a Christmas Sermons Category
A dedicated Christmas Sermons category is created, and related content is gathered and reassigned to improve site structure and content discoverability.
7. Advanced Searches for Seasonal Content
Additional sermon series are found using keywords such as Advent, Christmas, and Manger, along with date-based filtering to locate overlooked content.
8. Repairing SEF URLs with sh404SEF
The session shifts to fixing duplicate, broken, and outdated SEF URLs using sh404SEF, including deleting and regenerating problematic URLs and setting up redirects.
9. Cleaning Legacy Audio Tags and Database Records
Tim tackles old audio embed tags stored in Joomla content and UCM tables, using DB Replacer, regular expressions, and phpMyAdmin to repair malformed data and version records.
10. Final Site Cleanup and Optimization
The livestream concludes with batch tagging sermons, resolving duplicate aliases, repairing broken MP3 and favicon URLs, configuring automatic 404 redirects, and preparing the site for improved organization and SEO performance.
Please send any feedback or bug reports or queries to;
Contact Tim Davis โบ
Joomla Training Cohort โบ https://cybersalt.com/jtc
Add comment