Is it possible to extract date time fields into other format instead of Pega date format in BIX 6.3?
We are using pega BIX 6.3 where when we export any date time type fields like pxCreateDateTime or pxUpdateDateTime, they are being extracted in Pega date format like "20150518T053624.000 GMT". I could not find any place in extract rule to reformat the date time field like dd/MM/yyyy hh24:mm. So is it possible to perform such reformat through Pega extract rule or any other way? Or we have to perform it outside of Pega?
1. I am also facing same problem when I am trying to export the data into CSV file . I need to change Date format for thePega Datetime format to other system formats(Ex : should change BIGdata readable format).
2. And also i need have when conditions like (before exporting data into CSV we need to check whether that property has value or not , if that property does not have value should map some other property in other pageList.)
Please help me how can I achieve above two scenarios.
The issue was raised with Pega GCS under SR reference SR-A3434 and final response from GCS as below
"BIX is just a raw extraction tool and Data formation (change) does not come under the scope of this tool, so it wouldn’t possible to entrain the enhancement request for this change."
Unfortunately no solution can be provided from pega in respect to this. It is not even possible via some hotfix or BIX product enhancements. Some alternative could be using the file software like XLS, if possible using some date conversion function.
We have upgraded to pega 7 from 6.2 and after upgrade We are seeing the change in data type attribute(type="xs:string" is in Pega 6 but in Pega 7 it is coming as type="xs:date"). Is there a way we can have same data type attribute in Pega 7 as we have in 6. Also in few of the place additional attribute is coming as nillable="true"