Roadmap Item Import To CSV Error

Products

• Clarity PPM SaaS

Issue/Introduction

Request URL: https://server_example/ppm/rest/v1/virtual/dataImporter

HTTP Version: http/2.0Request method: POST

{
  "_failedRecordRows": "3, 4, 5, 6, 7",
  "_self": "https://server_example/ppm/rest/v1/virtual/dataImporter",
  "_totalCount": 5,
  "_recordsFailed": 5,
  "_recordsInserted": 0
}

ERROR 2024-05-15 10:56:25,287 [http-nio-8080-exec-111] rest.validation (clarity:user:session:PPM_REST_API) (42da1af9-75d4-4ac9-8cee-a484bc0f0cd4) ODFResourceProvider :: Could not create resource. Object code alias: [ requestUrl: https://server_example/ppm/rest/v1/roadmaps/5086676/roadmapItems , _restResourceName : roadmapItems , _id : null , _parentInfo : com.ca.ppm.rest.RequestContext$ParentInfo@9946e96 , _apiVersion : v1 , _includeLinksArray : true , _contextId : 5154936 , _hierarchyId : -1 , _isGroupBy : false , _isPartition : false]
ERROR 2024-05-15 10:56:25,288 [http-nio-8080-exec-111] rest.validation (clarity:user:session:PPM_REST_API) (42da1af9-75d4-4ac9-8cee-a484bc0f0cd4) ExceptionInfo ::  Could not create resource. Resource name: roadmapItems. Error code: validation.lookupValueInvalid Error message: CMN-0009: Attribute 'In Plan' has invalid Lookup Value 'In Plan'
ERROR 2024-05-15 10:56:25,288 [http-nio-8080-exec-111] ppm.rest (clarity:user:session:PPM_REST_API) (42da1af9-75d4-4ac9-8cee-a484bc0f0cd4) CustomerResourceHandler ::  exception occurred while performing action:create
com.ca.ppm.rest.exception.BadRequestException: CMN-0009: Attribute 'In Plan' has invalid Lookup Value 'In Plan'

Cause

The possible values are
'Not in Plan' denoted by 1
'In Plan' denoted by 2

Instead of using the string, use the numeric representation.
 

Resolution

Use the following example instead:

"ID","Name","In Plan"
"name","inPlan"
"1DELETE ME. A Sample Roadmap Item, CSV Import",2
"2DELETE ME. A Sample Roadmap Item, CSV Import",2
"3DELETE ME. A Sample Roadmap Item, CSV Import",2
"4DELETE ME. A Sample Roadmap Item, CSV Import",2
"5DELETE ME. A Sample Roadmap Item, CSV Import",2