Settings sheets

Hello
I have a form which when I upload minus the settings sheet works find and I
can submit the data
I followed https://opendatakit.org/help/encrypted-forms/ on how to encrypt
the form and got the attached public key
However whenever insert the key into excel (form also attached) it
automatically goes into separate cells, plus after that when I try
submitting the filled in form it brings error: invalid status code on head
request. if you have a web proxy, you may need to login to your netwrk,
when i remove the settings sheet everything works out well.
I need the form to be secure
Thanx

Birth_Defects_Surveillancefinal.xls (92.5 KB)

mypublickey.pem (451 Bytes)

Sorry, it appears the directions were a bit unclear. I've clarified them
and relabelled them as step 6 in the process:

6. Updating the public_key field in the XLSForm settings worksheet.
Open the MyPublicKey.pem file in Notepad (Windows) or TextEdit (Mac).
Remove the leading and trailing '---...' lines. Then remove all new-lines
(carriage-returns) from the file. Select the resulting very-long string,
and paste it into the public_key field in the XLSForm settings worksheet.
This very-long string will become the base64RsaPublicKey attribute in the
resulting encrypted form definition. Note that you obviously need to be
especially careful that this is ONLY the public key, and not the contents
of the original public-private key file (which would also appear to work
but provide no security).

··· On Tue, Apr 21, 2015 at 12:02 AM, Ayoub Kakande wrote:

Hello
I have a form which when I upload minus the settings sheet works find and
I can submit the data
I followed https://opendatakit.org/help/encrypted-forms/ on how to
encrypt the form and got the attached public key
However whenever insert the key into excel (form also attached) it
automatically goes into separate cells, plus after that when I try
submitting the filled in form it brings error: invalid status code on head
request. if you have a web proxy, you may need to login to your netwrk,
when i remove the settings sheet everything works out well.
I need the form to be secure
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

Dear Mitch,
Apologies for replying on this string.

Please i also experince the same error messege when i enter the submission url in the settings of the xlsform.

How best do we set the submission url in the settings of xlsform to work?

Thanks.

Collins

··· -----Original Message----- From: "Mitch Sundt" Sent: ‎4/‎21/‎2015 7:53 PM To: "ODK Community" Subject: Re: [ODK Community] Settings sheets

Sorry, it appears the directions were a bit unclear. I've clarified them and relabelled them as step 6 in the process:

  1. Updating the public_key field in the XLSForm settings worksheet.
    Open the MyPublicKey.pem file in Notepad (Windows) or TextEdit (Mac). Remove the leading and trailing '---...' lines. Then remove all new-lines (carriage-returns) from the file. Select the resulting very-long string, and paste it into the public_key field in the XLSForm settings worksheet. This very-long string will become the base64RsaPublicKey attribute in the resulting encrypted form definition. Note that you obviously need to be especially careful that this is ONLY the public key, and not the contents of the original public-private key file (which would also appear to work but provide no security).

On Tue, Apr 21, 2015 at 12:02 AM, Ayoub Kakande akakande@gmail.com wrote:

Hello
I have a form which when I upload minus the settings sheet works find and I can submit the data
I followed https://opendatakit.org/help/encrypted-forms/ on how to encrypt the form and got the attached public key
However whenever insert the key into excel (form also attached) it automatically goes into separate cells, plus after that when I try submitting the filled in form it brings error: invalid status code on head request. if you have a web proxy, you may need to login to your netwrk, when i remove the settings sheet everything works out well.
I need the form to be secure
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

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

because there can be different server types with different submission URL
constructions, you must specify the full URL for the submissions in the
submission_url field on the settings sheet.

This generally means replacing the "Aggregate.html" of your server with
"submission"

I.e., if you server is

https://opendatakit.appspot.com/Aggregate.html

Then you would enter:

https://opendatakit.appspot.com/submission

in the "submission_url" column of the XLS file.

··· On Sun, Apr 26, 2015 at 11:19 PM, Collins Adoyo wrote:

Dear Mitch,
Apologies for replying on this string.

Please i also experince the same error messege when i enter the submission
url in the settings of the xlsform.

How best do we set the submission url in the settings of xlsform to work?

Thanks.

Collins

From: Mitch Sundt mitchellsundt@gmail.com
Sent: ‎4/‎21/‎2015 7:53 PM
To: ODK Community opendatakit@googlegroups.com
Subject: Re: [ODK Community] Settings sheets

Sorry, it appears the directions were a bit unclear. I've clarified them
and relabelled them as step 6 in the process:

6. Updating the public_key field in the XLSForm settings worksheet.
Open the MyPublicKey.pem file in Notepad (Windows) or TextEdit (Mac).
Remove the leading and trailing '---...' lines. Then remove all new-lines
(carriage-returns) from the file. Select the resulting very-long string,
and paste it into the public_key field in the XLSForm settings
worksheet. This very-long string will become the base64RsaPublicKey
attribute in the resulting encrypted form definition. Note that you
obviously need to be especially careful that this is ONLY the public key,
and not the contents of the original public-private key file (which would
also appear to work but provide no security).

On Tue, Apr 21, 2015 at 12:02 AM, Ayoub Kakande akakande@gmail.com wrote:

Hello
I have a form which when I upload minus the settings sheet works find and
I can submit the data
I followed https://opendatakit.org/help/encrypted-forms/ on how to
encrypt the form and got the attached public key
However whenever insert the key into excel (form also attached) it
automatically goes into separate cells, plus after that when I try
submitting the filled in form it brings error: invalid status code on head
request. if you have a web proxy, you may need to login to your netwrk,
when i remove the settings sheet everything works out well.
I need the form to be secure
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

--

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