Working with User Defined Types Using Excel Add-In

Before importing a User Defined Type set into Historian from an Excel Worksheet, you can perform the following actions:

To add User Defined Types:

  1. Enter details into the columns in the excel worksheet.
    Note: The columns are listed here according to the way they appear in the Excel worksheet. However, it is recommended to fill the columns in the following sequence: UserDefinedTypeName, User- DefinedTypeDescription, FieldName, FieldDescription, FieldDatatype, IsMasterField, NumberOfFields, StoredFieldQualities and AdminSecurityGroup.
  2. Click Import UserDefinedTypes to import the types.

To modify the description of a User Defined Type:

  1. Click in the User Defined Type Description cell and modify the description.
    Note: You cannot modify the name of the type. If you change the name of the type, it is considered as a new type.
  2. Click the Import User Defined Types to import the types.

To add fields:

  1. Select the UserDefinedType to which you wish to add a field.
  2. Add the name of the type in the UserDefinedTypeName column. The name should be same as the type selected by you.
  3. Enter the details in the UserDefinedTypeDescription, FieldName, FieldDescription, FieldDatatype, IsMasterField, NumberOfFields, StoredFieldQualities and AdminSecurityGroup columns.
  4. In the NumberOfFields column, enter the total number of fields. Ensure that this value is the same for the current field and existing fields in the user defined type.

    For example, if a UserDefinedType has two fields already and you are adding a third field, the number of fields for all the three fields should be changed to three. A new field is added to the UserDefinedType on import.

To modify fields:

  1. Select the field you wish to modify by clicking the row in the Excel worksheet.
  2. Modify the values by clicking in the respective columns. The field/fields are modified on import.

To delete fields:

  1. Select the row that has the field you wish to delete.
  2. Right-click the row and select Delete. Alternatively, you can also use the Delete key on your key- board.
  3. Click the Import UserDefinedTypes to update your changes.