Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Jira/Confluence Issue Pasting

For various reasons, I am using a confluence table (not Jira macro) to drop project issues into a table that get converted with the full summary (see below)

table view.png 

 

I am doing this by manually copying/pasting the url from Jira into my table in Confluence.

This is fine for small projects, but cumbersome for large projects.

I've seen in other places people who export the all of the issues into a csv and then concatenate the Key field to a separate field with ""https://examplegear.atlassian.net/browse/." 

The problem I'm facing is that when I generate that new link for each Key, Confluence doesn't do the conversion as seen above. It's just the hyperlink.

So: it works if I copy the link from Jira, but not from any other source, even though the urls are the same.

In confluence, when I edit the converted Jira link I see that it's been converted to JQL (see below):

url conversion to jql.png 

Is there a faster, more efficient way to bulk copy/paste project URLS so they convert the way I want them to in Confluence? What is happening in the background that allows it to work when going directly from Jira > Confluence that isn't happening when I just insert the exact same link from another source (e.g. a CSV).

Thank you in advance - JK

1 answer

You can use a mammoth amount of Excel concatenation to create wiki markup as described here: https://confluence.atlassian.com/doc/jira-issues-macro-139380.html

 

So you'd be aiming to create a string from each one that looks something like:

{jiraissues:anonymous=true|url=https://jira.atlassian.com/issues/?filter=41225}

and then nest that within pipes in your excel. So your excel formula would look something like the below (where B3 is the cell containing a Jira ticket ID)

=CONCATENATE("| ","{jiraissues:anonymous=true|url=https://jira.atlassian.com/browse/",B3,"} |")

...but as you say, you'll rapidly get to the point where just finding a way to use the normal jira issues macro table view and/or some plugins are a better use of time :)  

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you