Configure column set-column item properties in WQMS_Reports_Admin Excel file - Intergraph Smart WQMS - 6 - Administration & Configuration - Hexagon PPM

Intergraph Smart Weld Quality Management System Administration

Language
English
Product
Intergraph Smart WQMS
Search by Category
Administration & Configuration
Smart WQMS Version
6

In this section, you can define Column set, column item and their relationships that must appear in the reports.The ColumnSet-ColumnItem configuration for reports is maintained in the WQMS-Reports_Admin.xlsm file. This file is in located in the \\Smart WQMS\Models folder.

There are three kinds of column sets in the reports:

  • Header Column Set (HCS) - Contains properties of NOI, ROI, and project Information.

  • Weld Details Column Set (WDCS) - Contains drawing details of welds in an NOI or ROI.

  • Body Column Set (BCS) - Contains welds properties of a selected drawing.

To define column-set, column-items, and their relationship for the reports:

  1. Open WQMS-Reports-Admin Excel sheet.

  2. Navigate to ColumnSet sheet and edit the following properties to create a new column set:

    • UID - Type a unique identification name for the column set in the report.

    • Name - Type a name of the column-set.

    • Description - Type the description of the column-set in the report.

    • Solution(s) - Type * to load the data to SPF database, or type Deleted to avoid loading the data to SPF database.

    • ContainerID - Defines the package or .xml file that contains the object.

  3. Navigate to ColumnItem Sheet > SPFColumnItem section and edit the following properties to create a column item:

    • UID - Type a unique identification name for the column item in the report.

    • Name - Type a name of the column-item.

    • Description - Provide the description of the column item in the report.

    • Solution(s) - Type * to load the data to SPF database, or type Deleted to avoid loading the data to SPF database.

    • ContainerID - Defines the package or .xml file that contains the object.

  4. Navigate to ColumnItem sheet > SPFColumnSetColumnItem section and edit the following properties to create a relationship between column-set and column-item:

    • UID - UID1.UID2.

    • UID1 - Enter the UID that is created in ColumnSet sheet.

    • UID2 - Enter the UID that is created in SPFColumnItem section of ColumnItem sheet.

    • Description - Provide a description for the column item in the report.

    • OrderValue - Specify the order in which the modules must display in the UI.

    • WQMSDecimalPointPrecision - Specify the number of digits that must appear after decimal point for a value in the report.

    • WQMSCustomDisplayRegExpn - Use regular expressions to customize the pattern of value that appears in the report.

    • SPFCellDefaultCreateValue - Type the default value for the property that must appear in the report.

    • WQMSEnvVariable - Specify the property that must be mapped to the environment variable. This property must be appended to WQMSDummyProperty that populates the values in the reports.

      For example, ENV.CREATECONFIGUID~IWQMSProjectConfig.WQMSProjectNumber.

      Here IWQMSProjectConfig is the interface. Using this interface, WQMSProjectNumber property is mapped to the environment variable ENV.CREATECONFIGUID. This environment variable will be appended to WQMSDummyProperty. The value in this dummy property will be populated in the reports.

    • Solution(s) - Type * to load the data to SPF database, or type Deleted to avoid loading the data to SPF database.

    • ContainerID - Defines the package or .xml file that contains the object.