Field encryption

Hi guys,

Does the ODK encryption do field encryption or form encryption?

And where exactly does the encrypted form go in the database?

Trying to understand the database structure for the encrypted forms,
database created by Aggregate

Hey Thabo,

As far as I know, it does form encryption, that's why you have the column
public key in the settings tab of you xls form(not for particular fieldsin the form) or the <submission action= "
*your url" *base64RsaPublicKey=" *your public key"/> * tag in your xml/
xform definition.

When submitting the form given that it is encrypted, you cant really export
and view the data without the private key thus the use of odk briefcase to
pull the encrypted form from your submission url.
This is what I think.
don't know whether I have answered your question.

Thanks.
Regards
Ezra

··· On Thursday, May 16, 2013 9:13:05 AM UTC+3, Coulson Thabo Kgathi wrote: > > Hi guys, > > Does the ODK encryption do field encryption or form encryption? > > And where exactly does the encrypted form go in the database? > > Trying to understand the database structure for the encrypted forms, > database created by Aggregate >

Thanks Ezra

the reason why i am asking this i wanted to automate form decryption and
use the decrypted data in someway.

i have been trying to figure a way to pass parameters on a script to the
source code of the ODK Briefcase which i am not successful yet. because
having to decrypt all the forms time and again is a bit of a pain

Hi Coulson,

In the SurveyCTO version of Briefcase (we call it the "client"), we have
streamlined the download-decrypt-export process significantly, but it still
requires you to (a) enter your password, and (b) press two GO! buttons,
each time you want to process new data. We have had a request to add
command-line support so that you can pass the password on the command-line
and have everything happen without user intervention, but we haven't gotten
to it yet.

You can definitely make it happen with a custom version of Briefcase, but
you'll need to re-work the code a bit to automate it all. Certainly that
would be easier than building your own download-and-decrypt solution, since
Briefcase has all of the logic that you want... you just need to rework the
flow a bit.

Good luck,

Chris

··· On Thu, May 16, 2013 at 9:53 AM, Coulson Thabo Kgathi wrote:

Thanks Ezra

the reason why i am asking this i wanted to automate form decryption and
use the decrypted data in someway.

i have been trying to figure a way to pass parameters on a script to the
source code of the ODK Briefcase which i am not successful yet. because
having to decrypt all the forms time and again is a bit of a pain

--
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.

Sorry Thabo, I see what your are asking, I for one though have not heard of
any instance of automated decryption.
Probably someone out there has, we'll wait and see.

The best of Luck.
Regards
Ezra

··· On Thu, May 16, 2013 at 10:53 AM, Coulson Thabo Kgathi wrote:

Thanks Ezra

the reason why i am asking this i wanted to automate form decryption and
use the decrypted data in someway.

i have been trying to figure a way to pass parameters on a script to the
source code of the ODK Briefcase which i am not successful yet. because
having to decrypt all the forms time and again is a bit of a pain

--
You received this message because you are subscribed to a topic in the
Google Groups "ODK Developers" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit-developers/uy9DqxbmVCA/unsubscribe?hl=en
.
To unsubscribe from this group and all its topics, send an email to
opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.