RoomScene 3D
Download

From an Excel equipment list to a 3D model of your racks

Almost every facility has the equipment list in a spreadsheet. It is the right place to start a migration, but rarely in a state a tool can read. This guide covers the columns, the cleaning, the naming and the import, in that order.

Published

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, store and ask 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 gen3 with 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.

ColumnExampleRule
NamePO-SRV-04Unique. Same as the monitoring host name
RoomCAROne spelling per room, from a fixed list
RackA07Empty for floor equipment and spares
U21Lowest U the device occupies
Height (U)2Whole number; 0 for side-mounted PDUs
TypeServerFrom a short fixed list
MakeGenericOne spelling per manufacturer
Model2U serverTrimmed, consistent
SerialSN-48213Empty if unknown, never “N/A”
Management IP10.20.7.21One address, no mask or notes
OwnerPlayout teamA team, not a person who may leave
Power (W)750Nameplate, per device
Weight (kg)28Number 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.

  1. Unmerge every cell and fill the rack name down to each device row.
  2. Split the location text into room, rack, U and height. A formula gets most of it; fix the rest by hand. U21-22 becomes U 21, height 2.
  3. Expand grouped rows. “4 × audio embedder” becomes four rows, each with its own serial if you can find it.
  4. Trim spaces and normalise spellings in Room, Make, Model and Type. A pivot table on each column shows the variants quickly.
  5. 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.
  6. Check the U positions rack by rack. Sort by rack and U, and look for two devices claiming the same U.
  7. 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.

Try it on your own rooms

RoomScene 3D is a 30-day trial with every feature on. Install it on a test server and import one room.

Download the 30-day trial Ask for a quote

contact@roomscene3d.com · tahirfeyzioglu@gmail.com