Question

How to send BLOB data directly to the consumers in excel sheet without using BIX extract.

How to send BLOB data directly to the consumers in excel sheet without using BIX extract.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

Pega
April 12, 2016 - 3:10pm

Hi Krishna, Good morning!

  • could we try reading ....
    • through Obj- methods
    • build a page list
    • then pass the page list to RULE-OBJ-ACTIVITY @BASECLASS PXCONVERTRESULTSTOCSV

Please share your thoughts/comments, Thank you!

psahukaru

April 12, 2016 - 3:18pm
Response to sahup1

Hello,

Thank you!

Can we do anything from the DB side without using Pega?

Regards,

Krishna!

Pega
April 12, 2016 - 3:24pm
Response to KrishnaTejaM7925

or would creating a report definition be of quick use/help?

Pega
April 13, 2016 - 2:32am

Quick question for understanding: The BLOB is a compressed Pega specific format of representing the data (in clipboard). It is essentially a byte stream that only Pega platform can make sense of. Please clarify why you would need that stream in Excel?

April 13, 2016 - 8:42am

I believe you can use a UDF to read the values of a specific property from within the BLOB. Maybe then you could export the results of the query to xls or csv?

Pega
April 13, 2016 - 8:48am
Response to JoeAbiSleiman

Note that UDF queries are extremely slow and can only work with scalar references. So if your BLOB contains a nested structure, then it would not be possible to get all entries. Example - page list property where the list may have different number of entries in each row.

February 21, 2017 - 6:32am

Is there any pega libraries available or any other means to extract the BLOB into a readable format (could be XML) without using pega application. External teams have access to database so need to know how can they access BLOB content?

February 21, 2017 - 6:36am
Response to NaveenM4289

Hi Naveen,

You have replied to an older thread which lacks activity. To gather better visibility for your question, I have branched it to a new question. You may continue your conversation on this thread: https://pdn.pega.com/community/product-support/question/there-any-pega-libraries-available-or-any-other-means-extract

Hope the information is helpful.

Thanks!

Vidyaranjan | Community Moderator | Pegasystems Inc.