Previous Topic: Example: Load a CI with Multiple Embedded RelationshipsNext Topic: Example: Load a Spreadsheet that Contains Change Specifications

General Resource Loader (GRLoader) › How to Prepare for Loading Spreadsheet Data › Example: Create a CI and a Relationship by Specifying the UUID

Example: Create a CI and a Relationship by Specifying the UUID

Use GRLoader to load a spreadsheet that contains CIs and relationships by specifying the UUID.

In the following example, the # transaction column begins on row A1 in Sheet12 of grloader_sample_spreadsheet.xls:

# transaction

objecttype

name

class

provider_id

type

dependent_name

1

ci

server1

Server

 

 

 

2

relation

 

 

12345678901234567890123456789012

uses

server2

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 Sheet12 -n

GRLoader creates the following CIs and relationships: