Question
Areteans
GB
Last activity: 31 Dec 2019 14:44 EST
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***
Pegasystems Inc.
IN
Hi,
Please check below link. It might help you.
https://community.pega.com/support/support-articles/bix-xml-output-file-name-specific-format
Areteans
GB
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.
Pegasystems Inc.
IN
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://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
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://community.pega.com/sites/default/files/help_v719/procomhelpmain.htm
Pegasystems Inc.
IN
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
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
Areteans
GB
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 ?