Please use the attached templates to format your data ready for importing into CareLineLive. 

Please discuss timeframes on your first onboarding session, where a team member will be able to advise you of turn around times to getting the import completed.  These times may vary if amendments need to be made to the templates in order to get them into the correct format.

Data

The columns vary depending on which type of data you are using. Check the column headings for information about how the data within that column should be formatted.

Required columns

Columns that are required are marked with an asterisk: *

Referencing teams, categories, or contract types

When a column requires you to link to an existing record (such as a Team, Contract Type, Journal Category etc) you will need to make sure that the value matches the name of the related item exactly.

Referencing Carers/Clients

When importing data that is related to a carer or client, you will be asked to provide information that allows the system to match the imported record to an existing carer or client record within CareLineLive.

You may either provide the record ID, or the individuals First Name, Last Name and Postcode in order to match to the correct record.

ID This can either be the Reference Code (6-7 characters, e.g. JOHDOE), or the long UUID from the URL of the individual's profile (e.g, 123e4567-e89b-12d3-a456-426614174000).
First Name Useful if you're compiling your import data ahead of time and you're not sure what the ID is. Must either match the carer/client import template or the existing record exactly.
Last Name
Post Code

Custom Fields

If you have chosen to add Custom Fields for carer or client records, you can import them using the standard Carer & Client import templates. Please note you will need to add the Custom Field Definitions before importing, otherwise the import will fail.

The columns for custom fields are not included in the default import templates, and you will need to add them yourself.

  1. Add a new column to the end of the headings in the import template. Order doesn't matter
  2. The column name must be prefixed with Custom:, followed by the name of the field. 
    • For example, if you have a field named "Allergic to dogs", the column heading should be "Custom: Allergic to dogs"
    • Note that the field name must exactly match the name within CareLineLive.

Generated reference numbers can also be imported using this process, however you should ensure that imported numbers do not clash with numbers already in the system.

Attachments