Example: Load a Spreadsheet with Column Names that Contain Invalid CI Attribute Names

General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data › Example: Load a Spreadsheet with Column Names that Contain Invalid CI Attribute Names

Example: Load a Spreadsheet with Column Names that Contain Invalid CI Attribute Names

Use GRLoader and translation file to load a spreadsheet with column names that contain invalid CI attribute names. The name column begins on row C5. The column headings match CI attribute names in the following example in Sheet7 of grloader_sample_spreadsheet.xls:

name	class		hard_drive_capacity	carrier	phys_mem
server1	Server	ignore	ok		ok
server2	Server	ignore	ok		ok
acd1	ACD	ignore		ok	ok
server3	Discovered Hardware	ignore			ok

Before you run GRLoader, create a translation file named Sheet7.rul that contains the following XML:

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

After you create this XML file, load the data with GRLoader by executing the following command:

grloader -u username -p password -s http://sdm-host:8080 -i grloader_sample_spreadsheet.xls -sss Sheet7 -ssfr 5 -tf Sheet7.rul -n

GRLoader ignores the first four rows and column E because E5 is empty, and loads four CIs with no errors.