Is it possible to update lifecycle_status field using GRLoader.

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Is it possible to import info with GRLoader to the field "lifecycle_status" via the TWA?

Environment

Release : CA Servicedesk Manager 17.X

Resolution

Please follow these below steps : 
Step 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 

Step 2:
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 =====================================