Skip to main content

8. How to Import Clients

The Import feature simplifies the process of adding or updating large volumes of client data. By uploading a properly formatted CSV file, users can seamlessly onboard new clients or update existing records. The system supports default values for missing fields and ensures data consistency by validating unique identifiers like email addresses. This functionality is ideal for businesses looking to streamline client onboarding, manage bulk updates efficiently, and maintain up-to-date client records without manual entry.

Use Cases

  • Onboarding New Clients
    Import a formatted CSV file to upload multiple client records at once, with default values automatically filling in missing data for streamlined onboarding.

  • Bulk Updating Client Data
    Import updated client details (e.g., email address changes) by re-uploading an edited CSV file. The system automatically updates existing records based on unique identifiers.

  • Partner Data Onboarding
    Import CSV files submitted by partners or affiliates, with missing fields auto-filled by default values, ensuring fast and consistent onboarding.

ID First Name Last Name Email Project Desk Active Type Created
666c2c2f32735479fd3e9a5c John Doe john.doe @example.com 66524609caa3558dd8f8da65 67a346ad8092c651c919337e True Personal 2024-06-13T15:06:02.802Z
66829b2e43c91e3ce480b6c4 Emma Smith emma.smith @example.com 66524609caa3558dd8f8da65 67a346ad8092c651c919337e False Personal 2024-07-01T07:33:52.343Z
668787f6def210c1fcfa2c92 Michael Brown michael.brown @example.com 66524609caa3558dd8f8da65 67a346ad8092c651c919337e True Personal 2024-07-05T05:29:59.572Z

File Format: CSV Only – Ensure the file is saved in CSV format before uploading. 

2.7.jpg

Important: For project and desk, you must specify their ID values.

Column Descriptions:
  • ID (Required): A unique identifier for each client (system-generated – do not modify).
  • firstName (Required): Client's first name.
  • lastName (Optional): Client's last name.
  • email (Required): Client's email address (must be unique).
  • project (Required): The ID of the project the client is associated with.
  • desk (Required): The ID of the desk assigned to the client.
  • active (Required): Indicates whether the client is active.
  • type (Required): The type of client account.
  • created (Required): The date and time when the client account was created.

Note: Only firstName and email are mandatory; all other fields will be assigned default values if not provided.

Navigate to Clients in the left-hand menu. (1)

In the upper‐top-right corner of the Clients page,list, click onthe Import.Import button. (2)

Interface (38).png

  • A modal window appears titled “Wants to import clients?” will overlay the screen (Screenshot 2).

    Requirements typically include:

    • File format:format must be CSV only—no Excel, Word, or plain-text files.

    • User limit:limit: Noup moreto than5 5000000 records per filefile; larger files are rejected.

    • Security restrictions:restrictions: Nothe CSV must contain no macros, scripts, macros, or executable contentexecutables.

    • Formatting:Formatting requirementsMust: adherecolumns must match the system’s schema (see the file format documentation link in the modal).

    • Scroll within the modal to theread requiredevery fieldbullet structurepoint and confirm your file complies.

    2.3.jpg

    • Click the Attach file button at the bottom of the modal (Screenshot 3).

    • In your file picker, locate and select the CSVprepared CSV.

    • The modal will display your file fromname youronce computer.attached—double-check it’s the correct file.

    • Hit Upload to begin processing.

    The

      system uploads and processes your CSV.

    • WhileAfter importing,confirming, the system maywill displayshow a statusbrief message.“Processing…” status.

    • Do not refresh or close the browser; you can navigate elsewhere in the app while it runs.

    • Larger files (thousands of rows) may take a minute or two—be patient.

    Clients _ default 1440x900.jpg

    • Once complete, open the importNotifications finishes,bell icon in the header.

    • Look for messages like “Client(s) imported successfully — 828 clients were imported” (Screenshot 4).

    • If errors occurred, you’ll receive an “Import failed” alert with a Notificationlink willto appear.download error details—fix your CSV and retry.

    The notification confirms that your clients have been imported successfully.

    Troubleshooting & Best Practices

    • Row-level errors

    Download the error report (if offered) to see which lines failed.

    • Incremental updates

    To update existing clients, include their ID or email. Fields you omit will remain unchanged.

    • Split large imports

    If you exceed 5 000 rows, break into multiple files by alphabetical or date chunks.

    • Validate locally

    Run a quick script or spreadsheet validation on your CSV to catch formatting issues before upload.

    The Import tool empowers you to manage client records at scale—with minimal clicks and zero manual typing. Once your CSV is validated, you’ll have new or updated client profiles in seconds, freeing your team to focus on high-value work (onboarding calls, KYC checks, relationship building). If you need further details on field mappings or sample templates, see the file format documentation linked in the import modal.

Back to top