Edit all links in Jira comments

nwylie December 19, 2019

We are moving our backend storage provider and Im looking for a way to change all the links to the new locations.

We have a document tracking old link location and then new link location. For confluence I am performing an XML dump then applying a sed loop to find replace. 

The Jira equivalent seems to be a SQL dump and then sed, but has anyone done any online changes? Perhaps a similar loop but with an alter statement?

Trying to avoid downtime as much as possible.

1 answer

0 votes
Alex Laycy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 19, 2019

Hi @nwylie ,

 

Just to clarify/confirm, is it the links within your external document that you're looking to update? 

 

What tool or service is this document making use of? (Excel, G Sheets etc?)

 

- Alex

nwylie December 19, 2019

Hi Alex, 

Right now people link to box.com for their documents from jira comments. We are migrating these to onedrive, so the URLs for the links need to change.

We will have a document with the old (box) url and the new (onedrive) url and my current plan is to use a mysql (our db) REPLACE loop for these or a dump + sed.

Can you think of any other, better, way to handle this?

Thanks,

Neil

Suggest an answer

Log in or Sign up to answer