[Commcare-export tool] Non-answered questions imported as empty strings: '' into postgrsql

Users
1

Hi All,
I encountered an error causing the Commcare Export tool to provide errors
when using the 'map via' option.
When questions are imported to database they are written as empty strings:
''
When the export tool tries to alter the column type an error is generated.
(similar as when done manual conversion).

A workaround inside the database:
when replacing the empty strings for null values type conversion works:
UPDATE SET = cast(nullif(, '') AS numeric);

I encounterd this with export tool version 0.14 and 0.15 to postgresql 9.6
I am not sure if other systems are affected.

P.s. I also reported it to the github export tool space

2

Thanks for your feedback Jos.

We'll try incorporate a fix for that in the next release.

Simon Kelly
Director of Server Engineer | Dimagi

ยทยทยท On 22 August 2017 at 09:18, Jos van der Ent wrote:

Hi All,
I encountered an error causing the Commcare Export tool to provide errors
when using the 'map via' option.
When questions are imported to database they are written as empty strings:
''
When the export tool tries to alter the column type an error is generated.
(similar as when done manual conversion).

A workaround inside the database:
when replacing the empty strings for null values type conversion works:
UPDATE SET = cast(nullif(, '') AS numeric);

I encounterd this with export tool version 0.14 and 0.15 to postgresql 9.6
I am not sure if other systems are affected.

P.s. I also reported it to the github export tool space

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