Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gadde Srikar Krishna (GaddeSrikarK)
Capgemini

Capgemini
IN
GaddeSrikarK Member since 2018 2 posts
Capgemini
Posted: Jan 21, 2019
Last activity: Jan 28, 2019
Posted: 21 Jan 2019 16:15 EST
Last activity: 28 Jan 2019 8:50 EST
Closed

Create child cases using data derived from excel sheet (for each row)

I have created an excel template and used MSO Parse File method in activity to parse excel file and store data in a page.

The format looks like NewDetailsList(Page) ->ExcelDataList -> ExcelDataList(1)
ExcelDataList(2)

Now I'm trying to use this data to create multiple child cases one for each row of the
list->ExcelDataList (with configuration as shown in "Capture1.PNG")

When I run the case, It shows an error (as shown in "ErrorCapture.PNG")

My Clipboard looks this way (shown in "ClipboardCapture.PNG")

Can someone suggest me with possible changes made that can make it work.

To see attachments, please log in.
Case Management
Cloud Services

Posted: 5 years ago
Posted: 22 Jan 2019 9:07 EST
Carissa Wenhardt (CarissaW_GCS)
PEGA
Senior Principal Engineer, Technical Support, Industry Apps
Pegasystems Inc.
US

The child case class should be included in the 'Child case types' section of the parent's case type rule. It would also need to inherit from Work-.

To see attachments, please log in.
Posted: 5 years ago
Posted: 28 Jan 2019 3:08 EST
Ujjwala Ponduri (UjjwalaP)
PEGA
Senior Solutions Architect, Launchpad Provider Success
Pegasystems Inc.
US

Yes there is a need of a child class extending from work- need to be created. And also the same child class name need to be given in the Class property of you CAPTURE screen shot.

As you selected Other and didnt give any class there the system is trying to create child with the class as in the ExcelDataPage entry which is a Data- class and so child case will not be created.

To see attachments, please log in.
Posted: 5 years ago
Posted: 28 Jan 2019 8:20 EST
kamalesh Mohanty (Kamalesh_mohanty)
Areteans
Associate director- Technology
Areteans
IN

Hi, 

In order to create multiple child cases in parent class "TGB-HRApps-Data-ExcelDataList"(I assume this has direct inheritance to Work-Cover-/Work-) you have to do following steps.

1. Create 1/multiple child cases which have parent-child relationship with TGB-HRApps-Data-ExcelDataList(You can use case explorer).

2. In your excel you should either have that child case name or you should populate the case class property in the pagelist post excel parsing.

3. As you are using other as the case type and "pyStartCase" as the starter flow you need to make sure the class name of the child case type is there n the page list.

This way it should work. 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice