Hi Team,
I am facing issue while trying to exporting the commcare data by using the
advanced API by using the below command line syntax and the the value
defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id
$.metadata.idusernameform.meta.username
The above combination is exporting the data from the previously available
applications under the emergency project but we may not need all those data
to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined field
value in the above area under # Value in the query file
With regards,
Gurudayal Sahu
Hi Gurudayal
You should only be getting data for forms with that exact XMLNS (every form
should have a unique XMLNS) so if you want to get data for a different form
(in the same app or another app) you can just change the XMLNS value to
match the form you want data for.
Let me know if that's not what you're asking or if I've missed something.
Simon
···
On 6 May 2015 at 07:19, Gurudayal Sahu wrote:
Hi Team,
I am facing issue while trying to exporting the commcare data by using
the advanced API by using the below command line syntax and the the value
defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id$.
metadata.idusernameform.meta.username
The above combination is exporting the data from the previously available
applications under the emergency project but we may not need all those data
to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined field
value in the above area under # Value in the query file
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 your quick response.
I have specified the exact XMLNS for a single form but still its exporting
the data that does not belong with the specified exact SMLNS . Even we
followed the same setup process earlier and it was working perfectly fine.
Please alert me, if any other details required from my side to troubleshoot
the issue.
With regards,
Gurudayal Sahu
···
On Wed, May 6, 2015 at 12:54 PM, Simon Kelly wrote:
Hi Gurudayal
You should only be getting data for forms with that exact XMLNS (every
form should have a unique XMLNS) so if you want to get data for a different
form (in the same app or another app) you can just change the XMLNS value
to match the form you want data for.
Let me know if that's not what you're asking or if I've missed something.
Simon
On 6 May 2015 at 07:19, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Hi Team,
I am facing issue while trying to exporting the commcare data by using
the advanced API by using the below command line syntax and the the value
defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id$.
metadata.idusernameform.meta.username
The above combination is exporting the data from the previously available
applications under the emergency project but we may not need all those data
to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined field
value in the above area under # Value in the query file
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.
Hi Gurudayal
I'm not able to reproduce your problem. When I run that query all the data
I get back is for the "Participant Registration" form.
I think if you're still having problems you should report an issue and we
can take it from there.
Thanks
Simon
···
On 6 May 2015 at 10:03, Gurudayal Sahu wrote:
Dear Simon,
Thanks for your quick response.
I have specified the exact XMLNS for a single form but still its
exporting the data that does not belong with the specified exact SMLNS .
Even we followed the same setup process earlier and it was working
perfectly fine.
Please alert me, if any other details required from my side to
troubleshoot the issue.
With regards,
Gurudayal Sahu
On Wed, May 6, 2015 at 12:54 PM, Simon Kelly skelly@dimagi.com wrote:
Hi Gurudayal
You should only be getting data for forms with that exact XMLNS (every
form should have a unique XMLNS) so if you want to get data for a different
form (in the same app or another app) you can just change the XMLNS value
to match the form you want data for.
Let me know if that's not what you're asking or if I've missed something.
Simon
On 6 May 2015 at 07:19, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Hi Team,
I am facing issue while trying to exporting the commcare data by using
the advanced API by using the below command line syntax and the the value
defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id
$.metadata.idusernameform.meta.username
The above combination is exporting the data from the previously
available applications under the emergency project but we may not need all
those data to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined field
value in the above area under # Value in the query file
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.
--
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 all your support.
We have some other forms named as "Participation Registration" in other
applications available under same project "emergency" and probably its
getting the data from those forms.
Based on our data collection with the newly issue reported form , it should
contain the data from the month of Mar-April 2015 (including testing data)
only but it is getting the data with the older dates also.
So kindly suggest,how should we take it forward in reporting the issue.
With regards,
Gurudayal Sahu
···
On Wed, May 6, 2015 at 3:59 PM, Simon Kelly wrote:
Hi Gurudayal
I'm not able to reproduce your problem. When I run that query all the data
I get back is for the "Participant Registration" form.
I think if you're still having problems you should report an issue and we
can take it from there.
Thanks
Simon
On 6 May 2015 at 10:03, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Dear Simon,
Thanks for your quick response.
I have specified the exact XMLNS for a single form but still its
exporting the data that does not belong with the specified exact SMLNS .
Even we followed the same setup process earlier and it was working
perfectly fine.
Please alert me, if any other details required from my side to
troubleshoot the issue.
With regards,
Gurudayal Sahu
On Wed, May 6, 2015 at 12:54 PM, Simon Kelly skelly@dimagi.com wrote:
Hi Gurudayal
You should only be getting data for forms with that exact XMLNS (every
form should have a unique XMLNS) so if you want to get data for a different
form (in the same app or another app) you can just change the XMLNS value
to match the form you want data for.
Let me know if that's not what you're asking or if I've missed something.
Simon
On 6 May 2015 at 07:19, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Hi Team,
I am facing issue while trying to exporting the commcare data by using
the advanced API by using the below command line syntax and the the value
defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id
$.metadata.idusernameform.meta.username
The above combination is exporting the data from the previously
available applications under the emergency project but we may not need all
those data to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined field
value in the above area under # Value in the query file
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.
--
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.
Hi Gurudayal
Sorry, I didn't realize you had multiple apps with forms that had the same
XMLNS (I'll look into how that came about). What you can do is add an
additional filter to your query to limit the data to only forms from a
specific app. The filter should be called "app_id" and the value should be
the ID of the application. You can get the application ID from the
application URL on CommCare HQ:
https://www.commcarehq.org/a/{ domain }/apps/view/{ app_id }/
e.g.
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id$.
metadata.idapp_idf09bceafefdba9256ae837f5a803b340usernameform.meta.username
Cheers
Simon
···
On 6 May 2015 at 12:53, Gurudayal Sahu wrote:
Dear Simon,
Thanks for all your support.
We have some other forms named as "Participation Registration" in other
applications available under same project "emergency" and probably its
getting the data from those forms.
Based on our data collection with the newly issue reported form , it
should contain the data from the month of Mar-April 2015 (including testing
data) only but it is getting the data with the older dates also.
So kindly suggest,how should we take it forward in reporting the issue.
With regards,
Gurudayal Sahu
On Wed, May 6, 2015 at 3:59 PM, Simon Kelly skelly@dimagi.com wrote:
Hi Gurudayal
I'm not able to reproduce your problem. When I run that query all the
data I get back is for the "Participant Registration" form.
I think if you're still having problems you should report an issue and we
can take it from there.
Thanks
Simon
On 6 May 2015 at 10:03, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Dear Simon,
Thanks for your quick response.
I have specified the exact XMLNS for a single form but still its
exporting the data that does not belong with the specified exact SMLNS .
Even we followed the same setup process earlier and it was working
perfectly fine.
Please alert me, if any other details required from my side to
troubleshoot the issue.
With regards,
Gurudayal Sahu
On Wed, May 6, 2015 at 12:54 PM, Simon Kelly skelly@dimagi.com wrote:
Hi Gurudayal
You should only be getting data for forms with that exact XMLNS (every
form should have a unique XMLNS) so if you want to get data for a different
form (in the same app or another app) you can just change the XMLNS value
to match the form you want data for.
Let me know if that's not what you're asking or if I've missed
something.
Simon
On 6 May 2015 at 07:19, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Hi Team,
I am facing issue while trying to exporting the commcare data by
using the advanced API by using the below command line syntax and the the
value defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627
id$.metadata.idusernameform.meta.username
The above combination is exporting the data from the previously
available applications under the emergency project but we may not need all
those data to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined
field value in the above area under # Value in the query file
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.
--
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.
--
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
Thanks for your timely support, after adding the additional filtering, its
working fine.
With regards,
Gurudayal Sahu
···
On Wed, May 6, 2015 at 4:45 PM, Simon Kelly wrote:
Hi Gurudayal
Sorry, I didn't realize you had multiple apps with forms that had the same
XMLNS (I'll look into how that came about). What you can do is add an
additional filter to your query to limit the data to only forms from a
specific app. The filter should be called "app_id" and the value should be
the ID of the application. You can get the application ID from the
application URL on CommCare HQ:
https://www.commcarehq.org/a/{ domain }/apps/view/{ app_id }/
e.g.
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627id$.
metadata.idapp_idf09bceafefdba9256ae837f5a803b340username
form.meta.username
Cheers
Simon
On 6 May 2015 at 12:53, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Dear Simon,
Thanks for all your support.
We have some other forms named as "Participation Registration" in other
applications available under same project "emergency" and probably its
getting the data from those forms.
Based on our data collection with the newly issue reported form , it
should contain the data from the month of Mar-April 2015 (including testing
data) only but it is getting the data with the older dates also.
So kindly suggest,how should we take it forward in reporting the issue.
With regards,
Gurudayal Sahu
On Wed, May 6, 2015 at 3:59 PM, Simon Kelly skelly@dimagi.com wrote:
Hi Gurudayal
I'm not able to reproduce your problem. When I run that query all the
data I get back is for the "Participant Registration" form.
I think if you're still having problems you should report an issue and
we can take it from there.
Thanks
Simon
On 6 May 2015 at 10:03, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Dear Simon,
Thanks for your quick response.
I have specified the exact XMLNS for a single form but still its
exporting the data that does not belong with the specified exact SMLNS .
Even we followed the same setup process earlier and it was working
perfectly fine.
Please alert me, if any other details required from my side to
troubleshoot the issue.
With regards,
Gurudayal Sahu
On Wed, May 6, 2015 at 12:54 PM, Simon Kelly skelly@dimagi.com wrote:
Hi Gurudayal
You should only be getting data for forms with that exact XMLNS (every
form should have a unique XMLNS) so if you want to get data for a different
form (in the same app or another app) you can just change the XMLNS value
to match the form you want data for.
Let me know if that's not what you're asking or if I've missed
something.
Simon
On 6 May 2015 at 07:19, Gurudayal Sahu gurudayalsahu@gmail.com wrote:
Hi Team,
I am facing issue while trying to exporting the commcare data by
using the advanced API by using the below command line syntax and the the
value defined in the query file :
#command line syntax :
C:\python27\scripts\commcare-export --output-format sql --output
mssql+pyodbc://sa:xxxxxxxx@dsnnamexxx --project emergency --query
c:\exports\nepal-relief-1\configfile.xlsx --username xxxxxxxxx --password
xxxxxx
Value in the query file
Data SourceFilter NameFilter ValueFieldSource Fieldformxmlns.exact
http://openrosa.org/formdesigner/4CC21E18-202B-4522-9804-91305E154627
id$.metadata.idusernameform.meta.username
The above combination is exporting the data from the previously
available applications under the emergency project but we may not need all
those data to get exported except only from a single application.
We want to export the data only from a single application named as
"Nepal-Relief-1" under emergency domain.
Kindly suggest, if any changes with the above combination.
Thanks in advance for your support.
Note:
Instead of the uploading the query file, i am sharing the defined
field value in the above area under # Value in the query file
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.
--
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.
--
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.