If this is a one time only job, then forget about writing a custom module but rather use the bean shell module and write a script for it.
Concerning your query: You can test queries in the AdminCentral. See the menu item "Tools" > "JCR Queries". Something like SELECT * FROM nt:base WHERE CONTAINS(*, 'www89.xxxx.com') should at least give you all pages and paragraphs containing the old url. But you would still have to figure out in what node data this was since the query above searches in all node datas of a node. If the paragraphs were set up smartly and the urls can only be in a node data named "text" for instance, things will be a bit easier. -will On 12.08.2010, at 09:53, shihong wrote: > > i just got a task from job place. the company want me to add a new function > in magnolia, by which administrator can change all the url link > in a batch way. (i.e. www89.xxxx.com/ ...... -> www88.xxxx.co/..........) for > each link. not one at a time or page by page. > > I have a couple of questions related to the problem. I'm very grateful if > someone can help me out? > -- my solution is to create a module and add it to the magnolia, The module > primarily calls the JCR API to retrieve all urls stored in content repository > and replace them > if it work? or there exists a much simpler way? > > -- I'm not good the JCR API and JackRabbit. How could I find the URL > information for each link in the content repository? (the concrete > SQL query ) > > thanks a lot > > ---------------------------------------------------------------- > For list details see > http://www.magnolia-cms.com/home/community/mailing-lists.html > To unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
