Data storage and presentation - What would you do?

Rick Lewis_wxz8xz

Hi,

I'm looking for a better way of doing what I'm currently doing.  Here's what I'm doing:

I have a process that runs some activities on a server.  When that process finishes, I write the results to a confluence page.  The results are in a basic confluence page in an html table.  With each run, I put the data values at the top of the html table on the confluence page.  I do some shenanigans to figure out what the top of the html table is.  It's not pretty.  Since I wrote the script in shell, i'm doing a bunch of sed search&replaces on the confluence page file and then reposting that back to confluence as a new version of that page.

Here's what I'm wondering about:

1. Can the "raw" data i'm supplying from the server process run be stored in confluence and can confluence then use that data to build the html table dynamically?
2. I can't store this data outside of what's available to me as a regular confluence user,   Is there a place to put raw data into confluence for use by other pages?  If so, what is that mechanism?

 

I'd love to learn the right way to handle a situation like this.  

Thank you!

R

 

Katerina Kovriga {Stiltsoft}

Hi @Rick Lewis

If you have the possibility to somehow pull your data in CSV or JSON format, then you can browse the Atlassian Marketplace for the apps that allow you to create tables based on such files (I think there even will be free add-ons).

Our app - Table Filter and Charts for Confluence - is generally used for filtration, data aggregation, visualization and table calculations. But we also provide the Table from CSV and Table from JSON macros that allow you to create dynamically changing Confluence tables based on CSV, TSV and JSON data sources (attachments and URLs, the latter option may really suit your case).