Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

8
Replies
540
Views
WeiLin Member since 2018 1 post
Accenture Pte Ltd
Posted: Nov 1, 2018
Last activity: Feb 5, 2019
Closed

BIX: pxExtractDateTime & pxExtractIdentifier not populated

Hi,

I've set up the BIX to extract the properties to the database table, however the pxExtractDateTime and pxExtractIdentifier is not getting populated in the table. Is there anything that I'm required to configure to populate the 2 columns?

Thanks!

To see attachments, please log in.
Case Management
Data Integration

Posted: 6 years ago

Hi,

Are the properties are getting extracted successfully?

Are you running BIX from command line?

Can you try to extract to different source (like CSV/ XML) and see if you are able to get these values?

Thanks,

Venkat

To see attachments, please log in.
Posted: 6 years ago

Hi! Thanks for the reply!

All properties are extracted properly except for the pxExtractDateTime and pxExtractIdentifier.

I'm running BIX using the Pega Extract.

I've tried extracting to CSV and XML. pxExtractDateTime and pxExtractIdentifier is both extracted in the CSV but not in the xml.

To see attachments, please log in.
Posted: 6 years ago

Hi WeiLin,

I'm able to replicate the issue. pxExtractIdentifier, pxExtractDateTime are coming in CSV, DB extract but not in XML extract.

In fact, this is a bug in CSV extract to fetch pxExtractIdentifier, pxExtractDateTime columns. We have PegaCSVUtility to stop fetching these columns in CSV extract.

Please let us know what is the need for you to fetch these.

Thanks,

Venkat

To see attachments, please log in.
Posted: 6 years ago

Hi,

Thanks for the reply. As I would like to use the pxExtractDateTime to find out when the record was extracted, it would be necessary to have that property. Would there be anyway to retrieve that property in the DB extract?

Thank you.

To see attachments, please log in.
Posted: 6 years ago

Thanks for this post. What changes do i need to do in the BIX Extract rule in 7.3.1 to stop fetching pxExtractIdentifier and pxExtractDateTime columns please?

To see attachments, please log in.
Posted: 6 years ago

i need to exclude fetching pxextractdatetime& pxextractidentifier into the csv files. is there a way to exclude these two fields from the extract?

To see attachments, please log in.

Related content:

Related content has not currently been identified for this post.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice