Variables in imported cases not visible

Hi,
I have imported a few cases using excel importer. The imported file has
other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

Hi Prachi,

Could you please share screenshots of your configuration? Specifically it
would be useful to see your case list configuration, the properties you’re
loading into the form, and the Case List report page for one of the cases
you imported.

Cheers,
Will

··· On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel wrote:

Hi,
I have imported a few cases using excel importer. The imported file has
other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi


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 Will,
Thank you for the response. Have attached 2 screenshots of the variable in
the tool, the question where it is being referenced and the cases being
imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

Test sample.xlsx (9.7 KB)

··· On Mon, Jul 10, 2017 at 4:33 PM William Pride wrote:

Hi Prachi,

Could you please share screenshots of your configuration? Specifically it
would be useful to see your case list configuration, the properties you’re
loading into the form, and the Case List report page for one of the cases
you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file has
other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able to
load properties into it from cases imported in the case importer. Maybe I’m
misunderstanding what you’re trying to do?

Cheers,
Will

··· On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the variable in
the tool, the question where it is being referenced and the cases being
imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration? Specifically it
would be useful to see your case list configuration, the properties you’re
loading into the form, and the Case List report page for one of the cases
you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file has
other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 William,
The form updates or closes a case. Sharing the screenshot for the same.
[image: image.png]

Thanks,
Prachi

··· On Mon, Jul 10, 2017 at 5:05 PM William Pride wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able to
load properties into it from cases imported in the case importer. Maybe I’m
misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the variable
in the tool, the question where it is being referenced and the cases being
imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration? Specifically
it would be useful to see your case list configuration, the properties
you’re loading into the form, and the Case List report page for one of the
cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file has
other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Apologies, my mistake

It looks like that “sub_typology” question does not have any default value
loaded into it - perhaps that’s your issue?

Cheers,
Will

··· On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able to
load properties into it from cases imported in the case importer. Maybe I’m
misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the variable
in the tool, the question where it is being referenced and the cases being
imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration? Specifically
it would be useful to see your case list configuration, the properties
you’re loading into the form, and the Case List report page for one of the
cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file
has other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 William,
Any specific reason why a default value should be loaded? There are quite a
few questions which refer to these imported variables. So not sure. Also, I
tried creating a label with Typology and it showed blank.
Thanks,
Prachi

··· On Mon, Jul 10, 2017 at 5:12 PM William Pride wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default value
loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able to
load properties into it from cases imported in the case importer. Maybe I’m
misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the variable
in the tool, the question where it is being referenced and the cases being
imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration? Specifically
it would be useful to see your case list configuration, the properties
you’re loading into the form, and the Case List report page for one of the
cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file
has other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Prachi,

That is the mechanism by which case properties are loaded into the form to
be used. If you want to reference the property in multiple places you could
load it into that hidden value, than reference that hidden value in the
rest of the form.

Cheers,
Will

··· On Mon, Jul 10, 2017 at 7:44 AM, Prachi Patel wrote:

Hi William,
Any specific reason why a default value should be loaded? There are quite
a few questions which refer to these imported variables. So not sure. Also,
I tried creating a label with Typology and it showed blank.
Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:12 PM William Pride wpride@dimagi.com wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default
value loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able
to load properties into it from cases imported in the case importer. Maybe
I’m misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the
variable in the tool, the question where it is being referenced and the
cases being imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration?
Specifically it would be useful to see your case list configuration, the
properties you’re loading into the form, and the Case List report page for
one of the cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file
has other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 William,
So the hidden variable typology should be referenced by the typology in the
properties listed below? If that is yes, then it hasn’t worked. Sorry for
so many questions but I seem to be stuck perpetually!

Thanks,
Prachi

··· On Mon, 10 Jul 2017, 17:29 William Pride, wrote:

Hi Prachi,

That is the mechanism by which case properties are loaded into the form to
be used. If you want to reference the property in multiple places you could
load it into that hidden value, than reference that hidden value in the
rest of the form.

Cheers,
Will

On Mon, Jul 10, 2017 at 7:44 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
Any specific reason why a default value should be loaded? There are quite
a few questions which refer to these imported variables. So not sure. Also,
I tried creating a label with Typology and it showed blank.
Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:12 PM William Pride wpride@dimagi.com wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default
value loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able
to load properties into it from cases imported in the case importer. Maybe
I’m misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the
variable in the tool, the question where it is being referenced and the
cases being imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration?
Specifically it would be useful to see your case list configuration, the
properties you’re loading into the form, and the Case List report page for
one of the cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported file
has other variables like age, typology etc which I want to use in my tool.
However, when I refer them back in the main form, it shows me blank despite
showing in the case list. Please help!

Thanks,
Prachi

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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Prachi,

From what I can tell from your screenshots the root issue is that the
hidden variable ‘typology’ is not being loaded with the case property
‘typology’ as a default value. This is necessary in order for any case
properties, including imported ones, to be loaded into a form.

Cheers,
Will

··· On Mon, Jul 10, 2017 at 8:33 AM, Prachi Patel wrote:

Hi William,
So the hidden variable typology should be referenced by the typology in
the properties listed below? If that is yes, then it hasn’t worked. Sorry
for so many questions but I seem to be stuck perpetually!

Thanks,
Prachi

On Mon, 10 Jul 2017, 17:29 William Pride, wpride@dimagi.com wrote:

Hi Prachi,

That is the mechanism by which case properties are loaded into the form
to be used. If you want to reference the property in multiple places you
could load it into that hidden value, than reference that hidden value in
the rest of the form.

Cheers,
Will

On Mon, Jul 10, 2017 at 7:44 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
Any specific reason why a default value should be loaded? There are
quite a few questions which refer to these imported variables. So not sure.
Also, I tried creating a label with Typology and it showed blank.
Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:12 PM William Pride wpride@dimagi.com wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default
value loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be able
to load properties into it from cases imported in the case importer. Maybe
I’m misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the
variable in the tool, the question where it is being referenced and the
cases being imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration?
Specifically it would be useful to see your case list configuration, the
properties you’re loading into the form, and the Case List report page for
one of the cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported
file has other variables like age, typology etc which I want to use in my
tool. However, when I refer them back in the main form, it shows me blank
despite showing in the case list. Please help!

Thanks,
Prachi

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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 Will,
How shall we do that?

Thanks,
Prachi

··· On Mon, 10 Jul 2017, 20:12 William Pride, wrote:

Prachi,

From what I can tell from your screenshots the root issue is that the
hidden variable ‘typology’ is not being loaded with the case property
‘typology’ as a default value. This is necessary in order for any case
properties, including imported ones, to be loaded into a form.

Cheers,
Will

On Mon, Jul 10, 2017 at 8:33 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
So the hidden variable typology should be referenced by the typology in
the properties listed below? If that is yes, then it hasn’t worked. Sorry
for so many questions but I seem to be stuck perpetually!

Thanks,
Prachi

On Mon, 10 Jul 2017, 17:29 William Pride, wpride@dimagi.com wrote:

Hi Prachi,

That is the mechanism by which case properties are loaded into the form
to be used. If you want to reference the property in multiple places you
could load it into that hidden value, than reference that hidden value in
the rest of the form.

Cheers,
Will

On Mon, Jul 10, 2017 at 7:44 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
Any specific reason why a default value should be loaded? There are
quite a few questions which refer to these imported variables. So not sure.
Also, I tried creating a label with Typology and it showed blank.
Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:12 PM William Pride wpride@dimagi.com wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default
value loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the
same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be
able to load properties into it from cases imported in the case importer.
Maybe I’m misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the
variable in the tool, the question where it is being referenced and the
cases being imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration?
Specifically it would be useful to see your case list configuration, the
properties you’re loading into the form, and the Case List report page for
one of the cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel <prachi@cms-india.org wrote:

Hi,
I have imported a few cases using excel importer. The imported
file has other variables like age, typology etc which I want to use in my
tool. However, when I refer them back in the main form, it shows me blank
despite showing in the case list. Please help!

Thanks,
Prachi

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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[image: image.png]

I am assuming this is what you were talking about. Unfortunately, this is
not working either

··· On Mon, Jul 10, 2017 at 8:56 PM Prachi Patel wrote:

Hi Will,
How shall we do that?

Thanks,
Prachi

On Mon, 10 Jul 2017, 20:12 William Pride, wpride@dimagi.com wrote:

Prachi,

From what I can tell from your screenshots the root issue is that the
hidden variable ‘typology’ is not being loaded with the case property
‘typology’ as a default value. This is necessary in order for any case
properties, including imported ones, to be loaded into a form.

Cheers,
Will

On Mon, Jul 10, 2017 at 8:33 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
So the hidden variable typology should be referenced by the typology in
the properties listed below? If that is yes, then it hasn’t worked. Sorry
for so many questions but I seem to be stuck perpetually!

Thanks,
Prachi

On Mon, 10 Jul 2017, 17:29 William Pride, wpride@dimagi.com wrote:

Hi Prachi,

That is the mechanism by which case properties are loaded into the form
to be used. If you want to reference the property in multiple places you
could load it into that hidden value, than reference that hidden value in
the rest of the form.

Cheers,
Will

On Mon, Jul 10, 2017 at 7:44 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
Any specific reason why a default value should be loaded? There are
quite a few questions which refer to these imported variables. So not sure.
Also, I tried creating a label with Typology and it showed blank.
Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:12 PM William Pride wpride@dimagi.com wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default
value loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the
same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be
able to load properties into it from cases imported in the case importer.
Maybe I’m misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel <prachi@cms-india.org wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the
variable in the tool, the question where it is being referenced and the
cases being imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration?
Specifically it would be useful to see your case list configuration, the
properties you’re loading into the form, and the Case List report page for
one of the cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel < prachi@cms-india.org> wrote:

Hi,
I have imported a few cases using excel importer. The imported
file has other variables like age, typology etc which I want to use in my
tool. However, when I refer them back in the main form, it shows me blank
despite showing in the case list. Please help!

Thanks,
Prachi

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 a topic
in the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe
.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Prachi,

That looks correct. When you view the case in the Case List report is that
property (‘typology’) set for the case that you’re opening?

Cheers,
Will

··· On Mon, Jul 10, 2017 at 12:17 PM, Prachi Patel wrote:

[image: image.png]

I am assuming this is what you were talking about. Unfortunately, this is
not working either

On Mon, Jul 10, 2017 at 8:56 PM Prachi Patel prachi@cms-india.org wrote:

Hi Will,
How shall we do that?

Thanks,
Prachi

On Mon, 10 Jul 2017, 20:12 William Pride, wpride@dimagi.com wrote:

Prachi,

From what I can tell from your screenshots the root issue is that the
hidden variable ‘typology’ is not being loaded with the case property
‘typology’ as a default value. This is necessary in order for any case
properties, including imported ones, to be loaded into a form.

Cheers,
Will

On Mon, Jul 10, 2017 at 8:33 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
So the hidden variable typology should be referenced by the typology in
the properties listed below? If that is yes, then it hasn’t worked. Sorry
for so many questions but I seem to be stuck perpetually!

Thanks,
Prachi

On Mon, 10 Jul 2017, 17:29 William Pride, wpride@dimagi.com wrote:

Hi Prachi,

That is the mechanism by which case properties are loaded into the
form to be used. If you want to reference the property in multiple places
you could load it into that hidden value, than reference that hidden value
in the rest of the form.

Cheers,
Will

On Mon, Jul 10, 2017 at 7:44 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
Any specific reason why a default value should be loaded? There are
quite a few questions which refer to these imported variables. So not sure.
Also, I tried creating a label with Typology and it showed blank.
Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:12 PM William Pride wpride@dimagi.com wrote:

Apologies, my mistake

It looks like that “sub_typology” question does not have any default
value loaded into it - perhaps that’s your issue?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:36 AM, Prachi Patel prachi@cms-india.org wrote:

Hi William,
The form updates or closes a case. Sharing the screenshot for the
same.
[image: image.png]

Thanks,
Prachi

On Mon, Jul 10, 2017 at 5:05 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

That forms looks like it registers a new case so you wouldn’t be
able to load properties into it from cases imported in the case importer.
Maybe I’m misunderstanding what you’re trying to do?

Cheers,
Will

On Mon, Jul 10, 2017 at 7:20 AM, Prachi Patel < prachi@cms-india.org> wrote:

Hi Will,
Thank you for the response. Have attached 2 screenshots of the
variable in the tool, the question where it is being referenced and the
cases being imported.

Hope this helps! Thanks
[image: image.png]

[image: image.png]

On Mon, Jul 10, 2017 at 4:33 PM William Pride wpride@dimagi.com wrote:

Hi Prachi,

Could you please share screenshots of your configuration?
Specifically it would be useful to see your case list configuration, the
properties you’re loading into the form, and the Case List report page for
one of the cases you imported.

Cheers,
Will

On Sun, Jul 9, 2017 at 8:07 AM, Prachi Patel < prachi@cms-india.org> wrote:

Hi,
I have imported a few cases using excel importer. The imported
file has other variables like age, typology etc which I want to use in my
tool. However, when I refer them back in the main form, it shows me blank
despite showing in the case list. Please help!

Thanks,
Prachi

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 a topic
in the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/
DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in
the Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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 a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-users/DetZcSbW4iU/unsubscribe.
To unsubscribe from this group and all its topics, 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.