Site Configuration Using a CSV File

If the Lighting Installer app isn't an option for you, the next most efficient means of site configuration is a comma separated value (CSV) file. SimplySNAP can export an existing lighting setup to .CSV, which you then edit in a spreadsheet or text editor. Once new lights are added in, you can import the .CSV file with the new lights added.

For information on creating the initial .CSV file, see Importing and Exporting Light Configurations using a .CSV File

To configure a site using a .CSV file:

1. Click the Export Lights button to generate the initial .CSV file.
2. Open the .CSV file. You'll notice 12 column headings corresponding to the configuration information for lighting controllers.

Table 2.1: .CSV File Fields

Field Name	Description	Acceptable Input Values
* name	The user defined name of the light.	A string of characters
* snapaddr	The 6 or 16 digit SNAP Address for the light, in hex format. (For example, 1cd2e3 or 001c2c1b2606e458.)	Six digits
* type	The type of light controller that is being configured.	Acceptable values are: DIM10-087-00 DIM10-087-04 DIM10-100-00 DIM10-250-11 DIM10-281-21 DIM10-283-20 LP001-001 LP002-001 LP150-00 OCF01-10T OCF01-1RT TL5-B1
description	A general description of the light.	A string of characters.
zones	The groups this light is included in. All lights are always included in the "All" group. Up to eight additional zones may be configured.	List Zone names separated by the | character. For example: Zone 1|Zone 2
* power_on_level	The brightness level for the light when power is cycled, provided the light supports dimming.	A number, 1 - 100 (Default is 80)
* slot	Reserved for future use.	0
y	The geographic longitude for the light.	A single longitude entry
x	The geographic latitude for the light.	A single latitude entry
location_id	A user defined location id, such as pole number, office number, etc.	A string of characters
street_address	The street address where this light is located.	A string of characters
* antenna_compensation	Determines the power of communication signals transmitted from the Lighting Controller. (Use 'North America' if you do not know what to use.)	North America CE

* Indicates a Required Field

NOTE: Field names don't necessarily correspond to what you'll see in the user interface.

3. Enter each new light as a separate row in the .CSV file. When all lights are entered, save the file, click the Import Lights button, and follow the on-screen instructions to upload the new lights.