CSV import - hyperlinks not working

Question

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.

Stiltsoft support · Answer

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.

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

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.

nmanideep92 · Answer

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

Katerina Kovriga {Stiltsoft} · Answer

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.