Help with lookup tables

Hi Sanu

There is documentation on Lookup Tables on the help site here:
https://help.commcarehq.org/display/commcarepublic/Lookup+Tables

Note that its only available to project on the Standard Plan or higher.

I’m not sure how Lookup Tables will help you with your need to monitor and
evaluate the work of mobile users though. Can you not get the information
that you need from the worker monitoring reports?

··· On 13 March 2015 at 04:50, Sanu Ghalan 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.


Simon Kelly
Senior Engineer | Dimagi South Africa