Exporting Your Data

Learn how to export all data from Power Diary, including client records, appointments, invoices, and more. Follow step-by-step instructions for data export and document downloads.

Master users or users with the Allow Database Export permission are able to export the account and practitioners information at any time. Data is exported into a zipped CSV file which can be unzipped and opened by Excel or similar programs. The database export allows you to backup clients, client notes and forms, appointments, referrer profiles, client contacts, client communication, third parties, invoices, payments, services, products, session packs, Medicare (AUS) claims, client insurance details, and any uploaded documents (client files). 

Important

The exported data is available for download for 72 hours after the link is available. After 72 hours, the link is removed from the download list. The list will store the export information for 14 days for record-keeping purposes.

In this article:

Export Types:

There are these export types applied when exporting data: 

  1. All Data: Will export data for all clients and practitioners.
  2. Data Linked to Practitioner: Will export data for the practitioner and their clients. 
  3. Data Linked to Specific Client: Will export data for the chosen client.

There are some exceptions to note:

  • Invoices and appointments: When filtering by Data linked to practitioner this will export all invoices billed to the practitioner, and all appointments booked with that practitioner. This is so that you can export the data associated with them, rather than exporting all invoices or appointments for clients linked to that practitioner - in the event that those clients have invoices or appointments with other practitioners. 
  • Services, Products & Packs: All services, products and packs in the account will be exported regardless of whether filtering by a specific practitioner or client, given this information is linked to the account but not to a specific practitioner or client. By default, this option will be unchecked when you choose to filter by a practitioner or client.

How to Export Data:

  1. Go to Settings > Practice > Data Export
  2. Select the desired export type:
    1. All data (Will export data for all clients and practitioners)
    2. Data linked to practitioner (Will export data for the practitioner and their clients)
    3. Data linked to specific client (Will export data for the chosen client)
  3. Select the data that you want to export
  4. Click Export
  5. Return to this page later to download a copy of your data (times may vary depending on the amount of data being exported)

Export Uploaded Documents:

  1. Go to Settings > Practice  > Data Export
  2. Click on Uploaded Client Files
  3. Select the desired filtering:
    1. All data (Will export files for all clients and practitioners)
    2. Data linked to practitioner (Will export files for the practitioner and their clients)
    3. Data linked to specific client (Will export files for the chosen client)
  4. Choose whether to export all files or select a start and end date for files uploaded during a certain period
  5. Click Export. Return to this page after waiting for the data to be prepared to download a copy of your data.

Note

The time that the system takes to prepare your data can vary dramatically depending on the age of the account and the amount of data that is stored within it. For example, for newer accounts with a few calendars, this might only take a few minutes, whereas for a more established account with ten or more calendars and a lot of data may take several hours.

Export Personal and Group appointments

1. To export all personal and group appointments created in your account, you need to select Appointments and select the All Data option. 

2. To export personal and group appointments for one practitioner only, you need to select   Appointments and select the Data Linked to Practitioner option, then select that specific practitioner

The Client Appointments.csv file will be exported, and you will be able to sort it by the AppointmentTypeID column to select Personal and Group appointment types. 

Data Export Outcome

  • Once you have defined what data you will be exporting, click on the Export button. Depending on the amount of data, it may take up to two hours to complete the download. You will see a notification to inform you of this.
  • When the download is completed, the Download List section at the bottom of the Settings > Practice > Data Export page will include ZIP files ready to be downloaded on your device.
    The Client Files .zip file will include all client files that were uploaded to your account, organised in folders by client profile name. 
    The Data Export .zip file will include  a number of CSV files which can be opened by Excel or similar programs. There you will find clients, client notes and forms, appointments, referrers, client contacts, client communication, third parties, invoices, payments, services, products, session packs, Medicare (AUS) claims, client insurance details


Hint 💡

You are able to generate PDF files with all notes and forms that were ever created for a particular client. In some circumstances this could be a more suitable format to provide such data when requested. 

  • To create such PDF files, you need to navigate to Client Profile > Records > Notes or > Forms
  • When on that page, you will see a large button at the top that says Print All
  • Click on it and the system will generate a PDF file that would include all client notes or forms in one document. 
  • You will be able to either print this file, or download it as PDF on your computer.