Question

3
Replies
312
Views
 David Bertoli (bertd)
PEGA
Sr. System Architect
Pegasystems Inc.
CH
bertd Member since 2016 5 posts
PEGA
Posted: May 31, 2018
Last activity: June 26, 2018
Posted: 31 May 2018 4:41 EDT
Last activity: 26 Jun 2018 5:06 EDT
Closed
Solved

Change Output File Template delimiter

Hi all,

please could anybody help with PegaMarketing. Where can I change the default "," delimiter to ";" in PegaMarketing 731? I customized the PopulateColumnName and WriteToStaging activities in PegaMarketing721, but WriteToStaging activity was withdrawn in PegaMarketing722 and after upgrading from PegaMarketing 721 to PegaMarketing 731, the customized activitiy WriteToStaging with ";" doesn't work any more.

Thanks a lot

Best regards

Decision Management
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 5 Jun 2018 7:05 EDT
Abhijit Sarkar (AbhijitSarkar_GCS)
PEGA

Pegasystems Inc.

Hi ,


Could you save as the PopulateColumnName activity  of Rule-Obj-Template class in your ruleset.


Then in the step 1.2 ( Property-set step) use Param.PopulatedColumnString + ";"


Check if this works for you.


Regards


Abhijit


 
Posted: 2 years ago
Posted: 26 Jun 2018 5:00 EDT
David Bertoli (bertd)
PEGA
Sr. System Architect
Pegasystems Inc.
CH

Hi,


unfortunately, to customize PopulateColumnName is not sufficient enough. It changes the delimiter only in header columns. There was one more activity to be customized in 721 (WriteToStaging), which cared about the rest of columns.


Regards


David

Accepted Solution

Posted: 2 years ago
Posted: 26 Jun 2018 5:06 EDT
David Bertoli (bertd)
PEGA
Sr. System Architect
Pegasystems Inc.
CH

The solution is to install HFIX-44795 and follow these steps:


1) set desired delimiter in Dynamic System Setting PegaMKT-Engine:MKTFileDelimiter - this will be used for all NEW templates from this point forward

2) if it is desired to persist this to all existing templates run activity Code-Pega-List.PersistNewDelimiterToFileTemplates