Bulk string replacement across Confluence

[Sabina H_]

We’re looking for a way to perform mass string replacements across all of our Confluence pages.

Many of our pages contain non-clickable hyperlinks to our network folders (i.e. resources outside of Confluence or Jira) in our corporate network. We're renaming these folders/locations and now we need a way to do a bulk replacement of the URL strings. We have over 6000 pages that have strings that need replaced, so manually isn't an option.

We can produce a table of ‘what to find’ and ‘what to replace with’, we just need a query or tool of some sort that our IT department can safely run that will make the changes. Help guide us please!

Example:

Old string: \\corp.ourcompany.net\department\Shop\purchases\wireframes\Shop_Navigation

New string: \\corp.ourcompany.net\marketing\online\store\purchases\wireframes\Shop_Navigation

Possibly related:

https://answers.atlassian.com/questions/149769/bulk-change-of-links-in-confluence

https://marketplace.atlassian.com/plugins/de.ck.confluence.gsr

https://jira.atlassian.com/browse/CONF-2522

[Bob Swift]

Confluence Command Line Interface (CLI) and use modifyPage. Use runFromPageList to run the modify across a set of pages. This might take a while to run, but can be done while the system is live. The change will be recorded in page history.

An alternative would be to shutdown Confluence and do the appropriate update sql against the content table.

[Sabina H_]

Thanks for the reply, right now we need a free option, buying another plugin is out at the moment.

Where can I find more info on how to do the appropriate SQL statements against the content table?

[Bob Swift]

The SQL isn't that difficult, but you need someone who knows what they are doing and make sure you have a backup.

However, I would suspect this one task could be done within your 30 day free evaluation license period ;).

[Sabina H_]

Very true, I think we'll give that a try. We can use @allto search and replace within all pages in an instance, correct?

[Sabina H_]

Very true, I think we'll give that a try. We can use @allto search and replace within all pages in an instance, correct?