Page 1 of 1
Excel Datasource automatic refresh data
Posted: Fri May 06, 2022 3:07 pm
by acataluffi
Hi,
i'm trying to do a dashboard with Excel or CSV as datasource.
Right now, i just used Excel and I can see two different situation:
1. if i modify data (in Excel) in my .NET Viewer data doesn't update, so i should re-upload the dashboard datasource from .NET Designer Online.
2. if i modify data in my Stimulsoft designer DESKTOP APPLICATION data is automatically uploaded to the last file update.
My question is: how can i automatically upload data in my .NET Viewer too to see the update without reload datasource? Is it possible or not?
Thanks, I hope I was understandable
Re: Excel Datasource automatic refresh data
Posted: Mon May 09, 2022 9:20 pm
by Lech Kulikowski
Hello,
> 1. if i modify data (in Excel) in my .NET Viewer data doesn't update, so i should re-upload the dashboard datasource from .NET Designer Online.
How excel data was added to that report?
Thank you.
Re: Excel Datasource automatic refresh data
Posted: Tue May 10, 2022 1:57 pm
by acataluffi
Lech Kulikowski wrote: ↑Mon May 09, 2022 9:20 pm
Hello,
> 1. if i modify data (in Excel) in my .NET Viewer data doesn't update, so i should re-upload the dashboard datasource from .NET Designer Online.
How excel data was added to that report?
Thank you.
Hi,
i should load the file from .NET Designer and not by code.
So, from .NET Dashboard > Dictionary > Data Source > Add Data source
Re: Excel Datasource automatic refresh data
Posted: Wed May 11, 2022 9:41 am
by Lech Kulikowski
Hello,
In the data source to the excel file is a specified path or added as a resource?
Thank you.
Re: Excel Datasource automatic refresh data
Posted: Wed May 11, 2022 2:11 pm
by acataluffi
Lech Kulikowski wrote: ↑Wed May 11, 2022 9:41 am
Hello,
In the data source to the excel file is a specified path or added as a resource?
Thank you.
Hi,
i get it as a file from file input
Thank u
Re: Excel Datasource automatic refresh data
Posted: Fri May 13, 2022 6:51 am
by Lech Kulikowski
Hello,
You can set the RefershTime option for the dashboard to automatically update data.
Thank you.
Re: Excel Datasource automatic refresh data
Posted: Mon May 16, 2022 6:48 am
by acataluffi
Hello,
i tried to set RefreshTime and add some data in my Excel File but the dashboard doesn't update the data, it only refresh itself.
The only way to update data is load a new excel datasource with updated data.
Thank you
Re: Excel Datasource automatic refresh data
Posted: Tue May 17, 2022 11:29 am
by Lech Kulikowski
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.