CasewareDocs

Decrypting CSV files

To switch to CSV mode, select the CSV Files option at the top left of the Data Privacy dialog.

The Decryption tab for CSV files lets you do the following:

Select files and fields

  1. Select a previously pseudonymized file from the File drop-down list.
  2. From the Field drop-down list, select the field or fields you want to apply decryption to.

You can repeat this for multiple files.

Note:

  • Make sure that you select only files and fields to which you have previously applied pseudonymization.
  • If you remove the last field from a file, the entire file setup will be removed.

Apply decryption

From the Data privacy method drop-down list, you can apply only the Decrypt method. Note that only pseudonymized data can be decrypted. All other methods are irreversible.

Specify an output file name

Accept or overwrite the suggested name in the Output CSV file name field. Each output file must have a unique name. The app auto-generates names with a DPD (Data Privacy Decrypted) suffix. You can edit the name unless you've selected the Replace the existing CSV file option at the bottom of the dialog.

Enter the previously specified password

If you chose pseudonymization as your privacy method, you had to provide a password for each pseudonymization process. This password was used to encrypt the data, and in order to decrypt them you need to enter the password here or paste it from the clipboard using the Paste the password Clicking this icon pastes the password from the clipboard. icon.

Note:
Ensure that you use the exact password that you specified for the data you want to decrypt.

Output options

  • Save as new CSV file (default): Creates new files with the decrypted data.
  • Replace the existing CSV file: Overwrites the original files.
  • Speed boost: Is enabled by default for CSV files, offering much faster processing.
  • Ultra security: Makes processing extra secure.

Preview the decrypted data

The Preview button lets you verify that you're using the correct password for the correct dataset before running the full decryption.

Since decryption only works when the exact same password is used that was originally specified during encryption, a different password will result in the data not being decrypted.

The preview shows the first five values so you can confirm that the password matches the dataset. If the previewed values look correctly decrypted, you can safely proceed. If the results seem wrong, it's likely due to a mistyped password or using a password meant for a different dataset. In that case you should correct the input before continuing.

Start the process

Once everything is set, click Process to decrypt the full dataset. The app will begin decryption and show a progress dialog.

You can cancel the process at any time:

  • If you select to save progress, the partially processed file will be kept.
  • If you discard, the original state will be restored.