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.
Mapping Things to Multi-Space Zones
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 |