csv table export macro caching options

[Martin Berins]

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?

[Fabian Welz]

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

[Martin Berins]

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.

[Martin Berins]

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?

[Fabian Welz]

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?

[Martin Berins]

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.

[Fabian Welz]

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

[Andrey Khaneev _StiltSoft_]

Hi Martin,

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