# Commcare-export of archived forms

**URL:** <https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099>\
**Category:** Users\
**Created:** [March 5, 2015, 5:41pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099 "2015-03-05T17:41:51Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Creinkin](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/c/eb9ed0/32.png) [@Creinkin](https://forum.dimagi.com/u/Creinkin)\
**Post date:** [March 5, 2015, 5:41pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/1 "2015-03-05T17:41:51Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Simon\_Kelly](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/simon_kelly/32/494_2.png) [@Simon\_Kelly](https://forum.dimagi.com/u/Simon_Kelly)\
**Post date:** [March 6, 2015, 10:40am UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/2 "2015-03-06T10:40:54Z")

</div>

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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> 
> --  
> Simon Kelly  
> Senior Engineer | Dimagi South Africa

---

<div class="post-metadata">

**Author:** ![Simon\_Kelly](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/simon_kelly/32/494_2.png) [@Simon\_Kelly](https://forum.dimagi.com/u/Simon_Kelly)\
**Post date:** [March 9, 2015, 1:25pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/3 "2015-03-09T13:25:48Z")

</div>

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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > 
> > --  
> > Simon Kelly  
> > Senior Engineer | Dimagi South Africa
> 
> --  
> Simon Kelly  
> Senior Engineer | Dimagi South Africa

---

<div class="post-metadata">

**Author:** ![Caleb\_Reinking](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/c/91b2a8/32.png) [@Caleb\_Reinking](https://forum.dimagi.com/u/Caleb_Reinking)\
**Post date:** [March 9, 2015, 2:31pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/4 "2015-03-09T14:31:48Z")

</div>

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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Simon\_Kelly](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/simon_kelly/32/494_2.png) [@Simon\_Kelly](https://forum.dimagi.com/u/Simon_Kelly)\
**Post date:** [March 9, 2015, 2:37pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/5 "2015-03-09T14:37:15Z")

</div>

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:

- Form API  
[https://help.commcarehq.org/display/commcarepublic/List+Forms](https://help.commcarehq.org/display/commcarepublic/List+Forms)
- Case API  
[https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287](https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287)

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](mailto: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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> 
> --  
> Simon Kelly  
> Senior Engineer | Dimagi South Africa

---

<div class="post-metadata">

**Author:** ![Caleb\_Reinking](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/c/91b2a8/32.png) [@Caleb\_Reinking](https://forum.dimagi.com/u/Caleb_Reinking)\
**Post date:** [March 9, 2015, 2:40pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/6 "2015-03-09T14:40:02Z")

</div>

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:
> > 
> > - Form API  
> > [https://help.commcarehq.org/display/commcarepublic/List+Forms](https://help.commcarehq.org/display/commcarepublic/List+Forms)
> > - Case API  
> > [https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287](https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287)
> > 
> > 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](mailto: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](mailto: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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Simon\_Kelly](https://dimagi.b-cdn.net/user_avatar/forum.dimagi.com/simon_kelly/32/494_2.png) [@Simon\_Kelly](https://forum.dimagi.com/u/Simon_Kelly)\
**Post date:** [March 9, 2015, 2:43pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/7 "2015-03-09T14:43:39Z")

</div>

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](mailto: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:
> > > 
> > > - Form API  
> > > [https://help.commcarehq.org/display/commcarepublic/List+Forms](https://help.commcarehq.org/display/commcarepublic/List+Forms)
> > > - Case API  
> > > [https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287](https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287)
> > > 
> > > 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](mailto: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](mailto: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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> 
> --  
> Simon Kelly  
> Senior Engineer | Dimagi South Africa

---

<div class="post-metadata">

**Author:** ![Sanu\_Ghalan](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/s/a9adbd/32.png) [@Sanu\_Ghalan](https://forum.dimagi.com/u/Sanu_Ghalan)\
**Post date:** [March 13, 2015, 2:50am UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/8 "2015-03-13T02:50:45Z")

</div>

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](mailto: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](mailto: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:
> > > > 
> > > > - Form API  
> > > > [https://help.commcarehq.org/display/commcarepublic/List+Forms](https://help.commcarehq.org/display/commcarepublic/List+Forms)
> > > > - Case API  
> > > > [https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287](https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287)
> > > > 
> > > > 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](mailto: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](mailto: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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Nate](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/n/e95f7d/32.png) [@Nate](https://forum.dimagi.com/u/Nate)\
**Post date:** [March 20, 2015, 7:59pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/9 "2015-03-20T19:59:47Z")

</div>

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](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](mailto:skelly@dimagi.com) wrote:
> > 
> > > My pleasure.
> > > 
> > > On 9 March 2015 at 16:40, Caleb Reinking [Caleb.M.Reinking.2@nd.edu](mailto: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](mailto: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:
> > > > > 
> > > > > - Form API  
> > > > > [https://help.commcarehq.org/display/commcarepublic/List+Forms](https://help.commcarehq.org/display/commcarepublic/List+Forms)
> > > > > - Case API  
> > > > > [https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287](https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287)
> > > > > 
> > > > > 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](mailto: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](mailto: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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](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/](http://www.dimagi.com/)

---

<div class="post-metadata">

**Author:** ![Sanu\_Ghalan](https://dimagi.b-cdn.net/letter_avatar_proxy/v4/letter/s/a9adbd/32.png) [@Sanu\_Ghalan](https://forum.dimagi.com/u/Sanu_Ghalan)\
**Post date:** [April 16, 2015, 1:19pm UTC](https://forum.dimagi.com/t/commcare-export-of-archived-forms/2099/10 "2015-04-16T13:19:35Z")

</div>

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](https://dimagi.b-cdn.net/uploads/default/original/1X/e654e3f3d48e08521539c2730b1009a097ee8421.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](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](mailto: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](mailto:skelly@dimagi.com) wrote:
> > > 
> > > > My pleasure.
> > > > 
> > > > On 9 March 2015 at 16:40, Caleb Reinking [Caleb.M.Reinking.2@nd.edu](mailto: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](mailto: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:
> > > > > > 
> > > > > > - Form API  
> > > > > > [https://help.commcarehq.org/display/commcarepublic/List+Forms](https://help.commcarehq.org/display/commcarepublic/List+Forms)
> > > > > > - Case API  
> > > > > > [https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287](https://confluence.dimagi.com/pages/viewpage.action?pageId=12224287)
> > > > > > 
> > > > > > 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](mailto: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](mailto: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](mailto: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](mailto: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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > > For more options, visit [https://groups.google.com/d/optout](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](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > > For more options, visit [https://groups.google.com/d/optout](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](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/](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](mailto:commcare-users+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
