- illinoisvmAsked on July 25, 2015 at 01:07 AM
When I download my encrypted forms, the data within the form stays encrypted. How do I get the data to export as data and not encrypted data.
- SammyAnswered on July 25, 2015 at 05:08 AM
You will need to upload the private key you had downloaded earlier when enabling form encryption, you are usually prompted to upload this private key when you access you encrypted forms.
If you had not been prompted kindly clear your browser cache then login again and try to access the encrypted submissions
Please refer to this guide for pointers on how to do this
- illinoisvmAnswered on July 26, 2015 at 08:43 PM
I can view the data unencrypted on JotForm, but when I export as PDF or XLS, I get encrypted data, and there is no way for me to import my key to either Adobe or OpenOffice.
- SammyAnswered on July 27, 2015 at 02:09 AM
Unfortunately the key only works in the jotform environment and cant be used ion adobe or open office.
I have cleared your forms cache on our end, kindly try login in to your account and export the data again.
- illinoisvmAnswered on August 02, 2015 at 12:55 AM
Data is still encrypted. I also am experiencing another issue where I am not getting notifications when forms are filled out.
- SammyAnswered on August 02, 2015 at 02:03 AM
Were you given the option to upload the key when you were viewing the form submissions? you should receive a prompt to upload you key file. Kindly try again and let us know of the outcome
Regarding the emails we were experiencing an issue with our mailing provider (Amazon SES), this has been resolved, kindly try submitting a test submissions
- illinoisvmAnswered on August 05, 2015 at 09:38 PM
I have my key, and pointed JotForm to its location when asked, but all data is still encrypted upon download.
Email is working now.
- JotForm SupportEltonCrisAnswered on August 06, 2015 at 12:08 AM
Thanks for reply.
I have raised this thread to our developers so they can provide insights about this. This could be a bug or maybe intentional since encrypted data are only viewable within Jotform boundary. Anyways, you will receive updates via this thread once they're available.
- illinoisvmAnswered on September 23, 2015 at 10:25 PM
Any movement on this?
- alp_denizAnswered on September 24, 2015 at 12:15 AM
Apologies for my colleagues' incorrect explanation of the situation here.
Encrypted forms cannot be exported as PDF, Excel or CSV, since it is mathematically impossible for neither our software nor us to decrypt the submissions without the private key. To correct further, your key is never uploaded anywhere, it is only loaded into your browser for client-side decryption.
However, I see that this feature is very much required so I will add this as a feature request. It might be possible to provide a solution to it via either a HTML/Grid report or a post-processed CSV file.
- illinoisvmAnswered on October 22, 2015 at 10:01 PM
Excellent. It would ease our process of keeping track of members while maintaining the peace of mind that their information is secure.
- TSMDaveAnswered on October 30, 2015 at 11:34 AM
alp_deniz - this is something that would be supremely useful for us. I've had several thousand form submissions before I realized that it was setup to view only one-at-a-time, and it's becoming a major problem.
That being said, it looks like the JSEncryptExports.js script could be extended to parse out a CSV of the decrypted contents locally, just like it does on the screen. Is there any way that could be worked into the mix? I've really got to find another way around this. Thanks!
- ULHSAnswered on March 04, 2016 at 09:13 AM
Did this get fixed? We need this urgently.
- JotForm UI DevelopermertAnswered on March 04, 2016 at 09:59 AM
Unfortunately, there is no update for this one. When there is an update about this issue, you will be informed from this thread through email. Currently, I renewed the ticket, so our developer will come with the answers.
Thank you for your understanding.
- pattissimonAnswered on March 09, 2016 at 11:42 AM
I also need this same solution. Hope to see something soon.
- pattissimonAnswered on March 16, 2016 at 12:01 AM
- JotForm SupportChriistianAnswered on March 16, 2016 at 02:10 AM
There is currently no update for this request. Rest assured we will let you know from this thread if there are any news from our developer.
- owazestrAnswered on June 01, 2016 at 12:33 PM
I am looking for this export of encrypted data feature also, I am replying here to hopefully be subscribed to this forum thread.
- JotForm SupportKiranAnswered on June 01, 2016 at 12:52 PM
With your response on this thread, you are also subscribed to the thread. You should be also receiving an email with any update we have in this regard.
- swalker286Answered on June 06, 2016 at 03:47 PM
Need this also...
- JotForm SupportKiranAnswered on June 06, 2016 at 04:52 PM
Thank you for upvoting the feature request. You'll be posted on the thread once we have any update in this regard.
- edw266Answered on July 01, 2016 at 10:22 PM
- JotForm SupportEltonCrisAnswered on July 01, 2016 at 11:52 PM
As mentioned by our developer, this isn't possible for implementation. However, there may be ways to retrieve decrypted data through table or grid reports. This isn't yet implemented so I have opened a separate feature request for your thread here https://www.jotform.com/answers/874437. We will update you on that thread once this is implemented.
- bashprosAnswered on October 24, 2016 at 08:21 PM
Upon looking at your method for downloading Excel/CSV/PDF, it looks like your PHP code is generating the files. I would recommend moving that to a client-side using a plugin such as the following:
There are plugins for CSV/PDF that do just the same.
Without doing this, you are making encryption difficult, borderline impossible for anyone who doesn't have the expertise to do it manually.
- didst2Answered on October 30, 2016 at 02:12 PM
- JotForm SupportJanAnswered on October 30, 2016 at 04:06 PM
I created a separate thread for your issue. Please refer to this URL: https://www.jotform.com/answers/975813
- JohnAnswered on November 07, 2016 at 11:05 AM
Mathematically impossible? You talk as if creating CSV files browser-side is not possible. It is.
- JotForm SupportKiranAnswered on November 07, 2016 at 12:16 PM
I think he is referring to the possibility of decrypting the encrypted submissions to export. Since the private key is not stored anywhere in the server and it is provided only to you as a download option when the encryption is turned on.
Your response has been received by @alp_deniz and you'll be receiving an update if there is any other information in this regard.
- GearBuildersAnswered on June 13, 2017 at 11:29 AM
For what it's worth, while I don't know about Excel downloads, the form data does remain unencrypted when "printed" from the Inbox to a PDF or similar via the Print button in the form's Inbox. This is a 1-by-1 process, so probably too slow for a large database like yours, @TSMDave, it is at least a workaround in the meantime.