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 11 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.