Trouble with data in export

Hi all - Having trouble with exporting data to excel for one of the forms we
have created in our application. When we export we get most of the data with
no problem with the exception of 2 fields - one of which is driver name

When we export all of the fields in the form the driver name appears as
"af700c70-4334-4900-938d-b5a080ac9671" instead of “JOHN” for example. This
field and one other are pulled from values entered in another form and these
values appear just fine for the user in the application. As you can see from
the below we are getting driver name from a case called “usafiri” where I
can see the driver names listed

                                                            <label

ref=“jr:itext(‘driver_name-label’)” />

                                                            <itemset

nodeset=“instance(‘casedb’)/casedb/case[@case_type=‘usafiri’]”>

                                                            </itemset>

                                            </select1>

Here’s the bind statement we are using

Feel like I am missing something obvious - any ideas out there?

Thank you in advance

··· ---------------

Steve Ollis

Chief Operating Officer

D-tree International

http://www.d-tree.org http://www.d-tree.org/

+1.410.443.3916

Skype: ollisste

Hi Steve,

To isolate whether the issue is with the export or the form logic, could
you have someone on your team fill out a form where you know the field
should be set, and then view the form via the submit history report and
check whether it’s there?

(Someone else might see something obviously wrong in your expression in the
meantime).

Cory

··· On Fri, May 10, 2013 at 8:27 AM, Steve Ollis wrote:

Hi all - Having trouble with exporting data to excel for one of the forms
we have created in our application. When we export we get most of the data
with no problem with the exception of 2 fields – one of which is driver name



When we export all of the fields in the form the driver name appears as
“af700c70-4334-4900-938d-b5a080ac9671” instead of “JOHN” for example. This
field and one other are pulled from values entered in another form and
these values appear just fine for the user in the application. As you can
see from the below we are getting driver name from a case called “usafiri”
where I can see the driver names listed****


****

                                                            <label

ref=“jr:itext(‘driver_name-label’)” />****

                                                            <itemset

nodeset=“instance(‘casedb’)/casedb/case[@case_type=‘usafiri’]”>****

****

****

                                                            </itemset>

                                            </select1>****

Here’s the bind statement we are using****

****


Feel like I am missing something obvious – any ideas out there?****


Thank you in advance****


---------------****

Steve Ollis****

Chief Operating Officer****

D-tree International****

http://www.d-tree.org****

+1.410.443.3916****

Skype: ollisste****



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/groups/opt_out.

Steve,

Yeah, agreed with cory that it’s difficult to debug this without having a
form submission and the XML to look at.

So
/data/accept_referral_group/driver_name

is properly being filled with the caseid and the problem is that

/data/driver_name_node

is not being filled with the name?

··· On Fri, May 10, 2013 at 10:16 AM, Cory Zue wrote:

Hi Steve,

To isolate whether the issue is with the export or the form logic, could
you have someone on your team fill out a form where you know the field
should be set, and then view the form via the submit history report and
check whether it’s there?

(Someone else might see something obviously wrong in your expression in
the meantime).

Cory

On Fri, May 10, 2013 at 8:27 AM, Steve Ollis sollis@d-tree.org wrote:

Hi all - Having trouble with exporting data to excel for one of the forms
we have created in our application. When we export we get most of the data
with no problem with the exception of 2 fields – one of which is driver name



When we export all of the fields in the form the driver name appears as
“af700c70-4334-4900-938d-b5a080ac9671” instead of “JOHN” for example. This
field and one other are pulled from values entered in another form and
these values appear just fine for the user in the application. As you can
see from the below we are getting driver name from a case called “usafiri”
where I can see the driver names listed****


****

                                                            <label

ref=“jr:itext(‘driver_name-label’)” />****

                                                            <itemset

nodeset=“instance(‘casedb’)/casedb/case[@case_type=‘usafiri’]”>****

****

****

                                                            </itemset>

                                            </select1>****

Here’s the bind statement we are using****

****


Feel like I am missing something obvious – any ideas out there?****


Thank you in advance****


---------------****

Steve Ollis****

Chief Operating Officer****

D-tree International****

http://www.d-tree.org****

+1.410.443.3916****

Skype: ollisste****



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/groups/opt_out.


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/groups/opt_out.

Thanks Clayton - have been tracking back now to the build where this was
working and will see what we can sort out by looking at the differences

Steve

··· From: commcare-users@googlegroups.com [mailto:commcare-users@googlegroups.com] On Behalf Of Clayton Sims Sent: Friday, May 10, 2013 11:03 AM To: commcare-users Subject: Re: Trouble with data in export

Steve,

Yeah, agreed with cory that it’s difficult to debug this without having a
form submission and the XML to look at.

So

/data/accept_referral_group/driver_name

is properly being filled with the caseid and the problem is that

/data/driver_name_node

is not being filled with the name?

On Fri, May 10, 2013 at 10:16 AM, Cory Zue <czue@dimagi.com mailto:czue@dimagi.com > wrote:

Hi Steve,

To isolate whether the issue is with the export or the form logic, could you
have someone on your team fill out a form where you know the field should be
set, and then view the form via the submit history report and check whether
it’s there?

(Someone else might see something obviously wrong in your expression in the
meantime).

Cory

On Fri, May 10, 2013 at 8:27 AM, Steve Ollis <sollis@d-tree.org mailto:sollis@d-tree.org > wrote:

Hi all - Having trouble with exporting data to excel for one of the forms we
have created in our application. When we export we get most of the data with
no problem with the exception of 2 fields - one of which is driver name

When we export all of the fields in the form the driver name appears as
"af700c70-4334-4900-938d-b5a080ac9671" instead of “JOHN” for example. This
field and one other are pulled from values entered in another form and these
values appear just fine for the user in the application. As you can see from
the below we are getting driver name from a case called “usafiri” where I
can see the driver names listed

                                                            <label

ref=“jr:itext(‘driver_name-label’)” />

                                                            <itemset

nodeset=“instance(‘casedb’)/casedb/case[@case_type=‘usafiri’]”>

                                                            </itemset>

                                            </select1>

Here’s the bind statement we are using

Feel like I am missing something obvious - any ideas out there?

Thank you in advance


Steve Ollis

Chief Operating Officer

D-tree International

http://www.d-tree.org http://www.d-tree.org/

+1.410.443.3916 tel:%2B1.410.443.3916

Skype: ollisste


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
mailto:commcare-users%2Bunsubscribe@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out.


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
mailto:commcare-users%2Bunsubscribe@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out.


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
mailto:commcare-users+unsubscribe@googlegroups.com .
For more options, visit https://groups.google.com/groups/opt_out.