Question

Unable to Generate the CSV file

Hi,

I want to generate the Excel file based on the PageList from Pega. For this, i am using the OOTB Activity "pxConvertResultsToCSV" and giving the pxResults as input to this Activity.

But, i am getting a message "No Stream to Display" . Please find the below screen print for your reference.

How can i generate the Excel with this Activity.Any help would be Greatly appreciated.

Thank you,

KSR Prasad

Comments

Keep up to date on this post and subscribe to comments

Pega
May 4, 2018 - 10:35am

If you run the Tracer with all event types enabled, you should be able to see what stream is null.  Also showing the error message from the PegaRULES log file with the stack trace (probably duplicated in the Tracer) will help.

Pega
May 4, 2018 - 10:56am

it is a good idea to check some other activity like : pzExportGridsInfo to understand how this activity has been used in OOTB rules.

Pega
May 6, 2018 - 7:30am

Where are you running this activity from? On click of a button ?

If you are calling this on click of a button, configure on click action 'open url in window' and configure the above activity in this action. With this you should be able to download file.

November 13, 2018 - 1:12pm

Hi,

I tried to generate the CSV file with the report definition as source, I got the results in the excel but I failed to the get the results from the join classes.

Example : If I have a report  on X class  and having the joins with Y and Z, then trying to generate the CSV then I am able to get the properties in X class only. pxPages data is not coming in the CSV files.

 

Thanks

Dileep