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

Question

Replies

1239

Views

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_A

PEGA

replied to TawSernTan

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://docs.pega.com/pega-marketing-731-user-guide

Posted: 2 years ago

Posted: 27 Jan 2019 22:46 EST

LEEYT2011

replied to TawSernTan

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 Krishnan

PEGA

replied to TawSernTan

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 ?

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.

Show Less

Get Started with Community

Question

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

About Pegasystems

Question

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

Related content:

About Pegasystems

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