Using Bulk Asset Configurator

You can use the Bulk Asset Configurator to populate all your equipment and the equipment's properties. Typically, you would create an empty Bulk Asset Configurator file formatted as an Excel spreadsheet and modify that spreadsheet with the design of your system. For the Start-Up Guide, you can download and execute a preconfigured Excel spreadsheet to simplify this process and save you a lot of typing.

Prior to executing the Excel spreadsheet, open the file in Excel and examine its contents to understand the process. In the ClassInstantiation worksheet, you can see several rows and columns. Each column has a named header and each row represents one instance of a device or piece of equipment. For example, the first three rows represent your three tanks.

The following table describes the first eight columns on the ClassInstantiation worksheet.

Column

Description

TargetEquipment

The address to your equipment location under Project Explorer > Assets > Equipment, using the Name values for the equipment, and not the Display Name values.

For example, TFMS/TNK/ means Project Explorer > Assets > EquipmentTank Farm Management System > Tanks, and the Bulk Asset Configurator will create the equipment in this row at this location.

When instantiating equipment, the Bulk Asset Configurator creates the entire path to the equipment, even if that path previously did not exist. For example, if you set TargetEquipment to TFMS/TNK/FOLDER, the Bulk Asset Configurator automatically creates FOLDER under TFMS/TNK, even if FOLDER did not previously exist under TFMS/TNK.

InstanceName

The Name value for the new equipment, and not the Display Name value.

EquipmentClass

The complete path to the equipment class is used when instantiating the new equipment.

Param_Display

The Display Name that you created in the Tank equipment class. Note that the Bulk Asset Configurator is not case-sensitive.

Param_DEN

The value of the Real-time data tag that you created in the Tank's Density property. For example, (ua:DXPTankFarm\[urn:Takebishi:DxpOpcUaServer:customprovider]PLC01.Tank01.Density) represents the complete address of the incoming data for the Tank 01 property and it tells GENESIS where to find the Density value in real-time.

Param_DEPT

The value of the Real-time data tag that you created in the Tank's Depth property. For example, (ua:DXPTankFarm\[urn:Takebishi:DxpOpcUaServer:customprovider]PLC01.Tank01.Depth) represents the complete address of the incoming data for the Tank 01 Depth value.

Param_INR_PRES

The Real-time data tag value for the Tank's Inner Pressure property. For example, (ua:DXPTankFarm\[urn:Takebishi:DxpOpcUaServer:customprovider]PLC01.Tank01.Pressure) represents the complete address of the incoming data for the Tank 01 Inner Pressure value.

Param_TEMP

The value of the Real-time data tag for the Tank's Temperature property. For example, (ua:DXPTankFarm\[urn:Takebishi:DxpOpcUaServer:customprovider]PLC01.Tank01.Temperature) represents the complete address of the incoming data for the Tank 01 Temperature value.

The remaining columns are the Display Name parameters and associated properties for the rest of the equipment (Pumps, Valves, Pressure Indicators, and Flow Indicators). These act the same as the Tank columns. The Bulk Asset Configurator compares the Display Name parameter with the column name and populates the value with the contents of the current cell.