Username not getting exported through by defining it in the query file

Hi,

I wanted to do the case export the for the mobile username also through
the commcare export tool but its not getting exported by defining the
source filed named as “last_modified_by_username” or “user_name”.

Kindly suggest what should be specified under source field of the Commcare
data export tool query file to get the data case data for the user name.

Thanks in advance for the support.

With regards,
Gurudayal Sahu

“metadata.username” should work or else “form.meta.username”

··· On 8 May 2015 at 09:55, Gurudayal Sahu wrote:

Hi,

I wanted to do the case export the for the mobile username also through
the commcare export tool but its not getting exported by defining the
source filed named as “last_modified_by_username” or “user_name”.

Kindly suggest what should be specified under source field of the Commcare
data export tool query file to get the data case data for the user name.

Thanks in advance for the support.

With regards,
Gurudayal Sahu


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa

Dear Simon,

Thanks for the suggestion. I tried it but still not working.

With regards,
Gurudayal Sahu

··· On Friday, 8 May 2015 13:28:55 UTC+5:30, skelly wrote: > > "metadata.username" should work or else "form.meta.username" > > On 8 May 2015 at 09:55, Gurudayal Sahu <guruda...@gmail.com > wrote: > >> Hi, >> >> I wanted to do the case export the for the mobile username also through >> the commcare export tool but its not getting exported by defining the >> source filed named as "last_modified_by_username" or "user_name". >> >> Kindly suggest what should be specified under source field of the >> Commcare data export tool query file to get the data case data for the user >> name. >> >> Thanks in advance for the support. >> >> With regards, >> Gurudayal Sahu >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CommCare Developers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-developers+unsubscribe@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Simon Kelly > Senior Engineer | Dimagi South Africa >

Sorry, those were for form exports. For a case export you can only get the
user ID (“user_id”) and not the username.

··· On 8 May 2015 at 10:20, Gurudayal Sahu wrote:

Dear Simon,

Thanks for the suggestion. I tried it but still not working.

With regards,
Gurudayal Sahu

On Friday, 8 May 2015 13:28:55 UTC+5:30, skelly wrote:

“metadata.username” should work or else “form.meta.username”

On 8 May 2015 at 09:55, Gurudayal Sahu guruda...@gmail.com wrote:

Hi,

I wanted to do the case export the for the mobile username also through
the commcare export tool but its not getting exported by defining the
source filed named as “last_modified_by_username” or “user_name”.

Kindly suggest what should be specified under source field of the
Commcare data export tool query file to get the data case data for the user
name.

Thanks in advance for the support.

With regards,
Gurudayal Sahu


You received this message because you are subscribed to the Google
Groups “CommCare Developers” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa

Hi Simon,

Please find the result with the different options tried :

1.form.meta.user_id : Null value during export
2.metadata.user_id : Null value during exporting

3.user_id : It is exporting a common id as
"a150a503675b0b142c64fd6666bd58b6" but not the user name.

Thanks & regards,
Gurudayal Sahu

··· On Friday, 8 May 2015 14:19:44 UTC+5:30, skelly wrote: > > Sorry, those were for form exports. For a case export you can only get the > user ID ("user_id") and not the username. > > On 8 May 2015 at 10:20, Gurudayal Sahu <guruda...@gmail.com > wrote: > >> Dear Simon, >> >> Thanks for the suggestion. I tried it but still not working. >> >> With regards, >> Gurudayal Sahu >> >> On Friday, 8 May 2015 13:28:55 UTC+5:30, skelly wrote: >>> >>> "metadata.username" should work or else "form.meta.username" >>> >>> On 8 May 2015 at 09:55, Gurudayal Sahu wrote: >>> >>>> Hi, >>>> >>>> I wanted to do the case export the for the mobile username also >>>> through the commcare export tool but its not getting exported by defining >>>> the source filed named as "last_modified_by_username" or "user_name". >>>> >>>> Kindly suggest what should be specified under source field of the >>>> Commcare data export tool query file to get the data case data for the user >>>> name. >>>> >>>> Thanks in advance for the support. >>>> >>>> With regards, >>>> Gurudayal Sahu >>>> >>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "CommCare Developers" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to commcare-developers+unsubscribe@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Simon Kelly >>> Senior Engineer | Dimagi South Africa >>> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CommCare Developers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-developers+unsubscribe@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Simon Kelly > Senior Engineer | Dimagi South Africa >

Yes, as I mentioned, case exports don’t support the username so I would
recommend getting the username from somewhere else e.g. a user export from
the CommCare user interface.

··· On 8 May 2015 at 11:31, Gurudayal Sahu wrote:

Hi Simon,

Please find the result with the different options tried :

1.form.meta.user_id : Null value during export
2.metadata.user_id : Null value during exporting

3.user_id : It is exporting a common id as
"a150a503675b0b142c64fd6666bd58b6" but not the user name.

Thanks & regards,
Gurudayal Sahu

On Friday, 8 May 2015 14:19:44 UTC+5:30, skelly wrote:

Sorry, those were for form exports. For a case export you can only get
the user ID (“user_id”) and not the username.

On 8 May 2015 at 10:20, Gurudayal Sahu guruda...@gmail.com wrote:

Dear Simon,

Thanks for the suggestion. I tried it but still not working.

With regards,
Gurudayal Sahu

On Friday, 8 May 2015 13:28:55 UTC+5:30, skelly wrote:

“metadata.username” should work or else “form.meta.username”

On 8 May 2015 at 09:55, Gurudayal Sahu guruda...@gmail.com wrote:

Hi,

I wanted to do the case export the for the mobile username also
through the commcare export tool but its not getting exported by defining
the source filed named as “last_modified_by_username” or “user_name”.

Kindly suggest what should be specified under source field of the
Commcare data export tool query file to get the data case data for the user
name.

Thanks in advance for the support.

With regards,
Gurudayal Sahu


You received this message because you are subscribed to the Google
Groups “CommCare Developers” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa


You received this message because you are subscribed to the Google
Groups “CommCare Developers” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Simon Kelly
Senior Engineer | Dimagi South Africa