CSV Import Templates
Downloading an Import Template
In Commissioner, to download a CSV import template, select Save Import Template File from the file menu.
- Select the PMU import template if you wish to build a detailed map file based on fixture serial numbers, zone assignments, network settings, and (optionally) exact positioning as specified by X and Y coordinates.
- Select the Zone import template to build a skeleton map file containing only zones and the corresponding network IDs, active power level, inactive power level, and sensor delay for each zone.
- Select the Geometric import template to build a map file based on relative fixture position and fixture serial numbers.
PMU Template
Serial Number: The fixture serial number (required data).
Name: The fixture name (optional).
Zone: The fixture's zone assignment (optional). Note that if a zone is not imported, Commissioner will create a new zone.
Zone Network: The zone's network assignment (optional). If importing into a map file with existing zones, and the zone exists on a different network, the zone will be moved to the network specified in the .CSV file.
PMU Network: The fixture's "source" network (optional). This tells Commissioner where to discover the fixture prior to programming into the zone network. Note that if a PMU Network is not specified, Commissioner will use the factory default network, A01.
X: The fixture's position coordinate on the horizontal axis (optional).
Y: The fixture's position coordinate on the vertical axis (optional).
Expected Children: Number of connected LLEs or third-party luminaires (use this field only when the "fixture" is a DLA).
Tip: The 0,0 origin is the upper-left vertex of the map grid (where the fixture target is located when you create new map file). Each line on the map grid is 20 points away from the next closest line in the same axis. Therefore, if, for example, you enter an X coordinate of 100, and a Y coordinate of 20, the fixture will be placed on the fifth line to the right of the origin and one line below the origin.
Description: Text description of the fixture (optional).
Zone Template
Use the zone template to build a skeleton map file based on zones. This is a time saving measure for building a partially complete map file when you know the room layout of a facility, and how you want the zones to operate, but you do not have a sticker book containing fixture serial numbers.
Geometric Template
Use the geometric template to rapidly create a grid of fixtures based on serial numbers. Each line of the file is serial numbers entered in CSV form that are imported into their relative locations in the CSV.
For example, the following:
06000001, 06000002, 06000003
06000004, , 06000006
imports three fixtures across the first row, then two fixtures with a space between them in the second row.
This is a time saving measure for building a partially complete map file when you already have a detailed sticker map (assign zones, networks, etc after importing the grid into Commissioner).