Defining the terminal data

The terminal data is saved in file called Terminal.csv that you need to create and add content to.

Procedure

  1. Go to /opt/IBM/energy/data/<your_directory_name>/terminals on the application server, and create a file named terminal.csv.
    Note: The directory <your_directory_name> is created by you and has the name that you require.
  2. Add the following content to the file: 
    mRID,isActive,name,description,sequenceNumber,connected,phases,resource,connectivityNode
    The data in the terminal.csv file is loaded to the ObjectID, Resource and Location tables. The columns in the .csv file include:
    Table 1. The columns in the .csv file
    Field Type Description
    mRID VARCHAR(256) Master resource id. A string based identifier of the terminal.
    isActive CHAR(1) Indicates if current terminal is active.
    name VARCHAR(128) The name of the terminal.
    description VARCHAR(512) Description of terminal.
    sequenceNumber INTEGER The sequence number of terminal. If a resource has multiple terminals, the sequence number is used to order the terminals in sequence.
    connected CHAR(1) Indicates if the terminal is connected.
    phases VARCHAR(32) The phases of the terminal.
    resource VARCHAR(256) The mRID of the resource that the terminal is connected to.
    connectivityNode VARCHAR(256) The mRID of the connectivity node that the terminal is connected to.

    The meter asset is connected to distribution transformer through terminals and connectivity nodes. If the meter Meter_1813699 is connected to the distribution transformer DT_101221, the terminal of Meter_1813699 is Terminal_Meter_1813699_1 and the terminal of DT_101221 is Terminal_DT_101221_2. The two terminals are both connected to connectivity node CN_cn85555. Here is a diagram for the connection information:

    Figure 1. A diagram that shows the connection information
    Connectivity node with two terminals, one for the meter 1813699 and one for a distribution transformer 101221.
  3. Here is a sample Terminal.csv file. 
    mRID,isActive,name,description,sequenceNumber,connected,phases,resource,connectivityNode
"Terminal_Meter_1813699_1","1","Terminal 1","Terminal 1","1","1",,"Meter_1813699","CN_cn85555""1",
"Terminal_DT_101221_2","Terminal 2","Terminal 2","2","1",,"DT_101221","CN_cn85555"