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
| Required | |
| Parameter | Description |
|---|
| -u | Userid for logon |
| -p | Password for logon |
| -s | Server URL including port (I.E. http://localhost:8080 |
.
| Optional | |
| Parameter | Description |
|---|
| -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 |
.
| Processing Options | |
| Parameter | Description |
|---|
| -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 |
.
| Output Options | |
| Parameter | Description |
|---|
| -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 |
.
| TWA Options | |
| Parameter | Description |
|---|
| -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 |
.
| Spreadsheet Input Options | |
| Parameter | Description |
|---|
| -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 |
.
| CSV Input Options | |
| Parameter | Description |
|---|
| -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 |
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
Integration FAQs
General Links
grloader.zip - Everthing you need to load Configuration Itens
CA WIKI - General Resource Loader GRLoader
https://wiki.ca.com/display/CASM1401/General+Resource+Loader+-+GRLoader
CA WIKI The+GRLoader+Command_815231 - PT-BR (apesar do título, está em português)
TEC601582 - How to create GRLoader load file
RI27896 - GRLoader stops responding when loading a large numbers of CI´s
TEC604592 - CMDB update ambiguity
120530-1 CMDB Best Practices and Service Model.pdf
CMDB Technical Reference
ahsar01
CORA
TEC484950
TEC476399
TEC541954
Communities Search by grloader
tec541954 - CORA Cleanup does not work with SQL Server 2008
tec484950 - Detailed CORA Trouble-Shooting Guide http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec541954.aspx
CMDB - Recommendations
SUPER GRLOADER (z_loader_sdm_v103_en.zip) by Daniel Bighelini
Was this information helpful? Give your feedback.