How to create a Multi-Space Zone

If your use case has a Zone as a parent entity of multiple Spaces (Rooms), the CSV connector can accommodate this with the Invert Space Zone Relationship option set to true in the Advanced Config.

Diagram of a Multi-Space Zone, where a Zone contains three Spaces with a Space->isPartOf->Zone relationship.

Mapping Things to Multi-Space Zones

Diagram of a Multi-Space Zone, where a Zone contains three Spaces with a Space->isPartOf->Zone relationship, and the Zone isFedBy a Thing..

Things cannot be mapped to more than one Space in a single CSV import because it will cause a conflict when the places are provisioned. Read more: What does the error "Provision Failed - RefIds are shared..." mean?

To avoid this clash, import Things & parent Zones in one sheet, and child Spaces & parent Zones in another sheet, all through the same CSV connector.

  • In the CSV connector Advanced Config, set Invert Space Zone Relationship to false and import Things & Zones (along with Building, Floors in each relevant row) in one sheet. This creates the Thing→Feeds→Zone relationship.
    • If the location of the Thing should be a specific, unique Space, populate the relevant Space data in this import. Make sure to import this sheet first if setting the Thing's location to a Space!
    • Leave the Space columns blank and the Thing's location will be assigned to the Floor.
  • In the Advanced Config, set Invert Space Zone Relationship to true and import the child Spaces & parent Zones in another sheet (along with Building, Floors in each relevant row). This creates the Room→isPartOf→Zone relationship.

Abridged Examples

Set Invert Space Zone Relationship to false and import Things & Zones. 

  • Leave Space columns empty to assign the Thing's location to the Floor.
  • Populate the Space columns with a specific, unique Space to assign the Thing's location to that Space.
zoneRefId zoneName zoneExactType thingRefId thingName thingExactType
HVACZONE01 HVAC Zone 01 HVAC_ZONE VAV01 Room 202 VAV Variable_Air_Volume_Box

Set Invert Space Zone Relationship to true and import child Spaces & parent Zones (leave Thing columns blank):

spaceRefId spaceName spaceCode zoneRefId zoneName zoneExactType thingRefId
ROOM101 Room 101 101 HVACZONE01 HVAC Zone 01 HVAC_ZONE  
ROOM103 Room 103 103 HVACZONE01 HVAC Zone 01 HVAC_ZONE  
ROOM107 Room 107 107 HVACZONE01 HVAC Zone 01 HVAC_ZONE  
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request