Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Bulk Copy of links into a Table

Jeff Flora
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 10, 2018

Want to copy multiple links into a table.  I'm using excel to create the links, and use a short name.  Trying to do this with Markup.  I have a lot of theses.  I don't want to use the wizard.

My Project Name: 12ABCD

My URL:   https://someapp/projects/12ABCD/home

Trying to insert: [12ABCD|https://someapp/projects/12ABCD/home]

It always copies over as a string "[12ABCD|https://someapp/projects/12ABCD/home]" into the table, but I want a link name as "12ABCD" that directs me to "https://someapp/projects/12ABCD/home".

 

If I could see the mark-up, this would be really quick.  XWIKI makes this super easy.

 

Thanks in advanced. - Jeff    

1 answer

0 votes
Joe Klimovitsky
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 16, 2021

I know this is an old question, but maybe it will help anyone anyway. 

The easy way that can save you some time in the future is to create a template in excel and format it as follow:

 

With the example above it if the headings were in row 1, and the rest of the data was in rows n+1. 

You'll use concatenation to format your table headers in C1:

=concat("||",A1,"||",B1,"||",C1,"||")

And for the rest of the data in C1+n:

=concat("|",A2,"|",B2,"|","[",A2,"|",B2,"]","|")

If you need both A & B in your confluence table, use the above concatenation. If you only need URLs in a table use something similar to:

=concat("||",C1,"||")

=concat("|","[",A2,"|",B2,"]","|")

Next, you copy all of column C. Back on the confluence page, you need to add a macro called Markup. You paste in the box what you copied, and it should format the table and the URLs correctly. 

I hope that helps 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events