CommCare Daily Export Excel Dashboard crashing

Hi All,

We are using daily exports to monitor our data through excel dashboards.
However, each time we update the dashboards, it downloads more and more
data which is making the dashboards very slow. Is there any way of setting
them up so they only download the most recent portion of the data and not
all the historic data as well?

Many thanks!

Jennie

Hi Jennie,

Unfortunately no. For high-volume projects we recommend changing your
workflow to use the data export tool
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool
.

Cory

··· On Wed, Mar 23, 2016 at 5:41 PM, Jennifer Brown wrote:

Hi All,

We are using daily exports to monitor our data through excel dashboards.
However, each time we update the dashboards, it downloads more and more
data which is making the dashboards very slow. Is there any way of setting
them up so they only download the most recent portion of the data and not
all the historic data as well?

Many thanks!

Jennie


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Many thanks for your reply Cory. Are there any other recommended ways in
which to analyse/present the data on a regular basis for daily monitoring?
We are also using Tableau but it seems like we will have the same problems
with the data accumulating over time? Unless it is possible to link Tableau
desktop straight to the CommCare server itself?

··· On Thursday, 24 March 2016 07:19:10 UTC, Cory Zue wrote: > > Hi Jennie, > > Unfortunately no. For high-volume projects we recommend changing your > workflow to use the data export tool > > . > > Cory > > On Wed, Mar 23, 2016 at 5:41 PM, Jennifer Brown <jennifer...@gmail.com > wrote: > >> Hi All, >> >> We are using daily exports to monitor our data through excel dashboards. >> However, each time we update the dashboards, it downloads more and more >> data which is making the dashboards very slow. Is there any way of setting >> them up so they only download the most recent portion of the data and not >> all the historic data as well? >> >> Many thanks! >> >> Jennie >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hey Jennifer,

The data export tool I linked will do incremental updates and can save to a
SQL database. So if you use that to save to a separate database you can
connect tableau to that. That setup has been successful for other projects.

cheers,
Cory

··· On Thu, Mar 24, 2016 at 12:21 PM, Jennifer Brown <jennifer.brown89@gmail.com wrote:

Many thanks for your reply Cory. Are there any other recommended ways in
which to analyse/present the data on a regular basis for daily monitoring?
We are also using Tableau but it seems like we will have the same problems
with the data accumulating over time? Unless it is possible to link Tableau
desktop straight to the CommCare server itself?

On Thursday, 24 March 2016 07:19:10 UTC, Cory Zue wrote:

Hi Jennie,

Unfortunately no. For high-volume projects we recommend changing your
workflow to use the data export tool
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool
.

Cory

On Wed, Mar 23, 2016 at 5:41 PM, Jennifer Brown jennifer...@gmail.com wrote:

Hi All,

We are using daily exports to monitor our data through excel dashboards.
However, each time we update the dashboards, it downloads more and more
data which is making the dashboards very slow. Is there any way of setting
them up so they only download the most recent portion of the data and not
all the historic data as well?

Many thanks!

Jennie


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.