Example: Load CI Data from the Extension Table

General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data › Example: Load CI Data from the Extension Table

Example: Load CI Data from the Extension Table

Use GRLoader to load a spreadsheet with CI data, including data from the extension table. The column headings match CI attribute names in the following example in Sheet2 of grloader_sample_spreadsheet.xls:

name	class	alarm_id	hard_drive_capacity	carrier	phys_mem
server1	Server	1	5		7
server2	Server	2	6
acd1	ACD	3		carrier1
server3	Discovered Hardware	4

To load the data with GRLoader, execute the following command:

grloader -u username -p password -s http://sdm-host:8080 -i grloader_sample_spreadsheet.xls -sss Sheet2 -n

GRLoader loads four CIs with no errors, including family-specific attributes.

If the data is offset from the A1 cell in Sheet3 in the spreadsheet, and the data has blank rows and columns, load the data by executing the following command:

grloader -u username -p password -s http://sdm-host:8080 -i grloader_sample_spreadsheet.xls -sss Sheet3 -n

GRLoader ignores blank rows, columns, and cells, and loads four CIs with no errors.

If the data in Sheet4 contains missing (or blank) column headings, such as E5, execute the following command:

grloader -u username -p password -s http://sdm-host:8080 -i grloader_sample_spreadsheet.xls -sss Sheet4 -n

GRLoader ignores the empty Column E (E5) and loads four CIs with no errors.

If the data in Sheet5 contains four rows that you want to ignore, and the CI data begins on the C5, execute the following command:

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

GRLoader ignores the first four rows and loads four CIs with no errors.