CommCare Export Tool

I’ve been using the commcare-export tool for a while now without any
issues. Yesterday, I started getting an error when using it. My query
sheets haven’t changed to my knowledge. I am using the tool to
create/update an sqlite database.

I am able to make requests for cases without any issue. When I make a
request for forms and use it to create an sqlite database file, everything
works as expected. But if I run the exact same command again to get any new
updates (as I’ve done many times before), I get the error below. Any ideas?

Traceback (most recent call last):

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/bin/commcare-export", line
9, in

load_entry_point('commcare-export==0.11.8', 'console_scripts', 

‘commcare-export’)()

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 185, in entry_point

main(sys.argv[1:])

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 71, in main

main_with_args(args)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 170, in main_with_args

writer.write_table(table)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/writers.py",
line 308, in write_table

for row in table['rows']:

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/minilinq.py",
line 255, in iterate

for item in source_result:

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/commcare_hq_client.py",
line 105, in iterate_resource

batch = self.get(resource, params)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/commcare_hq_client.py",
line 91, in get

raise Exception('GET %s failed (%s): %s' % (resource_url, 

response.status_code, response.text))

Exception: GET
https://www.commcarehq.org/a/spatialrepellents/api/v0.5/form/ failed (400):
{“error”: “Bad query parameter”}

Hello,

We’re looking into this issue and have logged it as a potential bug in our
system. We’ll follow up when we have more information or a workaround.

thanks,
Cory

··· On Fri, Apr 17, 2015 at 10:43 AM, wrote:

I’ve been using the commcare-export tool for a while now without any
issues. Yesterday, I started getting an error when using it. My query
sheets haven’t changed to my knowledge. I am using the tool to
create/update an sqlite database.

I am able to make requests for cases without any issue. When I make a
request for forms and use it to create an sqlite database file, everything
works as expected. But if I run the exact same command again to get any new
updates (as I’ve done many times before), I get the error below. Any ideas?

Traceback (most recent call last):

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/bin/commcare-export", line
9, in

load_entry_point('commcare-export==0.11.8', 'console_scripts',

‘commcare-export’)()

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 185, in entry_point

main(sys.argv[1:])

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 71, in main

main_with_args(args)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 170, in main_with_args

writer.write_table(table)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/writers.py",
line 308, in write_table

for row in table['rows']:

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/minilinq.py",
line 255, in iterate

for item in source_result:

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/commcare_hq_client.py",
line 105, in iterate_resource

batch = self.get(resource, params)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/commcare_hq_client.py",
line 91, in get

raise Exception('GET %s failed (%s): %s' % (resource_url,

response.status_code, response.text))

Exception: GET
https://www.commcarehq.org/a/spatialrepellents/api/v0.5/form/ failed
(400): {“error”: “Bad query parameter”}


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 for looking into this. I am now able to use the tool without
issue.

Hello,

These issues with the CommCare Export tool have now been resolved. Please
let us know if there are further issues.

Thanks,

··· -- Nate Haduch

Technical Support Analyst
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139
web: http://www.dimagi.com/

On Fri, Apr 17, 2015 at 2:45 PM, Cory Zue czue@dimagi.com wrote:

Hello,

We’re looking into this issue and have logged it as a potential bug in our
system. We’ll follow up when we have more information or a workaround.

thanks,
Cory

On Fri, Apr 17, 2015 at 10:43 AM, jolson6@nd.edu wrote:

I’ve been using the commcare-export tool for a while now without any
issues. Yesterday, I started getting an error when using it. My query
sheets haven’t changed to my knowledge. I am using the tool to
create/update an sqlite database.

I am able to make requests for cases without any issue. When I make a
request for forms and use it to create an sqlite database file, everything
works as expected. But if I run the exact same command again to get any new
updates (as I’ve done many times before), I get the error below. Any ideas?

Traceback (most recent call last):

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/bin/commcare-export", line
9, in

load_entry_point('commcare-export==0.11.8', 'console_scripts',

‘commcare-export’)()

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 185, in entry_point

main(sys.argv[1:])

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 71, in main

main_with_args(args)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/cli.py",
line 170, in main_with_args

writer.write_table(table)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/writers.py",
line 308, in write_table

for row in table['rows']:

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/minilinq.py",
line 255, in iterate

for item in source_result:

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/commcare_hq_client.py",
line 105, in iterate_resource

batch = self.get(resource, params)

File
"/Users/Jared/.virtualenvs/spatialrepellents_ci/lib/python2.7/site-packages/commcare_export/commcare_hq_client.py",
line 91, in get

raise Exception('GET %s failed (%s): %s' % (resource_url,

response.status_code, response.text))

Exception: GET
https://www.commcarehq.org/a/spatialrepellents/api/v0.5/form/ failed
(400): {“error”: “Bad query parameter”}


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.


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.