Dynamic Data Import & Export enables scheduled, bidirectional data synchronisation between Innomesh and external systems such as facilities management platforms, CMDB tools, and asset registers. Data flows through a shared S3-based repository — external systems push files in, Innomesh processes them and can push derived data back out.
How It Works
The pipeline has three stages: inbound, transformation, and outbound.
Inbound (Import)
An external system pushes a JSON or CSV file to the communal data import repository (an S3 bucket) on a configured schedule (minimum weekly). Innomesh detects the upload, ingests the file, and populates dynamic room fields in the Information Portal. Dynamic fields are auto-updated and not user-editable.
Transformation (Smart Room Attributes)
On a configured schedule, a transformation process analyses data from the Information Portal (both dynamic and static room fields) along with room configuration data. It derives Smart Room Attributes for each room and stores the results in the room attribute data store.
Outbound (Export)
Innomesh collects data from the room attribute store, room and asset records, and the data lake, then pushes it to the communal data export repository in the configured format. The external system retrieves the file on its own schedule.
Data Formats
Both import and export support JSON and CSV. Field keys in the source file must match the target field names configured in the import definition. Export configurations can include a {timestamp} placeholder in the filename to accumulate multiple exports without overwriting prior files.
Import Configuration
Import configurations are managed in Innomesh Portal under Administration > Smart Room Attributes. Each configuration defines:
- The filename pattern and file format (JSON or CSV) to ingest
- How to derive field values from the incoming data
- Which dynamic room fields to populate
Multiple import configurations can be active simultaneously, each targeting different source files or field sets.
Smart Room Attributes
Smart Room Attributes are derived values computed from room configuration data and room information fields. They can be viewed per room or across rooms in Summary Views.
Attribute Types
| Type | Description |
|---|---|
| Boolean | True/false based on match conditions |
| Number | Integer or calculated value (count, sum, or extracted number) |
| Text | String or concatenated values extracted from data |
Data Sources
Each attribute draws from exactly one source:
- Room Configuration — queries the room’s JSON configuration structure using JSONPath
- Room Information — queries flat fields in the Information Portal
Match Conditions
Match conditions define how an attribute value is derived. Conditions can be combined using AND (all must match) or OR (at least one must match) logic.
For Boolean attributes:
| Source | Strategies |
|---|---|
| Room Configuration | Element is present / not present / matches regex |
| Room Information | Field is present / not present / field matches regex |
For Number attributes (Room Configuration source):
| Strategy | Description |
|---|---|
| Value of first element | Extracts and converts the first matching element to a number |
| Count of elements | Counts matching elements (single element = 1) |
| Count of regex matches | Filters an array by regex and counts matches |
| Sum of elements | Sums values in a numeric array |
For Text attributes (Room Configuration source):
| Strategy | Description |
|---|---|
| Value of first element | Returns the first matching element |
| Value of all elements | Returns all matching elements, comma-separated |
| Value of first regex match | Returns the first regex capture group |
| Value of all regex matches | Returns all regex captures, comma-separated |
Export Configuration
Export configurations define what data to push and when. Each configuration specifies:
- Data type: Alert history, asset attributes, room attributes, room usage data, or user interaction data
- Fields: Which attributes or fields to include (selectable per data type)
- Schedule: Cron expression with a human-readable translation shown in the UI
- Time range: For time-bound data types (alert history, usage, interactions)
- Filename: Static name or template using
{timestamp} - Format: CSV or JSON
An Export Now option is available for on-demand exports without waiting for the next scheduled run.
Viewing Attributes in the Portal
Smart Room Attributes are surfaced in two places:
Single room view Attributes are displayed in the Room Attributes section of the room information view, grouped by user-defined grouping.
Summary Views Multi-room views can be configured under Administration > Smart Room Attributes > Summary Views. Each Summary View presents a selectable set of static room fields and Smart Room Attributes across all rooms in a single table. Views can be reordered and one can be set as the default. See Summary Views for configuration steps.