Automatic Upload feature

At the distribution site, we use your product CommCare to fill the
distribution form which contains the information of what items have been
distributed. In order to reduce human error, we are trying to create a drop
down menu for the users to select from instead of typing in. I found that
CommCare can setup a question with filtered choices and can update the look
up table manually.
https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables I wonder
if there is a way that CommCare can talk to our SQL database and update its
lookup table automatically? Or is this some API you are considering to
build in the future? I found CommCare has data forwarding/exporting
features but not much importing APIs except excel spreadsheet upload.

Hello,

I believe the excel spreadsheet upload
https://confluence.dimagi.com/display/commcarepublic/Bulk+upload+Lookup+Tables
is
the only API we have that allows you to modify lookup tables. In order to
communicate with your SQL database you’d probably need to write some
middleware of your own to perform the data pull and conversion from SQL to
Excel format.

Cheers,
Will

··· On Wed, Apr 12, 2017 at 7:29 AM, Wang Dawei wrote:

At the distribution site, we use your product CommCare to fill the
distribution form which contains the information of what items have been
distributed. In order to reduce human error, we are trying to create a drop
down menu for the users to select from instead of typing in. I found that
CommCare can setup a question with filtered choices and can update the look
up table manually. https://confluence.dimagi.com/display/
commcarepublic/Lookup+Tables I wonder if there is a way that CommCare can
talk to our SQL database and update its lookup table automatically? Or is
this some API you are considering to build in the future? I found CommCare
has data forwarding/exporting features but not much importing APIs except
excel spreadsheet upload.


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/d/optout.

Thank you!

Do we need a paid commcare account for this excel upload function? Is there
a interface instead of command line?

··· On Wednesday, April 12, 2017 at 4:56:22 AM UTC-4, William Pride wrote: > > Hello, > > I believe the excel spreadsheet upload > is > the only API we have that allows you to modify lookup tables. In order to > communicate with your SQL database you'd probably need to write some > middleware of your own to perform the data pull and conversion from SQL to > Excel format. > > Cheers, > Will > > On Wed, Apr 12, 2017 at 7:29 AM, Wang Dawei <weeo...@gmail.com > wrote: > >> At the distribution site, we use your product CommCare to fill the >> distribution form which contains the information of what items have been >> distributed. In order to reduce human error, we are trying to create a drop >> down menu for the users to select from instead of typing in. I found that >> CommCare can setup a question with filtered choices and can update the look >> up table manually. >> https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables I >> wonder if there is a way that CommCare can talk to our SQL database and >> update its lookup table automatically? Or is this some API you are >> considering to build in the future? I found CommCare has data >> forwarding/exporting features but not much importing APIs except excel >> spreadsheet upload. >> >> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hi Will:

Is this function still valid? I was trying to use this, but it gives me
this:

  • About to connect() to www.commcarehq.org port 443 (#0)

  • Trying 146.20.47.186… connected

  • Connected to www.commcarehq.org (146.20.47.186) port 443 (#0)

  • Initializing NSS with certpath: sql:/etc/pki/nssdb

  • CAfile: /etc/pki/tls/certs/ca-bundle.crt

CApath: none

  • SSL connection using TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256

  • Server certificate:

  • subject: CN=*.commcarehq.org,O=Dimagi
    Inc,L=Cambridge,ST=Massachusetts,C=US

  • start date: Nov 11 00:00:00 2016 GMT

  • expire date: Dec 30 23:59:59 2017 GMT

  • common name: *.commcarehq.org

  • issuer: CN=thawte SSL CA - G2,O=“thawte, Inc.”,C=US

  • Server auth using Digest with user ‘wang337@purdue.edu’

  • failed creating formpost data

  • Connection #0 to host www.commcarehq.org left intact

curl: (26) failed creating formpost data

  • Closing connection #0
··· On Wednesday, April 12, 2017 at 4:56:22 AM UTC-4, William Pride wrote: > > Hello, > > I believe the excel spreadsheet upload > is > the only API we have that allows you to modify lookup tables. In order to > communicate with your SQL database you'd probably need to write some > middleware of your own to perform the data pull and conversion from SQL to > Excel format. > > Cheers, > Will > > On Wed, Apr 12, 2017 at 7:29 AM, Wang Dawei <weeo...@gmail.com > wrote: > >> At the distribution site, we use your product CommCare to fill the >> distribution form which contains the information of what items have been >> distributed. In order to reduce human error, we are trying to create a drop >> down menu for the users to select from instead of typing in. I found that >> CommCare can setup a question with filtered choices and can update the look >> up table manually. >> https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables I >> wonder if there is a way that CommCare can talk to our SQL database and >> update its lookup table automatically? Or is this some API you are >> considering to build in the future? I found CommCare has data >> forwarding/exporting features but not much importing APIs except excel >> spreadsheet upload. >> >> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Yes, I believe you need at least a Standard Plan to use this feature. And
no, I’m not aware of any interface besides the command line for using this
functionality.

Cheers,
Will

··· On Tue, Apr 25, 2017 at 1:24 AM, Wang Dawei wrote:

Thank you!

Do we need a paid commcare account for this excel upload function? Is
there a interface instead of command line?

On Wednesday, April 12, 2017 at 4:56:22 AM UTC-4, William Pride wrote:

Hello,

I believe the excel spreadsheet upload
https://confluence.dimagi.com/display/commcarepublic/Bulk+upload+Lookup+Tables is
the only API we have that allows you to modify lookup tables. In order to
communicate with your SQL database you’d probably need to write some
middleware of your own to perform the data pull and conversion from SQL to
Excel format.

Cheers,
Will

On Wed, Apr 12, 2017 at 7:29 AM, Wang Dawei weeo...@gmail.com wrote:

At the distribution site, we use your product CommCare to fill the
distribution form which contains the information of what items have been
distributed. In order to reduce human error, we are trying to create a drop
down menu for the users to select from instead of typing in. I found that
CommCare can setup a question with filtered choices and can update the look
up table manually. https://confluence.dimagi.com/display/commcarepubl
ic/Lookup+Tables I wonder if there is a way that CommCare can talk to
our SQL database and update its lookup table automatically? Or is this some
API you are considering to build in the future? I found CommCare has data
forwarding/exporting features but not much importing APIs except excel
spreadsheet upload.


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-user...@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-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/d/optout.

Hi,

If you are on the standard plan, you can bulk upload lookup tables using
the interface as described here
https://confluence.dimagi.com/display/commcarepublic/Creating+and+Updating+Lookup+Tables.

Hope that helps,

Farid

··· On Mon, Apr 24, 2017 at 7:24 PM, Wang Dawei wrote:

Thank you!

Do we need a paid commcare account for this excel upload function? Is
there a interface instead of command line?

On Wednesday, April 12, 2017 at 4:56:22 AM UTC-4, William Pride wrote:

Hello,

I believe the excel spreadsheet upload
https://confluence.dimagi.com/display/commcarepublic/Bulk+upload+Lookup+Tables is
the only API we have that allows you to modify lookup tables. In order to
communicate with your SQL database you’d probably need to write some
middleware of your own to perform the data pull and conversion from SQL to
Excel format.

Cheers,
Will

On Wed, Apr 12, 2017 at 7:29 AM, Wang Dawei weeo...@gmail.com wrote:

At the distribution site, we use your product CommCare to fill the
distribution form which contains the information of what items have been
distributed. In order to reduce human error, we are trying to create a drop
down menu for the users to select from instead of typing in. I found that
CommCare can setup a question with filtered choices and can update the look
up table manually. https://confluence.dimagi.com/display/commcarepubl
ic/Lookup+Tables I wonder if there is a way that CommCare can talk to
our SQL database and update its lookup table automatically? Or is this some
API you are considering to build in the future? I found CommCare has data
forwarding/exporting features but not much importing APIs except excel
spreadsheet upload.


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-user...@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-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/d/optout.

That error (‘failed creating formpost data’) looks like an issue with cURL
creating the payload rather than with CommCareHQ. I’ve never seen this
issue before - is the path correct and do you have proper permissions to
access that file?

··· On Thu, Jun 29, 2017 at 3:53 AM, Wang Dawei wrote:

failed creating formpost data

Hi Will:

Thank you so much for your help. bulk upload
https://confluence.dimagi.com/display/commcarepublic/Bulk+upload+Lookup+Tables is
exactly what I’m looking for. I wonder if I need to deploy every time I
update the lookup table? Or it will be updated automatically on the device?
If not, is there a command line for deploy?

Best,
Dawei

··· On Tuesday, April 25, 2017 at 11:52:10 AM UTC+5:30, William Pride wrote: > > Yes, I believe you need at least a Standard Plan to use this feature. And > no, I'm not aware of any interface besides the command line for using this > functionality. > > Cheers, > Will > > On Tue, Apr 25, 2017 at 1:24 AM, Wang Dawei <weeo...@gmail.com > wrote: > >> Thank you! >> >> Do we need a paid commcare account for this excel upload function? Is >> there a interface instead of command line? >> >> On Wednesday, April 12, 2017 at 4:56:22 AM UTC-4, William Pride wrote: >>> >>> Hello, >>> >>> I believe the excel spreadsheet upload >>> is >>> the only API we have that allows you to modify lookup tables. In order to >>> communicate with your SQL database you'd probably need to write some >>> middleware of your own to perform the data pull and conversion from SQL to >>> Excel format. >>> >>> Cheers, >>> Will >>> >>> On Wed, Apr 12, 2017 at 7:29 AM, Wang Dawei wrote: >>> >>>> At the distribution site, we use your product CommCare to fill the >>>> distribution form which contains the information of what items have been >>>> distributed. In order to reduce human error, we are trying to create a drop >>>> down menu for the users to select from instead of typing in. I found that >>>> CommCare can setup a question with filtered choices and can update the look >>>> up table manually. >>>> https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables I >>>> wonder if there is a way that CommCare can talk to our SQL database and >>>> update its lookup table automatically? Or is this some API you are >>>> considering to build in the future? I found CommCare has data >>>> forwarding/exporting features but not much importing APIs except excel >>>> spreadsheet upload. >>>> >>>> -- >>>> 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-user...@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-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >