Bulk import from a CSV
If your inventory already lives in a spreadsheet, you don’t have to retype it. Map your columns to TermZ session fields, then produce the import JSON envelope — any small script or spreadsheet formula can do the conversion.
Map columns to fields
Section titled “Map columns to fields”| Spreadsheet column | Session field | Notes |
|---|---|---|
| Name | name |
Required. Display name (also used for dedup). |
| Host / IP | host |
Hostname or IP. |
| Protocol | kind |
ssh, telnet, raw, serial, or local. |
| Username | username |
Login user. |
| Folder | folder_path |
POSIX-style, e.g. /Datacenter/Core. Missing folders are auto-created. |
| Device type | equipment_type |
Router, switch, firewall…; custom types allowed. |
| Tags | tags |
An array — see below. |
| Credential | credential |
Name of a stored credential to link. |
| Notes | notes |
Freeform. |
Tags from a delimited column
Section titled “Tags from a delimited column”Spreadsheets usually keep tags in one cell (e.g. prod;core;dc-east). Split that string on your delimiter into a JSON array:
"tags": ["prod", "core", "dc-east"]Wrap it in the envelope
Section titled “Wrap it in the envelope”Emit one object per row inside the sessions array:
{ "version": 1, "sessions": [ { "name": "core-rtr-01", "host": "10.0.4.1", "kind": "ssh", "username": "netadmin", "folder_path": "/Datacenter/Core", "equipment_type": "router", "tags": ["prod", "core"], "credential": "netadmin-prod" } ]}