Date and Time Filters in ODK Briefcase and Aggregate

Support
1

There is no way to filter what is downloaded to ODK Briefcase -- it grabs
everything.
Nor is there a way to filter what gets exported from ODK Briefcase.

W.r.t. date and time filters in ODK Aggregate. It recognizes a number of
different date formats:

*These formats assume UTC (GMT) times:

··· * 2012-04-23 2012-04-23T23:02:33.000

and the more US-centric:

Mon Apr 23 23:02:33 2012
04/23/2012 23:02:33.000

*These formats allow you to specify a timezone:
*
2012-04-23T23:02:33.000PDT
2012-04-23PDT

and the more US-centric:

Mon, 23 Apr 2012 23:02:33 PDT
Monday, 23-Apr-2012 23:02:33 PDT
Mon Apr 23 23:02:33 PDT 2012

Filters with timezones are converted to UTC (GMT) and compared against the
values stored in Aggregate, which are always stored as UTC (GMT).

Time values can be entered using these formats:

23:02:33.000
23:02:33.000PDT

I haven't tried filtering on time (it would be for a time field type), so I
am uncertain exactly how that would work.

Mitch

On Wed, Aug 8, 2012 at 2:43 PM, dlee@mgeo.ca wrote:

Hi,

Is there any way to filter what gets downloaded into ODK Briefcase or
filter what is exported out of Briefcase?

Also, I have been trying in Aggregate to filter my records based on the
collect date. Every time I try to "Apply Filter" it looks like the page
refreshes and my filter is not applied. I'm able to filter based on other
columns successfully. Perhaps the date format I am using is wrong (ex:
12-Jul-2012)?

Any help would be greatly appreciated.

Thanks,
Dana

--
Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

2

Hi guys,

do we have any update on filtering within aggregate? Thanks.

··· On Thursday, August 9, 2012 at 7:31:45 AM UTC+8, Mitch Sundt wrote: > There is no way to filter what is downloaded to ODK Briefcase -- it grabs everything. > Nor is there a way to filter what gets exported from ODK Briefcase. > > W.r.t. date and time filters in ODK Aggregate. It recognizes a number of different date formats: > > > These formats assume UTC (GMT) times: > > > > > > > 2012-04-23 > > 2012-04-23T23:02:33.000 > > and the more US-centric: > > > > > Mon Apr 23 23:02:33 2012 > > > > 04/23/2012 23:02:33.000 > > These formats allow you to specify a timezone: > > 2012-04-23T23:02:33.000PDT > > 2012-04-23PDT > > > and the more US-centric: > > Mon, 23 Apr 2012 23:02:33 PDT > > Monday, 23-Apr-2012 23:02:33 PDT > > Mon Apr 23 23:02:33 PDT 2012 > > > Filters with timezones are converted to UTC (GMT) and compared against the > values stored in Aggregate, which are always stored as UTC (GMT). > > > ---------------------- > Time values can be entered using these formats: > > 23:02:33.000 > > 23:02:33.000PDT > > I haven't tried filtering on time (it would be for a time field type), so I am uncertain exactly how that would work. > > Mitch > > On Wed, Aug 8, 2012 at 2:43 PM, wrote: > > > Hi, > > > > Is there any way to filter what gets downloaded into ODK Briefcase or filter what is exported out of Briefcase? > > > > Also, I have been trying in Aggregate to filter my records based on the collect date. Every time I try to "Apply Filter" it looks like the page refreshes and my filter is not applied. I'm able to filter based on other columns successfully. Perhaps the date format I am using is wrong (ex: 12-Jul-2012)? > > > > > Any help would be greatly appreciated. > > > > Thanks, > > Dana > > > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com
3

Yes, you can filter what gets exported to CSV if you use the Briefcase
CLI. https://opendatakit.org/use/briefcase/

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Wed, Feb 3, 2016 at 6:59 AM, rivera.raffy@gmail.com wrote:

Hi guys,

do we have any update on filtering within aggregate? Thanks.

On Thursday, August 9, 2012 at 7:31:45 AM UTC+8, Mitch Sundt wrote:

There is no way to filter what is downloaded to ODK Briefcase -- it grabs everything.
Nor is there a way to filter what gets exported from ODK Briefcase.

W.r.t. date and time filters in ODK Aggregate. It recognizes a number of different date formats:

These formats assume UTC (GMT) times:

2012-04-23

2012-04-23T23:02:33.000

and the more US-centric:

Mon Apr 23 23:02:33 2012

04/23/2012 23:02:33.000

These formats allow you to specify a timezone:

2012-04-23T23:02:33.000PDT

2012-04-23PDT

and the more US-centric:

Mon, 23 Apr 2012 23:02:33 PDT

Monday, 23-Apr-2012 23:02:33 PDT

Mon Apr 23 23:02:33 PDT 2012

Filters with timezones are converted to UTC (GMT) and compared against the
values stored in Aggregate, which are always stored as UTC (GMT).

Time values can be entered using these formats:

23:02:33.000

23:02:33.000PDT

I haven't tried filtering on time (it would be for a time field type), so I am uncertain exactly how that would work.

Mitch

On Wed, Aug 8, 2012 at 2:43 PM, dl...@mgeo.ca wrote:

Hi,

Is there any way to filter what gets downloaded into ODK Briefcase or filter what is exported out of Briefcase?

Also, I have been trying in Aggregate to filter my records based on the collect date. Every time I try to "Apply Filter" it looks like the page refreshes and my filter is not applied. I'm able to filter based on other columns successfully. Perhaps the date format I am using is wrong (ex: 12-Jul-2012)?

Any help would be greatly appreciated.

Thanks,

Dana

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

4

The filters will once again work when the next ODK Aggregate gets released.
Probably not until I am back from a vacation -- toward the end of March.

··· On Wed, Feb 10, 2016 at 5:25 AM, Yaw Anokwa wrote:

Yes, you can filter what gets exported to CSV if you use the Briefcase
CLI. https://opendatakit.org/use/briefcase/

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Wed, Feb 3, 2016 at 6:59 AM, rivera.raffy@gmail.com wrote:

Hi guys,

do we have any update on filtering within aggregate? Thanks.

On Thursday, August 9, 2012 at 7:31:45 AM UTC+8, Mitch Sundt wrote:

There is no way to filter what is downloaded to ODK Briefcase -- it
grabs everything.
Nor is there a way to filter what gets exported from ODK Briefcase.

W.r.t. date and time filters in ODK Aggregate. It recognizes a number
of different date formats:

These formats assume UTC (GMT) times:

2012-04-23

2012-04-23T23:02:33.000

and the more US-centric:

Mon Apr 23 23:02:33 2012

04/23/2012 23:02:33.000

These formats allow you to specify a timezone:

2012-04-23T23:02:33.000PDT

2012-04-23PDT

and the more US-centric:

Mon, 23 Apr 2012 23:02:33 PDT

Monday, 23-Apr-2012 23:02:33 PDT

Mon Apr 23 23:02:33 PDT 2012

Filters with timezones are converted to UTC (GMT) and compared against
the
values stored in Aggregate, which are always stored as UTC (GMT).

Time values can be entered using these formats:

23:02:33.000

23:02:33.000PDT

I haven't tried filtering on time (it would be for a time field type),
so I am uncertain exactly how that would work.

Mitch

On Wed, Aug 8, 2012 at 2:43 PM, dl...@mgeo.ca wrote:

Hi,

Is there any way to filter what gets downloaded into ODK Briefcase or
filter what is exported out of Briefcase?

Also, I have been trying in Aggregate to filter my records based on the
collect date. Every time I try to "Apply Filter" it looks like the page
refreshes and my filter is not applied. I'm able to filter based on other
columns successfully. Perhaps the date format I am using is wrong (ex:
12-Jul-2012)?

Any help would be greatly appreciated.

Thanks,

Dana

--

Post: opend...@googlegroups.com

Unsubscribe: opendatakit...@googlegroups.com

Options: http://groups.google.com/group/opendatakit?hl=en

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

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

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

5

Hey @yanokwa,

I have looked through the Briefcase documentation on CLI but I don't seem to find how to apply a filter to the pull process. Please help.

6

Thanks for reading the docs! You can't filter on the pull, you can only filter on export.