How to import Clients

This article will show you how to import clients into your Uptick server

Teresa Bui avatar
Written by Teresa Bui
Updated over a week ago

There are 2 ways to set up clients in Uptick.

1. Add clients directly into your server
If you only need to set up a few clients or make a change here or there, we advise doing it directly within the system rather than through the importer.

2. Add multiple clients using the data importer.

We recommend using the data importer method when:

  • Uploading initial data migration into Uptick

  • When making changes to a specific field(s) across many clients

This article will show you how to format your import spreadsheet in order to bring your core client data into Uptick.


Step 1: Populate your data for upload

  1. Download the Data Import Template Spreadsheet below.

  2. Fill out the spreadsheet with the information you want to upload. Please note some fields are required.

  3. Save as a .csv file

Required fields

If you are using Client Groups, you must have these in your Uptick server before you can import Clients.

Here is an article on how create a client group.

Field name on CSV template:

name

is_active

address

contact_name

email_address

Field name in Uptick:

Name

Is active

Address

Contact name

Email address

Description:

Name of the entity receiving the invoice for your services.

Options:

TRUE - This is a current client you are actively servicing. The majority will be TRUE.

FALSE - Client is not active, but you would like a record of them in your server.

Address of client's main office (Not necessarily the same as their site address)

First and Last name of the contact who will receive all communication

Email address of the main contact

Non-Required fields we recommend

Field name on CSV template:

mobile

phone_bh

notes

Field name in Uptick:

Mobile

Phone BH

Notes

Description:

Client's mobile number

Contact number to be used during business hours

Any key information about the client. This is an internal field only, not visible to the client

Step 2: Import your Data

  1. Sign into your Uptick server

  2. Navigate to Tools > Data Importer

  3. In the field 'What are you importing?', select 'Clients'.

  4. Choose your import file (this should be the .csv file you have saved).

  5. Click 'Start'. (If your file is large this may take a few minutes)

  6. Complete your 'Field Mapping'. If you are using our template, the mapping should pre-populate for you.


    Please check that the fields are mapped correctly.

    Uploading data using your own spreadsheet? Check out the right-hand side for an overview of the Uptick fields and their descriptions to assist with Field Mapping.

  7. Click 'Save and Preview'.

  8. Review your preview to ensure that the data has passed all checks before proceeding. If it has not, you may see an error screen, which looks like this:

    If you receive errors, please fix these on your .csv file and click 'Re-upload file'. You should see the green banner above before proceeding.

    If you need help understanding the error, please contact Uptick Support.

  9. Click 'Finalise'

  10. Your data should now be 'PROCESSING' with a Job status: RUNNING:

  11. When your data has finished being uploaded you will see 'FINISHED' and a Job status: DONE

  12. You can now navigate to People > Clients in your main menu to see your newly uploaded Clients!


Data Import CSV Template

Please download this csv template to upload your clients.
It contains:

  • Required fields

  • Recommended fields

  • An example of each field

    Please note that this is a highly simplified template designed for ease of use. If you are interested in seeing our extended template, it is available for download from the Data Importer module of your server. Please reach out to Uptick Product Support if you have questions about any fields in the extended template.

Did this answer your question?