How to create a Multi-Zone Space

If your use case has a Space (Room) as a parent entity of multiple Zones, the CSV connector can accommodate this by default. The default Invert Space Zone Relationship setting (false) creates the relationship Zone->isPartOf->Room for Zones and Spaces mapped together in the same row.

Mapping Things to Multi-Zone Spaces

Thing located in parent Space

If each Thing is located in the parent Multi-Zone Space, this can be imported with one sheet. Here's an abridged example:

This will create these relationships:

• VAV01->hasLocation->ROOM 101 and HVACZONE01->isPartOf->ROOM101
• VAV02->hasLocation->ROOM 101 and HVACZONE02->isPartOf->ROOM102

Thing located in a Space other than the parent

However, if each Thing feeding the Multi-Zone Space is located in some other Space -- not the parent Space of the HVAC Zone it feeds -- this use case can be accommodated with multiple imports to the same CSV connector. 

The Advanced Config setting for Invert Space Zone Relationship should be false or left as default (blank) for each step. Executing each step in the order below is also important.

1. First, import First import Things & Spaces (along with Building, Floors in each relevant row), where the Space is the actual location of the Thing. This creates the desired Thing→hasLocation→Space relationship.
2. After setting the Thing's location, import Spaces & Zones, where the Spaces are the parent Spaces of each Zone. This creates the relationship Zone→isPartOf→Space and avoids mapping Things to Spaces where they aren't actually located.
3. Finally, import Things & Zones. This creates the relationship Thing→feeds→Zone for each Zone that makes up the Multi-Zone Space.

Abridged Examples

First: Import Things & Spaces (leave Zone columns blank)

Second: Import Spaces & Zones (leave Thing columns blank)

Third: Import Things & Zones (leave Space columns blank)

If you need further assistance, contact Mapped Support.