Using Lookup Tables with Case Sharing!

Hi there.

I am creating a commcare App to support project’s health workers, called
Health Promoters. Because we have a project database already setup and have
collected all beneficiary details and group membership, we thought it would
be more consistent to push some of these existing records to commcare so
data duplication is avoided, and also that would help us integrate/build an
“interface” between project database and the data collected via commcare.
How possible is it, in commcare, to treat table rows as “cases” ???

Like since , for example, we have a table of CareGroups each belonging to
a row in the HealthPromoters table, with the Health Promoters being the
commcare mobile users(App users), is it possible for Health Promoter to be
able to see care groups only assigned to them via table relationships? I am
a newbie to commcare, and will greatly appreciate your help, and please
find attached sample tables for your reference.

Thanks,
Chaiwa.

CareGroups.xlsx (14 KB)

HealthPromoters.xlsx (9.86 KB)

Chaiwa,

The structure of your data fits very well with the relationships supported
by CommCare. In this case the Care Groups would be cases in your
application, the Health Promoters would be users as you suggest, and you
can map cases to your users in such a way that only cases belonging to that
user will show up on their case list.

I’d recommend reading the documentation here
https://confluence.dimagi.com/display/commcarepublic/Excel+Importer+Instructions,
in particular the pages about creating cases from import
https://confluence.dimagi.com/display/commcarepublic/Creating+New+Cases+-+Select+File+to+Import
and assigning imported cases to a user
https://confluence.dimagi.com/display/commcarepublic/Assigning+imported+cases+to+a+user.
If you haven’t already you might want to check out the page about cases
https://confluence.dimagi.com/display/commcarepublic/Case+Management in
CommCare.

Best,
Will

··· On Fri, Jun 27, 2014 at 8:11 AM, Chaiwa Berian wrote:

Hi there.

I am creating a commcare App to support project’s health workers, called
Health Promoters. Because we have a project database already setup and have
collected all beneficiary details and group membership, we thought it would
be more consistent to push some of these existing records to commcare so
data duplication is avoided, and also that would help us integrate/build an
"interface" between project database and the data collected via commcare.
How possible is it, in commcare, to treat table rows as “cases” ???

Like since , for example, we have a table of CareGroups each belonging to
a row in the HealthPromoters table, with the Health Promoters being the
commcare mobile users(App users), is it possible for Health Promoter to be
able to see care groups only assigned to them via table relationships? I am
a newbie to commcare, and will greatly appreciate your help, and please
find attached sample tables for your reference.

Thanks,
Chaiwa.


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.