Automating ODK Briefcase Push/Pull from Appengine to SQL

Hello Guys,

I've read every post on this group that mentions Briefcase but didn't
get the answer I was looking for so hopefully you can help. Initially
we setup to use ODK with Appengine. We are testing a new reporting
system based on SQL so I setup an AWS server with MySQL. I currently
(manually) pull data off the Appengine host and push to the AWS host
using briefcase (and being in Africa this also gives us a local backup
incase we lose internet which happens more than we like).

My question is can I automate the push/pull using command line (batch
file) or similar. I think https://code.google.com/p/opendatakit/wiki/BriefcaseAggregateAPI
is what most people would use but I am not a web dev and have no idea
how to implement this (and I expect that I would be recoding briefcase
in web form).

Thanks for any help in advance.

M.P

As far as I know, there's no way to automate this with the existing
Briefcase. However, the source code is available, so you can customize it
according to your own needs.

Best,

Chris

··· On Fri, Jun 7, 2013 at 12:50 PM, Mustafa Pirbhai wrote:

Hello Guys,

I've read every post on this group that mentions Briefcase but didn't
get the answer I was looking for so hopefully you can help. Initially
we setup to use ODK with Appengine. We are testing a new reporting
system based on SQL so I setup an AWS server with MySQL. I currently
(manually) pull data off the Appengine host and push to the AWS host
using briefcase (and being in Africa this also gives us a local backup
incase we lose internet which happens more than we like).

My question is can I automate the push/pull using command line (batch
file) or similar. I think
https://code.google.com/p/opendatakit/wiki/BriefcaseAggregateAPI
is what most people would use but I am not a web dev and have no idea
how to implement this (and I expect that I would be recoding briefcase
in web form).

Thanks for any help in advance.

M.P

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

Couldn't you use AWS as the primary data collection tool with updates sent to local dbs when internet connections are available?

Correct, we don't have a code in ODK Briefcase to process the command line
arguments and do something other than present a GUI.

If someone writes a command-line interface, we'd be happy to fold it into
the mainline. This would likely be a different class implementing
'main(..)' that calls into the action classes -- ODK Briefcase already has
3 different classes that implement main(...), so one more is not a
problem. The 'command line' version of ODK Briefcase would be an
executable jar that invokes that new main(...).

Mitch

··· On Fri, Jun 7, 2013 at 4:30 AM, Christopher Robert wrote:

As far as I know, there's no way to automate this with the existing
Briefcase. However, the source code is available, so you can customize it
according to your own needs.

Best,

Chris

On Fri, Jun 7, 2013 at 12:50 PM, Mustafa Pirbhai info@tgharusha.comwrote:

Hello Guys,

I've read every post on this group that mentions Briefcase but didn't
get the answer I was looking for so hopefully you can help. Initially
we setup to use ODK with Appengine. We are testing a new reporting
system based on SQL so I setup an AWS server with MySQL. I currently
(manually) pull data off the Appengine host and push to the AWS host
using briefcase (and being in Africa this also gives us a local backup
incase we lose internet which happens more than we like).

My question is can I automate the push/pull using command line (batch
file) or similar. I think
https://code.google.com/p/opendatakit/wiki/BriefcaseAggregateAPI
is what most people would use but I am not a web dev and have no idea
how to implement this (and I expect that I would be recoding briefcase
in web form).

Thanks for any help in advance.

M.P

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

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

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

We can't do that as it will require a major recall of user devices to
change the settings.

How hard would it be to write a new main()? Something a experienced
dev can cobble together in a few hours or a major project in and off
itself?

M.P

Hi Mustafa,

My guess is that an experienced Java developer could pull something
together in 4-8 hours of work. You might try hiring somebody at oDesk.com,
if you can't find anybody in the existing ODK community.

Best,

Chris

··· On Wed, Jun 12, 2013 at 9:46 AM, Mustafa Pirbhai wrote:

We can't do that as it will require a major recall of user devices to
change the settings.

How hard would it be to write a new main()? Something a experienced
dev can cobble together in a few hours or a major project in and off
itself?

M.P

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

Mustafa
You can look at the org.opendatakit.briefcase.ui.MainFoemUploderWindow
class.
This is what responsible for uploading the forms.
You can write a similar class and create batch files(.cmd files) to call
this class.

Thanks
Deepak

··· On Wed, Jun 12, 2013 at 1:18 PM, Christopher Robert wrote:

Hi Mustafa,

My guess is that an experienced Java developer could pull something
together in 4-8 hours of work. You might try hiring somebody at oDesk.com,
if you can't find anybody in the existing ODK community.

Best,

Chris

On Wed, Jun 12, 2013 at 9:46 AM, Mustafa Pirbhai info@tgharusha.comwrote:

We can't do that as it will require a major recall of user devices to
change the settings.

How hard would it be to write a new main()? Something a experienced
dev can cobble together in a few hours or a major project in and off
itself?

M.P

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

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

--
Deepak Sharma
http://www.linkedin.com/in/rikindia

oDesk it is. I actually had the bright idea of automating it using
something like autohotkey but apparently there is no linux equivalent.
Thanks for the help guys.