Dashboard update problem

Hi,
Also posted this on an old topic of the same nature, but I’m having a
problem with the excel dashboard integration. I followed the tutorial
https://confluence.dimagi.com/display/commcarepublic/Tutorial%3A+Create+an+Excel+Dashboard and
I can press refresh in my dashboard and it prompts me for my password and
appears to refresh the data, yet the new data does not get added. The only
data in the dashboard is from the date that I created it. I tried exporting
the new data normally and it comes out in that export, just not in the
excel dashboard. How can I get the dashboard to a. add my new data, and b.
auto update?

In the data connections in excel I have enable background refresh and
refresh every 60min checked (and have tried refreshing with just one or the
other as well).
One thing I noticed which was inconsistent with the tutorial was that when
I create the dashboard feed, even though I have ‘create a daily saved
report’ checked, when I click create and it brings me back to the
dashboards page, it doesn’t say ‘saved for daily report’ like the photo
below from the tutorial- there is only the update data button.

I have also tried pressing this update data button again and then recopying
the link or refreshing my dashboard but that does not work either.
If I create a new dashboard feed and a new dashboard in excel, it includes
the newest data, but that is probably only because it was created today,
and will have the same problem and not update with tomorrow’s data.
Please let me know if you can help in any way asap!

Thanks!

Follow up question along the same lines- I will be mapping my data and have
it set up so that the GIS program detects and refreshes when the file
changes, however the file has to be a csv. If I use the dashboard feed link
to draw data into a csv file (rather than normal excel doc) will the
auto-update still work? (assuming I can get it to work at all)

Thanks!

··· On Thursday, March 23, 2017 at 11:11:20 AM UTC-4, Liz T wrote: > > Hi, > Also posted this on an old topic of the same nature, but I'm having a > problem with the excel dashboard integration. I followed the tutorial > and > I can press refresh in my dashboard and it prompts me for my password and > appears to refresh the data, yet the new data does not get added. The only > data in the dashboard is from the date that I created it. I tried exporting > the new data normally and it comes out in that export, just not in the > excel dashboard. How can I get the dashboard to a. add my new data, and b. > auto update? > > In the data connections in excel I have enable background refresh and > refresh every 60min checked (and have tried refreshing with just one or the > other as well). > One thing I noticed which was inconsistent with the tutorial was that when > I create the dashboard feed, even though I have 'create a daily saved > report' checked, when I click create and it brings me back to the > dashboards page, it doesn't say 'saved for daily report' like the photo > below from the tutorial- there is only the update data button. > > > I have also tried pressing this update data button again and then > recopying the link or refreshing my dashboard but that does not work > either. > If I create a new dashboard feed and a new dashboard in excel, it includes > the newest data, but that is probably only because it was created today, > and will have the same problem and not update with tomorrow's data. > Please let me know if you can help in any way asap! > > Thanks! >