Bulk Update using Excel Binary File And Activity

-

 Hi All,

In this blog we will see how we can use binary excel file and activity for bulk update.


Follow Below Steps:-

Create Excel file  having following columns.

In excel, in first row put following headings:-   Case ID , T Event ID, T Name, Quarter, ExpectedTDate,

TStatus, 

In second row put following

{.pxResults().pyID}

{.pxResults().TUEventID}

{.pxResults().TUName}

{.pxResults().TrueUpQuarter}

{.pxResults().ExpectedTUDate}

{.pxResults().TUStatus}


Create Activity now

Step 1  First Create Activity

ID = TUpdate

CL = Data-Portal


Step 2   Define Pages & Classes

UploadPage                       Code-Pega-List

UploadPage.pxResults            C-C-Art-Work-T

WorkObjectToCreate               C-C-Art-Work-T

TUDeliverables                   Index-C-C-Art-Data-DeliverablesList

FinalTUWorkPage           C-C-Art-Work-T


Step 3 Define Steps in Activity

1) Page-New      Step page = UploadPage


2)  Call pxParseExcelFile      Step page = UploadPage

*FSFileName = @trim(pxRequestor.pyFileUpload)

*TemplateRFB = Art!TUpdate!XLSX


3) Loop = For each embedded page

Property-Set            Step Page = UploadPage.pxResults


Param.amanager = .AManager

Param.cuser = .CUSER

Param.amanager1 = .AManager1

Param.cuser1 = .Cuser1

Param.cmanagerid = Cmanagerid

Param.case = .pyID


3.1) Page-New           StepPage = WorkObjectToCreate


3.2)  Page-New            StepPage = TUDeliverables


3.3) Property-Set            StepPage = TUDeliverables 

.DDate = UploadPage.pxResults(<CURRENT>).ExpectedTUDate

.DName = "T-Report"

.TName =  UploadPage.pxResults(<CURRENT>).TName

.DNotes = UploadPage.pxResults(<CURRENT>).DNotes

.ReportID = UploadPage.pxResults(<CURRENT>).TEventID

.pxInsIndexedKey = "C-C-ART-WORK"+UploadPage.pxResults(<CURRENT>).pyID

.pxIndexPurpose = "Index_DeliverablesList"

.pxIndexCount = @whatComesAfterLast(UploadPage.pxResults(<CURRENT>).TEventID,'-')

.TQuarter = "FY22Q2"


3.4) Property-Set             Step Page = WorkObjectToCreate

.CID =  UploadPage.pxResults(<CURRENT>).pyID

.CKey = "C-C-ART-WORK"+UploadPage.pxResults(<CURRENT>).pyID

.TQuarter = UploadPage.pxResults(<CURRENT>).TQuarter

.pyID = UploadPage.pxResults(<CURRENT>).TEventID

.pxInsName = UploadPage.pxResults(<CURRENT>).TEventID


3.5)  Call  svcAddWorkObject             Step Page = svcAddWorkObject

FlowType = pyStartCase

workPage = FinalTUWorkPage


3.6)  Call UpdateStatus            Step Page = FinalTUWorkPage

*StatusWork = OPEN-NOTSTARTED


3.7) Call commitWithErrorHandling         Step Page = FinalTUWorkPage


3.8)  Call Save          Step Page = TUDeliverables


3.9)  Call CommitData            Step Page = TUDeliverables


4) Page-Remove           Step Page = UploadPage


Thank you!! Will see you all in next blog post 😊.


Comments

Post a Comment

Popular posts from this blog

pxSubscript and pxListSubscript Properties In Pega

-
Image
  .pxSubscript   And  .pxListSubscript Property-Set                         CasePg.Stakeholderlist Param.Indexpurpose  = "Index_Stakeholderlist" Param.InsIndexedKey  =  "CIGNA-CIGNAAUTO-WORK"+CasePg.pyID local.cnt  =   .pxListSubscript Param.IndexCount = local.cnt-1 How to get index value from pagelist?  The property pxListSubscript will hold the index of the current page that you are in How to get index in a pagelist during iteration While iterating in a pagelist Example : EmployeeList To refer to page at that point: we use EmployeeList(<CURRENT> ) But how to get the index if we have to write some condition, like at index= nth position => achieve some logic. Answer : pxListSubscript Pega provides one property called pxListSubscript which is declaratively calculated and kept at each page level in a pagelist. We can use it instead of setting  a property a...
Read more

Frequently Used Date Expressions In Pega

-
Image
 Hi, In this post I will show some of the frequently used date expressions in pega. Before starting we will see some of the date subscripts used in date functions. For Ex:   If date is =  05/March/2023 yyyy = Year => 2023 YYYY => 2023 MM = Month => 03 M=> 3 MMMM  ===> March MMM ====> Mar dd = Date/day  => 05 d ===> 5 1) pxFormatDateOnly(CurrentDateTime(),"yyyyMMdd","MM/dd/yyyy")   Here, CurrentDateTime()  = 20230618T025027.005 GMT                                                                                CurrentDateTime() returns the current date and time. pxFormatDateOnly() = Format/reformat a Date Time string using a specified parameters. Output  =  06/18/2023  { which is 18 June 2023} 2)...
Read more

pyForEachCount In Pega

-
Image
pyForEachCount holds the current iteration number. You can examine (but not alter) this value in the step.                 When processing the For loop or iterating over a Value List or Page List property, the parameter param.pyForEachCount holds the current iteration number.  You can examine (but not alter) this value in the step. For example, to iterate only over the first ten  pages or values, you can exit the iteration when pyForEachCount is greater than 10. In below example we will see how we can use pyForEachCount in data transform and set value in .pxResults.
Read more