You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I need to export a confluence table data from one space and import it in another space. I used the export to csv feature (also enabled the Export Clickable Links option) to generate the csv file and I am using Table From CSV macro to import it. Original table has few fields that contains hyperlinks. Those hyperlinks are exported as hyperlink functions e.g. =HYPERLINK("http://www.microsoft.com", "Microsoft"). During the import I need those hyperlinks to be shown as clickable links in the confluence. Instead it is just displaying the raw Hyperlink function data as such. Is there any setting or parameter I need to change to get the imported data with clickable links? Any alternative method to export/import table data that contains hyperlinks is also appreciated?
N.B. Making mirrored copy of table like using Table excerpt Include is not what I need. Need onetime import or data.
Thanks a lot for any suggestions.
Hi @Ashok Ambigapathy ,
We can suggest using the following workaround: export your table without the Export Clickable Links option enabled. Then your hyperlinks will be exported as a plain text: www.abc.com instead of the =HYPERLINK("http://www.abc.com/";"www.abc.com").
@Katerina Kovriga _Stiltsoft_ I have a similar issue but in my case I am uploading a csv from unix environment to confluence with a field as =HYPERLINK("https://www.abc.com";"ABC"). and I want the table to just display "ABC" as a clickable link in the table transformer macro. Can you suggest how can I achieve this.
Hi @nmanideep92 ,
We can suggest the following: firstly split the cell contents to get the "valuable" part of the link and then reconstruct it via the FORMATWIKI function.
FORMATWIKI("[Link|" + CONCAT("https://www.", 'Link 1', ".com/") + "]") AS 'New Link'
(SELECT T1.'Link'->split(".")->1 AS 'Link 1'
Here the internal SELECT splits the contents of your cells by point, but you can also cut your string and use other AlaSQL functions to get the "abc", "cde", etc. parts.
In the external SELECT we reconstruct the clickable links.