Import your clients Excel (CSV)

Who can use this feature?

System & User administrators only

Your organisation on Qwil Messenger is composed of two user types Staff and Clients with Client Teams that are used to connect users to each other. You are the one assigning the client team so that your clients know who they can start a chat with. Once you have set up your teams, onboarding a new client to Qwil is as simple as filling in their details, and assigning them to the correct team.

Client users are the external users that you invite to use the system to be provided services from you. As opposed to staff that can search for other staff, Client users can only see contacts you have defined in their client team. This is why client teams always have to be set up first and a staff included before an invitation is sent.

What to expect?

  • To import your clients you will first need to have created manually or imported client teams to our system.

  • Once you've populated the excel template for all the Client users and assigned them to their client teams, they will all be receiving an email invite on a daily basis until accepted. 

  • Once an invitation is accepted, the client member will see the staff members and other members of the Client team. The Staff covering the client will also receive a notification through the Butler.

Populate and upload your clients' Excel (CSV) file.

  1. As an admin user, navigate to the administration menu and click on Clients.

  2. Click on the Import button.

    S71.1__1_.png
  3. Download the client CSV template.

    Screenshot_2020-12-09_at_10.03.38.png
  4. Populate the CSV template as per the example below. Make sure you put the following values in each of the columns:

    Note: If you have set up a default client team (ie one team for all staff and clients), and the Group identifiers and Group UUID are left empty, the client will be assigned to the default client team


    More explanation on each field is included below.

    client_table__1_.png
  5. Upload your populated CSV using the Select file button.

    Note: You can select the checkbox "Ignore entries with identifiers already in use" to avoid creating duplicates. If you do not click this checkbox and you try to upload a duplicated record you will see an error. 

  6. Once you have uploaded your file click Import.

  7. Click Done. Your client invitations will be created.

Note: CSV templates do not keep the phone number formatting when the file is closed (i.e. the +44). You can use this formula in a separate spreadsheet ="+" & [cell ref] it will add the '+ to the cells its already in and paste it as value in the CSV column again.



Was this article helpful?