Previous Topic: Example: Load a Spreadsheet that Rejects Bad DataNext Topic: Loading Relationship Data from Spreadsheets

General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data › Example: Load a Spreadsheet Using Embedded Relationships

Example: Load a Spreadsheet Using Embedded Relationships

Use GRLoader to load a spreadsheet that contains CIs and relationships using embedded relationships. If you want to specify more than one identifying attribute, you cannot use embedded relationships.

In the following example, the name column begins on row A1 in Sheet10 of grloader_sample_spreadsheet.xls:

name

class

connects to

hosts

accounting

Service

 

 

server1

Server

 

accounting

server2

AIX

server1

accounting

server3

UNIX

 

GIS

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 Sheet10 -aer yes -n

GRLoader creates the following CIs:

GRLoader creates the following relationships: