How to Extract Client Data for a Subpoena

Efficiently export client data from Power Diary with our detailed guide. Learn how to export client notes, forms, invoices, and more directly from the Client Profile or using the Data Export tool.

In this article:

Exporting Data from Client Profiles

You can download the following data directly under the Client's Profile:

Clinical Notes

1. Navigate to the Client Profile.
2. Select the 'Records' submenu.
3. Click on 'Notes'.
4. Use the 'Print All' button at the top to print all clinical notes to PDF in one go.

Admin Notes

1. Navigate to the Client Profile.
2. Select the 'Admin' submenu.
3. Click on 'Admin Notes'.
4. Use the 'Print All' button at the top to print all admin notes to PDF in one go.

Clinical Forms

1. Navigate to the Client Profile.
2. Select the 'Records' submenu.
3. Click on 'Forms'.
4. Use the 'Print All' button at the top to print all forms to PDF in one go.

Admin Forms

1. Navigate to the Client Profile.
2. Select the 'Admin' submenu.
3. Click on 'Admin Forms'.
4. Use the 'Print All' button at the top to print all admin forms to PDF in one go.

Invoices

1. Navigate to the Client Profile.
2. Select the 'Billing' submenu.
3. Click on 'Invoice'.
4. Enter each invoice one by one.
5. Select 'print' in the top right to download each invoice.

Uploaded Clinical Documents and Files

1. Navigate to the Client Profile.
2. Select the 'Records' submenu.
3. Click on 'File'.
4. Download each file by clicking the 'cog' icon.

Uploaded Admin Documents

1. Navigate to the Client Profile.
2. Select the 'Admin' submenu.
3. Click on 'Admin Files'.
4. Download each file by clicking the 'cog' icon.
 

Note:

To export a complete client communications record, please use the data export tool located in Tools → Data Export

 

Exporting Large Data Sets

For a comprehensive data export, use the following steps:
1. Navigate to Tools → Data Export.
2. Apply filters as needed to specify the data you require.
3. Click the blue 'Export' button.
4. A downloadable link will appear at the base of the screen.
5. Click the link to download a ZIP file containing the data.

For a more detailed step-by-step guide, please refer to our article on Exporting Your Data.

By following these steps, you can efficiently export all necessary client data in a streamlined and organized manner. If you have any questions or need further assistance, feel free to contact our support team at support@powerdiary.com.

Encrypting and password-protecting CSV and PDF files

Please be aware that the instructions provided are recommendations, and Power Diary does not take responsibility for the results.

Encrypting/Password Protecting CSV Files


Using Microsoft Excel
1. Open your CSV file in Excel:
   - Launch Excel.
   - Go to `File → Open` and select your CSV file.

2. Save as an Excel Workbook:
   - Go to `File → Save As`.
   - Choose the location where you want to save the file.
   - In the `Save as type` dropdown, select `Excel Workbook (*.xlsx)`.
   - Click `Save`.

3. Encrypt the Excel Workbook:
   - Go to `File → Info`.
   - Click `Protect Workbook` and then `Encrypt with Password`.
   - Enter a password and confirm it.
   - Save the file.

4. Convert the Encrypted Excel File back to CSV (if necessary):
   - Open the encrypted Excel file.
   - Go to `File → Save As`.
   - In the `Save as type` dropdown, select `CSV (Comma delimited) (*.csv)`.
   - Save the file. Note that this will remove the encryption, so keep the Excel version for security.

Using 7-Zip (for Windows)
1. Install 7-Zip:
   - Download and install 7-Zip from here.

2. Compress and Encrypt the CSV File:
   - Right-click on your CSV file.
   - Select `7-Zip → Add to archive`.
   - In the `Add to Archive` window, set the `Archive format` to `zip`.
   - Enter a password in the `Encryption` section.
   - Click `OK`.

Using macOS Terminal
1. Open Terminal:
   - Open Terminal from `Applications → Utilities → Terminal`.

2. Compress and Encrypt the CSV File:
   - Navigate to the folder containing your CSV file using the `cd` command.
   - Use the following command to compress and encrypt:

     zip -e encrypted_file.zip your_file.csv

   - Enter and confirm the password.

Encrypting/Password Protecting PDF Files


Using Adobe Acrobat
1. Open your PDF in Adobe Acrobat:
   - Launch Adobe Acrobat.
   - Open your PDF file.

2. Encrypt the PDF:
   - Go to `File → Protect Using Password`.
   - Choose `Encrypt with Password`.
   - Enter a password and decide the type of password protection (e.g., for opening the document, for editing, etc.).
   - Save the file.