I am new to the confluence and working small requirement. I want to read CSV/txt file from local computer and do some manipulation on that read value before displaying confluence page. Is there any way we can do this using User macro or with predefined function?
Your answers will help me lot to meet my deadline.
There's a new Table from CSV macro you could try in the Table Filter and Charts app. This macro allows you to output a table from CSV or TSV data source on the Confluence page.
By the way, Table from CSV supports outputting data not only from an attached file but also from a URL. And you can use the following data formats: Wiki markup, Markdown, Plain text.
Here's an example of how to use it and manipulate data with the Table Transformer macro then:
1. Add Table from CSV on the Confluence page.
Type in the name of the CSV file from Confluence attachments and click insert.
The table loaded:
2. Wrap the manually created table and Table from CSV with the Table Transformer macro.
Choose the preset needed or write your own SQL query.
Using both Table from CSV and Table Transformer you can load a file and manipulate its data.
Probably you can use ConfiForms ListView to show the data from your form and put the advised macro inside the macro body, in this macro body you can access ConfiForms field values via [entry.field_name] notations that can be passed (and evaluated to values first) to "inner macros"
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event