Import equipment

This article lists the columns you can use when you import equipment from a CSV file, and how Kompass decides whether a row updates an existing record or adds a new one. For how the Import dialog works, see Import records from a CSV file. Developers using the API can find the same columns in the API reference.

Where to import

Open Equipment, choose Actions, then Import.

How rows are matched

  • A row with an id updates that item. Otherwise Kompass looks for an item with exactly the same identifier. A row that matches nothing adds a new item.
  • The same identifier may appear only once in a file on rows without an ID.

Reading the column tables

Required marks a column a new record needs. A row that updates an existing record only changes the columns in your file, so you can leave the others out. Finds the record marks a column Kompass uses to find the existing record a row updates. Column names must match exactly, including underscores. Where a column only takes certain values, the description lists them. A column marked Needs an extra permission is only accepted from users who have that permission; for anyone else the import reports it as an unknown column. The Download template button in the Import dialog gives you the header row for your own permissions.

Equipment

Column Required Finds the record Description
id No Yes Kompass ID of the record to update. When empty, the row adds a new record unless its other columns match an existing one.
assigned No No First day of the assignment, such as 2026-01-31. Give it together with assigned_user_id or assigned_user_email.
assigned_user_email No No Email address of the user the equipment is assigned to. Or use assigned_user_id.
assigned_user_id No No Kompass ID of the user the equipment is assigned to. Or use assigned_user_email.
barcode No No Barcode on the equipment label.
calibration No No Date the next calibration is due, such as 2026-01-31.
category_id No No Kompass ID of the equipment category. Or use category_name.
category_name No No Name of the equipment category. Or use category_id.
department_id No No Kompass ID of the department that uses the equipment. Or use department_name.
department_name No No Name of the department that uses the equipment. Or use department_id.
end No No Last day the equipment is available, such as 2026-01-31. Leave empty if it stays available.
identifier No Yes Identifier shown on the equipment, such as an asset number. Used to find an existing item when id is empty.
name Yes No Equipment name.
notes No No Notes about the equipment.
owner_id No No Kompass ID of the equipment owner. Or use owner_name.
owner_name No No Name of the equipment owner. Or use owner_id.
purchase_order No No Purchase order number the equipment was bought on.
schedule No No Put yes to show the equipment on the Schedule.
serial No No Serial number of the equipment.
start Yes No First day the equipment is available, such as 2026-01-31.
tags No No Tag names separated by commas, or a list in square brackets such as ["Design, Build"] for a name that contains a comma. The record gets exactly these tags; an empty cell removes them all.
udf No No Custom field values, such as {"region": "North"}. Leave the column out to keep the current values.
udf_schema_id No No ID of the custom field set to use. Leave empty for the default set.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us