What a typical equipment sheet looks like
A sheet that has been kept for ten years by five engineers carries the habits of all five. Before designing anything, open it and list what you find. Most sheets have some of these:
- A single “Location” column holding
CAR A07 U21-22,MCR rack 3,storeandask the night shift. - Merged cells for a rack, with devices listed below and the rack name only on the first row.
- Meaning carried by colour: red rows are retired, yellow rows are on loan. A tool cannot read colour.
- One row for “4 × audio embedder” instead of four rows with four serials.
- Several tabs, one per room, with slightly different columns on each.
- Model names written three ways:
SRV-2U Gen3,2U Gen3,srv-2u gen3with a trailing space.
None of this is a problem for a person reading the sheet. All of it is a problem for an import. The work is turning a document written for people into a table written for a program.
Design the columns
The target is one row per physical device, one fact per column. Split the location into its parts, because the tool needs each part separately to place the device.
| Column | Example | Rule |
|---|---|---|
| Name | PO-SRV-04 | Unique. Same as the monitoring host name |
| Room | CAR | One spelling per room, from a fixed list |
| Rack | A07 | Empty for floor equipment and spares |
| U | 21 | Lowest U the device occupies |
| Height (U) | 2 | Whole number; 0 for side-mounted PDUs |
| Type | Server | From a short fixed list |
| Make | Generic | One spelling per manufacturer |
| Model | 2U server | Trimmed, consistent |
| Serial | SN-48213 | Empty if unknown, never “N/A” |
| Management IP | 10.20.7.21 | One address, no mask or notes |
| Owner | Playout team | A team, not a person who may leave |
| Power (W) | 750 | Nameplate, per device |
| Weight (kg) | 28 | Number only |
Status columns such as “retired” or “on loan” replace the colours. Free text goes in one Notes column at the end, where nothing depends on it.
Clean the data
Do the cleaning in the spreadsheet, before the import. It is faster there, and every engineer already knows how to use filters and find-and-replace.
- Unmerge every cell and fill the rack name down to each device row.
- Split the location text into room, rack, U and height. A formula gets most of it; fix the rest by hand.
U21-22becomes U 21, height 2. - Expand grouped rows. “4 × audio embedder” becomes four rows, each with its own serial if you can find it.
- Trim spaces and normalise spellings in Room, Make, Model and Type. A pivot table on each column shows the variants quickly.
- Find duplicates on Name and on Serial. Two rows with the same serial are either a copy-paste error or a device that moved and was entered twice.
- Check the U positions rack by rack. Sort by rack and U, and look for two devices claiming the same U.
- Move retired equipment to a separate tab. It does not belong in the rooms.
Agree on naming conventions
Naming is where a migration either links up with monitoring or does not. The rule that pays off most: the device name in the inventory is the host name in Zabbix. Same spelling, same case. If Zabbix calls it PO-SRV-04 and the sheet calls it Playout 4, a person can match them, a program cannot.
Pick a pattern of function plus number and apply it everywhere: PO-SRV-04, ENC-07, MV-CAR-01 for a multiviewer. Keep the location out of the name. A device named A07-SRV-2 carries a wrong name from the day it moves to A09.
Where the sheet and Zabbix disagree, decide which one changes. Usually it is the sheet, because the Zabbix host name may already be used in triggers, actions and dashboards.
Import with a preview
Never import straight into the live data. Whatever tool you move to, run the import as a dry run first: every row classified as new, changed or rejected, with a reason for each rejection. Fix the rejections in the sheet and run it again until the only rejections left are ones you understand.
In RoomScene 3D, that preview is how every import works. You download the blank template or paste your own columns; English and Turkish column headings are both recognised. Each row appears as new, changed or rejected with the reason, before anything is written. Excel (.xlsx) and CSV are both accepted.
Devices you send to a room land in that room's draft, not in the live layout. They are sorted into racks by type, servers to the server rack and graphics to the graphics rack, or onto the floor. You then adjust them in design mode, check the front view of each rack against the sheet, and apply the draft when it looks right. The racks then appear in 3D with each device at its U range, the same view described on the rack elevation page.
Link the inventory to Zabbix hosts
If the facility runs Zabbix, the inventory and the host list should describe the same equipment. Matching them is where the naming work pays back.
- RoomScene 3D connects to Zabbix with a read-only API token. It reads hosts, problems and items, and writes nothing.
- Hosts whose names match an inventory device are linked automatically. Those devices then show their open problems in Zabbix severity colours, on the device, the rack and the room.
- Hosts that do not match wait in an unplaced list, filtered by host group, until someone places or links them.
- If the spreadsheet is thin, Zabbix hosts can seed the inventory instead, and you fill in rack and U afterwards.
- The reconciliation page lists both gaps: hosts Zabbix has that the inventory lacks, and inventory devices missing from Zabbix.
More on what happens after the link is made is in Zabbix problems on a 3D server room and on the Zabbix page.
Treat unplaced devices as a work list
After the first import, some equipment will not have a position. That is normal. Spares in the store, a converter on a desk, a host Zabbix knows about that nobody can find. The mistake is to force them into a rack to make the list empty.
Work the list down instead. Sort it by owner and send each team its own lines. For each device the answer is one of four: place it at its real U, put it on a room floor, mark it as a spare, or retire it. Broadcast gear that cannot be monitored at all, a passive frame or an analogue distribution amplifier, should be marked “not monitorable” so it neither looks healthy nor shows up as missing.
Once the list is short and the racks match the floor, stop editing the spreadsheet. Export from the tool when someone needs Excel; RoomScene 3D exports the whole inventory or one room at any time. A spreadsheet that is still being edited in parallel is how the next migration starts.
The 30-day trial has every feature on. Download it and import one room from your cleaned sheet.