GRLoader and lifecycle_status field

Document ID : KB000102663
Last Modified Date : 19/06/2018
Show Technical Document Details
Question:
Is it possible to import info with GRLoader to the field "lifecycle_status" via the TWA?
Environment:
CA Service Desk Manager 14.1
CA Service Desk Manager 17.1
Answer:
Yes this is possible:

1) 
Create a file.csv file with the following content: 

name,system_name,class,tran_chg_ref_num,lifecycle_status 
Frnk01, Frank01SN,Unix,test,aaaaaaaaa 

Load it into the TWA with: 

grloader -s http://localhost:8080 -u servicedesk -p password -lttwar -csvf FILE.csv 

And from the TWA into the MDB: 

grloader -s http://localhost:8080 -u servicedesk -p password -iia -n -a -lftwa 

The GRLOADER.log files shows: 

06/08 13:09:55.381 INFO GRLoader 496 GRLoader Started - load from csv file(null) - to TWA in Ready state 
06/08 13:09:55.381 INFO GRLoader 512 =============================================================================== 
06/08 13:10:00.655 INFO grDataMgr 200 Multi-tenancy is not enabled 
06/08 13:10:04.545 INFO grCSVrdr 223 grCSVrdr1300 added attr(name) value(Frnk01) to csv transaction 
06/08 13:10:04.545 INFO grCSVrdr 223 grCSVrdr1300 added attr(system_name) value( Frank01SN) to csv transaction 
06/08 13:10:04.545 INFO grCSVrdr 223 grCSVrdr1300 added attr(class) value(Unix) to csv transaction 
06/08 13:10:04.545 INFO grCSVrdr 223 grCSVrdr1300 added attr(tran_chg_ref_num) value(test) to csv transaction 
06/08 13:10:04.545 INFO grCSVrdr 223 grCSVrdr1300 added attr(lifecycle_status) value(aaaaaaaaa) to csv transaction 
06/08 13:10:05.095 INFO GRLoader 306 
06/08 13:10:05.123 INFO GRLoader 306 
06/08 13:10:05.123 INFO GRLoader 306 Results: 
06/08 13:10:05.123 INFO GRLoader 306 Read Skipped Inserts Updates Errors Warnings 
06/08 13:10:05.124 INFO GRLoader 306 TWA CI 1 0 1 0 0 0 
06/08 13:10:05.125 INFO GRLoader 306 TWA Rel 0 0 0 0 0 0 
06/08 13:10:05.125 INFO GRLoader 306 
06/08 13:10:05.125 INFO GRLoader 859 =============================================================================== 
06/08 13:10:05.125 INFO GRLoader 306 GRLoader completed. 
06/08 13:10:05.125 INFO GRLoader 861 =============================================================================== 
06/08 13:11:03.725 INFO GRLoader 495 =============================================================================== 
06/08 13:11:03.727 INFO GRLoader 496 GRLoader Started - load from twa - to CMDB - CI Updates allowed / inserts allowed 
06/08 13:11:03.727 INFO GRLoader 512 =============================================================================== 
06/08 13:11:05.219 INFO grDataMgr 200 Multi-tenancy is not enabled 
06/08 13:11:06.822 INFO GRLoader 306 No Relation transactions were ready for loading from the TWA 
06/08 13:11:06.833 INFO GRLoader 306 
06/08 13:11:06.833 INFO GRLoader 306 Results: 
06/08 13:11:06.833 INFO GRLoader 306 Read Skipped Inserts Updates Errors Warnings 
06/08 13:11:06.834 INFO GRLoader 306 CI 1 0 1 0 0 0 
06/08 13:11:06.834 INFO GRLoader 306 Relation 0 0 0 0 0 0 
06/08 13:11:06.834 INFO GRLoader 306 
06/08 13:11:06.834 INFO GRLoader 859 =============================================================================== 
06/08 13:11:06.835 INFO GRLoader 306 GRLoader completed. 
06/08 13:11:06.835 INFO GRLoader 861 =====================================