Prepare select list definitions - Intergraph Smart Engineering Manager - Help - Intergraph

Metadata Import Utility Help

PPMProduct
Intergraph Smart Engineering Manager
PPMCategory_custom
Help
Version_SPEM_custom
7.2 (2014 R2)

The Select List worksheet allows you to add or modify values for select lists and select list entries.

  1. In the Excel file, click the Select List tab to display the Select List Definitions worksheet.

  2. Place the cursor in the last cell of the table in Column G (Dependent List/Value) and press the Tab key.

    A new table row is added and the cursor moves to the first column of that row.

    When adding new data rows on the worksheet, you must ensure that those rows are added inside the Excel table in which the headers are located. For more information about adding rows, refer to the Microsoft Excel Online Help topic Resize a table by adding rows and columns.

  3. In the new row, enter values in the columns according to what you want to do as shown in the following table.

    What do you want to do?

    Current Select List

    Select List

    Current Value

    Value

    Create a new select list

    Blank

    <New value>

    Blank

    Blank

    Modify an existing select list

    <Existing value>

    <New value>

    Blank

    Blank

    Create a new select list entry in an existing select list

    <Existing value>

    <Existing value> or blank

    Blank

    <New value>

    Modify a select list entry in a select list

    <Existing value>

    <Existing value> or blank

    <Existing value>

    <New value>

    • The Current Select List and Select List columns should be blank in the row where the values for the select list appear. Select list entry values that you want to add or modify are added in the succeeding rows below the row where the select list is entered.

    • It is not possible to modify a select list entry using the Metadata Import Utility if the current value of that select list entry in the database is blank. In such cases, the software ignores the blank database value and treats that value as if it were a non-existent row; that is, it creates a new select list entry.

  4. In the Disable column, select No for the select list entries you want to appear in the program interface.

  5. To make another select list or select list entry dependent on a select list or select list value, type an appropriate value under the Dependent List/Value column.

  6. Save the Excel file.