Question

3
Replies
1219
Views
 Taw Sern Tan (TawSernTan)
M1 Ltd

M1 Ltd
SG
TawSernTan Member since 2015 40 posts
M1 Ltd
Posted: April 9, 2018
Last activity: January 28, 2019
Posted: 9 Apr 2018 21:43 EDT
Last activity: 28 Jan 2019 14:10 EST
Closed

Pega Marketing to output to file with date stamp included in the filename?

Hi,

We are implementing Pega Marketing, and we will need to output the result of Campaigns to a flat file and pass over to printer house for printing of DM.

Is there anyway of naming the output file such that it will contain the date/time stamp in the filename? We like to generate a unique file for each of the campaign run so that we are able to rely on the file in the event of any dispute arises.

Regards.

***Edited by Moderator Marissa to update platform capability tags****

Pega Marketing 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: 17 Apr 2018 17:42 EDT
Saleem Abdelsayed (Saleem_A)
PEGA
Sr. Director, Product Management
Pegasystems Inc.
US

There is currently no direct way in the product to achieve this currently.  What is possible today is to create a output finalization extension using the Advanced section of a file template.  There you can specify an activity to run on file finalization.  That activity could copy the file to a location or name of your choosing that includes today's date.  See the user guide for 'Configuring File and Table Finalization' here: https://pdn.pega.com/documents/pega-marketing-731-user-guide
Posted: 2 years ago
Posted: 27 Jan 2019 22:46 EST
Yin Teng Lee (LEEYT2011)
M1
Manager
M1
SG

Our output file will be generated at different time of the day, how can we fix the finalized time schedule. Any better way that we can solve this problem.


Community plse help


A simple task yet not able to achieve ?


 
Posted: 2 years ago
Posted: 28 Jan 2019 13:23 EST
Sriram Coimbatore Krishnan (Sriram Krishnan)
PEGA
Principal Solution Architect -Decision Analytics and Marketing
Pegasystems Inc.
US
Hi,


Can you please make it clear - if you are expecting 1 file per day or more than that ? If it is just 1 file per day then Saleem's comment earlier is fully valid.


Why are you not able to do this in the finalization extension of the file template configuration ?


If you are looking for more than a single file in a day (same file name) and looking for a LESS than a "Daily" schedule in the Finalization of the file template ? like hourly or by the minute.


Unfortunately daily is the least you get OOTB in the template rule.


Also please note - your finalization schedule even if set in the file to be hourly or less than that - your solution won't be fool proof.


The reason for that is the campaign's end life cycle is NOT really tied with the finalization of the file.


If there is a schedule overlap between campaigns and file finalization - you will get a mix of records.


 


Can you possibly think of adding a additional column / property in the file template to differentiate the records and still do daily finalization ?


For example :


Name AddressLine1 AddressLine2 zipCode RunIDentifier


aaa               bbb                            ccc                               1234                  .ProgramRunID (PR-4125)


 


Just like the above example, the template could be configured to output the ProgramRunID under the PegaMKT-Work-Offer class.