Data Export Tool | SQL Database

Users
1

Hi,

I have started working on CommCare data export tool (Link
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool), export
to SQL database, and got stuck with following questions.

  1. How/where to provide form name in configuration excel file?
  2. It does not throw any message (success/failure) while execution.
  3. No log maintain for execution
    • If project space name, form name, data field name does not exist it
      does not notify.
  4. No tutorial available for SQL database export.

Please advise how I can overcome from above situation.

Thanks,
Vipin Gupta

2

Hi Vipin

  1. How/where to provide form name in configuration excel file?

When running the tool you specify the path of the configuration file using
the '--query' command line parameter.

  1. It does not throw any message (success/failure) while execution.

By default you will only see output if there have been any errors. You can
use the '--verbose' command line flag to get more output .

  1. No log maintain for execution
    • If project space name, form name, data field name does not exist it
      does not notify.

If the project space name is incorrect you will like get an authorization
error. The tool is specifically designed not to error for fields that don't
exist. If you want to be able to see when values don't exist more clearly
you can use the '--missing-value' parameter to specify a value to use when
the field is missing.

  1. No tutorial available for SQL database export.

Please refer to this section of the documentation where it describes how
to save the data to a SQL database:
CommCare Data Export Tool - CommCare Public - CommCare Public

To get more information about the command line options you can run
"commcare-export --help".

Best regards
Simon

3

ThanksSimon for the explanation.

Regarding Point1: Where I will mention form name in the configuration excel
file? We can give the path of the configuration file in command line, but
how to mention what form's data needs to be fetched.

Thanks
Vipin Gupta

··· On Tuesday, May 30, 2017 at 7:27:33 PM UTC+5:30, skelly wrote: > > Hi Vipin > >> >> 1. How/where to provide form name in configuration excel file? >> >> When running the tool you specify the path of the configuration file > using the '--query' command line parameter. > >> >> 1. It does not throw any message (success/failure) while execution. >> >> By default you will only see output if there have been any errors. You > can use the '--verbose' command line flag to get more output . > >> >> 1. No log maintain for execution >> - If project space name, form name, data field name does not exist it >> does not notify. >> >> If the project space name is incorrect you will like get an authorization > error. The tool is specifically designed not to error for fields that don't > exist. If you want to be able to see when values don't exist more clearly > you can use the '--missing-value' parameter to specify a value to use when > the field is missing. > >> >> 1. No tutorial available for SQL database export. >> >> Please refer to this section of the documentation where it describes how > to save the data to a SQL database: > https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-4.SavetheoutputofanexamplequerytoaSQLdatabase > > > To get more information about the command line options you can run > "commcare-export --help". > > Best regards > Simon > >
4

Hi

You can't filter by form name but you can filter by form XMLNS. There are
instructions on the wiki about how to setup the filters:
https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-C.ExcelConfigurationDetails

You can get the form XMLNS by looking that the form XML on CommCareHQ

Simon Kelly
Director of Server Engineer | Dimagi

··· On 31 May 2017 at 10:08, Vipin Gupta wrote:

ThanksSimon for the explanation.

Regarding Point1: Where I will mention form name in the configuration
excel file? We can give the path of the configuration file in command line,
but how to mention what form's data needs to be fetched.

Thanks
Vipin Gupta

On Tuesday, May 30, 2017 at 7:27:33 PM UTC+5:30, skelly wrote:

Hi Vipin

  1. How/where to provide form name in configuration excel file?

When running the tool you specify the path of the configuration file
using the '--query' command line parameter.

  1. It does not throw any message (success/failure) while execution.

By default you will only see output if there have been any errors. You
can use the '--verbose' command line flag to get more output .

  1. No log maintain for execution
    • If project space name, form name, data field name does not exist it
      does not notify.

If the project space name is incorrect you will like get an
authorization error. The tool is specifically designed not to error for
fields that don't exist. If you want to be able to see when values don't
exist more clearly you can use the '--missing-value' parameter to specify a
value to use when the field is missing.

  1. No tutorial available for SQL database export.

Please refer to this section of the documentation where it describes
how to save the data to a SQL database: https://confluence.d
imagi.com/display/commcarepublic/CommCare+Data+Export+Tool#C
ommCareDataExportTool-4.SavetheoutputofanexamplequerytoaSQLdatabase

To get more information about the command line options you can run
"commcare-export --help".

Best regards
Simon

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

Thanks Simon,

While executing the command, I am getting an error. Both error (with the
command) and the configuration file is enclosed.

Please advise.
Thanks,
Vipin Gupta

Configuration_Settings_Dev.xlsx (9.16 KB)

Result.txt (3.95 KB)

··· On Thursday, June 1, 2017 at 4:31:04 PM UTC+5:30, skelly wrote: > > Hi > > You can't filter by form name but you can filter by form XMLNS. There are > instructions on the wiki about how to setup the filters: > https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-C.ExcelConfigurationDetails > > You can get the form XMLNS by looking that the form XML on CommCareHQ > > Simon Kelly > Director of Server Engineer | Dimagi > > On 31 May 2017 at 10:08, Vipin Gupta <vipi...@gmail.com > wrote: > >> ThanksSimon for the explanation. >> >> Regarding Point1: Where I will mention form name in the configuration >> excel file? We can give the path of the configuration file in command line, >> but how to mention what form's data needs to be fetched. >> >> Thanks >> Vipin Gupta >> >> >> On Tuesday, May 30, 2017 at 7:27:33 PM UTC+5:30, skelly wrote: >>> >>> Hi Vipin >>> >>>> >>>> 1. How/where to provide form name in configuration excel file? >>>> >>>> When running the tool you specify the path of the configuration file >>> using the '--query' command line parameter. >>> >>>> >>>> 1. It does not throw any message (success/failure) while execution. >>>> >>>> By default you will only see output if there have been any errors. You >>> can use the '--verbose' command line flag to get more output . >>> >>>> >>>> 1. No log maintain for execution >>>> - If project space name, form name, data field name does not >>>> exist it does not notify. >>>> >>>> If the project space name is incorrect you will like get an >>> authorization error. The tool is specifically designed not to error for >>> fields that don't exist. If you want to be able to see when values don't >>> exist more clearly you can use the '--missing-value' parameter to specify a >>> value to use when the field is missing. >>> >>>> >>>> 1. No tutorial available for SQL database export. >>>> >>>> Please refer to this section of the documentation where it describes >>> how to save the data to a SQL database: >>> https://confluence.dimagi.com/display/commcarepublic/CommCare+Data+Export+Tool#CommCareDataExportTool-4.SavetheoutputofanexamplequerytoaSQLdatabase >>> >>> >>> To get more information about the command line options you can run >>> "commcare-export --help". >>> >>> Best regards >>> Simon >>> >>> -- >> 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-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >