CSV import - hyperlinks not working

Ashok Ambigapathy May 14, 2021

Hello,

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.

1 answer

2 votes
Katerina Kovriga {Stiltsoft}
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.
May 17, 2021

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").

When you import your table, wrap the Table from CSV macro into the Table Transformer macro and create clickable links for the required column using the FORMATWIKI function.

nmanideep92
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!
October 26, 2023

@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. 

TIA. 

Stiltsoft support
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.
October 27, 2023

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.Fri 4-1.png

SELECT
FORMATWIKI("[Link|" + CONCAT("https://www.", 'Link 1', ".com/") + "]") AS 'New Link'
FROM
(SELECT T1.'Link'->split(".")->1 AS 'Link 1'
FROM T*)

Fri 4-2.png

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events