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
"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.
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"
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)
- 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.
- 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:
- (Most preferable) documents are structured in individual folders per client and the folder name identifies the relevant client.
- 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.