Jira table import to confluence

[Smadar Sagi]

I'm trying to import data from Jira using the Jira Macro

I have 2 questions:

1. is it possible to keep only the value and remove the table header?

2. how can I format the dates? the transformer Macro doesn't seem to impact it(colors are coming from transformer).

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Smadar Sagi ,

As for the Jira Issues headings, I don't think that it is possible to remove them.

What concerns the Table Transformer macro, you can modify the date format with the help of the FORMATDATE function.

Wrap your table in the Table Transformer macro body and set the required date format in the macro settings:

Now use the FORMATDATE function mentioned above:

SELECT T1.'Project',
FORMATDATE(T1.'Date') AS 'Date'
FROM T*

Hope this helps your case.

[Katerina Kovriga _Stiltsoft_]

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Brant Schroeder]

@Smadar Sagi Welcome to the Atlassian Community.  Since you are issue macro from Jira to Confluence I would suggest reaching out to their support here:  https://marketplace.atlassian.com/apps/1213392/issue-macro-from-jira-to-confluence?tab=support&hosting=server

I tried to find information about this in their documentation but it is unavailable at this time.  

[Pramodh M]

Hi @Smadar Sagi 

Welcome to Confluence!!

Table Header can be removed even with having data, Please refer to the second row of editor when you are working with tables

And for Color and date format, when you add the macro, there is a settings option where we can format the data

https://docs.stiltsoft.com/display/public/TFAC/How+to+use+Table+Transformer+macro

Thanks

[Smadar Sagi]

Thank you for the reply. This is Jira Macro not a regular table