Managing Configuration Items › Manage Staged Transactions › Populating the TWA › How to Load Data into the TWA Using GRLoader › lookup

lookup

When you specify data for lookup (SREL) attributes in the TWA, they must have the same format as if specified in native XML for GRLoader. Lookup attributes accept only a specific set of values that must be defined in related tables in CA SDM. These attributes also can have additional restrictions and exceptions that must be met for the assignment to occur. The specified values are the same whether specified using XML, SQL, or the TWA web interface.

To determine whether an attribute is an SREL, refer to the following CA CMDB Technical Reference sections:

• Families and Classes (SREL attributes are identified)
• Contact and Other Lookup Fields
• Fields Validated Against Data in Existing Tables (SREL)

Example: lookup XML

In the following example, the alternate SREL column is set by specifying the lookup parameter:

<ci>
<name>server1</name>
<owner lookup="userid">mckpe99</owner>
</ci>

In the TWA, the same thing can be accomplished by suffixing the alternate SREL column to the data value, surrounded by delimiters (see the following grloader.workarea.delimiters). The equivalent transaction is represented in the transaction work area as:

You also can set the delimiter character used above in the grloader configuration file:

grloader.workarea.delimiters=xy

x and y are different characters that typically do not appear in the work area.