Commcare-export of archived forms

Users
1

I am trying to use the commcare-export utility to do a nightly synch of
form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so that it
doesn't show up in reports, or in my case it drops off of the result set
from commcare-export.

Is there any way to structure my query so that I also get the archived form
submissions?

2

Hi

This isn't possible at present but we'll look into making it possible. I'll
get back to you when I have more details.

··· On 5 March 2015 at 19:41, wrote:

I am trying to use the commcare-export utility to do a nightly synch of
form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so that it
doesn't show up in reports, or in my case it drops off of the result set
from commcare-export.

Is there any way to structure my query so that I also get the archived
form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

3

Hi

I've just released a new version of the commcare-export tool that will
allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel query file
as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

··· On 6 March 2015 at 12:40, Simon Kelly wrote:

Hi

This isn't possible at present but we'll look into making it possible.
I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly synch of
form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so that
it doesn't show up in reports, or in my case it drops off of the result set
from commcare-export.

Is there any way to structure my query so that I also get the archived
form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

4

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the form was
    archived or not?
  2. I have never really used the filter functionality before. It seems to be
    a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

··· On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly wrote:

Hi

I've just released a new version of the commcare-export tool that will
allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel query
file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it possible.
I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly synch of
form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so that
it doesn't show up in reports, or in my case it drops off of the result set
from commcare-export.

Is there any way to structure my query so that I also get the archived
form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

5

Hi Caleb

Each form has a field 'archived' which will be true if the form has been
archived. The commcare-export tool is built on top of the CommCare API's
which are documented here:

You can use any of the input parameters as filters in the export tool but
you should note the export tool will automatically insert the date filters
based on the value of the '--since' command line parameter so it isn't
necessary to add those to the query file.

··· On 9 March 2015 at 16:31, Caleb Reinking wrote:

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the form
    was archived or not?
  2. I have never really used the filter functionality before. It seems to
    be a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly skelly@dimagi.com wrote:

Hi

I've just released a new version of the commcare-export tool that will
allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel query
file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it possible.
I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly synch of
form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so that
it doesn't show up in reports, or in my case it drops off of the result set
from commcare-export.

Is there any way to structure my query so that I also get the archived
form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

6

Many thanks! I always appreciate the speedy support I receive from the
CommCare team!

··· On Mon, Mar 9, 2015 at 10:37 AM, Simon Kelly wrote:

Hi Caleb

Each form has a field 'archived' which will be true if the form has been
archived. The commcare-export tool is built on top of the CommCare API's
which are documented here:

You can use any of the input parameters as filters in the export tool but
you should note the export tool will automatically insert the date filters
based on the value of the '--since' command line parameter so it isn't
necessary to add those to the query file.

On 9 March 2015 at 16:31, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the form
    was archived or not?
  2. I have never really used the filter functionality before. It seems to
    be a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly skelly@dimagi.com wrote:

Hi

I've just released a new version of the commcare-export tool that will
allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel query
file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it possible.
I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly synch
of form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so
that it doesn't show up in reports, or in my case it drops off of the
result set from commcare-export.

Is there any way to structure my query so that I also get the archived
form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

7

My pleasure.

··· On 9 March 2015 at 16:40, Caleb Reinking wrote:

Many thanks! I always appreciate the speedy support I receive from the
CommCare team!

On Mon, Mar 9, 2015 at 10:37 AM, Simon Kelly skelly@dimagi.com wrote:

Hi Caleb

Each form has a field 'archived' which will be true if the form has been
archived. The commcare-export tool is built on top of the CommCare API's
which are documented here:

You can use any of the input parameters as filters in the export tool but
you should note the export tool will automatically insert the date filters
based on the value of the '--since' command line parameter so it isn't
necessary to add those to the query file.

On 9 March 2015 at 16:31, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the form
    was archived or not?
  2. I have never really used the filter functionality before. It seems to
    be a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly skelly@dimagi.com wrote:

Hi

I've just released a new version of the commcare-export tool that will
allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel query
file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it possible.
I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly synch
of form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so
that it doesn't show up in reports, or in my case it drops off of the
result set from commcare-export.

Is there any way to structure my query so that I also get the
archived form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

8

Hi, Simon, can you help me plz, I'm a newly commcare user. Im just trying
to build a form for health survey project. I want to monitor and evaluate
the work of mobile worker/ user. But I could not find the way about
"fixture" option. so tell me about "fixture" option how to use it detail me
plz.

··· On Mon, Mar 9, 2015 at 8:28 PM, Simon Kelly wrote:

My pleasure.

On 9 March 2015 at 16:40, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Many thanks! I always appreciate the speedy support I receive from the
CommCare team!

On Mon, Mar 9, 2015 at 10:37 AM, Simon Kelly skelly@dimagi.com wrote:

Hi Caleb

Each form has a field 'archived' which will be true if the form has been
archived. The commcare-export tool is built on top of the CommCare API's
which are documented here:

You can use any of the input parameters as filters in the export tool
but you should note the export tool will automatically insert the date
filters based on the value of the '--since' command line parameter so it
isn't necessary to add those to the query file.

On 9 March 2015 at 16:31, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the form
    was archived or not?
  2. I have never really used the filter functionality before. It seems
    to be a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly skelly@dimagi.com wrote:

Hi

I've just released a new version of the commcare-export tool that will
allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel query
file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it
possible. I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly synch
of form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so
that it doesn't show up in reports, or in my case it drops off of the
result set from commcare-export.

Is there any way to structure my query so that I also get the
archived form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

9

Hi Sanu,

Please see the following link for resources on fixtures, which are also
known as lookup tables:
https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables

You might find fixtures to be useful in your project for populating select
options or providing features to only a select group of users. Do note that
they require some amount of hand-editing of XML within a form in order to
implement.

Thanks,

Nate

··· On Thu, Mar 12, 2015 at 10:50 PM, Sanu Ghalan < ghalan100shadhikhola@gmail.com> wrote:

Hi, Simon, can you help me plz, I'm a newly commcare user. Im just trying
to build a form for health survey project. I want to monitor and evaluate
the work of mobile worker/ user. But I could not find the way about
"fixture" option. so tell me about "fixture" option how to use it detail me
plz.

On Mon, Mar 9, 2015 at 8:28 PM, Simon Kelly skelly@dimagi.com wrote:

My pleasure.

On 9 March 2015 at 16:40, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Many thanks! I always appreciate the speedy support I receive from the
CommCare team!

On Mon, Mar 9, 2015 at 10:37 AM, Simon Kelly skelly@dimagi.com wrote:

Hi Caleb

Each form has a field 'archived' which will be true if the form has
been archived. The commcare-export tool is built on top of the CommCare
API's which are documented here:

You can use any of the input parameters as filters in the export tool
but you should note the export tool will automatically insert the date
filters based on the value of the '--since' command line parameter so it
isn't necessary to add those to the query file.

On 9 March 2015 at 16:31, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the
    form was archived or not?
  2. I have never really used the filter functionality before. It seems
    to be a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly skelly@dimagi.com wrote:

Hi

I've just released a new version of the commcare-export tool that
will allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel
query file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it
possible. I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly
synch of form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so
that it doesn't show up in reports, or in my case it drops off of the
result set from commcare-export.

Is there any way to structure my query so that I also get the
archived form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Nate Haduch

Technical Support Analyst
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139
web: http://www.dimagi.com/

10

Hi, Nate,
I want build more than one numeric or text field. I mean, as a table
content in form in one page. Here I share a example below. Is it possible
in commcare ? if possible to build this type of form page please suggest me.

Table of Content.docx (12.8 KB)

··· On Sat, Mar 21, 2015 at 1:44 AM, Nate Haduch wrote:

Hi Sanu,

Please see the following link for resources on fixtures, which are also
known as lookup tables:
Lookup Tables - CommCare Public - CommCare Public

You might find fixtures to be useful in your project for populating select
options or providing features to only a select group of users. Do note that
they require some amount of hand-editing of XML within a form in order to
implement.

Thanks,

Nate

On Thu, Mar 12, 2015 at 10:50 PM, Sanu Ghalan < ghalan100shadhikhola@gmail.com> wrote:

Hi, Simon, can you help me plz, I'm a newly commcare user. Im just trying
to build a form for health survey project. I want to monitor and evaluate
the work of mobile worker/ user. But I could not find the way about
"fixture" option. so tell me about "fixture" option how to use it detail me
plz.

On Mon, Mar 9, 2015 at 8:28 PM, Simon Kelly skelly@dimagi.com wrote:

My pleasure.

On 9 March 2015 at 16:40, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Many thanks! I always appreciate the speedy support I receive from the
CommCare team!

On Mon, Mar 9, 2015 at 10:37 AM, Simon Kelly skelly@dimagi.com wrote:

Hi Caleb

Each form has a field 'archived' which will be true if the form has
been archived. The commcare-export tool is built on top of the CommCare
API's which are documented here:

You can use any of the input parameters as filters in the export tool
but you should note the export tool will automatically insert the date
filters based on the value of the '--since' command line parameter so it
isn't necessary to add those to the query file.

On 9 March 2015 at 16:31, Caleb Reinking Caleb.M.Reinking.2@nd.edu wrote:

Thanks Simon! The process that you suggested worked very well!

A few followup questions:

  1. Is there a field that I can put in my query to show whether the
    form was archived or not?
  2. I have never really used the filter functionality before. It seems
    to be a very handy feature. Is there documentation anywhere on all of the
    available filters that can be used when building a query?

Regards,
Caleb

On Mon, Mar 9, 2015 at 9:25 AM, Simon Kelly skelly@dimagi.com wrote:

Hi

I've just released a new version of the commcare-export tool that
will allow you to include archived forms (v0.11.8). You can install it as
follows:

$ pip install -U commcare-export

To include archived forms you need to add a filter to your Excel
query file as follows:

  • Filter Name: include_archived
  • Filter Value: true

Best regards
Simon

On 6 March 2015 at 12:40, Simon Kelly skelly@dimagi.com wrote:

Hi

This isn't possible at present but we'll look into making it
possible. I'll get back to you when I have more details.

On 5 March 2015 at 19:41, creinkin@nd.edu wrote:

I am trying to use the commcare-export utility to do a nightly
synch of form/case data from the commcareHQ servers to a local server.

I recently came across the feature to archive a form submission so
that it doesn't show up in reports, or in my case it drops off of the
result set from commcare-export.

Is there any way to structure my query so that I also get the
archived form submissions?

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Simon Kelly
Senior Engineer | Dimagi South Africa

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

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

--
Nate Haduch

Technical Support Analyst
Dimagi, Inc | 585 Massachusetts Ave | Suite 3 | Cambridge, MA 02139
web: http://www.dimagi.com/

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