CA Service Management

Back to Library

CA SDM: GRLoader - Everthing you need to know - Loading Configuration Item

Recommend

Sep 18, 2015 11:16 AM

TMACUL

Another vision about Jim_Bauman document

CA SDM: GRLoader - Everthing you need to know.

Where are the GRLoader Transaction rules located in CMDB r12.x?

"The GRLoader Translation rules in CMDB r12.x are located in java/lib/grloader folder"

TEC511800

A. How to do

Images	Description
	01. Create some folder for your work MS DOS command Example: md 1grloader
	02.Copy grloader.exe
	03. Copy the files below and the Grloader folder from $NX_ROOT\java\lib Grloader.jar dom4j.jar poi-ooxml-schemas.jar poi.jar poi-ooxml.jar xmlbeans.jar
	04. Copy excel example from $NX_ROOT\samples grloader_sample_spreadsheet.xlsx
	05. Run GRloader command grloader -i grloader_sample_spreadsheet.xlsx -a -n -E -u servicedesk -p servicedesk What means commands: -i * - Input XML file -a - Allow updates to Configuration Items -n - Allow new CIs to be created -E - Allow overwriting of output XML files -u * - Userid for logon

TIPs to use TWA

GRLoader - TWA Options

-lftwa - use transaction work area(twa) instead of xml input file

-lttwa - write input file to twa

-chg *** - only process twa transactions for this change reference

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

-N *** - Path to nx.env, used when running JVM only

-cfg *** - configuration file. enter grloader -hc for details

Command example:

grloader -N GRLoader_12.7 -cfg LFTWA.cfg -lftwa -u user -p password

B. Parameter for grloader command

Parameter	Description
Required
-u	Userid for logon
-p	Password for logon
-s	Server URL including port (I.E. http://localhost:8080

Parameter	Description
Optional
-cfg	configuration file. enter grloader -hc for details
-i	Input XML file
-e	Error XML file (defaults to inputname_err.xml)
-N	Path to nx.env, used when running JVM only
-v	Show GRLoader version
-h	This help
-hc	configuration file help

Parameter	Description
Processing Options
-a	Allow updates to Configuration Items
-n	Allow new CIs to be created
-maxerror n	set maximum number of errors
-maxwarn n	set maximum number of warnings
-maxci n	maximum number of CIs to process
maxrel n	maximum number of relationships to process
-cor	change order required
-iia	- ignore invalid attributes
-addjar ***	adds specified jar to grloader classpath
-aer yes/no	allow embedded relationships (yes)
-P	Preload data - improves performance for large processing
-slump	- use slump protocol (may require addditional configuratio n)
-tf ***	file name to be used to translate values of attributes
-D ***	Name prefix for relations (defaults to "GRLoader")
-I	Ignore case of lookup attributes
-E	Allow overwriting of output XML files
-ad *=*	Set attribute default value
-ua	Update always. Disables identical data optimization

Parameter	Description
Output Options
-T ***	Trace Level
-C	Check input XML only
-simci	simulate ci operations only
-simrel	simulate relationship operations only
-nospinner	Don't show spinner
-sc ***	show class attributes for specified class
-scx ***	generate xml for the specified class

Parameter	Description
TWA Options
-lftwa	use transaction work area(twa) instead of xml input file
-lttwa	write input file to twa
-chg ***	only process twa transactions for this change reference number
-lttwar	load transactions into the ready state
-lftwai	inactivate successful transactions

Parameter	Description
Spreadsheet Input Options
-ssf ***	filename of excel spreadsheet
-sss ***	name of sheet within excel spreadsheet
-ssfr n	first row of the spreadsheet to be imported
-sslr n	last row of the spreadsheet to be imported
-ssfc n	first col number or letter of the spreadsheet to be impo rted
-sslc n	last col number or letter of the spreadsheet to be impor ted
-sses x	separator character for multiple embedded relationships

Parameter	Description
CSV Input Options
-csvf ***	csv file name
-csvsep	csv field separator (,)
-csvesc	csv field escape character (\)
-csvquote	csv quote character (")
-csvcom	csv comment character (#) Database Input Options
-dbdriver ***	java class name for the database driver of the input dat abase
-dbuser	*** - database username of the input database
-dbpswd	*** - database password
-dbstmt ***	database select statement
-dburl	url used to locate the database

Replace Symbolic Options
Parameter	Description
-rs	enable symbolic replacement in the input data now unique timestamp userid signed on user inputfile name of input file cicount current ci count relationcount current relationship count

Replace Symbolic Options

Parameter

Description

-rs

enable symbolic replacement in the input data

*now* unique timestamp

*userid* signed on user

*inputfile* name of input file

*cicount* current ci count

*relationcount* current relationship count

C. Custom Examples

C.1 A Load CI Other Contract - Extension Table

Expected Results:	1 CI are loaded
Run command:	grloader -i grloader_sample_spreadsheet -a -n -E -u servicedesk -p password …

tenant	name	class	con_num	con_start_date	con_end_date	con_ref	cost_center	con_comments	repair_org	resource_description	billing_contact_uuid	con_type
CA TECHNOLOGIES	My Item nam	Other contract	BR-2016-213515	01/01/2016	31/12/2018	283582	BRSP0001	My comments	CA EDUCATION	My contracct

Oficial Examples from CA Service Desk Manager

examples on sample directory

C.2 A Load CIs from simple spreadsheet CI data

Expected Results:	3 CIs are loaded
Run command:	grloader -i grloader_sample_spreadsheet -a -n -E -u servicedesk -p password …

name	class
server1	Server
server2	Server
acd1	ACD

C.3 Loading CIs and attributes from other than the first sheet in a workbook

Expected Results:	4 CIs are loaded
Run command:	grloader -i grloader_sample_spreadsheet -sss Sheet2

name	class	alarm_id	hard_drive_capacity	carrier	phys_mem
server1	Server	1	5		7
server2	Server	2	6
acd1	ACD	3		verizon
server3	Discovered Hardware	4

D. PRE REQUISITES

Topic from Official documents CORA_MDB_and_Assets_SC.pdf

When an asset is registered, CORA generates the asset uuid (ca_asset) by applying a black-box logic to the following six properties:

Serial Number „
Asset Tag (appearing as Alt Asset ID) „
Host Name „
Mac Address „
DNS Name „
Asset Label (Name)

CORA applies the following weighting system to these properties to determine if a match exists. Since certain properties are considered “more important” than others, CORA will recognize a duplicate based on those values alone.

Serial Number is the most highly weighted field. Two assets with the same serial number will always be matched by CORA unless Asset Tag or Host Name are different.
Alt Asset ID is the second most highly weighted field. Serial Number and Alt Asset ID appear at the highest level of the Asset Registration schema in ca_asset).
Host Name appears in the middle level (ca_logical_asset). If Serial Number and Alt Asset ID are blank the Host Name takes precedence over DNS and MAC Address values. Although more than one DNS/MAC pair can be specified for the same Host Name, it will still be considered the same Asset.
DNS Name and MAC Address are weighted the same. CORA will recognize the same asset if DNS or MAC address match and will create a new asset when they do not.
Finally, although Asset Label (Name) is required to create an asset, you can have multiple assets with the same name as long all the other CORA fields are empty.

TWA links (Transaction Work Area)

Transaction Work Area - CA Service Management - 14.1

How to Use the Web Interface to Update Data in the TWA - CA Service Management - 14.1 / Como usar a interface da Web para atualizar dados na TWA - Portuguese - Brazil

Populating the TWA - CA Service Management - 14.1 / Preenchendo o TWA - CA Service Management - 14.1 (Portuguese - Brazil)

TWA Administration - CA Service Management - 14.1

Troubleshooting CA Service Desk Manager Connector - CA Service Management - 14.1

Review and Modify Inbound Data Using Transaction Work Area (TWA) - CA Service Management - 14.1

TEC607892 - Can we use the "EMPTY" keyword to blank out a field that has a value when using GRLoader to update a Target CI?

TEC511086 - Is it possible to update a value to NULL using GRLoader? - <location>EMPTY</location>

TEC548758 - How to add rules for CMDB TWA tables to Archive and Purge in CMDB r12.1

TED511801 - When using GRloader to load from TWA are the errors written to a XML?

TWA SQL Column Names - Administration Guide Release 12.7.00