csv table export macro caching options

CSV table export macro plugin seems to be caching the output table - i.e. exporting from the same page in a certain time interval gives me the same output file although the page contents has already changed. I cannot seem to find any caching options to disable this or change the timing. I also tried to tick the volatile table checkbox on and off but that did not change it.

Plugin version 1.1.3

Confluence version 5.10.1

Could someone please advise?

6 answers

From what I read, you need the "volatile" option, and maybe it would help to put the export-csv plugin at the outermost position so that it encloses everything?

The plugin uses the confluence cache to save the data and make it faster. If you set it to "volatile" it won't be saving it in caches. But it does not use a temp file. 

You also could try to flush the cache of the plugin on the cache managment site

https://confluence.atlassian.com/doc/cache-statistics-150472.html

Fabian, thank you very much for your caching comment. Although I am pretty convinced it did not work when I raised the case (back then I suggested I tried it on and off), it seems to be doing better now with the volatile setting ticked.

Hi Martin,

As a workaround you can export table to CSV using Table Filter macro.

Are there other plugins involved or just a plain old table?

Fabian, I am afraid it is rather dynamic content generated by the 'SQL query' plugin, all of which is also wrapped inside 'Run Self-service reports' plugin. So, in a sense, the structure is as follows: <run><export><sql-query>results table</sql-query></export></run>. Please let me know if something is not clear.

Can you describe how you are using the table, so that it changes but the csv doesnt? 

I have to say, the plugin only exports everything as it is on page load, so maybe you are pressing some sort of filter-option in the browser after the page load?

Fabian, the problem definitely occurs with larger tables, say, several thousand rows.

 

The usage is as follows:
1) the page contains the run self-service plugin, which allows for selection of a country

2) inside the 'run' plugin (1) there is the 'export csv' plugin

3) inside the 'export csv' plugin (2) there is a sql-query plugin, which returns rows for the selected country

4) i run the page for one country, click 'export', it exports the file for the selected country.

5) i then re-run the page with a different country selected, the report shows the correct contents on the screen, but when I click 'export' the exported file still contains the data from step (4), even if I re-logon to a new browser session, and even if I change the browser from chrome to Firefox.

 

Could it have something to do with the plugin trying and failing to overwrite some temp file?

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,852 views 27 11
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you