Importing Dimensions

Dimensions represent entities such as companies, departments, roles, vendors, and more. Use the import tool to bulk-add or update these records. The process is identical for all dimension types, but required fields differ slightly.

Written By Tristan White

Last updated 5 months ago

Steps

  1. Open the Import Tool

    Go to Settings → Import Data and select Dimensions.

  2. Choose Dimension Type

    Pick the specific type: Company, Department, Group, Level, Role, Vendor, or Other.

    This ensures the correct field mapping for your data.

  3. Upload CSV

    • Download the sample template if you need a header guide.

    • Upload your CSV, confirm the delimiter (comma is default), and verify the first row is a header.

  4. Map Fields

    • Company type: Name is required. Optional fields include emails, VAT number, and industry.

      • Industry can be supplied as either a numeric ID or the exact label (case-insensitive). Unknown values default to 0 (None).

    • Other dimension types: Name is required, Description optional.

  5. Preview & Validate

    Review the summary of rows, valid entries, and any warnings. Nothing is imported until you confirm.

  6. Import

    Click Start Import to create or update the records.