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

Example: Load a CI with Multiple 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 Sheet11 of grloader_sample_spreadsheet.xls:

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

GRLoader creates the following CIs and relationships:

• The first three rows create three CIs.
• Row 4, processed after rows 1-3, creates the following CI relationships:
  • chief manages agent86
  • chief manages agent99
  • chief is managed by CEO
• As with XML input, the direction of the relationship is significant. In the manages column labeled, GRLoader creates two relationships, because chief is the provider for both dependents, agent86 and agent99.
• Because the is managed by attribute is a dependent/provider relationship type, the provider and dependents are switched in the is managed by column, because chief is a dependent and CEO is the provider.