API for registered users in CSV format?

Hi all,

I am trying to export the list of registered users (and their metadata) in
CSV format for the m4change domain. I can download it as xlsx in the
Cases/Referrals/Users export. I can also use the new JSON/XML API (
https://confluence.dimagi.com/display/commcarepublic/List+Users). Finally,
I know how to use the API to get at submissions using the User Registration
form as CSV files, but it appears that it is not being used for this domain.

So, the question is, how can I export the list of registered users into a
CSV file for the m4change app in a format similar to the output of this web
service call:

https://www.commcarehq.org/a/m4change/reports/export/?export_tag="http://openrosa.org/formdesigner/B4FD1933-C925-4FD3-A17A-9FB4A8727BA7"&format=csv&max_column_size=100

Thanks!
Jon

Hey Jon,

Would the bulk upload/download format work for you?

Go to Settings --> Mobile Workers --> Bulk Upload and there should be a
link you can use to get everything in csv format.

Cory

··· On Tue, Mar 26, 2013 at 3:11 PM, Jonathan Payne wrote:

Hi all,

I am trying to export the list of registered users (and their metadata) in
CSV format for the m4change domain. I can download it as xlsx in the
Cases/Referrals/Users export. I can also use the new JSON/XML API (
https://confluence.dimagi.com/display/commcarepublic/List+Users).
Finally, I know how to use the API to get at submissions using the User
Registration form as CSV files, but it appears that it is not being used
for this domain.

So, the question is, how can I export the list of registered users into a
CSV file for the m4change app in a format similar to the output of this web
service call:

https://www.commcarehq.org/a/m4change/reports/export/?export_tag="http://openrosa.org/formdesigner/B4FD1933-C925-4FD3-A17A-9FB4A8727BA7"&format=csv&max_column_size=100

Thanks!
Jon


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.

That’s what I’m using to export all other data from m4change, but there is no User Registration data available (it says “Not Available” next to the 2 User Registration forms, one for each app). It is not clear to me why these are unavailable.

jp

··· On Mar 26, 2013, at 3:21 PM, Cory Zue wrote:

Hey Jon,

Would the bulk upload/download format work for you?

Go to Settings --> Mobile Workers --> Bulk Upload and there should be a link you can use to get everything in csv format.

Cory

On Tue, Mar 26, 2013 at 3:11 PM, Jonathan Payne paynejd@gmail.com wrote:
Hi all,

I am trying to export the list of registered users (and their metadata) in CSV format for the m4change domain. I can download it as xlsx in the Cases/Referrals/Users export. I can also use the new JSON/XML API (https://confluence.dimagi.com/display/commcarepublic/List+Users). Finally, I know how to use the API to get at submissions using the User Registration form as CSV files, but it appears that it is not being used for this domain.

So, the question is, how can I export the list of registered users into a CSV file for the m4change app in a format similar to the output of this web service call:

https://www.commcarehq.org/a/m4change/reports/export/?export_tag="http://openrosa.org/formdesigner/B4FD1933-C925-4FD3-A17A-9FB4A8727BA7"&format=csv&max_column_size=100

Thanks!
Jon


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.

I think Cory was talking about the “users.xlsx” link on
https://www.commcarehq.org/a/m4change/settings/users/commcare/upload/ ; is
that what you’re talking about too?

Cheers,
Danny

··· 2013/3/26 Jonathan Payne

That’s what I’m using to export all other data from m4change, but there is
no User Registration data available (it says “Not Available” next to the 2
User Registration forms, one for each app). It is not clear to me why these
are unavailable.

jp

On Mar 26, 2013, at 3:21 PM, Cory Zue czue@dimagi.com wrote:

Hey Jon,

Would the bulk upload/download format work for you?

Go to Settings --> Mobile Workers --> Bulk Upload and there should be a
link you can use to get everything in csv format.

Cory

On Tue, Mar 26, 2013 at 3:11 PM, Jonathan Payne paynejd@gmail.com wrote:

Hi all,

I am trying to export the list of registered users (and their metadata)
in CSV format for the m4change domain. I can download it as xlsx in the
Cases/Referrals/Users export. I can also use the new JSON/XML API (
https://confluence.dimagi.com/display/commcarepublic/List+Users).
Finally, I know how to use the API to get at submissions using the User
Registration form as CSV files, but it appears that it is not being used
for this domain.

So, the question is, how can I export the list of registered users into a
CSV file for the m4change app in a format similar to the output of this web
service call:

https://www.commcarehq.org/a/m4change/reports/export/?export_tag="http://openrosa.org/formdesigner/B4FD1933-C925-4FD3-A17A-9FB4A8727BA7"&format=csv&max_column_size=100

Thanks!
Jon


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.


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.

Sorry about-- I was looking at the wrong spot. This is still coming through as a xlsx. Any way to adjust the format? (format=csv didn’t do the trick)

jp

··· On Mar 26, 2013, at 3:40 PM, Daniel Roberts wrote:

I think Cory was talking about the “users.xlsx” link on https://www.commcarehq.org/a/m4change/settings/users/commcare/upload/ ; is that what you’re talking about too?

Cheers,
Danny

2013/3/26 Jonathan Payne paynejd@gmail.com
That’s what I’m using to export all other data from m4change, but there is no User Registration data available (it says “Not Available” next to the 2 User Registration forms, one for each app). It is not clear to me why these are unavailable.
jp

On Mar 26, 2013, at 3:21 PM, Cory Zue czue@dimagi.com wrote:

Hey Jon,

Would the bulk upload/download format work for you?

Go to Settings --> Mobile Workers --> Bulk Upload and there should be a link you can use to get everything in csv format.

Cory

On Tue, Mar 26, 2013 at 3:11 PM, Jonathan Payne paynejd@gmail.com wrote:
Hi all,

I am trying to export the list of registered users (and their metadata) in CSV format for the m4change domain. I can download it as xlsx in the Cases/Referrals/Users export. I can also use the new JSON/XML API (https://confluence.dimagi.com/display/commcarepublic/List+Users). Finally, I know how to use the API to get at submissions using the User Registration form as CSV files, but it appears that it is not being used for this domain.

So, the question is, how can I export the list of registered users into a CSV file for the m4change app in a format similar to the output of this web service call:

https://www.commcarehq.org/a/m4change/reports/export/?export_tag="http://openrosa.org/formdesigner/B4FD1933-C925-4FD3-A17A-9FB4A8727BA7"&format=csv&max_column_size=100

Thanks!
Jon


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.


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.

Hi Jon,

There currently isn’t, unfortunately. You might have the best luck (and I’m
only saying this because I know you’re technical) just downloading it and
passing it through an xlsx-to-csv script for the short term if you can
figure out how to do that, though I realize it’s not ideal.

Cheers,
Danny

··· 2013/3/26 Jonathan Payne

Sorry about-- I was looking at the wrong spot. This is still coming
through as a xlsx. Any way to adjust the format? (format=csv didn’t do the
trick)

jp

On Mar 26, 2013, at 3:40 PM, Daniel Roberts droberts@dimagi.com wrote:

I think Cory was talking about the “users.xlsx” link on
https://www.commcarehq.org/a/m4change/settings/users/commcare/upload/ ;
is that what you’re talking about too?

Cheers,
Danny

2013/3/26 Jonathan Payne paynejd@gmail.com

That’s what I’m using to export all other data from m4change, but there
is no User Registration data available (it says “Not Available” next to the
2 User Registration forms, one for each app). It is not clear to me why
these are unavailable.
jp

On Mar 26, 2013, at 3:21 PM, Cory Zue czue@dimagi.com wrote:

Hey Jon,

Would the bulk upload/download format work for you?

Go to Settings --> Mobile Workers --> Bulk Upload and there should be a
link you can use to get everything in csv format.

Cory

On Tue, Mar 26, 2013 at 3:11 PM, Jonathan Payne paynejd@gmail.comwrote:

Hi all,

I am trying to export the list of registered users (and their metadata)
in CSV format for the m4change domain. I can download it as xlsx in the
Cases/Referrals/Users export. I can also use the new JSON/XML API (
https://confluence.dimagi.com/display/commcarepublic/List+Users).
Finally, I know how to use the API to get at submissions using the User
Registration form as CSV files, but it appears that it is not being used
for this domain.

So, the question is, how can I export the list of registered users into
a CSV file for the m4change app in a format similar to the output of this
web service call:

https://www.commcarehq.org/a/m4change/reports/export/?export_tag="http://openrosa.org/formdesigner/B4FD1933-C925-4FD3-A17A-9FB4A8727BA7"&format=csv&max_column_size=100

Thanks!
Jon


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.


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.


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.