Bulk string replacement across Confluence

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

2 answers

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.

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?

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 ;).

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

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Asked May 24, 2018 in Confluence

What are the resources that you use to learn more about Atlassian Products?

I am gathering information about resources available for Atlassian product knowledge transferring for a presentation in our local Atlassian User Group. I want to group them in four categories From ...

604 views 18 16
View question

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you