Excel integration with old data

Hello,

We’ve switched from ONA to CommCare and have just set up the Excel
dashboard integration feed for new data submitted to our form.

However, we have a ton of data from years of ONA.

Is there a way to permanently merge my CommCare-hosted dataset with my
legacy ONA dataset–without the web import overwriting my ONA data each
time it refreshes?

(These are form data, not case data. I’ve cleaned the data so that it
aligns with the CommCare output.)

Thank you for your help.
C

This article might help:

I think you’d want to have your ONA data in one worksheet and then your
CommCare data in another worksheet and then create a master sheet that
combines data from both.

Sheel

··· On Mon, Nov 13, 2017 at 6:44 AM, wrote:

Hello,

We’ve switched from ONA to CommCare and have just set up the Excel
dashboard integration feed for new data submitted to our form.

However, we have a ton of data from years of ONA.

Is there a way to permanently merge my CommCare-hosted dataset with my
legacy ONA dataset–without the web import overwriting my ONA data each
time it refreshes?

(These are form data, not case data. I’ve cleaned the data so that it
aligns with the CommCare output.)

Thank you for your help.
C


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.


Sheel Shah
Project Manager | Dimagi
m: +1.781.428.5419 | skype: sheel_shah