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
idupdates that item. Otherwise Kompass looks for an item with exactly the sameidentifier. 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. |