Question
Ashfiled
US
Last activity: 31 Jul 2017 6:06 EDT
How to create BIX CSV format file name dynamically
Hi,
We are extracting the BIX data into CSV format and using BIX pega agent with pyExtractDataByArg activity. Please let me know if you have any idea about creating the file name dynamically for CSV type of format?
Thanks,
Sreeni.
***Updated by Moderator: Marissa to update categories***
Pegasystems
IN
This is already covered here - https://collaborate.pega.com/question/how-dynamically-set-file-path-and-filename-bix-extract-running-help-pega-agent
Ashfiled
US
Thnaks for your response. Please let me know the above approach is for CSV format?
I didn't see anything for CSV format in the User Guide.
Pegasystems
IN
You can generate unique files names for the extracted files across multiple runs of the extract rule by using the option as specified in "Completing the File Specification tab" section in the BIX user guide.
Note that % options are same for XML or CSV.
Ashfiled
US
The above approach is not working for CSV format. Did you try for CSV format or XML?
Pegasystems Inc.
IN
An external shell script can be used to rename the BIX generated file with suitable unique file names.
Also, from pega perspective you can refer the below link
https://community.pega.com/sites/default/files/help_v717/procomhelpmain.htm
https://community.pega.com/knowledgebase/release-note/enhanced-bix-file-naming
Accepted Solution
Ashfiled
US
We are explicitly calling another activity and changing the file name as per our business requirements. We don't have any OOTB rules for this issue.
Eviden
GB
Thanks Man. Could you please share the shell script to rename the filename with the datetime format?. Currently it is giving the class name as a file name.