asked on October 29, 2019
hello :
My file is a big file csv (10 mg), who change once a day.
Could flexmonster load the file once for a day plz ?
That's means we needn't reload the file when we reopen page flexmonster !
Thanks
⋅ October 30, 2019
hello :
I think I did not express my problem well !
in fact, the data is renewed once a day, it is stable in the day.
but it is big, the flexmonster needs time to load,
I would like the flexmonster load the first time when we open the page, then when we reflesh the page, or reopen the page, the flexmonster does not need to reload the data. is there a cache in flexmonster to do it please ?
⋅ October 30, 2019
Hello,
Thank you for the details.
We would like to explain that Flexmonster does not cache/store any data in the user's browser.
It is due to security reasons. That's why if you need an additional layer with cache, you can try to implement it on top of the Flexmonster. For example, you can use inline JSON and cache it in the browser's localStorage (see example https://jsfiddle.net/flexmonster/c2e71fvj/). Please note that it is only possible with JSON, all other data sources require loading the data from external resources every time.
As an alternative solution, we suggest taking a look at our beta feature (for the next major release) that can help to dramatically reduce the loading time by querying already aggregated data from the server: https://github.com/flexmonster/api-data-source
Please let us know if you have any other questions.
Regards,
Ian
⋅ March 18, 2020
Hello,
We are happy to inform you that the custom data source API has been implemented in Flexmonster version 2.8.
The custom data source API is a communication protocol that allows exchanging aggregated data between your data layer and Flexmonster Pivot Table & Charts.
The main advantage of using custom data source API over parsing and loading the whole data set into the component is the possibility to operate with aggregated data and pass only the data required for the current report instead of loading the whole data set. It allows increasing the speed dramatically and handling much larger data volumes due to the fact the client's machine does not have to store the whole data set.
We have prepared two sample servers, including the .NET Core server, which supports connection to the CSV files. It can be found on our GitHub. Its source code is open, and you are welcome to use it or modify it in the way it fits your requirements.
The sample itself can be found by the following link: https://github.com/flexmonster/api-data-source. A quick overview of the mentioned example is placed in our documentation: https://www.flexmonster.com/doc/pivot-table-with-dot-net-core-server/.
Also, we recommend checking out our blog post in order to get familiar with the idea of custom data source API and find out more about the advantages it brings in: https://www.flexmonster.com/blog/connect-to-any-data-source-with-flexmonster/.
Do not hesitate to contact us in case any questions on this point occur.
Kind regards,
Illia
