Data Export Tool | Error

Users
1

Hi,

I have configured data export tool which exports data to SQL server. Some
fields having values like <map object at 0x0000000006955128>, these fields
are hidden due to display condition in the form.

When I am exporting data, I am getting following error.

sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError)
('Invalid parameter type. param-index=1 param-type=map', 'HY105')
[SQL: '
INSERT INTO [Household Details] (id, [form.hh_registration_dt],
completed_time, [form.new_hh_ind], [form.hh_registration_type],
received_on, username, [form.hh_admin_bnd_3], [form.hh_admin_bnd_2],
[form.hh_admin_bnd_1], started_time, [form.hh_admin_bnd_5],
[form.hh_admin_bnd_4])
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'] [parameters:
('b2b3baf3-003a-469c-9fc6-354da0d56431', <map object at
0x0000000006955128>, '2017-06-05T10:07:02.024000Z', 'U', <map object at
0x0000000006955FD0>, '2017-06-05T10:06:59.718795Z', 'vipin.gupta', <map
object at 0x0000000006955400>, <map object at 0x00000000069553C8>, <map
object at 0x00000000069552E8>, '2017-06-05T10:00:40.371000Z', <map object
at 0x0000000006955F60>, <map object at 0x0000000006955EF0>)]

Please advise how to overcome this issue.

Thanks,
Vipin Gupta

2

Hi Vipin

This is an issue with Python3. If you are able to use Python2 I would
recommend that. We do plan on fixing this issue but don't have a timeline
on when that will be done yet.

Simon Kelly
Director of Server Engineer | Dimagi

··· On 12 June 2017 at 08:22, Vipin Gupta wrote:

Hi,

I have configured data export tool which exports data to SQL server. Some
fields having values like <map object at 0x0000000006955128>, these fields
are hidden due to display condition in the form.

When I am exporting data, I am getting following error.

sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError)
('Invalid parameter type. param-index=1 param-type=map', 'HY105')
[SQL: '
INSERT INTO [Household Details] (id, [form.hh_registration_dt],
completed_time, [form.new_hh_ind], [form.hh_registration_type],
received_on, username, [form.hh_admin_bnd_3], [form.hh_admin_bnd_2],
[form.hh_admin_bnd_1], started_time, [form.hh_admin_bnd_5],
[form.hh_admin_bnd_4])
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'] [parameters:
('b2b3baf3-003a-469c-9fc6-354da0d56431', <map object at
0x0000000006955128>, '2017-06-05T10:07:02.024000Z', 'U', <map object at
0x0000000006955FD0>, '2017-06-05T10:06:59.718795Z', 'vipin.gupta', <map
object at 0x0000000006955400>, <map object at 0x00000000069553C8>, <map
object at 0x00000000069552E8>, '2017-06-05T10:00:40.371000Z', <map object
at 0x0000000006955F60>, <map object at 0x0000000006955EF0>)]

Please advise how to overcome this issue.

Thanks,
Vipin Gupta

--
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.

3

Hi Simon,
I try to avoid hi-jacking the topic, but I encounter the same challenge.
Is there an easy work around e.g. tell commcare-export tool to use python 2
instead of 3 when installed parallel (I know you can make changes in the
path (for windows) but than it also affects the rest of the operating
system.

Jos

4

Hi Jos

I'll be releasing a fix for this today. I'll ping back on this thread once
it's released.

Simon Kelly
Director of Server Engineer | Dimagi

··· On 1 August 2017 at 13:48, Jos van der Ent wrote:

Hi Simon,
I try to avoid hi-jacking the topic, but I encounter the same challenge.
Is there an easy work around e.g. tell commcare-export tool to use python
2 instead of 3 when installed parallel (I know you can make changes in the
path (for windows) but than it also affects the rest of the operating
system.

Jos

--
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.

5

The fix has been released as v0.14.0.

I have also added the latest version number to the documentation as a point
of reference:
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool

Simon Kelly
Director of Server Engineer | Dimagi

··· On 7 August 2017 at 12:13, Simon Kelly wrote:

Hi Jos

I'll be releasing a fix for this today. I'll ping back on this thread once
it's released.

Simon Kelly
Director of Server Engineer | Dimagi

On 1 August 2017 at 13:48, Jos van der Ent jos@safisana.org wrote:

Hi Simon,
I try to avoid hi-jacking the topic, but I encounter the same challenge.
Is there an easy work around e.g. tell commcare-export tool to use python
2 instead of 3 when installed parallel (I know you can make changes in the
path (for windows) but than it also affects the rest of the operating
system.

Jos

--
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.