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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.