Kindly request your support in helping me to undersand the following:
Can my SQL server read data from my commcare application? This would
help us to have online customized reporting dashboards. This would also
help us to fetch the data to make the same available to other tools and
dashboards that we use. If this is available, please guide us as to how to
configure this. If not available, is there a roadmap for this feature?
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
If we have some existing data that are available and would like to
import the same to the existing application, can we do that using excel
files? If we present the data in the excel file (with the same column
names and data), can the system import it? If no, are there any
work-arounds?
Thanks in advance for your quick guidence and support.
Can my SQL server read data from my commcare application? This
would help us to have online customized reporting dashboards. This would
also help us to fetch the data to make the same available to other tools
and dashboards that we use. If this is available, please guide us as to
how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or excel
format and then import it into SQL from there, or write a script to hit our
APIs and automate the process.
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would like to
import the same to the existing application, can we do that using excel
files? If we present the data in the excel file (with the same column
names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new cases,
though this feature has been requested a few times and is on the roadmap.
The easiest workaround is to use the submission API to submit XML that will
create the data for you, but this would require a bit of scripting. Others
on the list might have example scripts to get you started.
best,
Cory
···
On Sun, Mar 17, 2013 at 10:52 AM, Jeffrey Jose wrote:
We (www.aptivate.org) have just written a django application that sounds
like it does something pretty similar.
We have a standalone python library that talks to the commcare api and then
a django app that talks to the api wrapper and saves it in a mysql database
(or whatever django db backend you'd want to use).
If its of use to you, we should be open sourcing the code.
Sincerely,
Sarah Bird
···
On Sun, Mar 17, 2013 at 1:54 PM, Cory Zue wrote:
Can my SQL server read data from my commcare application? This
would help us to have online customized reporting dashboards. This would
also help us to fetch the data to make the same available to other tools
and dashboards that we use. If this is available, please guide us as to
how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or
excel format and then import it into SQL from there, or write a script to
hit our APIs and automate the process.
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would like to
import the same to the existing application, can we do that using excel
files? If we present the data in the excel file (with the same column
names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new
cases, though this feature has been requested a few times and is on the
roadmap. The easiest workaround is to use the submission API to submit XML
that will create the data for you, but this would require a bit of
scripting. Others on the list might have example scripts to get you started.
Hi Cory,
We are doing study for Nutritionin community! In that we are
taking Anthropometry of Family member for eg. height & weight , date of
birth etc..
we create module for that, but we want data as in row and once we done
antho for one member next time that member will not shown in mobile it must
be hide from mobile and who is pending that will be shown only pl help us
how to do this?
sincerely,
latika
···
On Tue, Mar 19, 2013 at 6:33 AM, Sarah Bird wrote:
Hi Jeffry,
We (www.aptivate.org) have just written a django application that sounds
like it does something pretty similar.
We have a standalone python library that talks to the commcare api and
then a django app that talks to the api wrapper and saves it in a mysql
database (or whatever django db backend you'd want to use).
If its of use to you, we should be open sourcing the code.
Sincerely,
Sarah Bird
On Sun, Mar 17, 2013 at 1:54 PM, Cory Zue czue@dimagi.com wrote:
Can my SQL server read data from my commcare application? This
would help us to have online customized reporting dashboards. This would
also help us to fetch the data to make the same available to other tools
and dashboards that we use. If this is available, please guide us as to
how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or
excel format and then import it into SQL from there, or write a script to
hit our APIs and automate the process.
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would like
to import the same to the existing application, can we do that using excel
files? If we present the data in the excel file (with the same column
names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new
cases, though this feature has been requested a few times and is on the
roadmap. The easiest workaround is to use the submission API to submit XML
that will create the data for you, but this would require a bit of
scripting. Others on the list might have example scripts to get you started.
Sorry for the long delay in replying. I have pushed our commcare api
wrapper to our github - GitHub - aptivate/commcare-api-wrapper: CommCare HQ API client.
This is not supported, so don't expect miracles :D, just public for others
to be able to see what we have done. We are using it in a live project
though so we're fairly confident it works and it has some tests.
The biggest problem we needed to solve was that we didn't just want the
data, we wanted to be able to display the "rich" data - turning answer &
question codes into their human readable form and presenting the data in
the same order as the questions were in the form.
To do this required using some unsupported API which thanks to help from
Danny & Cory at Dimagi we were able to do successfully.
We used this library with django where we store and process the data
further.
Best,
Bird
···
On Sun, Apr 14, 2013 at 1:13 AM, Jeffrey Jose wrote:
Dear Sarah,
I am sorry for the late reply to your mail.
Thanks for your reply and feedback. We shall try this and let you know.
Can you send me the links and documentations, using which I could try it
in a test environment. I plan to try this during early May and can I seek
your help, in case I am stuck.
We (www.aptivate.org) have just written a django application that sounds
like it does something pretty similar.
We have a standalone python library that talks to the commcare api and
then a django app that talks to the api wrapper and saves it in a mysql
database (or whatever django db backend you'd want to use).
If its of use to you, we should be open sourcing the code.
Sincerely,
Sarah Bird
On Sun, Mar 17, 2013 at 1:54 PM, Cory Zue czue@dimagi.com wrote:
Can my SQL server read data from my commcare application? This
would help us to have online customized reporting dashboards. This would
also help us to fetch the data to make the same available to other tools
and dashboards that we use. If this is available, please guide us as to
how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or
excel format and then import it into SQL from there, or write a script to
hit our APIs and automate the process.
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would like
to import the same to the existing application, can we do that using excel
files? If we present the data in the excel file (with the same column
names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new
cases, though this feature has been requested a few times and is on the
roadmap. The easiest workaround is to use the submission API to submit XML
that will create the data for you, but this would require a bit of
scripting. Others on the list might have example scripts to get you started.
Very cool! Apologies if this is a dumb question, but do you have an example
of the output that this tool produces?
thanks,
Cory
···
On Thu, May 9, 2013 at 9:38 AM, Sarah Bird wrote:
Hi all,
Sorry for the long delay in replying. I have pushed our commcare api
wrapper to our github - GitHub - aptivate/commcare-api-wrapper: CommCare HQ API client.
This is not supported, so don't expect miracles :D, just public for others
to be able to see what we have done. We are using it in a live project
though so we're fairly confident it works and it has some tests.
The biggest problem we needed to solve was that we didn't just want the
data, we wanted to be able to display the "rich" data - turning answer &
question codes into their human readable form and presenting the data in
the same order as the questions were in the form.
To do this required using some unsupported API which thanks to help from
Danny & Cory at Dimagi we were able to do successfully.
We used this library with django where we store and process the data
further.
Thanks for your reply and feedback. We shall try this and let you know.
Can you send me the links and documentations, using which I could try it
in a test environment. I plan to try this during early May and can I seek
your help, in case I am stuck.
We (www.aptivate.org) have just written a django application that
sounds like it does something pretty similar.
We have a standalone python library that talks to the commcare api and
then a django app that talks to the api wrapper and saves it in a mysql
database (or whatever django db backend you'd want to use).
If its of use to you, we should be open sourcing the code.
Sincerely,
Sarah Bird
On Sun, Mar 17, 2013 at 1:54 PM, Cory Zue czue@dimagi.com wrote:
Can my SQL server read data from my commcare application? This
would help us to have online customized reporting dashboards. This would
also help us to fetch the data to make the same available to other tools
and dashboards that we use. If this is available, please guide us as to
how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or
excel format and then import it into SQL from there, or write a script to
hit our APIs and automate the process.
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would like
to import the same to the existing application, can we do that using excel
files? If we present the data in the excel file (with the same column
names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new
cases, though this feature has been requested a few times and is on the
roadmap. The easiest workaround is to use the submission API to submit XML
that will create the data for you, but this would require a bit of
scripting. Others on the list might have example scripts to get you started.
Very basically, after you get the data out of the api, there's just a bunch
of properties on a form/case and a make_human_readable method (which we
took from commcare corehq).
Beyond that, I'm going to have to give a super-lame-nerd answer which is
can you take a look at the tests and see if you still have questions,
they're relatively well organized like
"test_resource_response_contains_a_list_of_dicts_with_valid_cases"
"test_get_xmlns_id_returns_correct_id" so should go through all the
different helper methods we've written so we could easily access the things
we were trying to.
Hope this helps.
Sorry for my brevity.
Cheers,
bird
···
On Thu, May 9, 2013 at 6:45 AM, Cory Zue wrote:
Hey Sarah,
Very cool! Apologies if this is a dumb question, but do you have an
example of the output that this tool produces?
Sorry for the long delay in replying. I have pushed our commcare api
wrapper to our github - GitHub - aptivate/commcare-api-wrapper: CommCare HQ API client.
This is not supported, so don't expect miracles :D, just public for others
to be able to see what we have done. We are using it in a live project
though so we're fairly confident it works and it has some tests.
The biggest problem we needed to solve was that we didn't just want the
data, we wanted to be able to display the "rich" data - turning answer &
question codes into their human readable form and presenting the data in
the same order as the questions were in the form.
To do this required using some unsupported API which thanks to help from
Danny & Cory at Dimagi we were able to do successfully.
We used this library with django where we store and process the data
further.
Thanks for your reply and feedback. We shall try this and let you know.
Can you send me the links and documentations, using which I could try it
in a test environment. I plan to try this during early May and can I seek
your help, in case I am stuck.
We (www.aptivate.org) have just written a django application that
sounds like it does something pretty similar.
We have a standalone python library that talks to the commcare api and
then a django app that talks to the api wrapper and saves it in a mysql
database (or whatever django db backend you'd want to use).
If its of use to you, we should be open sourcing the code.
Sincerely,
Sarah Bird
On Sun, Mar 17, 2013 at 1:54 PM, Cory Zue czue@dimagi.com wrote:
Can my SQL server read data from my commcare application?
This would help us to have online customized reporting dashboards. This
would also help us to fetch the data to make the same available to other
tools and dashboards that we use. If this is available, please guide us as
to how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or
excel format and then import it into SQL from there, or write a script to
hit our APIs and automate the process.
Does the system allow the data cleaning that would reflect the
changes directly to the database. For example, if a field staff reports
that he/she has entered the data incorrectl for a particular field, can we
correct that data? Exporting the data and correcting it would reflect the
changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would
like to import the same to the existing application, can we do that using
excel files? If we present the data in the excel file (with the same
column names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new
cases, though this feature has been requested a few times and is on the
roadmap. The easiest workaround is to use the submission API to submit XML
that will create the data for you, but this would require a bit of
scripting. Others on the list might have example scripts to get you started.
Decimal question Type for baby Weight ----- We need 4 digit answer, for e.g
2.350
Now suggest what & how to do???
Thanks
Regards
Latika
SNEHA, Mumbai
···
On Thu, May 9, 2013 at 7:25 PM, Sarah Bird wrote:
Very basically, after you get the data out of the api, there's just a
bunch of properties on a form/case and a make_human_readable method (which
we took from commcare corehq).
Beyond that, I'm going to have to give a super-lame-nerd answer which is
can you take a look at the tests and see if you still have questions,
they're relatively well organized like
"test_resource_response_contains_a_list_of_dicts_with_valid_cases"
"test_get_xmlns_id_returns_correct_id" so should go through all the
different helper methods we've written so we could easily access the things
we were trying to.
Hope this helps.
Sorry for my brevity.
Cheers,
bird
On Thu, May 9, 2013 at 6:45 AM, Cory Zue czue@dimagi.com wrote:
Hey Sarah,
Very cool! Apologies if this is a dumb question, but do you have an
example of the output that this tool produces?
Sorry for the long delay in replying. I have pushed our commcare api
wrapper to our github - GitHub - aptivate/commcare-api-wrapper: CommCare HQ API client.
This is not supported, so don't expect miracles :D, just public for others
to be able to see what we have done. We are using it in a live project
though so we're fairly confident it works and it has some tests.
The biggest problem we needed to solve was that we didn't just want the
data, we wanted to be able to display the "rich" data - turning answer &
question codes into their human readable form and presenting the data in
the same order as the questions were in the form.
To do this required using some unsupported API which thanks to help from
Danny & Cory at Dimagi we were able to do successfully.
We used this library with django where we store and process the data
further.
Thanks for your reply and feedback. We shall try this and let you
know. Can you send me the links and documentations, using which I could
try it in a test environment. I plan to try this during early May and can
I seek your help, in case I am stuck.
We (www.aptivate.org) have just written a django application that
sounds like it does something pretty similar.
We have a standalone python library that talks to the commcare api and
then a django app that talks to the api wrapper and saves it in a mysql
database (or whatever django db backend you'd want to use).
If its of use to you, we should be open sourcing the code.
Sincerely,
Sarah Bird
On Sun, Mar 17, 2013 at 1:54 PM, Cory Zue czue@dimagi.com wrote:
Can my SQL server read data from my commcare application?
This would help us to have online customized reporting dashboards. This
would also help us to fetch the data to make the same available to other
tools and dashboards that we use. If this is available, please guide us as
to how to configure this. If not available, is there a roadmap for this
feature?
This is not something that is supported today but is something we're
working on. Look for announcements coming soon.
For now your options are to use the exports to get the data in csv or
excel format and then import it into SQL from there, or write a script to
hit our APIs and automate the process.
Does the system allow the data cleaning that would reflect
the changes directly to the database. For example, if a field staff
reports that he/she has entered the data incorrectl for a particular field,
can we correct that data? Exporting the data and correcting it would
reflect the changes only to the exported file and during next export from
application would still show the old data.
You can use forms to update / overwrite data in a case, but there is
currently no way to edit existing data in a form.
If we have some existing data that are available and would
like to import the same to the existing application, can we do that using
excel files? If we present the data in the excel file (with the same
column names and data), can the system import it? If no, are there any
work-arounds?
The excel import feature currently does not allow you to create new
cases, though this feature has been requested a few times and is on the
roadmap. The easiest workaround is to use the submission API to submit XML
that will create the data for you, but this would require a bit of
scripting. Others on the list might have example scripts to get you started.