What should be source field name in the config file for the system genenrated field name during the case export

Hi,

I have a setup to export the data from Commcarehq to the Ms-SQL server by
using API (
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool)
,and it is getting exported successfully for all the fields except with the
below field names (appearing under properties) :

1.(info)Opened_date
2.(info)Closed
3.(info)Closed_date

I tried to define the above column name as similar name in the source filed
even tried to add as “info.” , "properties.info."
and “properties.info.meta.” but still not able to get any
data after exporting into the SQL server against the above column names.

Kindly suggest for the correct format for the above listed column names,
that should be defined in the source field in the configuration file (being
referred during the data export).

Thanks in advance.

With regards,
Gurudayal Sahu

Hello,

The proper fields to use are:

1.(info)Opened_date --> properties.date_opened
2.(info)Closed --> closed
3.(info)Closed_date --> date_closed

To figure this out in the future, you can refer to this line from the wiki:

(Power Users / Programmers Only) To find out exactly what fields are
available, you must view the raw output of the CommCareHQ Case List API
https://confluence.dimagi.com/display/commcarepublic/List+Cases and Form
List API. You can then reference these fields using an arbitrary JSONPath
https://github.com/kennknowles/python-jsonpath-rw into the structure.

··· On Thu, Feb 2, 2017 at 5:01 AM, Sahu wrote:

Hi,

I have a setup to export the data from Commcarehq to the Ms-SQL server by
using API (https://confluence.dimagi.com/display/commcarepublic/CommCa
re+Data+Export+Tool) ,and it is getting exported successfully for all the
fields except with the below field names (appearing under properties) :

1.(info)Opened_date
2.(info)Closed
3.(info)Closed_date

I tried to define the above column name as similar name in the source
filed even tried to add as “info.” , “properties.info.” and “properties.info.meta.” but still not able to
get any data after exporting into the SQL server against the above column
names.

Kindly suggest for the correct format for the above listed column names,
that should be defined in the source field in the configuration file (being
referred during the data export).

Thanks in advance.

With regards,
Gurudayal Sahu


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.