Is there a way we can skip extract Identifier, extract date time and double quotes for each value in CSV Output file through BIX Extraction? Please suggest any work arounds/alternatives.
We need to provide user ability to download huge data 50K+ records having 40MB+ size from data table and generate excel/csv file. I thought BIX extraction may be on of the option but stuck with above unwanted columns and double quotes.
***Edited by Moderator Marije to add Capability tags***
***Edited by Moderator Marije to add BUG readme tags***
Unique run identifier only applies to CSV and database output types. As these fields are for the Unique run identifier functionality, they are not used with XML files.
Your option is to revisit the use of the extracted data to make use of the new feature. or do post processing on the excel to remove this field.
Of interest on a seperate note. Another issue resolved in Pega 8.5.6 is where now we have added DSS settings to control BIX extraction time properties.
These three columns were introduced as of Pega 7.3.1 to handle any failures during BIX incremental extraction:
pxStartCommitDateTime, pxEndCommitDateTime, and pxLastSuccessFulCommitDateTime.
Those extra 3 columns are added to handle below issues.
In case failure BIX incremental extraction used to starts from the last extraction date time even if some batches were processed successfully. It did not always log what was the starting and ending datetime considered for the incremental extraction. As part of this fix BIX process has been enhanced to support above use cases so that we don't extract successfully extracted data again and log start, end and last successful extract date time.
To support better backwards compatibility, this fix introduces the below DSS to allow disabling of the new columns.