Bulk insert/update Configuration Item(CI) in SDM using grloader

Document ID : KB000010719
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

How to insert CI into SDM using Grloader

Instructions:

     1.       Navigate to path <NXroot>\CA\Service Desk Manager\samples\GRLoader

          Which will have the OOTB sample Grloader spreadsheet.

          1.PNG

2.       Make a copy of the “Grloader sample spreadsheet” on to local machine or on server where it can be edited.

Inserting new CI:

------------------------

3.       With OOTB functionalities only “Class” and “Name” fields are mandatory. So, filled the required fields.

Example: In the below screenshot trying to load 2 CI’s “Test CI1” and “Test CI2”

2.PNG

4.       Now save the file and copy it to server if edited on local machine.

5.       From SDM server: Open the command prompt and navigate to path where you saved the Grloader file you want to load and run the command:

3.PNG

 grloader -i grloader_sample_spreadsheet.xlsx -a -n -E -u servicedesk -p password

Note: You can get the command from same excel sheet. Please check the image 2.

6.       The output of the command ran will give us the output on if the CI’s are inserted or updated or errors.

7.       Can verify the same from SDM application.

4.PNG

 

Inserting new CI with extra fields and updating existing CI:

--------------------------------------------------------------

8.       If there are other fields that are mandatory to be filled while creating CI, you have get the correct Column name of that field from Data base and use it in same excel sheet

 Example: In below example, considered that hostname, mac address and serial number are mandatory fields.

 Added columns in same Sheet 1 of “Grloader sample spreadsheet”

From DB, got the Columns name of those fields as below:

Hostname: host_name

Mac address: mac_address

Serial number: serial_number

5.PNG

9.       Repeat steps from step 4 to step 6 to see the output.

Note: If CI already exists in SDM and you have used it again in grloader sample spreadsheet, it will Update the CI with new values.

6.PNG

10.   From SDM:

7.PNG

8.PNG

Grloader log file will be created under SDM-> log folder for every success or failure transaction.