Linking cases help

Dear all

I have two modules.The first one registers HH Head and his all members
that currently live with him.Inside this form there is also two repeat
groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module there is
one form witch asks about HIV for male only and Family health for female
adults.Inside the family health group there is repeat group which registers
Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am not
sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using Child
cases?

I recommend reading this Help Site page on how to link parent and child
case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

··· On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi wrote:

Dear all

I have two modules.The first one registers HH Head and his all members
that currently live with him.Inside this form there is also two repeat
groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module there is
one form witch asks about HIV for male only and Family health for female
adults.Inside the family health group there is repeat group which registers
Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am not
sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

1 Like

Hi Amelia

I am creating form Export as this is one time survey.I have read this link
and only shows whenever using case export.I have already exported the data
using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The rest
one time visit(serious of question are not available.).So that i don’t to
use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do you
think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using Child
cases?

I recommend reading this Help Site page on how to link parent and child
case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi teweldino.mvp@gmail.com wrote:

Dear all

I have two modules.The first one registers HH Head and his all members
that currently live with him.Inside this form there is also two repeat
groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module there
is one form witch asks about HIV for male only and Family health for female
adults.Inside the family health group there is repeat group which registers
Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am not
sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

Hi Tewelde,

If you are using the form export, you can link each form to the case it
belongs to using the case id. The case id is available in a form export if
that form updated the case. You can find it along with other generic near
the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case export
you can use parent ID to link your child cases to their parents. In this
way you can link form data about a child case back to the household head.

In the future, there are tricks you can use during application design that
make this process a bit easier. For example, you could save household head
name or ID to its child cases as a case property. In forms, you can load
this household head id case property into child forms in a hidden value.
Then each form submission will contain the name or ID of the household
head. In your form exports, the id of the household head will be right
there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

··· On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read this link
and only shows whenever using case export.I have already exported the data
using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The rest
one time visit(serious of question are not available.).So that i don’t to
use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do you
think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using Child
cases?

I recommend reading this Help Site page on how to link parent and child
case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi <teweldino.mvp@gmail.com wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module there
is one form witch asks about HIV for male only and Family health for female
adults.Inside the family health group there is repeat group which registers
Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am not
sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

Thanks Amelia

That makes sense now.But in case export i can’t see Parent ID only case id
is available in both cases types.

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Fri, Dec 25, 2015 at 7:25 AM, Amelia Sagoff wrote:

Hi Tewelde,

If you are using the form export, you can link each form to the case it
belongs to using the case id. The case id is available in a form export if
that form updated the case. You can find it along with other generic near
the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case export
you can use parent ID to link your child cases to their parents. In this
way you can link form data about a child case back to the household head.

In the future, there are tricks you can use during application design that
make this process a bit easier. For example, you could save household head
name or ID to its child cases as a case property. In forms, you can load
this household head id case property into child forms in a hidden value.
Then each form submission will contain the name or ID of the household
head. In your form exports, the id of the household head will be right
there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi teweldino.mvp@gmail.com wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read this
link and only shows whenever using case export.I have already exported the
data using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The rest
one time visit(serious of question are not available.).So that i don’t to
use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do you
think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using Child
cases?

I recommend reading this Help Site page on how to link parent and child
case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module there
is one form witch asks about HIV for male only and Family health for female
adults.Inside the family health group there is repeat group which registers
Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am
not sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

–
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.

Glad we’re getting closer! And I should have been more specific about how
to get the parent id - you were right, it does have to do with the row
numbers.

In the case export for a child case, you should see a section called
“Parent Cases”. Inside this section is a “case id”. This is what I was
referring to as the parent id.

Parent case ids will show up in a separate sheet or tab with a row number
that corresponds to the main export sheet/tab, very similar to repeat data.

Amelia

··· On Fri, Dec 25, 2015 at 10:42 AM, Tewelde Aregawi wrote:

Thanks Amelia

That makes sense now.But in case export i can’t see Parent ID only case
id is available in both cases types.

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:25 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

If you are using the form export, you can link each form to the case it
belongs to using the case id. The case id is available in a form export if
that form updated the case. You can find it along with other generic near
the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case export
you can use parent ID to link your child cases to their parents. In this
way you can link form data about a child case back to the household head.

In the future, there are tricks you can use during application design
that make this process a bit easier. For example, you could save household
head name or ID to its child cases as a case property. In forms, you can
load this household head id case property into child forms in a hidden
value. Then each form submission will contain the name or ID of the
household head. In your form exports, the id of the household head will be
right there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi <teweldino.mvp@gmail.com wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read this
link and only shows whenever using case export.I have already exported the
data using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The
rest one time visit(serious of question are not available.).So that i don’t
to use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do you
think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using
Child cases?

I recommend reading this Help Site page on how to link parent and child
case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module
there is one form witch asks about HIV for male only and Family health for
female adults.Inside the family health group there is repeat group which
registers Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am
not sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

–
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.

–
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.

Hello Amelia

​I have tried to link accordingly but they are many not matched cases.
you can look the stata result below.

Result                           # of obs.

··· ----------------------------------------- not matched 1,474 from master 1,474 (_merge==1) from using 0 (_merge==2)
matched                             2,959  (_merge==3)
-----------------------------------------

​

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:56 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Glad we’re getting closer! And I should have been more specific about how
to get the parent id - you were right, it does have to do with the row
numbers.

In the case export for a child case, you should see a section called
“Parent Cases”. Inside this section is a “case id”. This is what I was
referring to as the parent id.

Parent case ids will show up in a separate sheet or tab with a row number
that corresponds to the main export sheet/tab, very similar to repeat data.

Amelia

On Fri, Dec 25, 2015 at 10:42 AM, Tewelde Aregawi <teweldino.mvp@gmail.com wrote:

Thanks Amelia

That makes sense now.But in case export i can’t see Parent ID only case
id is available in both cases types.

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:25 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

If you are using the form export, you can link each form to the case it
belongs to using the case id. The case id is available in a form export if
that form updated the case. You can find it along with other generic near
the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case export
you can use parent ID to link your child cases to their parents. In this
way you can link form data about a child case back to the household head.

In the future, there are tricks you can use during application design
that make this process a bit easier. For example, you could save household
head name or ID to its child cases as a case property. In forms, you can
load this household head id case property into child forms in a hidden
value. Then each form submission will contain the name or ID of the
household head. In your form exports, the id of the household head will be
right there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read this
link and only shows whenever using case export.I have already exported the
data using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The
rest one time visit(serious of question are not available.).So that i don’t
to use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do
you think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using
Child cases?

I recommend reading this Help Site page on how to link parent and
child case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module
there is one form witch asks about HIV for male only and Family health for
female adults.Inside the family health group there is repeat group which
registers Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am
not sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

–
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.

–
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.

–
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.

Hello Amelia

I am able to link Household head with members and child with their
mothers.But i can’t link mother with Household head.? How can i link mother
with her child to Household head.I can’t find common variables To link this?

I need quick help in this.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Fri, Dec 25, 2015 at 7:41 PM, Tewelde Aregawi wrote:

Hello Amelia

​I have tried to link accordingly but they are many not matched cases.
you can look the stata result below.

Result                           # of obs.
-----------------------------------------
not matched                         1,474
    from master                     1,474  (_merge==1)
    from using                          0  (_merge==2)

matched                             2,959  (_merge==3)
-----------------------------------------

​

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:56 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Glad we’re getting closer! And I should have been more specific about how
to get the parent id - you were right, it does have to do with the row
numbers.

In the case export for a child case, you should see a section called
“Parent Cases”. Inside this section is a “case id”. This is what I was
referring to as the parent id.

Parent case ids will show up in a separate sheet or tab with a row number
that corresponds to the main export sheet/tab, very similar to repeat data.

Amelia

On Fri, Dec 25, 2015 at 10:42 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Thanks Amelia

That makes sense now.But in case export i can’t see Parent ID only case
id is available in both cases types.

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:25 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

If you are using the form export, you can link each form to the case it
belongs to using the case id. The case id is available in a form export if
that form updated the case. You can find it along with other generic near
the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case
export you can use parent ID to link your child cases to their parents. In
this way you can link form data about a child case back to the household
head.

In the future, there are tricks you can use during application design
that make this process a bit easier. For example, you could save household
head name or ID to its child cases as a case property. In forms, you can
load this household head id case property into child forms in a hidden
value. Then each form submission will contain the name or ID of the
household head. In your form exports, the id of the household head will be
right there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read this
link and only shows whenever using case export.I have already exported the
data using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The
rest one time visit(serious of question are not available.).So that i don’t
to use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do
you think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using
Child cases?

I recommend reading this Help Site page on how to link parent and
child case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module
there is one form witch asks about HIV for male only and Family health for
female adults.Inside the family health group there is repeat group which
registers Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I am
not sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

–
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.

–
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.

–
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.

Hi Tewelde,

In case useful, please see this help site page:
https://wiki.commcarehq.org/display/commcarepublic/Linking+Parent+and+Child+Case+Data

If you have multiple levels of parent/child relationships then you will
need to link the levels one at a time. For example, if you have parent ->
child -> grandchild, then you could link parent -> child, and then child->
grandchild to generate a master case list of grandchild cases that have the
child and parent ids.

Jeremy

··· On Sun, Dec 27, 2015 at 4:31 AM, Tewelde Aregawi wrote:

Hello Amelia

I am able to link Household head with members and child with their
mothers.But i can’t link mother with Household head.? How can i link mother
with her child to Household head.I can’t find common variables To link this?

I need quick help in this.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:41 PM, Tewelde Aregawi teweldino.mvp@gmail.com wrote:

Hello Amelia

​I have tried to link accordingly but they are many not matched cases.
you can look the stata result below.

Result                           # of obs.
-----------------------------------------
not matched                         1,474
    from master                     1,474  (_merge==1)
    from using                          0  (_merge==2)

matched                             2,959  (_merge==3)
-----------------------------------------

​

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:56 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Glad we’re getting closer! And I should have been more specific about
how to get the parent id - you were right, it does have to do with the row
numbers.

In the case export for a child case, you should see a section called
“Parent Cases”. Inside this section is a “case id”. This is what I was
referring to as the parent id.

Parent case ids will show up in a separate sheet or tab with a row
number that corresponds to the main export sheet/tab, very similar to
repeat data.

Amelia

On Fri, Dec 25, 2015 at 10:42 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Thanks Amelia

That makes sense now.But in case export i can’t see Parent ID only
case id is available in both cases types.

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:25 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

If you are using the form export, you can link each form to the case
it belongs to using the case id. The case id is available in a form export
if that form updated the case. You can find it along with other generic
near the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case
export you can use parent ID to link your child cases to their parents. In
this way you can link form data about a child case back to the household
head.

In the future, there are tricks you can use during application design
that make this process a bit easier. For example, you could save household
head name or ID to its child cases as a case property. In forms, you can
load this household head id case property into child forms in a hidden
value. Then each form submission will contain the name or ID of the
household head. In your form exports, the id of the household head will be
right there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read this
link and only shows whenever using case export.I have already exported the
data using form export and need to link Household head with his members and
Mother with here children.

In case export only updated information of the case is available.The
rest one time visit(serious of question are not available.).So that i don’t
to use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do
you think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using
Child cases?

I recommend reading this Help Site page on how to link parent and
child case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module
there is one form witch asks about HIV for male only and Family health for
female adults.Inside the family health group there is repeat group which
registers Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I
am not sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

–
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.

–
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.

–
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.

–
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.

–
Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.

Thank you Jeremy now everything is clear.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

··· On Mon, Dec 28, 2015 at 7:33 AM, Jeremy W. wrote:

Hi Tewelde,

In case useful, please see this help site page:
https://wiki.commcarehq.org/display/commcarepublic/Linking+Parent+and+Child+Case+Data

If you have multiple levels of parent/child relationships then you will
need to link the levels one at a time. For example, if you have parent ->
child -> grandchild, then you could link parent -> child, and then child->
grandchild to generate a master case list of grandchild cases that have the
child and parent ids.

Jeremy

On Sun, Dec 27, 2015 at 4:31 AM, Tewelde Aregawi teweldino.mvp@gmail.com wrote:

Hello Amelia

I am able to link Household head with members and child with their
mothers.But i can’t link mother with Household head.? How can i link mother
with her child to Household head.I can’t find common variables To link this?

I need quick help in this.

Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:41 PM, Tewelde Aregawi <teweldino.mvp@gmail.com wrote:

Hello Amelia

​I have tried to link accordingly but they are many not matched cases.
you can look the stata result below.

Result                           # of obs.
-----------------------------------------
not matched                         1,474
    from master                     1,474  (_merge==1)
    from using                          0  (_merge==2)

matched                             2,959  (_merge==3)
-----------------------------------------

​

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness and
Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:56 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Glad we’re getting closer! And I should have been more specific about
how to get the parent id - you were right, it does have to do with the row
numbers.

In the case export for a child case, you should see a section called
“Parent Cases”. Inside this section is a “case id”. This is what I was
referring to as the parent id.

Parent case ids will show up in a separate sheet or tab with a row
number that corresponds to the main export sheet/tab, very similar to
repeat data.

Amelia

On Fri, Dec 25, 2015 at 10:42 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Thanks Amelia

That makes sense now.But in case export i can’t see Parent ID only
case id is available in both cases types.

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 7:25 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

If you are using the form export, you can link each form to the case
it belongs to using the case id. The case id is available in a form export
if that form updated the case. You can find it along with other generic
near the bottom when you create a form export:
[image: Inline image 1]

You can use this ID to link the form to its case, and in the case
export you can use parent ID to link your child cases to their parents. In
this way you can link form data about a child case back to the household
head.

In the future, there are tricks you can use during application design
that make this process a bit easier. For example, you could save household
head name or ID to its child cases as a case property. In forms, you can
load this household head id case property into child forms in a hidden
value. Then each form submission will contain the name or ID of the
household head. In your form exports, the id of the household head will be
right there.

To answer your question about the rows in the excel sheet - these
correspond to repeat groups. If you included repeat groups in your form
export, each row corresponds to a different repeat group in the form. You
can find each repeat group’s data in another tab in your export.

Amelia

On Fri, Dec 25, 2015 at 9:49 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Hi Amelia

I am creating form Export as this is one time survey.I have read
this link and only shows whenever using case export.I have already exported
the data using form export and need to link Household head with his members
and Mother with here children.

In case export only updated information of the case is available.The
rest one time visit(serious of question are not available.).So that i don’t
to use case export.

There is Row number,Row number_0,Row number_1 in the Form export .Do
you think those variables are useful for linking ?If so How?
Best

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty, Selflessness
and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

On Fri, Dec 25, 2015 at 6:27 AM, Amelia Sagoff asagoff@dimagi.com wrote:

Hi Tewelde,

Because you are opening cases from repeats, I assume you are using
Child cases?

I recommend reading this Help Site page on how to link parent and
child case data:
https://confluence.dimagi.com/display/commcarepublic/Linking+Parent+and+Child+Case+Data

Hope this is helpful!

Amelia

On Fri, Dec 25, 2015 at 6:34 AM, Tewelde Aregawi < teweldino.mvp@gmail.com> wrote:

Dear all

I have two modules.The first one registers HH Head and his all
members that currently live with him.Inside this form there is also two
repeat groups which registers malaria cases and TB cases.

The second module holds Adult male and female ,inside this module
there is one form witch asks about HIV for male only and Family health for
female adults.Inside the family health group there is repeat group which
registers Birth if the woman give birth.

Here what i need is how to link those all cases with their data.I
am not sure which variable to take for linking.

Any one who have experience on this.?

With best regards,

Tewelde Aregawi

E-Health Specialist

MVP(MDE)

Tigray/Hawzein

Mobile +251933730215
Skype : tewelde.aregawi1
Face Book : tewelde aregawi

Courage, Strength, Determination, Compassion, Loyalty,
Selflessness and Confidence
Call
Send SMS
Add to Skype
You’ll need Skype CreditFree via Skype

–
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.

–
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.

–
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.

–
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.

–
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.

–
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.

–
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.

–
Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.

–
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.