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

Setting Default Attribute Values

In a typical business environment, you use an existing spreadsheet as an input to GRLoader. We recommend that you do not change the content in the spreadsheet. If that spreadsheet is incomplete and does not contain information necessary to import the data, you must specify the –ad (attribute default) option on the command line, as shown in the following example:

grloader -u username -p password -s http://sdm-host:8080 -i myspreadsheet.xlsx -ad tenant=tenanta -ad mdr_class=spreadsheet -ad mdr_name=mdr1 -n

You can specify any attribute with the –ad option. For example, set a default IP address with the following command:

grloader -u username -p password -s http://sdm-host:8080 -i myspreadsheet.xlsx -ad alarm_id=”Unknown” -n

If a row in the spreadsheet contains a value for alarm_id, then the default value is not used.

You can also specify attribute defaults for relationships. If myspreadsheet.xlsx contains both CIs and relationships, the relationships receive a warning message because alarm_id is not a valid relationship attribute. In this case, use the -iia parameter in GRLoader to ignore the invalid attribute name because this option suppresses the warning message.