Previous Topic: Example: Load a Spreadsheet with Column Names that Contain Invalid CI Attribute NamesNext Topic: Example: Load a Spreadsheet that Rejects Bad Data

General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data › Load a Spreadsheet that Does Not Contain mdr_name or tenant

Load a Spreadsheet that Does Not Contain mdr_name or tenant

Use GRLoader to load a spreadsheet that does not contain mdr_name or tenant. You can set attributes from the command line. The name column begins on C5. The column headings match CI attribute names in the following example in Sheet8 of grloader_sample_spreadsheet.xls:

name

class

tenant

federated_asset_id

server1

Server

 

f1

server2

Server

 

f2

acd1

ACD

tenantb

f3

server3

Discovered Hardware

tenantb

f4

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 Sheet8 -ssfr 5 -ad tenant=tenanta -ad mdr_name=ACMserver1 -ad mdr_class=ACM12 -n

GRLoader assigns server1 and server2 to tenanta, assigns all CIs with the mdr_name as ACMserver1, assigns all CIs with the mdr_class as ACM12, and loads the four CIs with no errors.