Data Export Tool | Error

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

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.

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

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.

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.