Commission a Lighting Device: Import CSV Data

Please review the Methods of Commissioning Lighting Devices before proceeding with the steps below.

The guide below details how to add fixtures using the import CSV data method. This method is recommended for all new installations larger than 50 lighting devices (sensors/fixtures). It is not recommended for small additions or troubleshooting.

This is an efficient method to add new lighting devices in large facilities. The commissioning agent will create a CSV file of device serial numbers using a barcode scanner, then import the file to Commissioner. The imported devices can then be quickly organized on the mapfile grid, associated with Zones, and renamed before being sync'd later on.

1. Open Commissioner
   
2. Navigate to File > Save Import Template File
   
3. Select the desired file type and format
   
1. PMU: import based on device serial numbers, zone assignments, network settings, and exact positioning as specified by X and Y coordinates. This is a time saving measure to build a partially complete map file when the layout of the facility and operation of the zones is known
2. Geometric (most common): import based on relative device position and serial numbers. For example, build a table with 3 columns and 10 rows to create a map containing a 3 x 10 grid of devices
3. Zone (Zones only): 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
   
   
   
   
4. Click Ok, and select a known location on the computer then click Save
   
5. Close Commissioner, then open the file saved in the previous step (most commonly, in Excel)
   
6. Fill in the required data for the template
   
1. For PMU and geometric imports, we recommend connecting a barcode scanner. Scan barcodes from the installer sticker map
2. For geometric imports, we recommend breaking imports into logical smaller facility parts to stay organized
7. Once complete, save the file as a CSV in a known location
   
8. Close the file and open Commissioner
   
9. For PMU and geometric imports: Move the target to the upper-left-most point of the desired import location on the grid
10. Click File > Import Map Data, then select the file
    
11. Once the import is complete, select and drag fixtures into position, and use the Fixture Spacing tool to place
    
1. For geometric imports, remember to edit fixtures and assign them to a Zone (select multiple fixtures and right-click to bulk edit)

• Related Articles

• Methods of Commissioning Lighting Devices

  Before new lighting devices will work with SiteWorx, they must be added to a Mapfile and commissioned to a gateway. This process is completed by installers or a commissioning agent using the Commissioner software program in combination with a USB ...

• Commission a Lighting Device: Wireless Discovery

  Please review the Methods of Commissioning Lighting Devices before proceeding with the steps below. The guide below details how to add fixtures using the import CSV data method. This method is recommended for additions of 10 or less lighting devices, ...

• Commission a Lighting Device: Serial Number Entry

  Please review the Methods of Commissioning Lighting Devices before proceeding with the steps below. The guide below details how to add fixtures using the serial number entry method. This method is recommended for installations under 50 lighting ...

• Data View

  The data view section of Commissioner contains key details of devices in a map, and its location is movable using the View menu. Fixtures (includes lighting sensors) Fixtures and sensors appear both on the map grid and in the fixture tab. However, ...

• Commission a TRH

  Before a Temperature and Relative Humidity sensor (TRH) will work with SiteWorx, it must be added to a Mapfile and commissioned to a gateway. This process is completed by installers or a commissioning agent using the Commissioner software program in ...