Importing Your Data

We can assist with importing your data, albeit from another system, or perhaps a spreadsheet containing client records

In this article:

Importing your Data

Once you have made the decision to move over to Power Diary, we are able to assist with importing data into your Power Diary account as a once-off complimentary service. There are no charges associated with the import. 

"What format does my data need to be in?"

We require the Data to be in Excel, CSV, or XML format. We can also accept database backups in BAK, SQL, or MS Access format. 

Any files/documents that need to be imported to client profiles would generally be provided in client-centric folders, including a unique ID linked to each client (in order to know which client to import them to), and some systems export Clinical Notes in HTML format, which we can work with

If you have your data in a format other than this, and you are unsure how to convert it into a suitable format, please don't hesitate to contact our Support Team who will be able to assist with determining whether the data can be converted, and if so can provide steps for how this can be done.  
We can't accept Data as HTML files (aside from Clinical notes), iCal appointment files nor Word, PDF or image formats (except for client documents/files)

"How do I share my data with Power Diary?"

You can share your data with us directly via your Power Diary account, by selecting   Setup > Data Import > Select or Drop your data files in > Submit.  Our Data Import Team will then be alerted that your Data is ready for analysis, and we will make contact to confirm that we have received your Data, and will keep you in the loop until your data has been imported.  

If your file is too large to share directly via your Power Diary account, please let us know and we will supply you with an alternative option for sharing the data with us.  The limit is 100MB to share via your Power Diary account.

"When can I upload my data?"

We can import your Data once you have made the decision to migrate to Power Diary. If you have not yet made a decision as to whether you are going to be moving over to Power Diary, the best way for you to gauge whether Power diary will fit your business needs would be to use your 14-day free Trial Period to assess that, and manually input test data yourself, for a small number of clients.  Our Data Import Service is offered only to clients who have decided to migrate over to Power Diary,  Focussing on importing for people who have decided to migrate, means we can take the time to understand and work with complex data and get a better outcome for people transitioning systems. 

Hint 💡

If you have less than, say, 50 clients and not a lot of linked data, we recommend that you input the data yourself. Our Data Import Team often has a pipeline of new imports, and it would be more expedient and quicker for you to input your own data when there is not a lot of it.  

"How long will the import take"

The time frame will vary depending on what data is presented and also whether or not the data requires much formatting to meet the requirements for importing into our database. A simple import of clients may take only a few hours, but we typically quote up to 24-48 hours. More complex data requiring formatting and manipulation may take longer, and our import specialists will keep you updated on their progress.

Importing Files and Notes does take a little longer, as this is a more manual and time-consuming process.  We would generally set an expectation for Files and Notes to be imported into your account within a week or two after your data has been imported into your account.

Plan to Bridge the Gap Period

There will always be a crossover period when switching systems, and the majority of our new clients manage this by means of manually inputting the new data that was created after the data from your previous system was exported, and where necessary, Merge Duplicate Clients to mitigate data loss.

That way you could start using Power Diary immediately.  Once your final data has been extracted from your previous system and provided to us for import, we recommend that you only use Power Diary and not your previous system going forward

What we can Import

Depending on the format and the content of the data provided, we are typically able to import the following data into your account:

  • Client details
  • Appointments (client, personal, and group)
  • Notes
  • Services
  • Products
  • Referrers
  • Referrals
  • Contacts
  • Third Parties (Billers)
  • Communications (SMS, letter, and email)
  • Documents/Files (see requirements under 'Can you upload documents into the client's profile?' below)
  • Financial Information (in some circumstances - see FAQ below);


Depending on where the data came from and what format it is in we may not be able to import all of the above. If this is the case we will contact you upon reviewing the data.

Important Notes

  • Recurring appointments are not maintained in the import. This is due to the information either not being included when given to Power Diary, or the way that this is recorded varies widely between different platforms and cannot be imported. Appointments in a recurring series will instead be imported as individual appointments.
  • We import data for all calendars/practitioners. If a calendar has not already been added to the account, (this is done so via Setup → Calendars) we will add the calendar into the account and make it inactive. This will ensure that all of the client and appointment data is imported for that practitioner, but you won't be charged for the calendar (and it won't show when viewing your calendars). You can make the calendar active at any time.
  • The data will need to be structured in a table-like format where there is a column header to denote the type of data within each column. Each entry will span across one row. If data is not structured in this format we will not be able to work with it for importing into the database.
  • Please ensure that any data is unlocked before sending it to us, or otherwise please email the import or support team the password to unlock the file. This will ensure that the team can access the data once received and avoid any delays.
  • The upload of documents to client profiles takes a week or two after your data has been imported, as this process is naturally time-consuming, which involves uploading each document into our server. We recommend you keep a copy of the documents as a reference in the interim while we work on this.
  • Appointments must contain a clear link to the client for the appointments to be imported as client appointments. This is typically provided with a column containing the unique client ID or the clients' full name related to the appointment. If there is no clear link to the client the data will be imported as personal appointments with the details of the appointment in the appointment title.

Frequently Asked Questions

Can you upload documents into clients' profiles?

Yes, we can upload documents (such as PDF, Word, HTML, etc) into client records in bulk. However, the data will need to specify the relevant client so that we can upload the data into the correct client profile. This can be managed in two ways:

  1. (Most preferable) documents are structured in individual folders per client and the folder name identifies the relevant client.
  2. Documents are listed under one folder, document title must list the client identifier.

The client can be identified with their full name, unique ID, and other unique information (or a combination of unique identifiers i.e name and DOB). As this data is typically larger in size, please compress/zip the data into one file before uploading.

Can you import financial information?
We can import invoices and payment information in some circumstances. The financial information will need to include sufficient information for us to be able to import it into the system. If you send through the data that you have available our import specialists will be able to review the data to determine whether it would be sufficient and compatible with importing into the system.
Please be aware that there can be complexities and differences within each system and their underlying structure and these cannot always be properly translated when moving data from one system to another. Financial history is complex and can involve many different elements such as discounts, write-offs, refunds, pre-payments, vouchers, etc. These can be recorded in different ways depending on the system, and often the data that is exported out of the system may not tell the whole story. This can lead to information in Power Diary in turn not reflecting the correct history of events.
If we cannot import financial data, we advise that you set a particular date to start invoicing in Power Diary and then record all financial activity in Power Diary. Any historical financial information should either be kept externally from your backups or use an accounting system to access the information there. This gives a clear idea of what information has been recorded in Power Diary and what was recorded in the old system.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us