Export to Excel using CommCare Export Tool

Hi,

We are trying to export data using CommCare Export Tool, and it is getting
success to download the desired data, but its not giving value of
Row_Number (row field) and Form_Id, started_time, completed_time, username
(all are info field).

··· -- Ajay

Hi Group Members,

Your help will be highly appreciated. Please support.

··· On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote: > > Hi, > > We are trying to export data using CommCare Export Tool, and it is getting > success to download the desired data, but its not giving value of > Row_Number (row field) and Form_Id, started_time, completed_time, username > (all are info field). > > -- > Ajay >

Hi,

Row Id is too important and mandatory for us. First please help us, as how
to export Row Id from CommCare-Export command line tool.

··· On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote: > > Hi, > > We are trying to export data using CommCare Export Tool, and it is getting > success to download the desired data, but its not giving value of > Row_Number (row field) and Form_Id, started_time, completed_time, username > (all are info field). > > -- > Ajay >

Hi Group Members,

Please help us on priority, as ‘Row Number’ export is too critical for us.
CommCare Support team, your quick intervention will be highly appreciated.

··· On Thursday, November 24, 2016 at 12:30:07 PM UTC+5:30, Ajay Singh wrote: > > > Hi, > > Row Id is too important and mandatory for us. First please help us, as how > to export Row Id from CommCare-Export command line tool. > > On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote: >> >> Hi, >> >> We are trying to export data using CommCare Export Tool, and it is >> getting success to download the desired data, but its not giving value of >> Row_Number (row field) and Form_Id, started_time, completed_time, username >> (all are info field). >> >> -- >> Ajay >> >

Hi Ajay,

Unfortunately it is not possible to export the row number using the
commcare-export tool (it’s not based off of the exports on the web UI).
Perhaps using Mysql’s auto_increment keyword could solve your problem?
http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

Ben

··· On Sat, Nov 26, 2016 at 3:23 PM, Ajay Singh wrote:

Hi Group Members,

Please help us on priority, as ‘Row Number’ export is too critical for us.
CommCare Support team, your quick intervention will be highly appreciated.

On Thursday, November 24, 2016 at 12:30:07 PM UTC+5:30, Ajay Singh wrote:

Hi,

Row Id is too important and mandatory for us. First please help us, as
how to export Row Id from CommCare-Export command line tool.

On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote:

Hi,

We are trying to export data using CommCare Export Tool, and it is
getting success to download the desired data, but its not giving value of
Row_Number (row field) and Form_Id, started_time, completed_time, username
(all are info field).


Ajay


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks Ben for your prompt support and reply.

As per your suggestion, MySQL’s auto_increment will not suffice my
requirement, as I need ‘RowNumber’ in export, to sync up and verify my
incremental exports with previous exports, from CommCare existing data.

And can you please also update about export of, FormId, started_time,
completed_time, username (all info field)?

@Support Team, can you please take this requirement as feature development
in CommCare Export Tool.

··· -- Thanks, *Ajay Singh* *Corporate** Renaissance **Group* Cell (India): +91-9711628763​ Email: ajay.singh@crgoup.co.in

[image: CR Group] http://www.crgroup.com/[image: Rapid-Fire Business
Intelligence & Analytics] http://www.tableau.com/

On Sun, Nov 27, 2016 at 5:00 AM, Ben Rudolph brudolph@dimagi.com wrote:

Hi Ajay,

Unfortunately it is not possible to export the row number using the
commcare-export tool (it’s not based off of the exports on the web UI).
Perhaps using Mysql’s auto_increment keyword could solve your problem?
http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

Ben

On Sat, Nov 26, 2016 at 3:23 PM, Ajay Singh ajay.singh@crgroup.co.in wrote:

Hi Group Members,

Please help us on priority, as ‘Row Number’ export is too critical for
us.
CommCare Support team, your quick intervention will be highly appreciated.

On Thursday, November 24, 2016 at 12:30:07 PM UTC+5:30, Ajay Singh wrote:

Hi,

Row Id is too important and mandatory for us. First please help us, as
how to export Row Id from CommCare-Export command line tool.

On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote:

Hi,

We are trying to export data using CommCare Export Tool, and it is
getting success to download the desired data, but its not giving value of
Row_Number (row field) and
​​
Form_Id, started_time, completed_time, username (all are info field).


Ajay


You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “CommCare Developers” group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/commcare-developers/iekB_LgBmZc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Ajay,

Perhaps you can use the the form’s id to verify whether the form needs to
be inserted or not. As for the properties you mentioned, you should be able
to get those with the following paths:

FormId - form_id
started_time - form.meta.timeStart
completed_time - form.meta.timeEnd
username - form.meta.username

Ben

··· On Sat, Nov 26, 2016 at 7:17 PM, Ajay Singh wrote:

Thanks Ben for your prompt support and reply.

As per your suggestion, MySQL’s auto_increment will not suffice my
requirement, as I need ‘RowNumber’ in export, to sync up and verify my
incremental exports with previous exports, from CommCare existing data.

And can you please also update about export of, FormId, started_time,
completed_time, username (all info field)?

@Support Team, can you please take this requirement as feature development
in CommCare Export Tool.


Thanks,
Ajay Singh
Corporate* Renaissance *Group
Cell (India): +91-9711628763​
Email: ajay.singh@crgoup.co.in

[image: CR Group] http://www.crgroup.com/[image: Rapid-Fire Business
Intelligence & Analytics] http://www.tableau.com/

On Sun, Nov 27, 2016 at 5:00 AM, Ben Rudolph brudolph@dimagi.com wrote:

Hi Ajay,

Unfortunately it is not possible to export the row number using the
commcare-export tool (it’s not based off of the exports on the web UI).
Perhaps using Mysql’s auto_increment keyword could solve your problem?
http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

Ben

On Sat, Nov 26, 2016 at 3:23 PM, Ajay Singh ajay.singh@crgroup.co.in wrote:

Hi Group Members,

Please help us on priority, as ‘Row Number’ export is too critical for
us.
CommCare Support team, your quick intervention will be highly
appreciated.

On Thursday, November 24, 2016 at 12:30:07 PM UTC+5:30, Ajay Singh wrote:

Hi,

Row Id is too important and mandatory for us. First please help us, as
how to export Row Id from CommCare-Export command line tool.

On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote:

Hi,

We are trying to export data using CommCare Export Tool, and it is
getting success to download the desired data, but its not giving value of
Row_Number (row field) and
​​
Form_Id, started_time, completed_time, username (all are info field).


Ajay


You received this message because you are subscribed to the Google
Groups “CommCare Developers” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “CommCare Developers” group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/commcare-developers/iekB_LgBmZc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks Ben,

I will try and let you update at the earliest.

··· -- Thanks, *Ajay Singh* *Corporate** Renaissance **Group* Cell (India): +91-9711628763​ Email: ajay.singh@crgoup.co.in

[image: CR Group] http://www.crgroup.com/[image: Rapid-Fire Business
Intelligence & Analytics] http://www.tableau.com/

On Sun, Nov 27, 2016 at 6:07 AM, Ben Rudolph brudolph@dimagi.com wrote:

Hi Ajay,

Perhaps you can use the the form’s id to verify whether the form needs to
be inserted or not. As for the properties you mentioned, you should be able
to get those with the following paths:

FormId - form_id
started_time - form.meta.timeStart
completed_time - form.meta.timeEnd
username - form.meta.username

Ben

On Sat, Nov 26, 2016 at 7:17 PM, Ajay Singh ajay.singh@crgroup.co.in wrote:

Thanks Ben for your prompt support and reply.

As per your suggestion, MySQL’s auto_increment will not suffice my
requirement, as I need ‘RowNumber’ in export, to sync up and verify my
incremental exports with previous exports, from CommCare existing data.

And can you please also update about export of, FormId, started_time,
completed_time, username (all info field)?

@Support Team, can you please take this requirement as feature
development in CommCare Export Tool.


Thanks,
Ajay Singh
Corporate* Renaissance *Group
Cell (India): +91-9711628763​
Email: ajay.singh@crgoup.co.in

[image: CR Group] http://www.crgroup.com/[image: Rapid-Fire Business
Intelligence & Analytics] http://www.tableau.com/

On Sun, Nov 27, 2016 at 5:00 AM, Ben Rudolph brudolph@dimagi.com wrote:

Hi Ajay,

Unfortunately it is not possible to export the row number using the
commcare-export tool (it’s not based off of the exports on the web UI).
Perhaps using Mysql’s auto_increment keyword could solve your problem?
http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

Ben

On Sat, Nov 26, 2016 at 3:23 PM, Ajay Singh ajay.singh@crgroup.co.in wrote:

Hi Group Members,

Please help us on priority, as ‘Row Number’ export is too critical for
us.
CommCare Support team, your quick intervention will be highly
appreciated.

On Thursday, November 24, 2016 at 12:30:07 PM UTC+5:30, Ajay Singh wrote:

Hi,

Row Id is too important and mandatory for us. First please help us, as
how to export Row Id from CommCare-Export command line tool.

On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote:

Hi,

We are trying to export data using CommCare Export Tool, and it is
getting success to download the desired data, but its not giving value of
Row_Number (row field) and
​​
Form_Id, started_time, completed_time, username (all are info field).


Ajay


You received this message because you are subscribed to the Google
Groups “CommCare Developers” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “CommCare Developers” group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/commcare-developers/iekB_LgBmZc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks a lot Mr. Ben for your quick support.

Its all info fields are working now, as suggested:

  1. started_time - form.meta.timeStart

  2. completed_time - form.meta.timeEnd

  3. username - form.meta.username

  4. FormId - form_id: small correction required.
    I have used guessing, and FormId is getting exported by 'form.id' field.

So in this way, the corrected one are:

FormId - form.id
started_time - form.meta.timeStart
completed_time - form.meta.timeEnd
username - form.meta.username

Once again, many-many thanks :slight_smile:

··· -- Thanks, *Ajay Singh* *Corporate** Renaissance **Group* Cell (India): +91-9711628763​ Email: ajay.singh@crgoup.co.in

[image: CR Group] http://www.crgroup.com/[image: Rapid-Fire Business
Intelligence & Analytics] http://www.tableau.com/

On Sun, Nov 27, 2016 at 6:07 AM, Ben Rudolph brudolph@dimagi.com wrote:

Hi Ajay,

Perhaps you can use the the form's id to verify whether the form needs to
be inserted or not. As for the properties you mentioned, you should be able
to get those with the following paths:

​​
FormId - form_id
started_time - form.meta.timeStart
completed_time - form.meta.timeEnd
username - form.meta.username

Ben

On Sat, Nov 26, 2016 at 7:17 PM, Ajay Singh ajay.singh@crgroup.co.in wrote:

Thanks Ben for your prompt support and reply.

As per your suggestion, MySQL's auto_increment will not suffice my
requirement, as I need 'RowNumber' in export, to sync up and verify my
incremental exports with previous exports, from CommCare existing data.

And can you please also update about export of, FormId, started_time,
completed_time, username (all info field)?

@Support Team, can you please take this requirement as feature
development in CommCare Export Tool.

--
Thanks,
Ajay Singh
Corporate* Renaissance *Group
Cell (India): +91-9711628763​
Email: ajay.singh@crgoup.co.in

[image: CR Group] http://www.crgroup.com/[image: Rapid-Fire Business
Intelligence & Analytics] http://www.tableau.com/

On Sun, Nov 27, 2016 at 5:00 AM, Ben Rudolph brudolph@dimagi.com wrote:

Hi Ajay,

Unfortunately it is not possible to export the row number using the
commcare-export tool (it's not based off of the exports on the web UI).
Perhaps using Mysql's auto_increment keyword could solve your problem?
http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

Ben

On Sat, Nov 26, 2016 at 3:23 PM, Ajay Singh ajay.singh@crgroup.co.in wrote:

Hi Group Members,

Please help us on priority, as 'Row Number' export is too critical for
us.
CommCare Support team, your quick intervention will be highly
appreciated.

On Thursday, November 24, 2016 at 12:30:07 PM UTC+5:30, Ajay Singh wrote:

Hi,

Row Id is too important and mandatory for us. First please help us, as
how to export Row Id from CommCare-Export command line tool.

On Wednesday, November 23, 2016 at 12:02:26 AM UTC+5:30, Ajay Singh wrote:

Hi,

We are trying to export data using CommCare Export Tool, and it is
getting success to download the desired data, but its not giving value of
Row_Number (row field) and
​​
Form_Id, started_time, completed_time, username (all are info field).

--
Ajay

--


You received this message because you are subscribed to the Google
Groups "CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--


You received this message because you are subscribed to a topic in the
Google Groups "CommCare Developers" group.
To unsubscribe from this topic, visit https://groups.google.com/d/to
pic/commcare-developers/iekB_LgBmZc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.