Get your first data into Netos
Netos works from the records in your NetBox environment: sites, devices, circuits, contracts and the reference data that describes them. This guide helps you choose how to get a first, small set of data in, and how to check what actually landed. The detailed steps for each route are in the product guides inside Netos.
What you need
- A Netos environment you can sign in to. See Get started.
- Permission to add data in that environment. Your Netos administrator grants it. See Groups and permissions.
- A small sample first, for example two sites and the devices in them, with a header row and one row per record.
- The identifier you will match on, for example the device name or the product identifier, and who owns the source data.
- One person who can approve changes, if your environment asks for approval.
Choose a route
| Your data | Route | Use it when |
|---|---|---|
| A spreadsheet (XLSX, XLS or CSV) | Spreadsheet import | A one-off or first load, such as an inventory export |
| A system that changes over time | Data feed through a data pipeline | The same source will refresh your records again and again |
| A small, specific change | Your AI assistant stages it for approval | You can describe the change, or attach a small file, in a chat |
%%{init: {"themeVariables": {"mainBkg": "#eef2f7", "textColor": "#1f2937"}}}%%
flowchart TD
A["What is the source?"] -->|"Spreadsheet"| B["Spreadsheet import"]
A -->|"System that refreshes"| C["Data feed"]
A -->|"A few records"| D["AI assistant, staged"]
B --> E["Review the staged rows"]
C --> E
D --> E
E --> F["Approve or reconcile"]
F --> G["Check the records in Netos"]
classDef step fill:#dbeafe,color:#1e3a8a,stroke:#2563eb
class B,C,D step
Whichever route you take, Netos stages the data first: you see what would be added or changed before anything is written.
Spreadsheet import
- Prepare the workbook: one header row, one row per record, and the identifier column filled in on every row. Parent records come first: a site must exist before a device can refer to it.
- In Netos, upload the workbook and choose the table it loads into, for example devices. Map each column in your file to a field in Netos.
- Run the import with automatic reconcile off, so the rows stop at staging.
- Review the staged rows: what would be new, what would change, and any rows that failed. Then reconcile.
- Check a few of the records themselves (see Check what landed).
The product guide inside Netos, Import Data Into NetBox From Excel, names every screen and field.
Data feed
A data feed refreshes records from another system on a schedule, for example a lifecycle or pricing reference, or an inventory source.
- Ask Netos for the feed or connector you need. Netos-published pipeline configurations install as packages in your environment.
- Check the pipeline's source connection, its field mappings and which of its steps are enabled.
- Run it once by hand and read the run's results: rows staged, failed and reconciled.
- Check the records it wrote, then let it run on its schedule.
The product guide inside Netos, Sync Data Feeds Through the Pipeline, covers each step.
With your AI assistant
Once your AI assistant is connected, you can ask it to check a small spreadsheet and stage it, for example "Check this device spreadsheet and stage it for import. Do not commit until I approve." It returns a review link, and nothing is written until an approver approves it. See Permissions and approvals.
Check what landed
A run that reports success is not proof that every row arrived. Before you rely on the data:
- Compare the number of records you meant to load with the number staged, failed and reconciled.
- Open two or three records in Netos and compare them with the source: one new record, and one that should have stayed as it was.
- For any failed or unmatched row, read its error, fix the source row or the mapping, and run again.
Troubleshooting
| What you see | Likely cause | Fix |
|---|---|---|
| No columns from your file appear | The sheet name, header row or target table is wrong | Check the sheet name spelling and the header row number |
| A row fails with a missing related record | The parent record, such as the site or device type, is not in Netos yet | Load the parent records first, then run again |
| Fewer records than expected | Some rows were rejected or did not match | Read the failed and unmatched rows in the run results |
| A field is blank after the run | The column is not mapped, or the source cell is empty | Check the mapping, then the source row |
| You cannot run the import | You lack the permission | Ask your Netos administrator |
Related
- Get started
- AI assistants
- Data assurance: what Netos does with your data
- Support: [email protected]