Question

Modify the filename generated from BIX

we are using OOTB pxExtractDataWithArgs activity to generate BIX extractions for multiple applications.

We have a requirement to achieve the following

  • Append certain text in the file to identify from which application the file was geenrated.
  • Currently the date is getting appended using ddmmyy format, we want to append timestamp as well to the filename.

for example, considering the below filename BIX_Data_Admin_Operator_ID_ExtractOperatorID_191204_1

This provides information that the file was generated from DATA-ADMIN-OPERATOR-ID class on 191204 , but does not convey the application name for which it was generated. So how can we pass a text like applicationname that would help in differentiating between files generated for different application. Also how to include timestamp in the filename itself

Thanks for your help in advance

***Edited by Moderator Marissa to update SR Details***

Group Tags

Comments

Keep up to date on this post and subscribe to comments

Pega
December 5, 2019 - 10:33pm

December 9, 2019 - 1:11am
Response to gundk

Surprisingly , I don't see the file specification tab when output format is csv file. Our dev env is pegacloud and we are using Pega 8.1.4 and BIX ruleset version 08-01-01. attached a screenshot below for extract ruleform.

 

 

Pega
December 9, 2019 - 1:27am
Response to ShuvadeepD

In the screen shot under Property, Click on class name and then click on Gare icon. You will find the file.

Pega
December 9, 2019 - 10:41pm

Hi Shuvadeep,

Kindly see if this is of any help.

This is expected behaviour.

When using BIX installed on cloud, file specification tab is not available in extract rule as users do not have access to cloud server file system. We have to configure a file system to to get all the extracted files there.

We to create a file system use that to get the extracted files there.Follow below help article to configure the file system for BIX:​https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#tools/BIX/howtorunbixoncloud.htm

Pega
December 11, 2019 - 11:02pm

Hi @ShuvadeepD

Tried a few more things for BIX extract (not on cloud) - 

1. For extract to CSV format we can specify the extract file name  by opening the 'Property configurations' in 'To File' (PFA).

2. For extract to XML format we can specify the extract file name in the 'File Specifications' tab in XML output file name.

For customizing the file name you can try following.

%c     --     gives class name 

%d     --     gives date (yy/mm/dd)

%i      --     for pzInsKey (ObjClass_Class in which extract rule is created_Extrct Rule Name_TimeStamp)

%r     --     gives Extract Rule Name

%s    --     gives No. of time the extract rule ran

%t     --     gives Time Stamp

How to use it for specifying file name --

BixTest_%c_%d_%s

We get output file name as --

BixTest_PGA_ShiftReg_Work_Demo_191212_1

 

December 18, 2019 - 1:17am
Response to handr1

Thanks for the help. but the issue is since we are on cloud I don't find the options you highlighted in screenshot. Is there any way to do this in Pegacloud environment ?