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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

387 views 17 9
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