RocketTheme - TOPIC: Modify many articles at once, is that posible? (1/2)

Welcome Guest! Login

0 items Join Now

ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down. Read our Farewell Blog Post for more details.

- Julián Fernández
- Sr. Rocketeer
- Posts: 155
- Thanks: 0
Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Hi there, i was wandering if that could be done, and how. In this case y had an article which has many instances (one pre category) and ill would like to change it in all categories at once.
  
  Any ideas?
  
  Thanks
- Debian 6.0.4 | PHP 5.3.3 | Apache/2.2.16 | Joomla latest version (1.5.x | 2.5.x)
  Current deploys http://www.lospisosflotantes.com.ar | http://www.movimientodesuelos.com
#416508
- Robert D. Wagers
- Elite Rocketeer
- Posts: 1545
- Thanks: 0
- Full-Time Cancer Fighter!
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Someone-else might have a better answer, but I've used the JCE editor offline to make changes then just upload them at once.
  I've never tried it other-wise. Sorry I'm much more help than that.
  Wage
- "Everyone has to get knocked-down every once-in-a-while, otherwise you'll never learn how to get-back-up! "
  A quote attributed to my Grandpa Wagers
#416517
- Julián Fernández
- Sr. Rocketeer
- Posts: 155
- Thanks: 0
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Intresting, im gonna try that one, so far ive manage to solve this using phpMyAdmin and doing this:
  update table_name set table_field = replace(table_field,'replace_that','with_this');
  
  Here is the example:
  update posts set content = replace(content,'dog','cat');
  
  That solved the problem of setting up a joomla site on localhost, backing up with joomlapack and restore on remote site. I was wondering if theres other way to do this, something that correct the paths automatically?.
  
  Theres the sites that a ive checked for this:
  http://blog.urbanmainframe.com/2008/07/mysql-search-replace/
  http://vyaskn.tripod.com/sql_server_search_and_replace.htm
  Thanks Wage
- Debian 6.0.4 | PHP 5.3.3 | Apache/2.2.16 | Joomla latest version (1.5.x | 2.5.x)
  Current deploys http://www.lospisosflotantes.com.ar | http://www.movimientodesuelos.com
#416540
- John Hodgkinson
- Hero Rocketeer
- Posts: 421
- Thanks: 0
- Retired, but build and run websites for organisations of school leaders and others - e.g. http://www.icponline.org, http://www.aspa.asn.au, http://www.appa.asn.au
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- I'm not sure what you want to alter in the articles, but have you tried Re-replacer? You can find it at extensions.joomla.org/extensions/edition/replace/4336
#416599
- Julián Fernández
- Sr. Rocketeer
- Posts: 155
- Thanks: 0
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- John, thats the kind of thing that i was looking for. Thanks!
- Debian 6.0.4 | PHP 5.3.3 | Apache/2.2.16 | Joomla latest version (1.5.x | 2.5.x)
  Current deploys http://www.lospisosflotantes.com.ar | http://www.movimientodesuelos.com
#416800
- John Hodgkinson
- Hero Rocketeer
- Posts: 421
- Thanks: 0
- Retired, but build and run websites for organisations of school leaders and others - e.g. http://www.icponline.org, http://www.aspa.asn.au, http://www.appa.asn.au
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Let us know how well it works for you.
#416929
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Check out this extension, too.
  
  extensions.joomla.org/extensions/news-pr...tent-management/2514
- Thanks,
  jim
#416941
- Julián Fernández
- Sr. Rocketeer
- Posts: 155
- Thanks: 0
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- @John, i was unable to get re-replacer doing anything noticiable. Any way as i said, solved my problem editing directly on the database.
  
  Just an update.
  @JEM, im gonna look that too
- Debian 6.0.4 | PHP 5.3.3 | Apache/2.2.16 | Joomla latest version (1.5.x | 2.5.x)
  Current deploys http://www.lospisosflotantes.com.ar | http://www.movimientodesuelos.com
#422900
- John Hodgkinson
- Hero Rocketeer
- Posts: 421
- Thanks: 0
- Retired, but build and run websites for organisations of school leaders and others - e.g. http://www.icponline.org, http://www.aspa.asn.au, http://www.appa.asn.au
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Hi Julian, Rereplacer does not touch your database. What it does is to enable you to make changes to things like names and words in the pages that rereplacer changes dynamically as the pages are displayed. For example, if you want to change all occurrences of the word 'London' to "Paris', rereplacer can do that for you - you don't have to search through every file for the word 'London'. But the original text in the Joomla database for your site is not changed. I also use it to make temporary changes for summer and winter seasons or for different months of the year.
#423216
- Julián Fernández
- Sr. Rocketeer
- Posts: 155
- Thanks: 0
Re: Modify many articles at once, is that posible?

Posted 15 years 6 months ago
- Yeah, thats what ive thought but like i said when rereplacer "article" is created and search replace filled + plublished, nothing happend Anyway dont worry about it, so far ive solved that issue editing directly the database and i guess that ill probably get other benefits if ive learn some mysql commands.
- Debian 6.0.4 | PHP 5.3.3 | Apache/2.2.16 | Joomla latest version (1.5.x | 2.5.x)
  Current deploys http://www.lospisosflotantes.com.ar | http://www.movimientodesuelos.com
#423590