Exports & Integrations

Platform-agnostic. Format-specific.

Struktive produces correctly formatted output for each target platform. Choose your format at download time — no re-upload, no re-processing.

DCIM export profiles

Three platform-specific export profiles, each producing the exact format required by the target DCIM's bulk import API.

NetBox

CSVSlug-based

Produces a slug-based CSV compatible with NetBox's bulk import API. Device types are matched against the NetBox DeviceType Library — matched devices receive the canonical slug, unmatched devices are flagged in the pre-flight report.

Struktive fieldNetBox fieldNotes
normVendormanufacturer (slug)Slugified, e.g. dell-technologies
normModeldevice_type (slug)Matched against DeviceType Library
hostnamenameDirect mapping
normSerialserialNormalised serial number
normSitesite (slug)Slugified site name
normRackrack (name)Rack identifier
normUpositionU position (integer)
categoryrole (slug)Compute→server, Networking→network-device, etc.
normStatusstatusactive / planned / staged / decommissioning
Pre-flight validation

After download, a pre-flight summary panel shows what needs to be done in NetBox before running the import:

  • Custom roles that must be created in NetBox before import
  • Device types not found in the DeviceType Library
  • Site slugs that don't exist in the target NetBox instance
  • Records with missing mandatory fields (device type, site)

Device42

CSV3-row header

Produces a three-row-header CSV in Device42's bulk import format. Device42 auto-creates manufacturers, hardware models, buildings, and racks on import — no pre-flight object creation required. The most turnkey of the three profiles.

Struktive fieldDevice42 fieldNotes
hostnamenameRow 1: field name, Row 2: type, Row 3: value
normSerialserial_noNormalised serial number
normVendormanufacturerAuto-created if not found
normModelhardwareAuto-created if not found
normSitebuildingAuto-created if not found
normRackrackAuto-created if not found
normUstart_atU position (integer)
categorytypephysical / virtual / blade / cluster host
normStatusin_serviceyes / no
Pre-flight validation

After download, a pre-flight summary panel shows what needs to be done in Device42 before running the import:

  • Records with missing hostname (required by Device42)
  • Records where U position could not be parsed
  • Assets classified as Out of Scope (excluded from export)

Sunbird dcTrack

XLSXMulti-sheet

Produces a multi-sheet XLSX. The main sheet contains assets in dcTrack's import format with hierarchical location strings. A companion 'Models Not Found' sheet lists device types that must be added to the dcTrack Models Library before import.

Struktive fieldSunbird dcTrack fieldNotes
hostnameItem NamedcTrack field name
normVendorManufacturerDirect mapping
normModelModelMust exist in Models Library
normSerialSerial NumberNormalised serial number
location (hierarchical)LocationSite > Room > Rack > U format
categoryItem TypeMapped to dcTrack item types
normStatusStatusInstalled / Planned / Stored
Pre-flight validation

After download, a pre-flight summary panel shows what needs to be done in Sunbird dcTrack before running the import:

  • Models not found in dcTrack Models Library (listed in companion sheet)
  • Assets with incomplete location (site or rack missing)
  • Assets classified as Out of Scope (excluded from export)

Analysis report formats

Five additional report formats for compliance, capacity planning, energy reporting, and custom tooling.

Struktive Native CSV

A flat 30-column CSV with all normalised fields, quality score, classification confidence, pipe-delimited issues list, and chain-of-custody metadata. Intended for CMDB, ServiceNow, custom tooling, or any system that doesn't use one of the three DCIM profiles.

normVendor, normModel, hostname, normSerial, normSite, normRack, normU, normRow, category, classificationConfidence, qualityScore, issues, normStatus, ipAddress, owner, purchaseDate, warrantyExpiry, isDuplicate, isOutOfScope, processedAt, jobId

Asset Register XLSX

A formatted Excel workbook with the full normalised asset register, category colour-coding, quality score conditional formatting, and a summary row. Suitable for stakeholder reporting and manual review.

All normalised fields + quality score banding + category colour coding + summary totals

Compliance Audit Pack

A six-tab XLSX: Cover (with sign-off block), Asset Register, Transformation Audit Trail, Duplicate Detection Register, Exceptions Log (grouped by issue type), and Methodology. Maps to NIST 800-53 CM-8, ISO 27001 A.5.9, SOC 2 CC6.1, PCI DSS 12.5.1.

6 tabs: Cover, Asset Register, Audit Trail, Duplicates, Exceptions, Methodology

Capacity Summary XLSX

A six-tab XLSX: Cover, Site Summary (with EU EED threshold flag), Rack Utilisation, Power Density, Category Breakdown, and Data Quality Heat Map. Intended for DC operations managers and capacity planning teams.

6 tabs: Cover, Site Summary, Rack Utilisation, Power Density, Category Breakdown, Data Quality Heat Map

EU EED Pre-Report

Pre-populates the asset-derived fields of EU Energy Efficiency Directive Annex I and II: installed IT power demand, rack counts, server/storage/network/cooling counts, and UPS capacity. Exported as a structured CSV for upload to the EU EED reporting portal.

IT power demand, rack count, server count, storage count, network count, cooling count, UPS capacity, site name, reporting year

How to export

1

Upload your CSV

Upload any DC asset CSV. No template required — Struktive maps your columns automatically.

2

Normalise

The seven-stage pipeline runs in under 60 seconds. Review the results, quality scores, and exceptions.

3

Choose your format

Click Download and select your target platform or report type. The pre-flight summary appears after DCIM exports.

Ready to export?

Upload a CSV and choose your export format at download time. No account required.