Filtering/Browsing submissionList htmlServlet Results

I've been working on a tool to download submissions using the
submissionList htmlServlet. When the submission list grows very large,
I'd like to filter these values on the submission date
("_LAST_UPDATE_DATE").

I tried to build a fake cursor that would start midway through the
results, but this doesn't seem to work.

I also tried to use the returned cursor in the results xml, but this
also doesn't appear to work.

Is it possible to build a cursor/queryResumePoint that can filter
these values?

I'm using ODK Aggregate 1.0 RC3 Tomcat, MySQL.

I think you're not properly UrlEncoding the cursor XML document.

Upgrade to RC4. I relaxed the cursor processing so that you can specify a
cursor without a URI (just a last update date).

Also, look at the Briefcase application, since it does exactly what you're
trying to do. It does not yet track what files it has already downloaded
(so it does not yet support incremental downloads or restarts).

Mitch

··· On Wed, Oct 26, 2011 at 11:45 AM, jpknoll wrote:

I've been working on a tool to download submissions using the
submissionList htmlServlet. When the submission list grows very large,
I'd like to filter these values on the submission date
("_LAST_UPDATE_DATE").

I tried to build a fake cursor that would start midway through the
results, but this doesn't seem to work.

I also tried to use the returned cursor in the results xml, but this
also doesn't appear to work.

Is it possible to build a cursor/queryResumePoint that can filter
these values?

I'm using ODK Aggregate 1.0 RC3 Tomcat, MySQL.

--
Mitch Sundt
Software Engineer


University of Washington
mitchellsundt@gmail.com

Got it working. I was UrlEncoding my cursor, but my framework would re-
encode the parameter string when I passed it to the URI constructor.

I'm writing the tool as a .net library. The client requires post
processing of the data, and most of our tools are also in .net c#.

··· On Oct 28, 5:35 pm, Mitch Sundt wrote: > I think you're not properly UrlEncoding the cursor XML document. > > Upgrade to RC4. I relaxed the cursor processing so that you can specify a > cursor without a URI (just a last update date). > > Also, look at the Briefcase application, since it does exactly what you're > trying to do. It does not yet track what files it has already downloaded > (so it does not yet support incremental downloads or restarts). > > Mitch > > > > > > > > > > On Wed, Oct 26, 2011 at 11:45 AM, jpknoll wrote: > > I've been working on a tool to download submissions using the > > submissionList htmlServlet. When the submission list grows very large, > > I'd like to filter these values on the submission date > > ("_LAST_UPDATE_DATE"). > > > I tried to build a fake cursor that would start midway through the > > results, but this doesn't seem to work. > > > I also tried to use the returned cursor in the results xml, but this > > also doesn't appear to work. > > > Is it possible to build a cursor/queryResumePoint that can filter > > these values? > > > I'm using ODK Aggregate 1.0 RC3 Tomcat, MySQL. > > -- > Mitch Sundt > Software Engineerhttp://www.OpenDataKit.org > University of Washington > mitchellsu...@gmail.com