Skip to content
  • There are no suggestions because the search field is empty.

Onboarding - Data migration

Importing existing clients, workers and staffers data into Lookout

This guide is for customers currently onboarding to Lookout.

Lookout uses a combination of templated spreadsheets and a service called Flatfile to help validate client, worker and staffer data is in the correct format.

* Please read through this guide in full before begining to prepare data. If at any stage you have additional questions or require further support, please don't hesitate to contact your Onboarding Specialist.

Jump to

Definitions

Please reference the below tables for information on the user and admin roles applicable to your clients, workers and staffers when completing the templates.

User Roles:

Role

Description

Client

The care recipient.

Authorised Representative

The person you wish to provide the same level of authority as the client. This includes access to the app.

Emergency Contact

The person you wish to identify as the emergency contact for the care recipient

Billing Contact

The person/s you wish to have email invoice summaries and monthly statements sent to.

Funder

The person/s or entity you will seek to provide the payment of the provided services.

Sharer

Additional users who you wish to grant access to the app for. Their view is limited to the schedule only.

Admin Roles:

These roles enable this staff member to configure/administer components of the system related to these business functions.

Role

Description

Finance

Allows user to create billing runs, set taxes, products and run financial reporting.

Human Resources

Allows the user to add a Staffer and Staffer roles.

Legal

Allows the user to create new agreement templates for memberships, services and care workers.

Marketplace

Allows the user to onboard new suppliers.

Workflow Management

Allows user to manage ticketing workflows, surveys, and cohorts.

Workforce

Allows the user to onboard new care workers, adjust pricing for care workers and manage verifications and requisites.

 

Preparing your data

We have created templates for each type of data that can be migrated across to Lookout.

Download a copy of each template.

Open each template file and begin to populate with your existing data.

Each template has colour coded coloumn headers that represent if the field is mandatory or optional.

  • Red = Mandatory

  • Green = Optional

Screen Shot 2022-02-24 at 4.12.25 pm

The 'Guide' sheet of each template will provide additional details on the fields and how to populate.

Screen Shot 2022-02-25 at 11.26.55 am

Fields with predefined responses show a dropdown:Screen Shot 2022-02-24 at 4.14.55 pm

Uploading your data

When you are ready to upload the completed templates, click the 'Upload files' button below and sign into your Flatfile account.

* Please contact your Onboarding Specialist if you have not recevied an invitiation to Flatfile.

 

Flatfile will show a 'Welcome Dashboard' with instructions on uploading and reviewing the templates.

Click Upload in the top left and select the completed template file to be loaded.

Screen Shot 2022-02-24 at 4.23.19 pm

Once the file has uploaded completely, click the folder icon that appears in the bottom right.

Onboarding Workspace

A pop up will appear to complete the import process. Select the sheet you want to import and the corrosponding template. The Sheet and Template names should match.

Import Staff Members

Select Yes to confirm that the first row contains column headers.

Upload Staff Members

Confirm all column names have a green tick and then click Continue.

Confirm changes

Your data will be checked against the required fields and formating required by Lookout. Any errors will be highlighted with an explanation.

Errors will typically be caused by:

  • Missing data in mandatory fields

  • Invalid formating

Errors can be corrected by double clicking into the field and amending the data manually or by uploading a new file with updated values.

Staff memebers

Once all errors have been corrected, click Approve All Rows. This will complete the data upload process for the file and notify Lookout.

Repeat the process for the remaining templates.

A member of the Lookout team will review the uploaded files and begin the process of importing the data into Lookout.