I'm having problem with getting data exported into excel from hidden
value calculation below:
if(count(instance('commcaresession')/session/user/data/village) > 0, instance('commcaresession')/session/user/data/village, "Unknown")
I'm using custom data form to create mobile users and one of the field populated is village. The beneficiaries registered by CHW should have the same village name as CHW saved onto the beneficiary registered from. But when exporting the information into excel the village colum is either blank or has the work "unknown on it. Your support is appreciated.
Hi Andrew,
There are a couple of reasons this could be occurring in your app, and it's
a bit hard to tell remotely how to best explore them.
Can you look at HQ's form reports and confirm whether or not the "village"
value is being set directly in the form's data for one of your forms?
If so, this is potentially an issue with the export configuration.
If not, the 'village' property may be named differently for your user, and
I can describe some steps to evaluate that user's data.
-Clayton
···
On Fri, Jun 30, 2017 at 6:39 AM, Andrew Ogongo wrote:
I'm having problem with getting data exported into excel from hidden
value calculation below:
if(count(instance('commcaresession')/session/user/data/village) > 0, instance('commcaresession')/session/user/data/village, "Unknown")
I'm using custom data form to create mobile users and one of the field populated is village. The beneficiaries registered by CHW should have the same village name as CHW saved onto the beneficiary registered from. But when exporting the information into excel the village colum is either blank or has the work "unknown on it. Your support is appreciated.
--
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.
Yes, I can confirm the "village" value is being set directly in the
form's data.
Could you describe your second possible cause of the issue and the
steps to follow. Thanks in advance.
Andrew
···
On Fri, Jun 30, 2017 at 5:59 PM, Clayton Sims wrote:
Hi Andrew,
There are a couple of reasons this could be occurring in your app, and
it's a bit hard to tell remotely how to best explore them.
Can you look at HQ's form reports and confirm whether or not the "village"
value is being set directly in the form's data for one of your forms?
If so, this is potentially an issue with the export configuration.
If not, the 'village' property may be named differently for your user, and
I can describe some steps to evaluate that user's data.
-Clayton
On Fri, Jun 30, 2017 at 6:39 AM, Andrew Ogongo aogongo@gmail.com wrote:
I'm having problem with getting data exported into excel from hidden
value calculation below:
if(count(instance('commcaresession')/session/user/data/village) > 0, instance('commcaresession')/session/user/data/village, "Unknown")
I'm using custom data form to create mobile users and one of the field populated is village. The beneficiaries registered by CHW should have the same village name as CHW saved onto the beneficiary registered from. But when exporting the information into excel the village colum is either blank or has the work "unknown on it. Your support is appreciated.
--
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/3omrkm7jz8c/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,
Sorry for the response delay.
There are two reasons the data may not be in an export:
- The export configuration may be referencing an old name for the value
- The form logic isn't properly importing the data at runtime
If the village value appears in the form (as confirmed from viewing the
form after submission on HQ and identifying that the value is in the form),
the field in the export may have changed.
Have you tried making a new export with all fields in the form and seen
whether the village is appearing under an unexpected key?
-Clayton
···
On Fri, Jun 30, 2017 at 2:06 PM, Andrew Ogongo wrote:
Yes, I can confirm the "village" value is being set directly in the
form's data.
Could you describe your second possible cause of the issue and the
steps to follow. Thanks in advance.
Andrew
On Fri, Jun 30, 2017 at 5:59 PM, Clayton Sims csims@dimagi.com wrote:
Hi Andrew,
There are a couple of reasons this could be occurring in your app, and
it's a bit hard to tell remotely how to best explore them.
Can you look at HQ's form reports and confirm whether or not the
"village" value is being set directly in the form's data for one of your
forms?
If so, this is potentially an issue with the export configuration.
If not, the 'village' property may be named differently for your user,
and I can describe some steps to evaluate that user's data.
-Clayton
On Fri, Jun 30, 2017 at 6:39 AM, Andrew Ogongo aogongo@gmail.com wrote:
I'm having problem with getting data exported into excel from hidden
value calculation below:
if(count(instance('commcaresession')/session/user/data/village) > 0, instance('commcaresession')/session/user/data/village, "Unknown")
I'm using custom data form to create mobile users and one of the field populated is village. The beneficiaries registered by CHW should have the same village name as CHW saved onto the beneficiary registered from. But when exporting the information into excel the village colum is either blank or has the work "unknown on it. Your support is appreciated.
--
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/to
pic/commcare-users/3omrkm7jz8c/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.