Bulk Slots from CSV Files

Utility to automatically create and set slots on many components and points using a single CSV file

Installation

1. Extract the zip file and copy the JAR file nmxcsvslot to your Niagara modules directory.

2. If Workbench is open, close it and relaunch.

3. If you are using this module on a local station, restart the station using the Application Director in your Platform.

4. If you are installing on a remote station, connect to the platform of the remote station. Go to the Software Manager and install the nmxcsvslot module to the remote station.

Usage

1. Drag the CSVSlot component from the palette and drop it anywhere in your station config tree.

2. In the property sheet for the CSVSlot component set the Container property using the Component Ord chooser. Its Ord should be the component that contains all of the points/components that will be listed in the first column of the CSV file.

3. In the property sheet for the CSVSlot component set the CSV File property using the File Ord chooser to the CSV file that contains the slot information.

4. Right-click on the CSVSlot component and go to Actions > Run CSV Slots

5. You will see the entire process output in your Application Director/station log.

6. The module can be removed and uninstalled from your station after you are done using it

CSV Notes

• It doesn’t matter what the first cell in the first column (A1 in Excel) has for a value but it must exist

• Each cell after the first in row 1 should be the exact (case sensitive) name of the slot you want to add/edit/remove

• Each cell in column 1 after row 1 should be the exact (case sensitive) name of the component that will be changed

• If you want to delete the slot on a particular component set the value of the cell to a single space

• If you want to ignore the slot on a particular component (it won’t be changed, added, or deleted) set the value to *

CSV Example

Component,building,equipment
Folder,test,test2
Folder1,test,test3
Folder2, ,test4
Folder3,*,*
Folder4,test,test6
Folder5,test,test7
Folder6,test,test8
Folder7,test,test9

Example Line-by-line Breakdown

Line #1 (configuration line): Component,building,equipment
Component is a placeholder and ignored. building and equipment are the two slots that will be used for the items below.

Line #2: Folder,test,test2
The component specified in the Container property is searched for a child named Folder and its building slot is set to test, and its equipment slot is set to test2 (slots are created if they don’t exist).

Line #4: Folder2, ,test4
The component specified in the Container property is searched for a child named Folder2 and its building slot is deleted if it exists, and its equipment slot is set to test4

Line #5: Folder3,,
The component specified in the Container property is searched for a child named Folder3 and ignores both the building and equipment slots (doesn’t matter if they exist or not, they will not be created or modified).

The unmentioned lines function exactly like Line #2.

Copyright 2020 NiagaraMods