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
Community showcase
Published Tuesday in Confluence

Introducing Praecipio Consulting, an Atlassian Solution Partner

Hey there Community!  My name is Vannya Vallejo, the Channel Communication Specialist at Atlassian and I want to help Atlassian users like you learn about our Solution Partners and how they c...

310 views 0 9
Read article

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