Question
Excellus Blue Cross Blue Shield
US
Last activity: 25 Mar 2022 11:10 EDT
Pega CDH: Finalization activity needs to access output template
Hello everyone!
I have a story which requires me to summarize data on one of the actual files created by a run of our pega marketing (cdh) scheduler. I am able to add a finalization activity on the data set rule. And I've confirmed it is working by sending myself an email from it. However, I need to know the page and properties to use to access the file or possibly a way to loop through all the data within the file.
I looked at a few of the other activities. More specifically, I started with FTPSample. I was using the TemplateRule page and the .FilePath and .FilePath properties to no avail. But I've also looked at many more and am still looking) that are already there ootb, but have not had any success with these. All I've tried to do is write the file name to a string and email it to myself.
Has anyone done anything like this before? If we can't do it at finalization, we can take another approach outside of pega...however this is not ideal for our long-term staff to maintain. We prefer it happen in pega.
Hello everyone!
I have a story which requires me to summarize data on one of the actual files created by a run of our pega marketing (cdh) scheduler. I am able to add a finalization activity on the data set rule. And I've confirmed it is working by sending myself an email from it. However, I need to know the page and properties to use to access the file or possibly a way to loop through all the data within the file.
I looked at a few of the other activities. More specifically, I started with FTPSample. I was using the TemplateRule page and the .FilePath and .FilePath properties to no avail. But I've also looked at many more and am still looking) that are already there ootb, but have not had any success with these. All I've tried to do is write the file name to a string and email it to myself.
Has anyone done anything like this before? If we can't do it at finalization, we can take another approach outside of pega...however this is not ideal for our long-term staff to maintain. We prefer it happen in pega.
This activity is still in development and I realize a java step as shown below is silly. Believe me, it will be doing something more meaningful later but for now I want to get the fully qualified file name of the file we're finalizing. I'm just working on a proof of concept and not requesting a full-fledged code review here :)
Excellus Blue Cross Blue Shield
US
I also tried to use the .FilePath, .FileName, and .TempFileName on page TemplateRunFile of type PegaMKT-Data-Outbound-TemplateRun-File. I found this when looking for other activities with the word "finalize" in them and bumping into a withdrawn one from ootb pega marketing. It is defined in pages & classes on my activity I'm using for testing.
when I put local.message in the body of the email, I end up with just the newlines. I'll keep trying and will update this thread if I find something.
Excellus Blue Cross Blue Shield
US
I think I'm getting very close. Here is an activity I found that appears to be what runs at finalization. And step 10 is the context in which your finalization activity gets called. Very useful information, at least I think so:
Pegasystems Inc.
US
Hi Richard,
Can you please explain a little bit more on the finalization requirements here ?
1. Do you just need the template rule information like .TemplateFilePath and FileName ?
2. Will you have multiple such file templates or your system has just one file path / name ?
3. Currently not sure what your custom processing requirements are - depending upon your needs you could leverage OOTB Pega capabilities instead of writing java code yourself too.
Few information which you can consume and see what fits for your needs:
1. While calling your custom GenerateAndSendFulfillmentCodeSummaryEmail you should have access to a named page called "TemplateRuleToFinalize" with the class name as "Rule-Obj-Template" - you can consume most of the metadata from there.
2. Under this named page there should be a property named "ActiveDataClass". This class will hold your "File" data-sets., that is associated with the relevant template. Something named "CDHFileData"
3. You could potentially leverage dataflow rule features to construct a custom dataflow with the CDHFileData as the source and target to be an activity where you consume the file contents as primary pages and do custom processing. Remember making a dataflow execute call would also potentially make that request async as it runs on a different node.
Updated: 25 Mar 2022 9:59 EDT
Excellus Blue Cross Blue Shield
US
@Sriram Krishnan Thank you very much for your reply! 1. Do you just need the template rule information like .TemplateFilePath and FileName ?
I would like both so that I can open the file and parse it.
2. Will you have multiple such file templates or your system has just one file path / name ?
There are multiple templates and we create multiple files, but only one for this data set that is triggered to write by certain actions, so I assume I'll get a unique file if I can just get the path and name.
3. Currently not sure what your custom processing requirements are - depending upon your needs you could leverage OOTB Pega capabilities instead of writing java code yourself too.
I need to provide a summary of data in the file. If there is a way to parse the data pega is going to write to the file, row-by-row, and accumulate counts of a certain custom column, I'll happily do it in pega. I haven't gotten far enough to determine which way is possible yet. Again the code I'm showing in the original post is a very rough early draft.
1. While calling your custom GenerateAndSendFulfillmentCodeSummaryEmail you should have access to a named page called "TemplateRuleToFinalize" with the class name as "Rule-Obj-Template" - you can consume most of the metadata from there.
@Sriram Krishnan Thank you very much for your reply! 1. Do you just need the template rule information like .TemplateFilePath and FileName ?
I would like both so that I can open the file and parse it.
2. Will you have multiple such file templates or your system has just one file path / name ?
There are multiple templates and we create multiple files, but only one for this data set that is triggered to write by certain actions, so I assume I'll get a unique file if I can just get the path and name.
3. Currently not sure what your custom processing requirements are - depending upon your needs you could leverage OOTB Pega capabilities instead of writing java code yourself too.
I need to provide a summary of data in the file. If there is a way to parse the data pega is going to write to the file, row-by-row, and accumulate counts of a certain custom column, I'll happily do it in pega. I haven't gotten far enough to determine which way is possible yet. Again the code I'm showing in the original post is a very rough early draft.
1. While calling your custom GenerateAndSendFulfillmentCodeSummaryEmail you should have access to a named page called "TemplateRuleToFinalize" with the class name as "Rule-Obj-Template" - you can consume most of the metadata from there.
I believe I have already tried this after finding the ootb activity FinalizeFileDBTemplateWrapper, but didn't post about it. I got a blank .FilePath and .FileName and .FileTempPath. I'll give it another try today. Our scheduler takes quite a while to run, even with a reduced segment, due to a recent code change.
2. Under this named page there should be a property named "ActiveDataClass". This class will hold your "File" data-sets., that is associated with the relevant template. Something named "CDHFileData"
I'll add this to my second attempt with TemplateRuleToFinalize.
3. You could potentially leverage dataflow rule features to construct a custom dataflow with the CDHFileData as the source and target to be an activity where you consume the file contents as primary pages and do custom processing. Remember making a dataflow execute call would also potentially make that request async as it runs on a different node.
Thank you! I really like this idea better than what I'm trying now. It might require a bit more testing and refactoring of other things. So for now I'll keep trying the finalization activity and consider this. Putting work item on our backlog for this great idea :)
Excellus Blue Cross Blue Shield
US
I get blank strings when I try to log .FilePath, .FileName, .FileTempPath, and .AbstractClassName as strings off the TemplateRuleToFinalize page. It is defined in pages and classes in my activity. I'm setting them to a local string variable and sending that string to myself in an email.
I'll keep looking for another page or try a different approach such as your suggested change to the dataflow.