Urgently need to decrypt previously encrypted submissions

  • Profile Image
    woodlandstransport
    Asked on December 02, 2020 at 12:52 AM

    Hi,

    https://www.jotform.com/woodlandstransport/ifs-holiday-camp

    I was testing out encrypted forms to secure my data but found that it was difficult to get my non-tech savvy staff to upload the jotform.key when viewing submissions, hence I switched it off.

    I did not realize that the previous submissions REMAIN encrypted and now I have no idea how to retrieve them. I cannot get my submitters to resubmit as I run a school bussing business and they already made payments at the end of the form.

    I have the downloaded jotform encryption key and I can send it to you. I do not know how to use it to decrypt the information.


    Please assist me urgently as I need the information within this 2 days to process service for the customers.

  • Profile Image
    Patrick_R
    Answered on December 02, 2020 at 02:06 AM

    Hi! Allow me to run some tests. I'll get back to you soon with an update.

    Thank you!

  • Profile Image
    woodlandstransport
    Answered on December 02, 2020 at 02:13 AM

    Hi, apparently I switched on encryption and I reuploaded the jotform.key that I originally downloaded and most of my data is now decrypted, however there are a significant amount of data that remains encrypted (like in the midst of many other submissions), could this be an error in the encryption process?

    Like the encryption key could decrypt the Submission "A" and Submission "C", but did not decrypt Submission "B" which happened between A and C.

  • Profile Image
    Patrick_R
    Answered on December 02, 2020 at 02:32 AM

    Hi! Yes, re-enabling the encryption indeed should solve the problem. But you need to click "I will use my existing keys" (as shown in the following screnshot).

    1606894335_5fc742ff19280_chrome-capture

    The encryption keys are also stored in browser's offline data. So, selecting this option, will pick the right key from the browser and show the data.

    - however there are a significant amount of data that remains encrypted (like in the midst of many other submissions), could this be an error in the encryption process?

    If a particular key was used to encrypt that data then it should be able to decrypt as well.

    Q) Did you switched on/off encryption multiple times on this form and created multiple keys in this process?

    If yes, then please note that only one key can be uploaded at a time. The key that you'll upload will decrypt only that data which was encrypted using this uploaded key. The other entries will remain encrypted.

    You can upload keys one-by-one to decrypt corresponding data and keep on downloading it in Excel format and later arrange all submissions data in one Excel file.

    If you're certain that you only used one encryption key and that you have the correct key with you, then you can re-upload the key and it might help.

    I'll strongly suggest you to download your data first in Excel or CSV format before trying different keys.

    I hope this helps. For further questions, fell free to reply back to this email.

    Thank you!