Example: Load a Spreadsheet that Contains Change Specifications

Use GRLoader to load a Change Order with multiple change specifications.

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

objecttype	chg	ci	attribute_name	attribute_value_planned
change specification	12345	server1	ip address	1.2.3.4
change specification	12345	server2	ip address	1.2.3.5
change specification	12345	server3	ip address	1.2.3.6
change specification	12345	server4	ip address	1.2.3.7

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 Sheet13

GRLoader creates four CIs and inserts the CIs into Change Order 12345.