General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data › Translation Rule Spreadsheet Attribute Mapping

Translation Rule Spreadsheet Attribute Mapping

Column names typically define the same CI or CI relationship attribute names. If the names differ, use a translation file to convert a column heading to an attribute name.

Important! The first row of the selected input area is significant because it contains column headings.

You map attribute names by including a rule which specifies a rule for the new keyword attribute name named attributename. GRLoader processes rules for attributename before applying value maps. A rule which specifies <attribute>attributename</attribute> is an attribute map, not a value map, so it changes the attribute name of an attribute, not the value of the attribute data.

For example, CA SDM requires that you load the IP address of a CI into a field named alarm_id. If the spreadsheet column name is ip address, use a translation rule to map ip address to alarm_id by using the following translation rule:

<rule>
   <attribute>attributename</attribute>
   <from>ip address</from>
   <to>alarm_id</to>
</rule> 

Mapping an attribute name to “” (blank) is equivalent to ignoring that attribute. In the following example, GRLoader ignores all owner data:

<rule>
   <attribute>attributename</attribute>
   <from>owner</from>
   <to></to>
</rule>