This reference describes the columns in the Entity Manager CSV file used to import and export assets.
Columns
| Column | Description |
|---|---|
| External ID | The asset's identifier. Required. Import matches each row to an existing asset by this value. |
| Name | The display name. Optional. |
| Asset Type | The Asset Type, by name. The type must already exist in Company Settings. |
| Groups | Group membership, as a comma-separated list of group names. |
| Tag Status | The tag's state, such as Online, Lost, or Not Assigned. |
| Tag ID | The assigned tag's identifier. |
Import
- Download the template with Get template in the Import wizard. The template includes the required columns and the optional columns.
- The wizard flags any missing required columns and any rows with errors before the import runs.
- Each row is matched to an existing asset by External ID. A new External ID creates a new asset; an existing one updates that asset.
Row error reasons
If a row cannot be imported, the wizard reports the reason. Common reasons:
| Reason | What it means |
|---|---|
| Required field | A required column is empty. |
| Entity Type / Entity Type Not Found | The Asset Type is missing or does not exist. |
| Entity Type Missing Attribute | A setting the Asset Type marks as required is not filled in. |
| Device / Device In Use / Device Not Found | The tag is missing, already assigned, or not in your account. |
| External ID | The External ID is missing or not valid. |
| No Access | Your role does not allow the change in that row. |
Export
- Export includes only the assets shown by your current search, filters, and sort order.