{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Please check out our ","type":"text"},{"text":"YouTube video","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"https://www.youtube.com/watch?v=baJ4ByWDIKQ"}}]},{"text":" or our ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://weweave.atlassian.net/wiki/spaces/CONFDATATABLES/pages/897450130"}},{"text":" to get an idea about how Data Tables for Confluence works.","type":"text"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"ee8d5c2f-60cb-4749-91a8-d9b97dafd70b"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"bb37acb4-0476-458b-ba77-60bf60d73802"}},{"type":"heading","attrs":{"level":1},"content":[{"text":"Installation","type":"text"}]},{"type":"paragraph","content":[{"text":"As any app for Confluence Cloud, you can install the app via the Confluence admin menu.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Log into your Confluence instance as an admin.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on “Apps > Manage apps” in the header menu.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on “Find new apps” on the right navigation.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Search for “Data Tables for Confluence” and select it.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on “Try it free” to install the app.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Usage","type":"text"}]},{"type":"paragraph","content":[{"text":"Data Tables for Confluence provides macros to create powerful tables.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data Tables","type":"text","marks":[{"type":"strong"}]},{"text":": This macro uses regular Confluence tables or a “Page Properties Report” macro as data source.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data Tables CSV","type":"text","marks":[{"type":"strong"}]},{"text":": This macro uses local CSV data (defined in the macro body) as data source.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data Tables CSV (Attachment)","type":"text","marks":[{"type":"strong"}]},{"text":": This macro uses CSV data from a file attached to the same Confluence page as data source.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data Tables CSV (Remote)","type":"text","marks":[{"type":"strong"}]},{"text":": This macro uses remote CSV data (defined via a remote URL) as data source.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data Tables Attachments","type":"text","marks":[{"type":"strong"}]},{"text":": This macro uses the attachments of a Confluence page as data source and renders a table with information such as the file name and file size.","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"To make use of one of the macros click the “Insert” / “+” Button in the edit mode, select one of the macros and follow the macro specific instructions below.","type":"text"}]},{"type":"paragraph","content":[{"text":"All macros support the table state saving and restoring feature which enabled by default (see macro option “Disable state saving“ below to disable this functionality). The table state information is stored for 7 days in the client’s browser and is used to restore the user specific table state after a page reload. Please note that for this functionality requires “third-party cookies” to be enabled in the client’s browser (see our ","type":"text"},{"text":"FAQ page","type":"text","marks":[{"type":"link","attrs":{"href":"https://weweave.atlassian.net/wiki/pages/resumedraft.action?draftId=897351971"}}]},{"text":" for more details).","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Macro “Data Tables”","type":"text"}]},{"type":"paragraph","content":[{"text":"The “Data Tables” macro uses regular Confluence tables or the “Page Properties Report” macro as data source. After inserting the macro, add a regular Confluence table or a “Page Properties Report” macro as macro body and change the macro settings appropriately.","type":"text"}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":50.0},"content":[{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":777,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":777,"alt":"image-20240328-144051.png","id":"294ee266-4418-4031-aed4-ed48351e14e8","collection":"contentId-897351827","type":"file","height":243}},{"type":"caption","content":[{"text":"Confluence table as data source","type":"text"}]}]}]},{"type":"layoutColumn","attrs":{"width":50.0},"content":[{"type":"paragraph"},{"type":"mediaSingle","attrs":{"layout":"center","width":774,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":774,"alt":"image-20240328-143820.png","id":"d51335ef-a395-4827-bda0-b5f4b32aebc1","collection":"contentId-897351827","type":"file","height":267}},{"type":"caption","content":[{"text":"“Page Properties Report” macro as data source","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"The macro supports the following options:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable paging","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the paging functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Page sizes","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable searching","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the (global) searching functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column filtering","type":"text","marks":[{"type":"strong"}]},{"text":": Enable column filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Exclude columns from search & filter","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to exclude from searching and filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column selector","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that allows to toggle visibility of individual columns.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable copy to clipboard","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that copies the table data to the clipboard.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable Excel export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .xlsx file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable CSV export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .csv file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable PDF export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .pdf file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable printing","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a “print” button.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fixed order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Number of columns defined in option “Order columns” for which the order is unchangeable.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Footer row","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data locale","type":"text","marks":[{"type":"strong"}]},{"text":": Defines the locale that should be used to parse numbers.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Hide the columns defined in option “Grouping columns“.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide header row","type":"text","marks":[{"type":"strong"}]},{"text":": Hide header row (disables sorting). ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Detail column: ","type":"text","marks":[{"type":"strong"}]},{"text":"Number of the column that contains the information that will be rendered as expandable/collapsible detail row.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Detail column format: ","type":"text","marks":[{"type":"strong"}]},{"text":"Defines if the detail column should be rendered as expandable detail row (default option “DetailRow“) or as overlay (option “Overlay”).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Show information","type":"text","marks":[{"type":"strong"}]},{"text":": Show dataset information such as number of records.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable state saving","type":"text","marks":[{"type":"strong"}]},{"text":": Disable automatic table state saving and restoring.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Macro “Data Tables CSV”","type":"text"}]},{"type":"paragraph","content":[{"text":"The “Data Tables CSV” macro uses (local) CSV data as data source. After inserting the macro, add the CSV data macro body and change the macro settings appropriately.","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"On pages using the “Legacy Editor” experience, the macro editor overlay shows a preview (if available) and you can enter the CSV data in the macro body ","type":"text"},{"text":"after","type":"text","marks":[{"type":"underline"}]},{"text":" closing the editor by clicking “Insert” or “Save”.","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":876,"id":"fc914013-4625-4b5c-99a6-b3ce0b8d4777","collection":"contentId-897351827","type":"file","height":537}}]},{"type":"paragraph","content":[{"text":"The macro supports the following options:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV header row","type":"text","marks":[{"type":"strong"}]},{"text":": Use the first row as column header.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV quote","type":"text","marks":[{"type":"strong"}]},{"text":": Define the character that is used as CSV quote, leave empty if no quote us used.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV delimiter","type":"text","marks":[{"type":"strong"}]},{"text":": Define the character that is used as CSV delimiter.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Column format","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated format (","type":"text"},{"text":"empty","type":"text","marks":[{"type":"em"}]},{"text":", “html”, “link” or “date” in format ","type":"text"},{"text":"YYYY-MM-DD","type":"text","marks":[{"type":"em"}]},{"text":") to be used for rendering the column, whereas “html” supports the tags ,
, and and “link” renders the data as hyperlink. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable paging","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the paging functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Page sizes","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable searching","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the (global) searching functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column filtering","type":"text","marks":[{"type":"strong"}]},{"text":": Enable column filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Exclude columns from search & filter","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to exclude from searching and filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column selector","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that allows to toggle visibility of individual columns.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable copy to clipboard","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that copies the table data to the clipboard.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable Excel export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .xlsx file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable CSV export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .csv file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable PDF export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .pdf file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable printing","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a “print” button.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fixed order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Number of columns defined in option “Order columns” for which the order is unchangeable.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Footer row","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data locale","type":"text","marks":[{"type":"strong"}]},{"text":": Define the locale that should be used to parse numbers.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Hide the columns defined in option “Grouping columns“.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide header row","type":"text","marks":[{"type":"strong"}]},{"text":": Hide header row (disables sorting).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Transpose (rotate) table:","type":"text","marks":[{"type":"strong"}]},{"text":" Rotate the full table 90 degrees (handle columns as rows and vice versa).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Show information","type":"text","marks":[{"type":"strong"}]},{"text":": Show dataset information such as number of records.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable state saving","type":"text","marks":[{"type":"strong"}]},{"text":": Disable automatic table state saving and restoring.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Macro “Data Tables CSV (Attachment)”","type":"text"}]},{"type":"paragraph","content":[{"text":"The “Data Tables CSV (Attachment)” macro uses a CSV file attached to the same Confluence page as data source. After inserting the macro, the attached file to load the CSV data from and all other CSV and table options can be defined in the macro settings. As the CSV data is loaded “on demand”, the table always reflects the data defined in the (attached) CSV file.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":15.0},"content":[{"type":"media","attrs":{"width":407,"id":"70d75eb9-5f75-4d46-8eb6-4fa7f218d788","collection":"contentId-897351827","type":"file","height":551}}]},{"type":"paragraph","content":[{"text":"The macro supports the following options:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Attachment","type":"text","marks":[{"type":"strong"}]},{"text":": Define the CSV file attached to the Confluence page to load the CSV data from.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV header row","type":"text","marks":[{"type":"strong"}]},{"text":": Use the first row as column header.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV quote","type":"text","marks":[{"type":"strong"}]},{"text":": Define the character that is used as CSV quote, leave empty if no quote us used.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV delimiter","type":"text","marks":[{"type":"strong"}]},{"text":": Define the character that is used as CSV delimiter.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Column format","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated format (","type":"text"},{"text":"empty","type":"text","marks":[{"type":"em"}]},{"text":", “html”, “link” or “date” in format ","type":"text"},{"text":"YYYY-MM-DD","type":"text","marks":[{"type":"em"}]},{"text":") to be used for rendering the column, whereas “html” supports the tags ,
, and and “link” renders the data as hyperlink.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable paging","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the paging functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Page sizes","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable searching","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the (global) searching functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column filtering","type":"text","marks":[{"type":"strong"}]},{"text":": Enable column filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Exclude columns from search & filter","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to exclude from searching and filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column selector","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that allows to toggle visibility of individual columns.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable copy to clipboard","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that copies the table data to the clipboard.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable Excel export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .xlsx file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable CSV export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .csv file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable PDF export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .pdf file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable printing","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a “print” button.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fixed order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Number of columns defined in option “Order columns” for which the order is unchangeable.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Footer row","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data locale","type":"text","marks":[{"type":"strong"}]},{"text":": Define the locale that should be used to parse numbers.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Hide the columns defined in option “Grouping columns“.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide header row","type":"text","marks":[{"type":"strong"}]},{"text":": Hide header row (disables sorting).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Transpose (rotate) table:","type":"text","marks":[{"type":"strong"}]},{"text":" Rotate the full table 90 degrees (handle columns as rows and vice versa).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Show information","type":"text","marks":[{"type":"strong"}]},{"text":": Show dataset information such as number of records.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable state saving","type":"text","marks":[{"type":"strong"}]},{"text":": Disable automatic table state saving and restoring.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Macro “Data Tables CSV (Remote)”","type":"text"}]},{"type":"paragraph","content":[{"text":"The “Data Tables CSV (Remote)” macro uses CSV remote data as data source. After inserting the macro, the URL to load the CSV data and all other CSV and table options can be defined in the macro settings. As the CSV data is loaded “on demand”, the table always reflects the data defined under the remote URL.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":50.0},"content":[{"type":"media","attrs":{"width":879,"id":"e8b46c13-3ab5-42a5-a511-d81a39b5f938","collection":"contentId-897351827","type":"file","height":542}}]},{"type":"paragraph","content":[{"text":"The macro supports the following options:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"URL","type":"text","marks":[{"type":"strong"}]},{"text":": Define the URL to load the remote CSV data from.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV header row","type":"text","marks":[{"type":"strong"}]},{"text":": Use the first row as column header.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV quote","type":"text","marks":[{"type":"strong"}]},{"text":": Define the character that is used as CSV quote, leave empty if no quote us used.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CSV delimiter","type":"text","marks":[{"type":"strong"}]},{"text":": Define the character that is used as CSV delimiter.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Column format","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated format (","type":"text"},{"text":"empty","type":"text","marks":[{"type":"em"}]},{"text":", “html”, “link” or “date” in format ","type":"text"},{"text":"YYYY-MM-DD","type":"text","marks":[{"type":"em"}]},{"text":") to be used for rendering the column, whereas “html” supports the tags ,
, and and “link” renders the data as hyperlink.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable paging","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the paging functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Page sizes","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable searching","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the (global) searching functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column filtering","type":"text","marks":[{"type":"strong"}]},{"text":": Enable column filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Exclude columns from search & filter","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to exclude from searching and filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column selector","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that allows to toggle visibility of individual columns.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable copy to clipboard","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that copies the table data to the clipboard.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable Excel export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .xlsx file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable CSV export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .csv file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable PDF export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .pdf file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable printing","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a “print” button.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fixed order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Number of columns defined in option “Order columns” for which the order is unchangeable.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Footer row","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated functions (“min” / “minimum”, “max” / “maximum”, “avg” / “average”, “sum”, “count”, “md” / “median” or empty) to be used in the footer row.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data locale","type":"text","marks":[{"type":"strong"}]},{"text":": Define the locale that should be used to parse numbers.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to group; “2;3” for example groups by column 2 and then by column 3.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Hide the columns defined in option “Grouping columns“.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide header row","type":"text","marks":[{"type":"strong"}]},{"text":": Hide header row (disables sorting).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Transpose (rotate) table:","type":"text","marks":[{"type":"strong"}]},{"text":" Rotate the full table 90 degrees (handle columns as rows and vice versa).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Show information","type":"text","marks":[{"type":"strong"}]},{"text":": Show dataset information such as number of records.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable state saving","type":"text","marks":[{"type":"strong"}]},{"text":": Disable automatic table state saving and restoring.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Macro “Data Tables Attachments”","type":"text"}]},{"type":"paragraph","content":[{"text":"The “Data Tables CSV Attachments” uses the list of attached files to that Confluence table as data source. After inserting the macro, the table options can be defined in the macro settings.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":272,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":317,"id":"467df749-972e-4753-8aef-2213aab18ee6","collection":"contentId-897351827","type":"file","height":725}}]},{"type":"paragraph","content":[{"text":"The macro supports the following options:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable paging","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the paging functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Page sizes","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated page sizes (number or “all”) to override default sizes if paging is enabled where the first entry is used as default page size; “all,50,100” for example shows options “50 / 100 / all” and “all” is selected by default","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable searching","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the (global) searching functionality.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column filtering","type":"text","marks":[{"type":"strong"}]},{"text":": Enable column filtering.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable column selector","type":"text","marks":[{"type":"strong"}]},{"text":": Enable the a button that allows to toggle visibility of individual columns.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable copy to clipboard","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that copies the table data to the clipboard.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable Excel export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .xlsx file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable CSV export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .csv file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable PDF export","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a button that exports the table data as .pdf file.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enable printing","type":"text","marks":[{"type":"strong"}]},{"text":": Enable a “print” button.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Show columns","type":"text","marks":[{"type":"strong"}]},{"text":": Select the columns to be included in the table. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Group column","type":"text","marks":[{"type":"strong"}]},{"text":": (Optional) column to group the data.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide grouping columns","type":"text","marks":[{"type":"strong"}]},{"text":": Hide the column defined in option “Group column”.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Hide header row","type":"text","marks":[{"type":"strong"}]},{"text":": Hide header row (disables sorting).","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Comma separated column numbers to order by initially (use “!” to order descending); “2!;1” for example uses column 2 (descending) as primary order column and column 1 (ascending) as second order column.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Fixed order columns","type":"text","marks":[{"type":"strong"}]},{"text":": Number of columns defined in option “Order columns” for which the order is unchangeable.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Show information","type":"text","marks":[{"type":"strong"}]},{"text":": Show dataset information such as number of records.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Disable state saving","type":"text","marks":[{"type":"strong"}]},{"text":": Disable automatic table state saving and restoring.","type":"text"}]}]}]}],"version":1}