Decrypt

Support
1

Hello,
I know this might be abit out of scope for this forumbut just incase any
one can help
I used collect to upload an encrypted xml form, users were able to fill
and submit data
am using mysql, when I go to workbench to extract the data I get a
columns with BASE64_ENCRYPTED_KEY word, I have the private key, how can I
dectrypt this data
Thanx

2

You need to use ODK Briefcase. https://opendatakit.org/use/briefcase/

Pull the data into ODK Briefcase.

Then Export the data to CSV. On that Export tab, there will be a place to
specify the private key.

··· On Wed, Jul 15, 2015 at 7:52 AM, Ayoub Kakande wrote:

Hello,
I know this might be abit out of scope for this forumbut just incase any
one can help
I used collect to upload an encrypted xml form, users were able to fill
and submit data
am using mysql, when I go to workbench to extract the data I get a
columns with BASE64_ENCRYPTED_KEY word, I have the private key, how can I
dectrypt this data
Thanx

--

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

3

Thanx so much Mitch, with briefcase I can pull sucessfuly.
My only problem is that I want to sometimes edit the data that has been
submitted and I think I can only do this inside MYSQL, is there any other
way of editing the data already submitted to my server since am
getting BASE64_ENCRYPTED_KEY in the rows in workbench
Thanx

··· On Wednesday, 15 July 2015 17:52:05 UTC+3, Ayoub Kakande wrote: > > Hello, > I know this might be abit out of scope for this forumbut just incase any > one can help > I used collect to upload an encrypted *xml f*orm, users were able to fill > and submit data > am using mysql, when I go to workbench to extract the data I get a > columns with BASE64_ENCRYPTED_KEY word, I have the private key, how can I > dectrypt this data > Thanx >
4

No. When forms are encrypted, the XML file that would have been submitted
to ODK Aggregate is encrypted all at once; there is no access to individual
fields of the encrypted form.

And, in general, the ODK 1.x tools do not support editing of finalized
forms. Other ODK-compatible servers may offer this, but ODK Aggregate does
not.

··· On Thu, Jul 16, 2015 at 4:58 AM, Ayoub Kakande wrote:

Thanx so much Mitch, with briefcase I can pull sucessfuly.
My only problem is that I want to sometimes edit the data that has been
submitted and I think I can only do this inside MYSQL, is there any other
way of editing the data already submitted to my server since am
getting BASE64_ENCRYPTED_KEY in the rows in workbench
Thanx

On Wednesday, 15 July 2015 17:52:05 UTC+3, Ayoub Kakande wrote:

Hello,
I know this might be abit out of scope for this forumbut just incase any
one can help
I used collect to upload an encrypted xml form, users were able to
fill and submit data
am using mysql, when I go to workbench to extract the data I get a
columns with BASE64_ENCRYPTED_KEY word, I have the private key, how can I
dectrypt this data
Thanx

--

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