Add a refresh button to clean-up the cache in .Stat DLM Excel add-in
Currently, there is an already in-built cache that has 2 functions:
- caching structures for the duration of 3 days
- caching data for the duration of the current Excel session
In order to allow users getting fresher structures or data than those in the current cache, the following enhancements should be added:
Add a cache clean-up feature (UI user button) in the first screen of the "Change selection" wizard, that empties the cache for all structures and data. It also triggers a reload of the theme tree/dataflow list.
The related button is to be added close to the dataflow drop-down list as per below mockup with a tooltip mentioning "Get latest version of dataset list":
The 2 data refresh buttons in the menu toolbar will empty the cache of the currently concerned data before requesting fresh data from the web service. Therefore these Refresh buttons will always make a new request to the underlying web service.
- Design a refresh button (available in the first comment of this ticket)
- Implement the action