Extract parent and child classes to same CSV file - BIX
My team and I have the business requirement of extracting a set of data to a single CSV file. This information is distributed between a parent and child class, which causes BIX to create a CSV file for each of the classes. There are a number of problems with this.
First, only as of Pega 7.2.1 does the -c flag put the data into a single file, and we are pretty sure that deployment will be in Pega 7.1.7 (we are developing on 7.2.2). What ruleset of BIX is required to obtain this functionality?
Furthermore, if we do achieve this, how will the file be formatted? The data is as follows: OutsideNA, Question1, Question2, Question3, (Country1, Country2, Country3, TIN1, TIN2, TIN3, Code1, Code2, Code3).
Finally, is there a way to achieve this behavior using an agent rather than a command line flag? We are using an agent to schedule this extraction every week.
My first question would be, why are you developing on 7.2.2 if the deployment will be on 7.1.7?
Offhand I'm unsure about -c, so I would need to do some research and testing (or perhaps someone else knows). That being said, if functionality wasn't introduced until 7.2.1, you need to be using at least that version for it to work. The version of BIX in use needs to align with the version of Pega.
I believe you can schedule extracts to run via agents starting in 7.1.8 using the pxExtractDataWithArgs activity. Prior to this, I don't think running it via an agent was something we supported.